contig_metadata
20 rows where bioproject = "PRJNA454503", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8095092 | 8095092 | PRJNA454503_P_NODE_10967_length_339_cov_2.151079_g10638_i0 | PRJNA454503 | 10967 | 339 | 2.151079 | 7.29215781 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 134 | 1.11e-26 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g10638 | i0 | 74.847 | 9.07079646017699 | 326 | 67 | 94 | 14 | 23 | 339 | 10988228 | 10987909 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 3075 | 134 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 13847192 | 13847192 | PRJNA454503_P_NODE_27511_length_242_cov_84.624309_g27182_i0 | PRJNA454503 | 27511 | 242 | 84.624309 | 204.79082778 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 436 | 5.1499999999999985e-118 | NTclustered | gi|28395338|gb|AY190663.1| | 56 | g27182 | i0 | 99.174 | 611.012396694215 | 242 | 2 | 100 | 0 | 1 | 242 | 664 | 905 | Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 147865 | 436 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 18294036 | 18294036 | PRJNA454503_P_NODE_375_length_1722_cov_12.786875_g244_i0 | PRJNA454503 | 375 | 1722 | 12.786875 | 220.1899875 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 2170 | 0 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g244 | i0 | 89.504 | 145.381533101045 | 1734 | 157 | 100 | 19 | 1 | 1722 | 7190399 | 7192119 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 250347 | 2170 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 18294356 | 18294356 | PRJNA454503_P_NODE_65155_length_208_cov_0.884354_g64826_i0 | PRJNA454503 | 65155 | 208 | 0.884354 | 1.83945632 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 110 | 5.72e-28 | NR | MEZ0312461.1 | 2818507 | g64826 | i0 | 91.5 | 0.850961538461538 | 59 | 5 | 85.1 | 0 | 31 | 207 | 4 | 62 | MEZ0312461.1 TetR/AcrR family transcriptional regulator [Myxococcota bacterium] | diamond | 177 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 22119043 | 22119043 | PRJNA454503_P_NODE_47438_length_218_cov_1.656051_g47109_i0 | PRJNA454503 | 47438 | 218 | 1.656051 | 3.61019118 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 136 | 2.9199999999999996e-35 | NR | MBA2540744.1 | 2026735 | g47109 | i0 | 97.2 | 1.98165137614679 | 72 | 2 | 99.1 | 0 | 218 | 3 | 233 | 304 | MBA2540744.1 response regulator [Deltaproteobacteria bacterium] | diamond | 432 | 136 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 22119147 | 22119147 | PRJNA454503_P_NODE_55098_length_211_cov_0.866667_g54769_i0 | PRJNA454503 | 55098 | 211 | 0.866667 | 1.82866737 | Corallococcus exercitus | 2316736 | Bacteria | Bacteria | 145 | 2.97e-30 | NTclustered | gi|2809270164|gb|CP102577.1| | 2316736 | g54769 | i0 | 79.524 | 5.54976303317536 | 210 | 37 | 98 | 6 | 2 | 208 | 6531739 | 6531533 | Corallococcus exercitus strain SDU142 chromosome, complete genome | blastn | 1171 | 145 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exercitus | ||
| 23394841 | 23394841 | PRJNA454503_P_NODE_56919_length_210_cov_1.892617_g56590_i0 | PRJNA454503 | 56919 | 210 | 1.892617 | 3.9744957 | Anaeromyxobacter sp. K | 447217 | Bacteria | Bacteria | 172 | 1.36e-38 | NTclustered | gi|196170270|gb|CP001131.1| | 447217 | g56590 | i0 | 84.181 | 9.27619047619048 | 177 | 28 | 84 | 0 | 4 | 180 | 2511314 | 2511490 | Anaeromyxobacter sp. K, complete genome | blastn | 1948 | 172 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. K | ||
| 24668759 | 24668759 | PRJNA454503_P_NODE_54680_length_211_cov_0.866667_g54351_i0 | PRJNA454503 | 54680 | 211 | 0.866667 | 1.82866737 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 257 | 3.66e-64 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g54351 | i0 | 88.679 | 391.668246445498 | 212 | 23 | 100 | 1 | 1 | 211 | 7089187 | 7088976 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 82642 | 257 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 26727537 | 26727537 | PRJNA454503_P_NODE_69521_length_207_cov_0.890411_g69192_i0 | PRJNA454503 | 69521 | 207 | 0.890411 | 1.84315077 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 56.6 | 1.84e-8 | NR | HEY3803016.1 | 2212474 | g69192 | i0 | 80.6 | 0.521739130434783 | 36 | 7 | 52.2 | 0 | 99 | 206 | 4 | 39 | HEY3803016.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 108 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27138962 | 27138962 | PRJNA454503_P_NODE_36962_length_230_cov_1.988166_g36633_i0 | PRJNA454503 | 36962 | 230 | 1.988166 | 4.5727818 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 92.8 | 5.37e-20 | NR | HMV70023.1 | 2818507 | g36633 | i0 | 70.5 | 2.81739130434783 | 61 | 18 | 79.6 | 0 | 205 | 23 | 26 | 86 | HMV70023.1 MopE-related protein [Myxococcota bacterium] | diamond | 648 | 92.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27486952 | 27486952 | PRJNA454503_P_NODE_52503_length_213_cov_1.296053_g52174_i0 | PRJNA454503 | 52503 | 213 | 1.296053 | 2.76059289 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 88.6 | 1.8e-18 | NR | MDO8527159.1 | 2026735 | g52174 | i0 | 60 | 2.87323943661972 | 70 | 27 | 97.2 | 1 | 2 | 208 | 240 | 309 | MDO8527159.1 DUF1156 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 612 | 88.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28212874 | 28212874 | PRJNA454503_P_NODE_34986_length_233_cov_1.377907_g34657_i0 | PRJNA454503 | 34986 | 233 | 1.377907 | 3.21052331 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 81.3 | 1.5e-16 | NR | HVV86035.1 | 2212474 | g34657 | i0 | 65.6 | 0.785407725321888 | 61 | 21 | 78.5 | 0 | 197 | 15 | 15 | 75 | HVV86035.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 183 | 81.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30455638 | 30455638 | PRJNA454503_P_NODE_35833_length_232_cov_1.298246_g35504_i0 | PRJNA454503 | 35833 | 232 | 1.298246 | 3.01193072 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 115 | 1.09e-27 | NR | HMF41143.1 | 3058050 | g35504 | i0 | 81.6 | 0.982758620689655 | 76 | 14 | 98.3 | 0 | 231 | 4 | 11 | 86 | HMF41143.1 tetratricopeptide repeat protein [Polyangia bacterium] | diamond | 228 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 30549985 | 30549985 | PRJNA454503_P_NODE_32453_length_236_cov_1.485714_g32124_i0 | PRJNA454503 | 32453 | 236 | 1.485714 | 3.50628504 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 91.7 | 1.48e-19 | NR | MDB4937664.1 | 1971228 | g32124 | i0 | 66.7 | 4.70338983050847 | 78 | 21 | 92.8 | 1 | 229 | 11 | 29 | 106 | MDB4937664.1 Flagellar hook-length control protein FliK [Labilithrix sp.] | diamond | 1110 | 91.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31181665 | 31181665 | PRJNA454503_P_NODE_49435_length_216_cov_1.677419_g49106_i0 | PRJNA454503 | 49435 | 216 | 1.677419 | 3.62322504 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 90.9 | 1.68e-19 | NR | MBA3457857.1 | 2026735 | g49106 | i0 | 70 | 1.95833333333333 | 70 | 21 | 97.2 | 0 | 215 | 6 | 319 | 388 | MBA3457857.1 lamin tail domain-containing protein [Deltaproteobacteria bacterium] | diamond | 423 | 90.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31245155 | 31245155 | PRJNA454503_P_NODE_38475_length_229_cov_0.976190_g38146_i0 | PRJNA454503 | 38475 | 229 | 0.97619 | 2.2354751 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.5 | 0.0162 | NR | MBI3079629.1 | 2026735 | g38146 | i0 | 37.8 | 1.91266375545852 | 45 | 27 | 59 | 1 | 54 | 188 | 81 | 124 | MBI3079629.1 hydantoinase B/oxoprolinase family protein [Deltaproteobacteria bacterium] | diamond | 438 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31276709 | 31276709 | PRJNA454503_P_NODE_37775_length_229_cov_1.970238_g37446_i0 | PRJNA454503 | 37775 | 229 | 1.970238 | 4.51184502 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 65.1 | 7.21e-11 | NR | HET6345509.1 | 2818507 | g37446 | i0 | 55.9 | 0.890829694323144 | 68 | 30 | 89.1 | 0 | 24 | 227 | 36 | 103 | HET6345509.1 type II secretion system protein GspM [Myxococcota bacterium] | diamond | 204 | 65.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31434894 | 31434894 | PRJNA454503_P_NODE_38076_length_229_cov_1.547619_g37747_i0 | PRJNA454503 | 38076 | 229 | 1.547619 | 3.54404751 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 119 | 1.59e-29 | NR | HEX5058701.1 | 2212474 | g37747 | i0 | 75.3 | 0.956331877729258 | 73 | 18 | 95.6 | 0 | 1 | 219 | 420 | 492 | HEX5058701.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 219 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32194291 | 32194291 | PRJNA454503_P_NODE_43098_length_223_cov_1.604938_g42769_i0 | PRJNA454503 | 43098 | 223 | 1.604938 | 3.57901174 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 58.5 | 6.41e-8 | NR | MCA9594328.1 | 2026763 | g42769 | i0 | 64.9 | 0.901345291479821 | 37 | 13 | 49.8 | 0 | 113 | 223 | 1 | 37 | MCA9594328.1 4-hydroxy-tetrahydrodipicolinate synthase [Myxococcales bacterium] | diamond | 201 | 58.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32321118 | 32321118 | PRJNA454503_P_NODE_82659_length_203_cov_0.915493_g82330_i0 | PRJNA454503 | 82659 | 203 | 0.915493 | 1.85845079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 108 | 1.43e-27 | NR | MBA2542933.1 | 2026735 | g82330 | i0 | 74.6 | 0.990147783251232 | 67 | 17 | 99 | 0 | 3 | 203 | 41 | 107 | MBA2542933.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 201 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;