RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1180292 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2868654 2868654 PRJNA1180292_P_NODE_12423_length_243_cov_0.917647_g12291_i0 PRJNA1180292 12423 243 0.917647 2.22988221 Terriglobus albidus 1592106 Bacteria Bacteria 322 1.51e-83   NTclustered gi|1724546188|gb|CP042806.1| 1592106 g12291 i0 90.574 59.2427983539095 244 21 100 2 1 243 6048442 6048684 Terriglobus albidus strain ORNL chromosome, complete genome blastn 14396 322 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus albidus
11796455 11796455 PRJNA1180292_P_NODE_12390_length_243_cov_0.917647_g12258_i0 PRJNA1180292 12390 243 0.917647 2.22988221 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 326 1.17e-84   NTclustered gi|2874253836|emb|OY969886.1| 171953 g12258 i0 90.947 179.489711934156 243 21 100 1 1 243 1650982 1651223 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 43616 326 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
11796558 11796558 PRJNA1180292_P_NODE_9850_length_249_cov_0.886364_g9718_i0 PRJNA1180292 9850 249 0.886364 2.20704636 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 154 6.01e-33   NTclustered gi|2874253678|emb|OY969112.1| 171953 g9718 i0 80.374 28.1726907630522 214 32 84 9 41 249 1708196 1707988 MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 blastn 7015 154 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14346873 14346873 PRJNA1180292_P_NODE_12092_length_244_cov_0.912281_g11960_i0 PRJNA1180292 12092 244 0.912281 2.22596564 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 178 3.48e-40   NTclustered gi|2874253956|emb|OY970281.1| 194844 g11960 i0 80.165 3.19672131147541 242 44 98 4 1 240 3843552 3843313 MAG: uncultured Acidobacteriaceae bacterium isolate MFD00008.bin.c.2 genome assembly, chromosome: 1 blastn 780 178 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
14346952 14346952 PRJNA1180292_P_NODE_8392_length_252_cov_0.871508_g8260_i0 PRJNA1180292 8392 252 0.871508 2.19620016 uncultured Holophaga sp. 188475 Bacteria Bacteria 145 3.66e-30   NTclustered gi|2621785467|emb|OY781925.1| 188475 g8260 i0 83.019 0.630952380952381 159 27 63 0 4 162 2808166 2808324 MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1 blastn 159 145 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Holophaga uncultured Holophaga sp.
21994517 21994517 PRJNA1180292_P_NODE_12958_length_242_cov_0.923077_g12826_i0 PRJNA1180292 12958 242 0.923077 2.23384634 uncultured Thermoanaerobaculia bacterium 3036248 Bacteria Bacteria 161 3.47e-35   NTclustered gi|2518540615|emb|OX638294.1| 3036248 g12826 i0 84.906 65.8140495867769 159 24 66 0 1 159 4590750 4590592 MAG: uncultured Thermoanaerobaculia bacterium isolate 42478a12-5572-4d71-959b-92ffd854a98d genome assembly, chromosome: 1 blastn 15927 161 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       uncultured Thermoanaerobaculia bacterium
21994599 21994599 PRJNA1180292_P_NODE_9258_length_250_cov_0.881356_g9126_i0 PRJNA1180292 9258 250 0.881356 2.20339 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 187 5.949999999999998e-43   NTclustered gi|2874254167|emb|OY970399.1| 171953 g9126 i0 81.858 4.084 226 38 89 3 5 227 1266026 1265801 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1 blastn 1021 187 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
23270069 23270069 PRJNA1180292_P_NODE_7919_length_253_cov_0.866667_g7787_i0 PRJNA1180292 7919 253 0.866667 2.19266751 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 298 2.6699999999999998e-76   NTclustered gi|2874253862|emb|OY969918.1| 171953 g7787 i0 88.048 98.2885375494071 251 30 99 0 1 251 975466 975216 MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1 blastn 24867 298 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);;