RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA638138" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA638138 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1885475 1885475 PRJNA638138_P_NODE_16642_length_269_cov_1.571429_g16427_i0 PRJNA638138 16642 269 1.571429 4.22714401 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 254 6.29e-63   NTclustered gi|2874254049|emb|OY970373.1| 171953 g16427 i0 88.318 6.76208178438662 214 21 79 4 9 220 3306296 3306507 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 1819 254 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
3160400 3160400 PRJNA638138_P_NODE_29703_length_245_cov_0.877907_g29488_i0 PRJNA638138 29703 245 0.877907 2.15087215 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 154 5.89e-33   NTclustered gi|2874253836|emb|OY969886.1| 171953 g29488 i0 79.73 6.35510204081633 222 37 91 6 19 239 2022234 2022020 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 1557 154 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
6987875 6987875 PRJNA638138_P_NODE_22906_length_249_cov_0.875000_g22691_i0 PRJNA638138 22906 249 0.875 2.17875 Granulicella tundricola 940615 Bacteria Bacteria 60.2 1.35e-4   NTclustered gi|321161386|gb|CP002480.1| 1198114 g22691 i0 100 0.1285140562249 32 0 13 0 96 127 1367819 1367788 Granulicella tundricola MP5ACTX9, complete genome blastn 32 60.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella tundricola
9537766 9537766 PRJNA638138_P_NODE_10608_length_324_cov_1.183267_g10393_i0 PRJNA638138 10608 324 1.183267 3.83378508 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 54.7 0.008   NTclustered gi|2874253836|emb|OY969886.1| 171953 g10393 i0 96.875 0.0987654320987654 32 1 10 0 261 292 2338543 2338574 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 32 54.7 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9537868 9537868 PRJNA638138_P_NODE_18848_length_253_cov_0.738889_g18633_i0 PRJNA638138 18848 253 0.738889 1.86938917 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 54.7 0.006   NTclustered gi|2874253836|emb|OY969886.1| 171953 g18633 i0 96.875 0.126482213438735 32 1 13 0 213 244 2338574 2338543 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 32 54.7 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
10813683 10813683 PRJNA638138_P_NODE_33289_length_242_cov_0.911243_g33074_i0 PRJNA638138 33289 242 0.911243 2.20520806 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 95.3 3.57e-15   NTclustered gi|2874254056|emb|OY970380.1| 2651171 g33074 i0 85.106 0.644628099173554 94 13 38 1 1 93 2507711 2507804 MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1 blastn 156 95.3 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
13363483 13363483 PRJNA638138_P_NODE_17571_length_262_cov_1.476190_g17356_i0 PRJNA638138 17571 262 1.47619 3.8676178 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 185 2.26e-42   NTclustered gi|2874253678|emb|OY969112.1| 171953 g17356 i0 86.982 0.645038167938931 169 17 64 5 4 170 1276467 1276632 MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 blastn 169 185 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;