RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1126661", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1126661 · 6 ✖

analysis 1

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
27607537 27607537 PRJNA1126661_P_NODE_15564_length_326_cov_4.897233_g15035_i0 PRJNA1126661 15564 326 4.897233 15.96497958 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.24e-8   NR KAL3808413.1 382380 g15035 i0 64.6 0.441717791411043 48 17 44.2 0 2 145 633 680 KAL3808413.1 hypothetical protein ACHAXA_001350 [Cyclostephanos tholiformis] diamond 144 62.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28207119 28207119 PRJNA1126661_P_NODE_38826_length_301_cov_3.859649_g38297_i0 PRJNA1126661 38826 301 3.859649 11.61754349 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 88.6 5.95e-18   NR KAK1733475.1 267567 g38297 i0 52.8 2.65116279069767 89 29 75.7 1 1 228 619 707 KAK1733475.1 glutamine synthetase (class 3) [Skeletonema marinoi] diamond 798 88.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28965254 28965254 PRJNA1126661_P_NODE_48588_length_297_cov_7.258929_g48059_i0 PRJNA1126661 48588 297 7.258929 21.55901913 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0409   NR KAL3901224.1 3061772 g48059 i0 44.4 1.03030303030303 54 27 51.5 1 155 3 22 75 KAL3901224.1 MAG: hypothetical protein SGARI_006104 [Bacillariaceae sp.] diamond 306 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30059252 30059252 PRJNA1126661_P_NODE_43931_length_300_cov_4.145374_g43402_i0 PRJNA1126661 43931 300 4.145374 12.436122 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 100 2.77e-22   NR CAJ1958394.1 2856 g43402 i0 92 1.86 50 4 50 0 150 299 894 943 CAJ1958394.1 unnamed protein product [Cylindrotheca closterium] diamond 558 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31418212 31418212 PRJNA1126661_P_NODE_84676_length_208_cov_6.125926_g84146_i0 PRJNA1126661 84676 208 6.125926 12.74192608 root 1 Root_unresolved Root_unresolved 77 1.98e-15   NR KAI2510657.1 210448 g84146 i0 56.5 3.85096153846154 69 30 99.5 0 208 2 107 175 KAI2510657.1 hypothetical protein MHU86_3768 [Fragilaria crotonensis] diamond 801 77.4 0.994832041343669 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32346859 32346859 PRJNA1126661_P_NODE_36539_length_301_cov_5.035088_g36010_i0 PRJNA1126661 36539 301 5.035088 15.15561488 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 59.7 7.94e-8   NR XP_002180535.1 556484 g36010 i0 52.9 1.16611295681063 68 29 64.8 2 8 202 248 315 XP_002180535.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 351 59.7 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);;