RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA415856 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
419181 419181 PRJNA415856_P_NODE_17281_length_209_cov_2.187500_g17020_i0 PRJNA415856 17281 209 2.1875 4.571875 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 318 1.64e-82   NTclustered gi|2874254102|emb|OY970185.1| 1672391 g17020 i0 94.634 199.732057416268 205 11 98 0 1 205 1860271 1860475 MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 blastn 41744 318 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
4246506 4246506 PRJNA415856_P_NODE_50764_length_161_cov_2.732143_g50503_i0 PRJNA415856 50764 161 2.732143 4.39875023 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 137 3.59e-28   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g50503 i0 94.505 3.96894409937888 91 2 57 3 71 161 1333754 1333841 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 639 137 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
5523174 5523174 PRJNA415856_P_NODE_47805_length_163_cov_0.877193_g47544_i0 PRJNA415856 47805 163 0.877193 1.42982459 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 108 2.86e-19   NTclustered gi|2891482138|emb|OZ219871.1| 2026734 g47544 i0 91.139 39.2944785276074 79 7 48 0 85 163 326202 326124 MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 5 blastn 6405 108 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
6797074 6797074 PRJNA415856_P_NODE_33326_length_169_cov_1.666667_g33065_i0 PRJNA415856 33326 169 1.666667 2.81666723 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 204 3.68e-48   NTclustered gi|2874253835|emb|OY969885.1| 1672391 g33065 i0 89.024 30.6508875739645 164 18 97 0 6 169 2093416 2093253 MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 blastn 5180 204 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
9347483 9347483 PRJNA415856_P_NODE_40488_length_165_cov_0.879310_g40227_i0 PRJNA415856 40488 165 0.87931 1.4508615 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 95.3 2.26e-15   NTclustered gi|2874253835|emb|OY969885.1| 1672391 g40227 i0 90.278 3.83030303030303 72 7 44 0 94 165 1581359 1581288 MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 blastn 632 95.3 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
10623207 10623207 PRJNA415856_P_NODE_34229_length_168_cov_1.285714_g33968_i0 PRJNA415856 34229 168 1.285714 2.15999952 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 233 4.7e-57   NTclustered gi|2874254102|emb|OY970185.1| 1672391 g33968 i0 91.716 114.27380952381 169 13 100 1 1 168 1857610 1857778 MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 blastn 19198 233 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
10623331 10623331 PRJNA415856_P_NODE_50549_length_162_cov_0.902655_g50288_i0 PRJNA415856 50549 162 0.902655 1.4623011 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 58.4 2.9e-4   NTclustered gi|2891482389|emb|OZ220079.1| 2026734 g50288 i0 92.683 0.253086419753086 41 2 25 1 32 71 65697 65657 MAG: Dehalococcoidia bacterium isolate 04bbb1fd-b304-46d8-a6aa-ea4a1f3e4c6b genome assembly, chromosome: 24 blastn 41 58.4 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
11898347 11898347 PRJNA415856_P_NODE_970_length_985_cov_24.576923_g825_i0 PRJNA415856 970 985 24.576923 242.08269155 uncultured Chloroflexota bacterium 166587 Bacteria Bacteria 1445 0   NTclustered gi|339646703|gb|JN037916.1| 166587 g825 i0 95.301 89.7695431472081 915 36 93 5 74 985 1 911 Uncultured Chloroflexi bacterium clone UHAS5.43 16S ribosomal RNA gene, partial sequence blastn 88423 1445 1 Bacteria   Bacillati Chloroflexota         uncultured Chloroflexota bacterium
15721819 15721819 PRJNA415856_P_NODE_11953_length_253_cov_2.568627_g11692_i0 PRJNA415856 11953 253 2.568627 6.49862631 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 379 9.269999999999998e-101   NTclustered gi|2874253725|emb|OY969567.1| 1672391 g11692 i0 93.701 430.97233201581 254 14 100 2 1 253 2429531 2429783 MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1 blastn 109036 379 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
15721826 15721826 PRJNA415856_P_NODE_12773_length_243_cov_2.494845_g12512_i0 PRJNA415856 12773 243 2.494845 6.06247335 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 370 5.32e-98   NTclustered gi|2874254066|emb|OY970149.1| 1672391 g12512 i0 94.215 492.716049382716 242 14 99 0 2 243 565837 566078 MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 blastn 119730 370 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
15722021 15722021 PRJNA415856_P_NODE_35113_length_167_cov_0.906780_g34852_i0 PRJNA415856 35113 167 0.90678 1.5143226 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 237 3.599999999999999e-58   NTclustered gi|2874253725|emb|OY969567.1| 1672391 g34852 i0 92.262 28.0059880239521 168 12 100 1 1 167 2427288 2427455 MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1 blastn 4677 237 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
18270996 18270996 PRJNA415856_P_NODE_40735_length_165_cov_0.879310_g40474_i0 PRJNA415856 40735 165 0.87931 1.4508615 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 196 6.02e-46   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g40474 i0 89.61 210.793939393939 154 16 93 0 4 157 274127 273974 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 34781 196 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
20209680 20209680 PRJNA415856_P_NODE_33216_length_169_cov_1.700000_g32955_i0 PRJNA415856 33216 169 1.7 2.873 Bacteria 2 Bacteria Bacteria 52.8 0.014   NTclustered gi|2621703428|emb|OY760687.1| 2026734 g32955 i0 100 0.331360946745562 28 0 17 0 76 103 2697616 2697589 MAG: Dehalococcoidia bacterium isolate f61cd74f-1a2a-4ce7-9ca1-272438b93162 genome assembly, chromosome: 1 blastn 56 52.8 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
22095951 22095951 PRJNA415856_P_NODE_9038_length_299_cov_1.952000_g8777_i0 PRJNA415856 9038 299 1.952 5.83648 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 243 1.5400000000000001e-59   NTclustered gi|2874253812|emb|OY969796.1| 1672391 g8777 i0 82.292 158.270903010033 288 43 95 7 16 299 3034307 3034590 MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 blastn 47323 243 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium

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