contig_metadata
20 rows where bioproject = "PRJNA529241", tax_phylum = "Armatimonadota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13255166 | 13255166 | PRJNA529241_P_NODE_468831_length_152_cov_1.243478_g466509_i0 | PRJNA529241 | 468831 | 152 | 1.243478 | 1.89008656 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 189 | 9.08e-44 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g466509 | i0 | 89.404 | 137.414473684211 | 151 | 15 | 99 | 1 | 2 | 152 | 1878923 | 1879072 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 20887 | 189 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 18350847 | 18350847 | PRJNA529241_P_NODE_225635_length_173_cov_5.117647_g223313_i0 | PRJNA529241 | 225635 | 173 | 5.117647 | 8.85352931 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.8 | 0.015 | NTclustered | gi|2108374973|gb|CP070648.1| | 2033014 | g223313 | i0 | 100 | 0.161849710982659 | 28 | 0 | 16 | 0 | 130 | 157 | 4706665 | 4706638 | MAG: Armatimonadetes bacterium isolate bin88 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 22177314 | 22177314 | PRJNA529241_P_NODE_397318_length_173_cov_1.058824_g394996_i0 | PRJNA529241 | 397318 | 173 | 1.058824 | 1.83176552 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 222 | 1.05e-53 | NTclustered | gi|2621703062|emb|OY760504.1| | 2033014 | g394996 | i0 | 90.533 | 419.115606936416 | 169 | 14 | 97 | 2 | 6 | 173 | 2411145 | 2410978 | MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1 | blastn | 72507 | 222 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26697572 | 26697572 | PRJNA529241_P_NODE_482261_length_151_cov_6.666667_g479939_i0 | PRJNA529241 | 482261 | 151 | 6.666667 | 10.06666717 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 99 | 5.319999999999999e-23 | NR | MCX7687571.1 | 2682145 | g479939 | i0 | 98 | 0.993377483443709 | 50 | 0 | 97.4 | 1 | 3 | 149 | 190 | 239 | MCX7687571.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 150 | 99 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27235575 | 27235575 | PRJNA529241_P_NODE_548903_length_151_cov_2.877193_g546581_i0 | PRJNA529241 | 548903 | 151 | 2.877193 | 4.34456143 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 67.4 | 1.81e-11 | NR | HTQ09850.1 | 2682144 | g546581 | i0 | 47.8 | 1.82781456953642 | 92 | 5 | 97.4 | 1 | 5 | 151 | 54 | 145 | HTQ09850.1 P-type DNA transfer ATPase VirB11 [Fimbriimonadaceae bacterium] | diamond | 276 | 67.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27425357 | 27425357 | PRJNA529241_P_NODE_389303_length_173_cov_2.433824_g386981_i0 | PRJNA529241 | 389303 | 173 | 2.433824 | 4.21051552 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 51.2 | 1.47e-5 | NR | MBX7134344.1 | 2682144 | g386981 | i0 | 87.5 | 0.416184971098266 | 24 | 3 | 41.6 | 0 | 168 | 97 | 96 | 119 | MBX7134344.1 ATP-binding protein [Fimbriimonadaceae bacterium] | diamond | 72 | 51.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27709702 | 27709702 | PRJNA529241_P_NODE_190584_length_173_cov_6.948529_g188262_i0 | PRJNA529241 | 190584 | 173 | 6.948529 | 12.02095517 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 54.3 | 1.23e-7 | NR | GIV13035.1 | 2682145 | g188262 | i0 | 100 | 0.416184971098266 | 24 | 0 | 41.6 | 0 | 74 | 3 | 19 | 42 | GIV13035.1 MAG: hypothetical protein KatS3mg021_1317 [Fimbriimonadales bacterium] | diamond | 72 | 54.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27850592 | 27850592 | PRJNA529241_P_NODE_347564_length_173_cov_2.882353_g345242_i0 | PRJNA529241 | 347564 | 173 | 2.882353 | 4.98647069 | Bacteria | 2 | Bacteria | Bacteria | 54.7 | 8.7e-7 | NR | OLD46484.1 | 1805024 | g345242 | i0 | 100 | 4.33526011560694 | 25 | 0 | 43.4 | 0 | 173 | 99 | 34 | 58 | OLD46484.1 MAG: hypothetical protein AUI83_15115 [Armatimonadetes bacterium 13_1_40CM_3_65_7] | diamond | 750 | 54.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium 13_1_40CM_3_65_7 | ||||||
| 28751198 | 28751198 | PRJNA529241_P_NODE_337547_length_173_cov_3.058824_g335225_i0 | PRJNA529241 | 337547 | 173 | 3.058824 | 5.29176552 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 76.6 | 1.17e-14 | NR | MBM3457300.1 | 2033014 | g335225 | i0 | 66.7 | 1.94219653179191 | 57 | 13 | 98.8 | 1 | 172 | 2 | 128 | 178 | MBM3457300.1 IS630 family transposase [Armatimonadota bacterium] | diamond | 336 | 76.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29287930 | 29287930 | PRJNA529241_P_NODE_563709_length_150_cov_5.672566_g561387_i0 | PRJNA529241 | 563709 | 150 | 5.672566 | 8.508849 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 54.3 | 8.4e-7 | NR | HRF59254.1 | 2682144 | g561387 | i0 | 58.8 | 1.02 | 51 | 15 | 90 | 1 | 143 | 9 | 164 | 214 | HRF59254.1 cobalamin-independent methionine synthase II family protein [Fimbriimonadaceae bacterium] | diamond | 153 | 54.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29603347 | 29603347 | PRJNA529241_P_NODE_252630_length_173_cov_4.367647_g250308_i0 | PRJNA529241 | 252630 | 173 | 4.367647 | 7.5560293100000004 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 46.6 | 6.32e-4 | NR | WP_025227707.1 | 1005039 | g250308 | i0 | 84 | 0.433526011560694 | 25 | 4 | 43.4 | 0 | 99 | 173 | 391 | 415 | WP_025227707.1 glutamate--tRNA ligase [Fimbriimonas ginsengisoli] | diamond | 75 | 46.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 30582753 | 30582753 | PRJNA529241_P_NODE_232453_length_173_cov_4.897059_g230131_i0 | PRJNA529241 | 232453 | 173 | 4.897059 | 8.47191207 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 45.8 | 0.00117 | NR | WP_052547575.1 | 1005039 | g230131 | i0 | 69.6 | 1.23121387283237 | 23 | 7 | 39.9 | 0 | 75 | 7 | 357 | 379 | WP_052547575.1 helix-turn-helix domain-containing protein [Fimbriimonas ginsengisoli] | diamond | 213 | 45.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 30772781 | 30772781 | PRJNA529241_P_NODE_528634_length_151_cov_3.640351_g526312_i0 | PRJNA529241 | 528634 | 151 | 3.640351 | 5.49693001 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 54.3 | 8.44e-7 | NR | MCL6531706.1 | 2033014 | g526312 | i0 | 100 | 0.496688741721854 | 25 | 0 | 49.7 | 0 | 76 | 2 | 10 | 34 | MCL6531706.1 electron transfer flavoprotein subunit alpha/FixB family protein [Armatimonadota bacterium] | diamond | 75 | 54.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30993783 | 30993783 | PRJNA529241_P_NODE_22534_length_450_cov_5.305085_g20271_i0 | PRJNA529241 | 22534 | 450 | 5.305085 | 23.8728825 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 51.2 | 3.89e-4 | NR | GIV03844.1 | 2682145 | g20271 | i0 | 50 | 0.346666666666667 | 52 | 26 | 34.7 | 0 | 183 | 28 | 1351 | 1402 | GIV03844.1 MAG: hypothetical protein KatS3mg015_2674 [Fimbriimonadales bacterium] | diamond | 156 | 51.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31515016 | 31515016 | PRJNA529241_P_NODE_341196_length_173_cov_3.007353_g338874_i0 | PRJNA529241 | 341196 | 173 | 3.007353 | 5.20272069 | Bacteria | 2 | Bacteria | Bacteria | 92 | 6.21e-20 | NR | CUU10825.1 | 1661580 | g338874 | i0 | 75 | 2.21965317919075 | 64 | 9 | 98.8 | 1 | 3 | 173 | 247 | 310 | CUU10825.1 hypothetical protein GBSOP10_108112, partial [Armatimonadetes bacterium GBS] | diamond | 384 | 92 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium GBS | ||||||
| 31862509 | 31862509 | PRJNA529241_P_NODE_539237_length_151_cov_3.236842_g536915_i0 | PRJNA529241 | 539237 | 151 | 3.236842 | 4.88763142 | Bacillati | 1783272 | Bacteria | Bacteria | 74.7 | 5.66e-14 | NR | MBI3927009.1 | 2033014 | g536915 | i0 | 74.1 | 3.21854304635762 | 54 | 9 | 97.4 | 1 | 150 | 4 | 893 | 946 | MBI3927009.1 efflux RND transporter permease subunit [Armatimonadota bacterium] | diamond | 486 | 75.1 | 0.994673768308922 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31974008 | 31974008 | PRJNA529241_P_NODE_215158_length_173_cov_5.514706_g212836_i0 | PRJNA529241 | 215158 | 173 | 5.514706 | 9.54044138 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 55.8 | 3.28e-7 | NR | MDQ7850410.1 | 2033014 | g212836 | i0 | 62.2 | 0.780346820809249 | 45 | 15 | 74.6 | 1 | 130 | 2 | 41 | 85 | MDQ7850410.1 helix-turn-helix domain-containing protein [Armatimonadota bacterium] | diamond | 135 | 55.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32005722 | 32005722 | PRJNA529241_P_NODE_232918_length_173_cov_4.882353_g230596_i0 | PRJNA529241 | 232918 | 173 | 4.882353 | 8.44647069 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 55.8 | 3.44e-7 | NR | MCL6534256.1 | 2033014 | g230596 | i0 | 100 | 0.433526011560694 | 25 | 0 | 43.4 | 0 | 1 | 75 | 505 | 529 | MCL6534256.1 hypothetical protein [Armatimonadota bacterium] | diamond | 75 | 55.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32259243 | 32259243 | PRJNA529241_P_NODE_558178_length_150_cov_7.132743_g555856_i0 | PRJNA529241 | 558178 | 150 | 7.132743 | 10.6991145 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 55.1 | 4.63e-7 | NR | HLV80127.1 | 2739509 | g555856 | i0 | 44.2 | 3.08 | 77 | 16 | 100 | 1 | 1 | 150 | 265 | 341 | HLV80127.1 substrate-binding domain-containing protein [Chthonomonadaceae bacterium] | diamond | 462 | 55.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 32543829 | 32543829 | PRJNA529241_P_NODE_370679_length_173_cov_2.661765_g368357_i0 | PRJNA529241 | 370679 | 173 | 2.661765 | 4.60485345 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.4 | 5.7e-6 | NR | MBC8102816.1 | 2033014 | g368357 | i0 | 92 | 0.867052023121387 | 25 | 2 | 43.4 | 0 | 2 | 76 | 158 | 182 | MBC8102816.1 aspartate aminotransferase family protein [Armatimonadota bacterium] | diamond | 150 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;