contig_metadata
17 rows where bioproject = "PRJNA690592", tax_clade = "delta/epsilon subdivisions" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14700561 | 14700561 | PRJNA690592_S_NODE_29292_length_558_cov_2.072165_g28292_i0 | PRJNA690592 | 29292 | 558 | 2.072165 | 11.5626807 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 69.4 | 5.46e-7 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g28292 | i0 | 89.091 | 0.263440860215054 | 55 | 6 | 10 | 0 | 1 | 55 | 7226688 | 7226742 | Persicimonas caeni strain YN101 chromosome | blastn | 147 | 69.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 17249586 | 17249586 | PRJNA690592_S_NODE_38234_length_494_cov_7.308789_g37223_i0 | PRJNA690592 | 38234 | 494 | 7.308789 | 36.10541766 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 647 | 0 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g37223 | i0 | 90.342 | 201.779352226721 | 497 | 42 | 100 | 6 | 1 | 494 | 14674 | 14181 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 99679 | 647 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 19030646 | 19030646 | PRJNA690592_S_NODE_153555_length_274_cov_1.517413_g152541_i0 | PRJNA690592 | 153555 | 274 | 1.517413 | 4.15771162 | Myxococcota | 2818505 | Bacteria | Bacteria | 388 | 1.69e-103 | NTclustered | gi|386873771|gb|JQ624277.1| | 34034 | g152541 | i0 | 92.364 | 100.386861313869 | 275 | 17 | 99 | 4 | 1 | 273 | 402 | 674 | Uncultured delta proteobacterium clone OTU-2-AFB 16S ribosomal RNA gene, partial sequence | blastn | 27506 | 388 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 27177065 | 27177065 | PRJNA690592_S_NODE_136902_length_288_cov_1.400000_g135888_i0 | PRJNA690592 | 136902 | 288 | 1.4 | 4.032 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 49.7 | 2.3e-4 | NR | MBN1946190.1 | 2099667 | g135888 | i0 | 36.4 | 1.11458333333333 | 55 | 35 | 57.3 | 0 | 2 | 166 | 721 | 775 | MBN1946190.1 methionine--tRNA ligase [Bradymonadales bacterium] | diamond | 321 | 49.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 27662679 | 27662679 | PRJNA690592_S_NODE_110764_length_314_cov_2.128631_g109750_i0 | PRJNA690592 | 110764 | 314 | 2.128631 | 6.68390134 | Myxococcota | 2818505 | Bacteria | Bacteria | 70.9 | 2.66e-12 | NR | OGQ91000.1 | 1797895 | g109750 | i0 | 41.1 | 3 | 107 | 52 | 99.4 | 3 | 2 | 313 | 54 | 152 | OGQ91000.1 MAG: hypothetical protein A2289_00830 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 942 | 70.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27840384 | 27840384 | PRJNA690592_S_NODE_193984_length_248_cov_1.422857_g192970_i0 | PRJNA690592 | 193984 | 248 | 1.422857 | 3.52868536 | Deltaproteobacteria bacterium SM23_61 | 1703399 | Bacteria | Bacteria | 43.5 | 0.0197 | NR | KPK87443.1 | 1703399 | g192970 | i0 | 51.2 | 0.495967741935484 | 41 | 19 | 49.6 | 1 | 15 | 137 | 216 | 255 | KPK87443.1 MAG: 2-ketoisovalerate ferredoxin oxidoreductase [Deltaproteobacteria bacterium SM23_61] | diamond | 123 | 43.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium SM23_61 | ||||||
| 28250854 | 28250854 | PRJNA690592_S_NODE_142726_length_283_cov_1.271429_g141712_i0 | PRJNA690592 | 142726 | 283 | 1.271429 | 3.59814407 | Persicimonas sp. | 2766932 | Bacteria | Bacteria | 81.6 | 5.85e-16 | NR | MFP4598647.1 | 2766932 | g141712 | i0 | 47.9 | 1.96113074204947 | 94 | 47 | 99.6 | 1 | 282 | 1 | 52 | 143 | MFP4598647.1 DMT family transporter [Persicimonas sp.] | diamond | 555 | 81.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas sp. | |||
| 29083482 | 29083482 | PRJNA690592_S_NODE_94828_length_335_cov_0.881679_g93814_i0 | PRJNA690592 | 94828 | 335 | 0.881679 | 2.95362465 | Bacteria | 2 | Bacteria | Bacteria | 69.7 | 2.04e-13 | NR | PIU86675.1 | 1973970 | g93814 | i0 | 68.2 | 0.770149253731343 | 44 | 14 | 39.4 | 0 | 307 | 176 | 1 | 44 | PIU86675.1 MAG: hypothetical protein COS67_01255, partial [Deltaproteobacteria bacterium CG06_land_8_20_14_3_00_44_19] | diamond | 258 | 69.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG06_land_8_20_14_3_00_44_19 | ||||||
| 29292900 | 29292900 | PRJNA690592_S_NODE_152609_length_275_cov_1.143564_g151595_i0 | PRJNA690592 | 152609 | 275 | 1.143564 | 3.144801 | Deltaproteobacteria bacterium CG23_combo_of_CG | 2026735 | Bacteria | Bacteria | 43.9 | 0.018 | NR | PIP43900.1 | 1973981 | g151595 | i0 | 34.5 | 0.6 | 55 | 35 | 58.9 | 1 | 45 | 206 | 21 | 75 | PIP43900.1 MAG: hypothetical protein COX17_04520 [Deltaproteobacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_60_8] | diamond | 165 | 43.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_60_8 | ||||||
| 29356229 | 29356229 | PRJNA690592_S_NODE_216589_length_240_cov_2.305389_g215575_i0 | PRJNA690592 | 216589 | 240 | 2.305389 | 5.5329336 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21 | 2013749 | Bacteria | Bacteria | 46.2 | 5.89e-4 | NR | PKN23782.1 | 2013749 | g215575 | i0 | 42.9 | 0.7 | 56 | 28 | 65 | 1 | 10 | 165 | 29 | 84 | PKN23782.1 MAG: hypothetical protein CVU64_23660 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21] | diamond | 168 | 46.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21 | ||||||
| 30082369 | 30082369 | PRJNA690592_S_NODE_52812_length_429_cov_3.174157_g51798_i0 | PRJNA690592 | 52812 | 429 | 3.174157 | 13.61713353 | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | 1797895 | Bacteria | Bacteria | 106 | 2.46e-25 | NR | OGQ91000.1 | 1797895 | g51798 | i0 | 42.9 | 1.97202797202797 | 140 | 76 | 97.9 | 2 | 421 | 2 | 54 | 189 | OGQ91000.1 MAG: hypothetical protein A2289_00830 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 846 | 106 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 30114005 | 30114005 | PRJNA690592_S_NODE_197912_length_247_cov_0.885057_g196898_i0 | PRJNA690592 | 197912 | 247 | 0.885057 | 2.18609079 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 97.1 | 2.92e-21 | NR | WP_141201199.1 | 2292766 | g196898 | i0 | 59.3 | 4.89473684210526 | 81 | 33 | 98.4 | 0 | 247 | 5 | 377 | 457 | WP_141201199.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Persicimonas caeni] | diamond | 1209 | 97.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 30967243 | 30967243 | PRJNA690592_S_NODE_13954_length_786_cov_2.208976_g13087_i0 | PRJNA690592 | 13954 | 786 | 2.208976 | 17.36255136 | Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_6 | 2026735 | Bacteria | Bacteria | 148 | 2.86e-40 | NR | OGQ79495.1 | 1797894 | g13087 | i0 | 44.9 | 0.603053435114504 | 158 | 86 | 60.3 | 1 | 312 | 785 | 10 | 166 | OGQ79495.1 MAG: hypothetical protein A3F90_11480 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19] | diamond | 474 | 148 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19 | ||||||
| 31389634 | 31389634 | PRJNA690592_S_NODE_184056_length_252_cov_1.290503_g183042_i0 | PRJNA690592 | 184056 | 252 | 1.290503 | 3.25206756 | Bacteria | 2 | Bacteria | Bacteria | 89.4 | 1.58e-19 | NR | OGQ24388.1 | 1797848 | g183042 | i0 | 53 | 7.90476190476191 | 83 | 39 | 98.8 | 0 | 2 | 250 | 140 | 222 | OGQ24388.1 MAG: hypothetical protein A2138_06805 [Deltaproteobacteria bacterium RBG_16_71_12] | diamond | 1992 | 89.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_16_71_12 | ||||||
| 31852478 | 31852478 | PRJNA690592_S_NODE_60177_length_406_cov_1.042042_g59163_i0 | PRJNA690592 | 60177 | 406 | 1.042042 | 4.23069052 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 143 | 1.58e-36 | NR | WP_146958785.1 | 2600177 | g59163 | i0 | 53.8 | 5.88916256157635 | 132 | 58 | 97.5 | 2 | 397 | 2 | 689 | 817 | WP_146958785.1 bifunctional aspartate kinase/diaminopimelate decarboxylase [Microvenator marinus] | diamond | 2391 | 143 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 31947178 | 31947178 | PRJNA690592_S_NODE_114397_length_310_cov_1.624473_g113383_i0 | PRJNA690592 | 114397 | 310 | 1.624473 | 5.0358663 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 60.5 | 4.95e-8 | NR | MBN1946190.1 | 2099667 | g113383 | i0 | 33.3 | 0.958064516129032 | 99 | 64 | 95.8 | 1 | 298 | 2 | 562 | 658 | MBN1946190.1 methionine--tRNA ligase [Bradymonadales bacterium] | diamond | 297 | 60.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 31958783 | 31958783 | PRJNA690592_S_NODE_14957_length_761_cov_3.559593_g14070_i0 | PRJNA690592 | 14957 | 761 | 3.559593 | 27.08850273 | delta/epsilon subdivisions | 68525 | Bacteria | Bacteria | 150 | 6.67e-40 | NR | PJB39919.1 | 1973967 | g14070 | i0 | 40.7 | 10.3521681997372 | 236 | 110 | 91.9 | 7 | 759 | 61 | 93 | 301 | PJB39919.1 MAG: hypothetical protein CO108_16020 [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12] | diamond | 7878 | 150 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 |
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);;