RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA615175", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA615175 · 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
6253524 6253524 PRJNA615175_P_NODE_2885_length_915_cov_2.964371_g2752_i0 PRJNA615175 2885 915 2.964371 27.12399465 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 171 2.4499999999999997e-37   NTclustered gi|1169296927|gb|KY364697.1| 29204 g2752 i0 92.5 20.8393442622951 120 7 25 2 534 652 4344 4462 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 19068 171 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29543312 29543312 PRJNA615175_P_NODE_10670_length_447_cov_2.850267_g10502_i0 PRJNA615175 10670 447 2.850267 12.74069349 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 94 4.7e-19   NR KAI2510264.1 210448 g10502 i0 31.1 3.7248322147651 164 96 98.7 1 7 447 750 913 KAI2510264.1 hypothetical protein MHU86_4142 [Fragilaria crotonensis] diamond 1665 94 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31913628 31913628 PRJNA615175_P_NODE_27177_length_255_cov_1.269231_g27009_i0 PRJNA615175 27177 255 1.269231 3.23653905 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 108 2.0800000000000004e-27   NR GFH59293.1 426638 g27009 i0 58.5 1.94117647058824 82 34 96.5 0 247 2 46 127 GFH59293.1 RL9, ribosomal protein 9 [Chaetoceros tenuissimus] diamond 495 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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