RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA773247", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA773247 · 12 ✖

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
26989820 26989820 PRJNA773247_P_NODE_24182_length_286_cov_1.690141_g24098_i0 PRJNA773247 24182 286 1.690141 4.83380326 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 68.2 7.37e-11   NR GKY98501.1 2872254 g24098 i0 44.2 0.996503496503496 95 51 99.7 2 2 286 791 883 GKY98501.1 hypothetical protein MPSEU_000807200 [Mayamaea pseudoterrestris] diamond 285 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27211162 27211162 PRJNA773247_P_NODE_30282_length_251_cov_0.865169_g30198_i0 PRJNA773247 30282 251 0.865169 2.17157419 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 122 2.91e-30   NR KAG7344151.1 303405 g30198 i0 71.1 1.9840637450199201 83 24 99.2 0 250 2 647 729 KAG7344151.1 translation initiation factor IF-2 [Nitzschia inconspicua] diamond 498 122 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27536863 27536863 PRJNA773247_P_NODE_28723_length_258_cov_11.902703_g28639_i0 PRJNA773247 28723 258 11.902703 30.70897374 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.024   NR GAX16917.1 1519565 g28639 i0 60.7 0.593023255813954 28 11 32.6 0 258 175 101 128 GAX16917.1 hypothetical protein FisN_5Hh294 [Fistulifera solaris] diamond 153 42.7 0.992974238875878 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27653763 27653763 PRJNA773247_P_NODE_19544_length_325_cov_18.214286_g19460_i0 PRJNA773247 19544 325 18.214286 59.1964295 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.78e-11   NR GAX22568.1 1519565 g19460 i0 49.3 0.636923076923077 69 29 63.7 1 1 207 166 228 GAX22568.1 apolipoprotein D and lipocalin family protein [Fistulifera solaris] diamond 207 68.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27969266 27969266 PRJNA773247_P_NODE_1205_length_1778_cov_32.453959_g1177_i0 PRJNA773247 1205 1778 32.453959 577.03139102 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 488 8.809999999999998e-166   NR CAB9518296.1 568900 g1177 i0 67.5 0.642857142857143 381 102 63.1 5 194 1315 33 398 CAB9518296.1 Dehydrogenase [Seminavis robusta] diamond 1143 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28537844 28537844 PRJNA773247_P_NODE_16087_length_367_cov_3.782313_g16003_i0 PRJNA773247 16087 367 3.782313 13.88108871 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 101 1.3299999999999999e-24   NR CAB9517348.1 568900 g16003 i0 48.5 0.841961852861035 103 46 84.2 1 311 3 35 130 CAB9517348.1 expressed unknown protein [Seminavis robusta] diamond 309 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28979873 28979873 PRJNA773247_P_NODE_23368_length_292_cov_1.360731_g23284_i0 PRJNA773247 23368 292 1.360731 3.97333452 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 104 1.2699999999999999e-24   NR KAI2508640.1 210448 g23284 i0 56.8 2.96917808219178 95 36 95.5 3 5 283 94 185 KAI2508640.1 putative catecholamine binding [Fragilaria crotonensis] diamond 867 104 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29990163 29990163 PRJNA773247_P_NODE_24811_length_282_cov_1.272727_g24727_i0 PRJNA773247 24811 282 1.272727 3.58909014 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 105 7.15e-24   NR GKY98501.1 2872254 g24727 i0 51.6 0.98936170212766 93 45 98.9 0 2 280 906 998 GKY98501.1 hypothetical protein MPSEU_000807200 [Mayamaea pseudoterrestris] diamond 279 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30432859 30432859 PRJNA773247_P_NODE_5913_length_712_cov_7.538341_g5833_i0 PRJNA773247 5913 712 7.538341 53.67298792 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.0137   NR GFH51278.1 426638 g5833 i0 41 0.257022471910112 61 34 25.7 1 74 256 182 240 GFH51278.1 hypothetical protein CTEN210_07754 [Chaetoceros tenuissimus] diamond 183 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32076456 32076456 PRJNA773247_P_NODE_16058_length_367_cov_18.448980_g15974_i0 PRJNA773247 16058 367 18.44898 67.7077566 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0396   NR EJK57904.1 159749 g15974 i0 35.3 0.948228882833787 116 67 88.3 3 43 366 262 377 EJK57904.1 hypothetical protein THAOC_22013 [Thalassiosira oceanica] diamond 348 44.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32771437 32771437 PRJNA773247_P_NODE_32720_length_245_cov_8.796512_g32636_i0 PRJNA773247 32720 245 8.796512 21.5514544 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 93.2 4.34e-22   NR GAX12443.1 1519565 g32636 i0 84.1 0.538775510204082 44 7 53.9 0 243 112 97 140 GAX12443.1 hypothetical protein FisN_2Hh277 [Fistulifera solaris] diamond 132 93.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32834434 32834434 PRJNA773247_P_NODE_13640_length_408_cov_1.149254_g13556_i0 PRJNA773247 13640 408 1.149254 4.68895632 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 74.7 1.36e-12   NR KAL3910512.1 3061772 g13556 i0 52.6 2.43382352941176 97 43 69.1 2 126 407 47 143 KAL3910512.1 MAG: hypothetical protein SGARI_002089 [Bacillariaceae sp.] diamond 993 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.

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