RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1031674 · 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
166650 166650 PRJNA1031674_P_NODE_18521_length_264_cov_2.581152_g18310_i0 PRJNA1031674 18521 264 2.581152 6.81424128 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 433 7.37e-117   NTclustered gi|76574290|gb|DQ139438.1| 171953 g18310 i0 96.212 33.2992424242424 264 10 100 0 1 264 1267 1004 Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence blastn 8791 433 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
1006747 1006747 PRJNA1031674_P_NODE_15321_length_276_cov_1.517241_g15110_i0 PRJNA1031674 15321 276 1.517241 4.18758516 Bacteria 2 Bacteria Bacteria 283 8.269999999999999e-72   NTclustered gi|76574295|gb|DQ139443.1| 171953 g15110 i0 90.323 171.721014492754 217 20 79 1 36 252 1285 1500 Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence blastn 47395 285 0.992982456140351 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
5269656 5269656 PRJNA1031674_P_NODE_26485_length_243_cov_2.264706_g26274_i0 PRJNA1031674 26485 243 2.264706 5.50323558 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 366 6.89e-97   NTclustered gi|76574288|gb|DQ139436.1| 171953 g26274 i0 93.852 59.0205761316872 244 13 100 2 1 243 406 164 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 14342 366 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
7819344 7819344 PRJNA1031674_P_NODE_19907_length_259_cov_1.655914_g19696_i0 PRJNA1031674 19907 259 1.655914 4.28881726 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 143 1.36e-29   NTclustered gi|2874253692|emb|OY969418.1| 171953 g19696 i0 83.333 4.25096525096525 156 24 60 2 26 180 6468655 6468501 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 1101 143 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9094096 9094096 PRJNA1031674_P_NODE_10708_length_291_cov_1.848624_g10497_i0 PRJNA1031674 10708 291 1.848624 5.37949584 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 167 9.23e-37   NTclustered gi|2874253885|emb|OY970060.1| 171953 g10497 i0 85.897 0.536082474226804 156 22 54 0 129 284 3649506 3649661 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 156 167 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
12485668 12485668 PRJNA1031674_P_NODE_18810_length_263_cov_2.231579_g18599_i0 PRJNA1031674 18810 263 2.231579 5.86905277 Bacteria 2 Bacteria Bacteria 486 5.5499999999999986e-133   NTclustered gi|157142601|gb|EU122872.1| 171953 g18599 i0 100 100.106463878327 263 0 100 0 1 263 23 285 Uncultured Acidobacteria bacterium clone REF-104 16S ribosomal RNA gene, partial sequence blastn 26328 486 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20567757 20567757 PRJNA1031674_P_NODE_16457_length_272_cov_1.547739_g16246_i0 PRJNA1031674 16457 272 1.547739 4.20985008 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 462 9.729999999999999e-126   NTclustered gi|2874253959|emb|OY970284.1| 2651171 g16246 i0 97.426 137.136029411765 272 6 100 1 1 272 6633468 6633198 MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1 blastn 37301 462 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;