RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA169559 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
5468352 5468352 PRJNA169559_P_NODE_32465_length_255_cov_1.853982_g30389_i0 PRJNA169559 32465 255 1.853982 4.7276541 Tautonia sociabilis 2080755 Bacteria Bacteria 379 9.359999999999998e-101   NTclustered gi|2260349439|ref|NR_176521.1| 2080755 g30389 i0 92.188 106.286274509804 256 19 100 1 1 255 1219 1474 Tautonia sociabilis strain GM2012 16S ribosomal RNA, partial sequence blastn 27103 379 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia sociabilis
9293151 9293151 PRJNA169559_P_NODE_32848_length_254_cov_1.253333_g30772_i0 PRJNA169559 32848 254 1.253333 3.18346582 Humisphaera borealis 2807512 Bacteria Bacteria 128 3.72e-25   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g30772 i0 96.154 47.1614173228346 78 3 61 0 177 254 5062760 5062683 Humisphaera borealis strain M1803 chromosome, complete genome blastn 11979 128 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
22041688 22041688 PRJNA169559_P_NODE_38198_length_239_cov_2.338095_g36121_i0 PRJNA169559 38198 239 2.338095 5.58804705 Humisphaera borealis 2807512 Bacteria Bacteria 403 5.15e-108   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g36121 i0 97.071 74.7824267782427 239 7 100 0 1 239 5065002 5064764 Humisphaera borealis strain M1803 chromosome, complete genome blastn 17873 403 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis

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