RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA781427" 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

  • PRJNA781427 · 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
2037809 2037809 PRJNA781427_P_NODE_86482_length_246_cov_0.890173_g85598_i0 PRJNA781427 86482 246 0.890173 2.18982558 Luteitalea sp. TBR-22 2802971 Bacteria Bacteria 132 2.77e-26   NTclustered gi|2131947417|dbj|AP024452.2| 2802971 g85598 i0 88.182 24.7113821138211 110 13 45 0 33 142 875760 875651 Vicinamibacteria bacterium TBR-22 DNA, complete genome blastn 6079 132 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp. TBR-22
3312920 3312920 PRJNA781427_P_NODE_81443_length_248_cov_0.880000_g80559_i0 PRJNA781427 81443 248 0.88 2.1824 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 128 3.62e-25   NTclustered gi|2874254056|emb|OY970380.1| 2651171 g80559 i0 91.398 0.375 93 8 38 0 1 93 2382874 2382966 MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1 blastn 93 128 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
10965632 10965632 PRJNA781427_P_NODE_74369_length_251_cov_0.865169_g73485_i0 PRJNA781427 74369 251 0.865169 2.17157419 Occallatibacter riparius 1002689 Bacteria Bacteria 303 5.69e-78   NTclustered gi|2304899767|gb|CP093313.1| 1002689 g73485 i0 88.71 5.62151394422311 248 28 99 0 4 251 2956018 2955771 Occallatibacter riparius strain DSM 25168 chromosome, complete genome blastn 1411 303 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Occallatibacter Occallatibacter riparius
13515862 13515862 PRJNA781427_P_NODE_97071_length_241_cov_0.916667_g96187_i0 PRJNA781427 97071 241 0.916667 2.20916747 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 235 2.0099999999999997e-57   NTclustered gi|2874253940|emb|OY970265.1| 171953 g96187 i0 84.232 8.29460580912863 241 38 100 0 1 241 1019706 1019946 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1 blastn 1999 235 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
16064535 16064535 PRJNA781427_P_NODE_96993_length_241_cov_0.916667_g96109_i0 PRJNA781427 96993 241 0.916667 2.20916747 Bryobacterales bacterium 2026791 Bacteria Bacteria 204 5.66e-48   NTclustered gi|2874253826|emb|OY969810.1| 2026791 g96109 i0 82.403 0.966804979253112 233 41 97 0 9 241 6925955 6925723 MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1 blastn 233 204 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
19888409 19888409 PRJNA781427_P_NODE_76536_length_250_cov_0.870056_g75652_i0 PRJNA781427 76536 250 0.870056 2.17514 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 141 4.7e-29   NTclustered gi|2874253950|emb|OY970275.1| 171953 g75652 i0 77.366 0.972 243 51 96 4 2 242 4449919 4450159 MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1 blastn 243 141 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
23714726 23714726 PRJNA781427_P_NODE_92719_length_243_cov_0.905882_g91835_i0 PRJNA781427 92719 243 0.905882 2.20129326 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 243 1.2100000000000004e-59   NTclustered gi|2874253786|emb|OY969770.1| 2952895 g91835 i0 85.652 1.95884773662551 230 33 95 0 2 231 4700532 4700761 MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1 blastn 476 243 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales 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);;