RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB8827 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
25801609 25801609 PRJEB8827c_S_NODE_2963_length_153_cov_1.559322_g2950_i0 PRJEB8827 2963 153 1.559322 2.38576266 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.6e-11   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g2950 i0 94.34 5.13725490196078 53 3 35 0 99 151 5273 5325 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 786 82.4 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
26073823 26073823 PRJEB8827c_S_NODE_3341_length_150_cov_3.060870_g3328_i0 PRJEB8827 3341 150 3.06087 4.591305 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 1.99e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g3328 i0 85.714 1.4 105 15 70 0 37 141 321 425 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26074509 26074509 PRJEB8827f_S_NODE_901_length_377_cov_4.225146_g881_i0 PRJEB8827 901 377 4.225146 15.92880042 Nitzschia sp. IriIs 1884248 SAR_Eukaryotes SAR_Eukaryotes 143 2.07e-29   NTclustered gi|944186150|dbj|LC052662.1| 1444690 g881 i0 86.26 1.78249336870027 131 18 35 0 7 137 1231 1361 Nitzschia sp. IriIs04 sec61alpha mRNA for Sec61alpha, complete cds blastn 672 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. IriIs04
26074607 26074607 PRJEB8827g_S_NODE_621_length_344_cov_97302.326861_g600_i0 PRJEB8827 621 344 97302.326861 334720.00440184 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 87.9 8.92e-13   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g600 i0 84.615 12.3720930232558 91 10 26 4 125 214 5360 5273 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 4256 87.9 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
26210101 26210101 PRJEB8827d_S_NODE_26222_length_159_cov_3.693548_g26218_i0 PRJEB8827 26222 159 3.693548 5.87274132 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 2.14e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g26218 i0 85.714 1.32075471698113 105 15 66 0 34 138 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26210868 26210868 PRJEB8827h_S_NODE_1486_length_256_cov_5.497738_g1467_i0 PRJEB8827 1486 256 5.497738 14.07420928 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.06e-15   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g1467 i0 75.194 6.26171875 258 36 96 23 11 255 25464 25222 Coscinodiscus granii mitochondrion, complete sequence blastn 1603 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
26482831 26482831 PRJEB8827g_S_NODE_1032_length_289_cov_2407.248031_g1011_i0 PRJEB8827 1032 289 2407.248031 6956.94680959 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 111 4.35e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g1011 i0 85.714 14.7958477508651 105 15 36 0 145 249 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 4276 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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