RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1012699" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA1012699 · 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
5260884 5260884 PRJNA1012699_P_NODE_345_length_575_cov_3.585657_g315_i0 PRJNA1012699 345 575 3.585657 20.61752775 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 782 0   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g315 i0 91.364 232.368695652174 579 39 99 9 1 572 1599871 1600445 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 133612 782 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
7380069 7380069 PRJNA1012699_P_NODE_2846_length_251_cov_1.685393_g2814_i0 PRJNA1012699 2846 251 1.685393 4.23033643 Telmatocola 1382832 Bacteria Bacteria 300 7.36e-77   NTclustered gi|2041266541|gb|CP074694.1| 1123043 g2814 i0 88.189 172.581673306773 254 26 99 4 2 251 3724028 3723775 Telmatocola sphagniphila strain SP2T chromosome, complete genome blastn 43318 300 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Telmatocola Telmatocola sphagniphila
24384157 24384157 PRJNA1012699_P_NODE_960_length_370_cov_1.898990_g928_i0 PRJNA1012699 960 370 1.89899 7.026263 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 527 4.7899999999999985e-145   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g928 i0 92.513 45.1324324324324 374 18 99 8 1 369 1600412 1600780 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 16699 527 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7

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