RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA312899", 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 · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA312899 · 11 ✖

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
9992489 9992489 PRJNA312899_P_NODE_1468_length_1260_cov_8.578860_g1331_i0 PRJNA312899 1468 1260 8.57886 108.093636 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 246 2.67e-74   NR GFH61200.1 426638 g1331 i0 46.1 14.7238095238095 319 155 75.7 8 130 1083 34 336 GFH61200.1 arginase [Chaetoceros tenuissimus] diamond 18552 248 0.991935483870968 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
18231242 18231242 PRJNA312899_P_NODE_42415_length_272_cov_12.278027_g41973_i0 PRJNA312899 42415 272 12.278027 33.39623344 Mayamaea atomus 431391 SAR_Eukaryotes SAR_Eukaryotes 459 1.2599999999999999e-124   NTclustered gi|168145942|emb|AM710599.1| 431391 g41973 i0 97.059 100.636029411765 272 8 100 0 1 272 16 287 Mayamaea atomus partial 28S rRNA gene, strain AT-199Gel01 blastn 27373 459 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea atomus
20780910 20780910 PRJNA312899_P_NODE_3357_length_944_cov_62.530726_g3105_i0 PRJNA312899 3357 944 62.530726 590.29005344 root 1 Root_unresolved Root_unresolved 343 9.949999999999999e-116   NR XP_002181180.1 556484 g3105 i0 79.5 3.31779661016949 205 42 65.1 0 3 617 13 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 3132 346 0.991329479768786 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27344919 27344919 PRJNA312899_P_NODE_51583_length_241_cov_3.145833_g51141_i0 PRJNA312899 51583 241 3.145833 7.58145753 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 67.4 7.6e-11   NR GFH46944.1 426638 g51141 i0 59.2 10.3070539419087 49 20 61 0 1 147 754 802 GFH46944.1 hypothetical protein CTEN210_03418 [Chaetoceros tenuissimus] diamond 2484 67.8 0.994100294985251 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27990403 27990403 PRJNA312899_P_NODE_83325_length_172_cov_2.471545_g82883_i0 PRJNA312899 83325 172 2.471545 4.2510574 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 57.8 5.79e-8   NR GAX21341.1 1519565 g82883 i0 92.9 0.488372093023256 28 2 48.8 0 18 101 264 291 GAX21341.1 hypothetical protein FisN_6Lh094 [Fistulifera solaris] diamond 84 57.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28891687 28891687 PRJNA312899_P_NODE_1688_length_1201_cov_35.958333_g1527_i0 PRJNA312899 1688 1201 35.958333 431.85957933 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 320 3.7599999999999995e-103   NR CAJ1954423.1 2856 g1527 i0 61.6 3.85179017485429 250 90 61.9 3 1178 435 144 389 CAJ1954423.1 unnamed protein product [Cylindrotheca closterium] diamond 4626 320 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30516593 30516593 PRJNA312899_P_NODE_102753_length_161_cov_0.910714_g102311_i0 PRJNA312899 102753 161 0.910714 1.46624954 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 58.5 3.24e-8   NR GFH48276.1 426638 g102311 i0 53.7 11.2360248447205 54 24 98.8 1 2 160 958 1011 GFH48276.1 exportin1 [Chaetoceros tenuissimus] diamond 1809 58.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30660548 30660548 PRJNA312899_P_NODE_63193_length_210_cov_1.677019_g62751_i0 PRJNA312899 63193 210 1.677019 3.5217399 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.3 8.5e-7   NR KAG7359130.1 303405 g62751 i0 56.8 11.2 37 16 52.9 0 196 86 43 79 KAG7359130.1 cyclophilin type peptidyl-prolyl cis-trans isomerase [Nitzschia inconspicua] diamond 2352 54.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32065712 32065712 PRJNA312899_P_NODE_34958_length_307_cov_4.744186_g34516_i0 PRJNA312899 34958 307 4.744186 14.56465102 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.2e-5   NR VEU39200.1 183589 g34516 i0 46.9 1.07491856677524 49 25 46.9 1 30 173 590 638 VEU39200.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 330 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
32399926 32399926 PRJNA312899_P_NODE_78839_length_180_cov_5.145038_g78397_i0 PRJNA312899 78839 180 5.1450379999999996 9.2610684 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.55e-5   NR KAL3789159.1 29204 g78397 i0 75.8 2.75 33 8 55 0 3 101 95 127 KAL3789159.1 hypothetical protein HJC23_012248 [Cyclotella cryptica] diamond 495 50.1 0.992015968063872 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32413951 32413951 PRJNA312899_P_NODE_40499_length_280_cov_7.121212_g40057_i0 PRJNA312899 40499 280 7.121212 19.9393936 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 81.6 6.05e-17   NR GKY94132.1 2872254 g40057 i0 48.9 0.942857142857143 88 43 92.1 1 12 269 25 112 GKY94132.1 hypothetical protein MPSEU_000379300 [Mayamaea pseudoterrestris] diamond 264 81.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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