RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA688352" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA688352 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
4494856 4494856 PRJNA688352_P_NODE_9344_length_247_cov_0.885057_g9241_i0 PRJNA688352 9344 247 0.885057 2.18609079 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 185 2.11e-42   NTclustered gi|2874253862|emb|OY969918.1| 171953 g9241 i0 81.116 2.80566801619433 233 42 94 2 15 246 1019291 1019522 MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1 blastn 693 185 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14695861 14695861 PRJNA688352_P_NODE_7932_length_250_cov_0.870056_g7829_i0 PRJNA688352 7932 250 0.870056 2.17514 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 159 1.3e-34   NTclustered gi|2621701418|emb|OY760136.1| 2910147 g7829 i0 78.571 1.008 252 47 100 6 1 250 1579438 1579684 MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 blastn 252 159 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
17244869 17244869 PRJNA688352_P_NODE_8434_length_249_cov_0.875000_g8331_i0 PRJNA688352 8434 249 0.875 2.17875 Geothrix sp. 1962974 Bacteria Bacteria 159 1.29e-34   NTclustered gi|2515262989|gb|CP126625.1| 1962974 g8331 i0 80.189 0.85140562248996 212 42 85 0 1 212 34543 34754 MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome blastn 212 159 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.
18518929 18518929 PRJNA688352_P_NODE_11575_length_242_cov_0.911243_g11472_i0 PRJNA688352 11575 242 0.911243 2.20520806 Bryobacterales bacterium 2026791 Bacteria Bacteria 198 2.6499999999999997e-46   NTclustered gi|2874254061|emb|OY970385.1| 2026791 g11472 i0 81.481 97.3305785123967 243 43 100 2 1 242 771261 771502 MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 blastn 23554 198 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
18518930 18518930 PRJNA688352_P_NODE_11595_length_242_cov_0.911243_g11492_i0 PRJNA688352 11595 242 0.911243 2.20520806 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 56.5 0.002   NTclustered gi|2621703956|emb|OY762911.1| 2651171 g11492 i0 96.97 0.272727272727273 33 1 14 0 102 134 330447 330479 MAG: Thermoanaerobaculia bacterium isolate 14c23368-4dca-4d55-9b94-f295180eceef genome assembly, chromosome: 1 blastn 66 56.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
21069289 21069289 PRJNA688352_P_NODE_12317_length_241_cov_0.916667_g12214_i0 PRJNA688352 12317 241 0.916667 2.20916747 Bryobacterales bacterium 2026791 Bacteria Bacteria 95.3 3.55e-15   NTclustered gi|2874254061|emb|OY970385.1| 2026791 g12214 i0 85.714 1.86721991701245 91 11 38 2 1 91 1357734 1357646 MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 blastn 450 95.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales 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);;