RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA642647", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Acidobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA642647 · 16 ✖

tax_clade 0

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
5721533 5721533 PRJNA642647_P_NODE_4625_length_169_cov_2.712121_g4575_i0 PRJNA642647 4625 169 2.712121 4.58348449 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 141 2.93e-29   NTclustered gi|2874253885|emb|OY970060.1| 171953 g4575 i0 98.734 76.2426035502959 79 1 73 0 1 79 4841101 4841179 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 12885 141 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
6996577 6996577 PRJNA642647_P_NODE_6586_length_151_cov_1.070175_g6536_i0 PRJNA642647 6586 151 1.070175 1.61596425 Acidobacteriota bacterium 1978231 Bacteria Bacteria 85.9 5.24e-18   NR MBK8810769.1 1978231 g6536 i0 79.6 1.96688741721854 49 10 97.4 0 4 150 286 334 MBK8810769.1 PBSX family phage terminase large subunit [Acidobacteriota bacterium] diamond 297 85.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
8271297 8271297 PRJNA642647_P_NODE_5207_length_166_cov_2.441860_g5157_i0 PRJNA642647 5207 166 2.44186 4.0534876 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 71.6 8.48e-13   NR MEN6533728.1 2212468 g5157 i0 54.2 1.30120481927711 72 14 95.8 1 5 163 181 252 MEN6533728.1 terminase family protein [Bryobacteraceae bacterium] diamond 216 71.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
9546589 9546589 PRJNA642647_P_NODE_4468_length_172_cov_1.000000_g4418_i0 PRJNA642647 4468 172 1 1.72 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 252 1.33e-62   NTclustered gi|2874254091|emb|OY970174.1| 171953 g4418 i0 93.491 129.046511627907 169 11 98 0 1 169 4357964 4357796 MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 blastn 22196 252 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
10822190 10822190 PRJNA642647_P_NODE_1189_length_321_cov_5.802817_g1139_i0 PRJNA642647 1189 321 5.802817 18.62704257 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 455 1.96e-123   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g1139 i0 92.698 101.233644859813 315 23 98 0 1 315 634209 633895 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 32496 455 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183
12097390 12097390 PRJNA642647_P_NODE_1190_length_321_cov_5.327465_g1140_i0 PRJNA642647 1190 321 5.327465 17.10116265 Paludibaculum fermentans 1473598 Bacteria Bacteria 449 9.14e-122   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g1140 i0 92.188 100.464174454829 320 21 99 4 4 321 4785457 4785140 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 32249 449 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
12097395 12097395 PRJNA642647_P_NODE_1930_length_249_cov_2.509434_g1880_i0 PRJNA642647 1930 249 2.509434 6.24849066 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 374 4.23e-99   NTclustered gi|76574295|gb|DQ139443.1| 171953 g1880 i0 94.262 106.056224899598 244 14 98 0 6 249 810 567 Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence blastn 26408 374 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14646938 14646938 PRJNA642647_P_NODE_6572_length_151_cov_1.324561_g6522_i0 PRJNA642647 6572 151 1.324561 2.00008711 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 233 4.1e-57   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g6522 i0 95.833 6.41059602649007 144 6 95 0 5 148 635088 635231 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 968 233 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183
24844325 24844325 PRJNA642647_P_NODE_4280_length_175_cov_1.391304_g4230_i0 PRJNA642647 4280 175 1.391304 2.434782 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 180 6.48e-41   NTclustered gi|76574295|gb|DQ139443.1| 171953 g4230 i0 92.126 120.531428571429 127 10 73 0 33 159 151 277 Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence blastn 21093 180 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
26732707 26732707 PRJNA642647_P_NODE_4281_length_175_cov_1.333333_g4231_i0 PRJNA642647 4281 175 1.333333 2.33333275 Chloracidobacterium sp. 2099375 Bacteria Bacteria 43.1 0.00146   NR MBK7804312.1 2099375 g4231 i0 36.7 0.84 49 31 84 0 171 25 10 58 MBK7804312.1 hypothetical protein [Chloracidobacterium sp.] diamond 147 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
27492124 27492124 PRJNA642647_P_NODE_5283_length_165_cov_2.851562_g5233_i0 PRJNA642647 5283 165 2.851562 4.7050773 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 60.5 1.06e-10   NR HOQ62224.1 2910147 g5233 i0 66.7 0.709090909090909 39 13 70.9 0 35 151 4 42 HOQ62224.1 hypothetical protein [Vicinamibacterales bacterium] diamond 117 60.5 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
27523613 27523613 PRJNA642647_P_NODE_6683_length_150_cov_2.283186_g6633_i0 PRJNA642647 6683 150 2.283186 3.424779 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 73.9 2.59e-15   NR HEY0658743.1 2283092 g6633 i0 63.3 0.98 49 18 98 0 149 3 47 95 HEY0658743.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 147 73.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27965605 27965605 PRJNA642647_P_NODE_6685_length_150_cov_2.141593_g6635_i0 PRJNA642647 6685 150 2.141593 3.2123895 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 50.1 2.74e-5   NR HUR97952.1 2283092 g6635 i0 54.2 0.96 48 22 96 0 147 4 170 217 HUR97952.1 PD-(D/E)XK nuclease family protein [Pyrinomonadaceae bacterium] diamond 144 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29796839 29796839 PRJNA642647_P_NODE_4471_length_172_cov_0.859259_g4421_i0 PRJNA642647 4471 172 0.859259 1.47792548 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 111 1.13e-30   NR HOK48165.1 2212468 g4421 i0 100 0.959302325581395 55 0 95.9 0 5 169 1 55 HOK48165.1 hypothetical protein [Bryobacteraceae bacterium] diamond 165 111 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
30492065 30492065 PRJNA642647_P_NODE_5033_length_166_cov_2.937984_g4983_i0 PRJNA642647 5033 166 2.937984 4.87705344 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 45.8 0.00105   NR HXO21049.1 2651171 g4983 i0 95.8 1.73493975903614 24 1 43.4 0 3 74 729 752 HXO21049.1 endopeptidase La [Thermoanaerobaculia bacterium] diamond 288 45.8 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
30504358 30504358 PRJNA642647_P_NODE_6493_length_151_cov_3.087719_g6443_i0 PRJNA642647 6493 151 3.087719 4.66245569 Bacteria 2 Bacteria Bacteria 57.4 5.57e-8   NR KXK01571.1 1617423 g6443 i0 96.2 1.54966887417219 26 1 51.7 0 2 79 183 208 KXK01571.1 MAG: DNA protecting protein DprA [Acidobacteria bacterium OLB17] diamond 234 57.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium OLB17

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;