RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 3 ✖

bioproject 1

  • PRJNA1160211 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_phylum 0

tax_kingdom 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
9967209 9967209 PRJNA1160211_S_NODE_91928_length_473_cov_6.772500_g90705_i0 PRJNA1160211 91928 473 6.7725 32.033925 Bacteria 2 Bacteria Bacteria 259 2.53e-64   NTclustered gi|82617822|gb|DQ267495.1| 357894 g90705 i0 77.681 220.589852008457 457 80 94 19 16 458 4314 4762 Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence blastn 104339 261 0.992337164750958 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium DeepAnt-1F12
16887794 16887794 PRJNA1160211_S_NODE_67554_length_528_cov_2.276923_g66353_i0 PRJNA1160211 67554 528 2.276923 12.02215344 Microvenator marinus 2600177 Bacteria Bacteria 649 0   NTclustered gi|1722470586|gb|CP042467.1| 2600177 g66353 i0 88.826 190.060606060606 528 59 100 0 1 528 4172210 4171683 Microvenator marinus strain V1718 chromosome, complete genome blastn 100352 649 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Microvenatoraceae Microvenator Microvenator marinus
18890356 18890356 PRJNA1160211_S_NODE_296755_length_215_cov_280.866197_g295522_i0 PRJNA1160211 296755 215 280.866197 603.86232355 Bacteria 2 Bacteria Bacteria 348 2.16e-91   NTclustered gi|523452606|gb|KF183026.1| 34034 g295522 i0 95.814 99.5720930232558 215 9 100 0 1 215 502 288 Uncultured delta proteobacterium clone S2-090 16S ribosomal RNA gene, partial sequence blastn 21408 348 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium

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);;