RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax_phylum = "Candidatus Sumerlaeota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Sumerlaeota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1240804 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
2899706 2899706 PRJNA1240804_P_NODE_71443_length_192_cov_1.839161_g71077_i0 PRJNA1240804 71443 192 1.839161 3.53118912 Candidatus Sumerlaea chitinivorans 2250252 Bacteria Bacteria 99 2.09e-16   NTclustered gi|1419285073|gb|CP030759.1| 2250252 g71077 i0 76.966 6.53125 178 38 93 3 1 178 160853 160679 Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome blastn 1254 99 1 Bacteria Bacteria candidate phyla   Candidatus Sumerlaeota Candidatus Sumerlaeia Candidatus Sumerlaeales Candidatus Sumerlaeaceae Candidatus Sumerlaea Candidatus Sumerlaea chitinivorans
11253531 11253531 PRJNA1240804_P_NODE_48449_length_221_cov_2.127907_g48083_i0 PRJNA1240804 48449 221 2.127907 4.70267447 Bacillati 1783272 Bacteria Bacteria 147 8.729999999999998e-31   NTclustered gi|1419285073|gb|CP030759.1| 2250252 g48083 i0 89.076 184.266968325792 119 12 53 1 18 135 160503 160621 Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome blastn 40723 148 0.993243243243243 Bacteria Bacteria candidate phyla   Candidatus Sumerlaeota Candidatus Sumerlaeia Candidatus Sumerlaeales Candidatus Sumerlaeaceae Candidatus Sumerlaea Candidatus Sumerlaea chitinivorans
22024790 22024790 PRJNA1240804_P_NODE_32138_length_259_cov_0.923810_g31772_i0 PRJNA1240804 32138 259 0.92381 2.3926679 Candidatus Sumerlaea chitinivorans 2250252 Bacteria Bacteria 278 3.58e-70   NTclustered gi|1419285073|gb|CP030759.1| 2250252 g31772 i0 87.552 164.737451737452 241 28 92 1 15 253 163010 163250 Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome blastn 42667 278 1 Bacteria Bacteria candidate phyla   Candidatus Sumerlaeota Candidatus Sumerlaeia Candidatus Sumerlaeales Candidatus Sumerlaeaceae Candidatus Sumerlaea Candidatus Sumerlaea chitinivorans

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