RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 25 ✖

bioproject 1

  • PRJNA637219 · 25 ✖

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
1885060 1885060 PRJNA637219_S_NODE_7522_length_189_cov_2.185714_g7477_i0 PRJNA637219 7522 189 2.185714 4.13099946 Conticribra weissflogii 1577725 SAR_Eukaryotes SAR_Eukaryotes 100 5.71e-17   NTclustered gi|193875927|gb|EU810336.1| 1577725 g7477 i0 87.356 0.46031746031746 87 11 46 0 102 188 1252 1166 Thalassiosira weissflogii translation elongation factor 1A-like mRNA, partial cds blastn 87 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Conticribra Conticribra weissflogii
3159786 3159786 PRJNA637219_S_NODE_5743_length_209_cov_1.900000_g5698_i0 PRJNA637219 5743 209 1.9 3.971 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 246 7.83e-61   NTclustered gi|2996370|emb|AJ000967.1| 29204 g5698 i0 88.725 0.976076555023923 204 20 96 3 1 201 528 731 Cyclotella cryptica mRNA for fucoxanthin chlorophyll a/c binding protein, fcp5 blastn 204 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
8261907 8261907 PRJNA637219_S_NODE_10927_length_167_cov_0.864407_g10882_i0 PRJNA637219 10927 167 0.864407 1.44355969 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 276 7.64e-70   NTclustered gi|1169296926|gb|KY364696.1| 29205 g10882 i0 96.407 93.5089820359281 167 6 100 0 1 167 4015 4181 Cyclotella meneghiniana 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 15616 276 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
14637755 14637755 PRJNA637219_S_NODE_392_length_602_cov_8.372514_g349_i0 PRJNA637219 392 602 8.372514 50.40253428 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 350 1.89e-91   NTclustered gi|657012367|gb|KF302531.1| 2850 g349 i0 86.52 18.5083056478405 319 41 53 2 1 318 68 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 11142 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17186807 17186807 PRJNA637219_S_NODE_6514_length_200_cov_1.284768_g6469_i0 PRJNA637219 6514 200 1.284768 2.569536 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 82.4 2.22e-11   NTclustered gi|66968231|gb|DQ060240.1| 2853 g6469 i0 85 0.8 80 12 40 0 121 200 2259 2180 Cylindrotheca fusiformis chloroplast fucoxanthin chlorophyll a/c-binding protein precursor (cffcpA-1A) gene, complete cds; nuclear gene for chloroplast product blastn 160 82.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
22285959 22285959 PRJNA637219_S_NODE_6938_length_195_cov_1.397260_g6893_i0 PRJNA637219 6938 195 1.39726 2.724657 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 316 5.41e-82   NTclustered gi|74325165|ref|NC_007405.1| 35128 g6893 i0 95.897 97.5076923076923 195 8 100 0 1 195 12594 12400 Thalassiosira pseudonana mitochondrion, complete genome blastn 19014 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
23561468 23561468 PRJNA637219_S_NODE_6679_length_198_cov_1.369128_g6634_i0 PRJNA637219 6679 198 1.369128 2.71087344 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 115 2.16e-21   NTclustered gi|223993504|ref|XM_002286400.1| 296543 g6634 i0 94.595 1.16161616161616 74 4 37 0 125 198 649 576 Thalassiosira pseudonana CCMP1335 fucoxanthin chlorophyll a/c protein 8 (Lhcf9), mRNA blastn 230 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
26732458 26732458 PRJNA637219_S_NODE_8601_length_180_cov_1.167939_g8556_i0 PRJNA637219 8601 180 1.167939 2.1022902 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 93.2 2.39e-20   NR EJK50234.1 159749 g8556 i0 72.9 2.85 59 16 98.3 0 179 3 304 362 EJK50234.1 hypothetical protein THAOC_30825 [Thalassiosira oceanica] diamond 513 93.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27238972 27238972 PRJNA637219_S_NODE_10903_length_167_cov_0.864407_g10858_i0 PRJNA637219 10903 167 0.864407 1.44355969 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.94e-6   NR GAX20673.1 1519565 g10858 i0 50 0.862275449101796 48 24 86.2 0 148 5 163 210 GAX20673.1 hypothetical protein FisN_32Hh062 [Fistulifera solaris] diamond 144 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27491857 27491857 PRJNA637219_S_NODE_17063_length_161_cov_0.910714_g17018_i0 PRJNA637219 17063 161 0.910714 1.46624954 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.16e-15   NR KAI2490620.1 210448 g17018 i0 76.5 0.950310559006211 51 12 95 0 1 153 332 382 KAI2490620.1 hypothetical protein MHU86_23948 [Fragilaria crotonensis] diamond 153 79.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28072522 28072522 PRJNA637219_S_NODE_6165_length_204_cov_1.129032_g6120_i0 PRJNA637219 6165 204 1.129032 2.30322528 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 91.7 6.7e-21   NR CAB9502681.1 568900 g6120 i0 95.6 3.30882352941176 45 2 66.2 0 3 137 178 222 CAB9502681.1 40S ribosomal protein S20 [Seminavis robusta] diamond 675 92 0.996739130434783 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28849277 28849277 PRJNA637219_S_NODE_8028_length_185_cov_1.125000_g7983_i0 PRJNA637219 8028 185 1.125 2.08125 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 71.6 9.04e-13   NR XP_002183207.1 556484 g7983 i0 61.7 3.27567567567568 47 18 76.2 0 184 44 164 210 XP_002183207.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 606 71.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29146481 29146481 PRJNA637219_S_NODE_5109_length_218_cov_1.810651_g5064_i0 PRJNA637219 5109 218 1.810651 3.94721918 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 112 1.4700000000000002e-27   NR GFH58295.1 426638 g5064 i0 73.2 2.94495412844037 71 19 97.7 0 2 214 285 355 GFH58295.1 precursor of dehydrogenase pyruvate dehydrogenase E1 component beta subunit [Chaetoceros tenuissimus] diamond 642 113 0.991150442477876 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29430052 29430052 PRJNA637219_S_NODE_1609_length_350_cov_1.817276_g1564_i0 PRJNA637219 1609 350 1.817276 6.360466 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 3.67e-32   NR EJK47833.1 159749 g1564 i0 59.1 4.36285714285714 88 36 75.4 0 2 265 280 367 EJK47833.1 hypothetical protein THAOC_33424 [Thalassiosira oceanica] diamond 1527 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30143817 30143817 PRJNA637219_S_NODE_11772_length_166_cov_0.871795_g11727_i0 PRJNA637219 11772 166 0.871795 1.4471797 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 68.9 7.6e-12   NR CAB9521483.1 568900 g11727 i0 69 0.759036144578313 42 13 75.9 0 5 130 546 587 CAB9521483.1 expressed unknown protein [Seminavis robusta] diamond 126 68.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30156401 30156401 PRJNA637219_S_NODE_5472_length_213_cov_1.243902_g5427_i0 PRJNA637219 5472 213 1.243902 2.64951126 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 51.2 2.49e-5   NR GFH47969.1 426638 g5427 i0 75 0.985915492957746 24 6 33.8 0 2 73 444 467 GFH47969.1 hypothetical protein CTEN210_04445 [Chaetoceros tenuissimus] diamond 210 51.6 0.992248062015504 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31515854 31515854 PRJNA637219_S_NODE_16296_length_162_cov_0.902655_g16251_i0 PRJNA637219 16296 162 0.902655 1.4623011 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.11e-4   NR CAJ1954685.1 2856 g16251 i0 55.9 3.62962962962963 34 15 63 0 113 12 2207 2240 CAJ1954685.1 unnamed protein product [Cylindrotheca closterium] diamond 588 48.1 0.993762993762994 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31534930 31534930 PRJNA637219_S_NODE_13036_length_165_cov_0.879310_g12991_i0 PRJNA637219 13036 165 0.87931 1.4508615 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 109 4.17e-27   NR KAL3790377.1 29204 g12991 i0 87.3 1 55 7 100 0 1 165 267 321 KAL3790377.1 hypothetical protein HJC23_002763 [Cyclotella cryptica] diamond 165 109 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31895123 31895123 PRJNA637219_S_NODE_17357_length_161_cov_0.910714_g17312_i0 PRJNA637219 17357 161 0.910714 1.46624954 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 108 5.870000000000001e-26   NR KAL3797493.1 29204 g17312 i0 100 3.95031055900621 53 0 98.8 0 3 161 1166 1218 KAL3797493.1 hypothetical protein HJC23_009857 [Cyclotella cryptica] diamond 636 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31914319 31914319 PRJNA637219_S_NODE_4097_length_237_cov_2.946809_g4052_i0 PRJNA637219 4097 237 2.946809 6.98393733 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.86e-5   NR EJK50186.1 159749 g4052 i0 52.5 0.506329113924051 40 18 50.6 1 235 116 106 144 EJK50186.1 hypothetical protein THAOC_30872 [Thalassiosira oceanica] diamond 120 49.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32040928 32040928 PRJNA637219_S_NODE_9378_length_174_cov_2.032000_g9333_i0 PRJNA637219 9378 174 2.032 3.53568 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.13e-11   NR KAL3821798.1 382380 g9333 i0 97.1 1.75862068965517 34 1 58.6 0 172 71 457 490 KAL3821798.1 hypothetical protein ACHAXA_008791 [Cyclostephanos tholiformis] diamond 306 68.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32167644 32167644 PRJNA637219_S_NODE_16338_length_162_cov_0.884956_g16293_i0 PRJNA637219 16338 162 0.884956 1.43362872 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 50.1 3.33e-5   NR CAB9507965.1 568900 g16293 i0 43.2 2.37037037037037 44 25 81.5 0 4 135 1007 1050 CAB9507965.1 Sushi domain-containing protein 2 [Seminavis robusta] diamond 384 50.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32243570 32243570 PRJNA637219_S_NODE_15378_length_162_cov_1.805310_g15333_i0 PRJNA637219 15378 162 1.80531 2.9246022 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.54e-9   NR KAL3797500.1 29204 g15333 i0 96.2 1.92592592592593 26 1 48.1 0 162 85 319 344 KAL3797500.1 hypothetical protein HJC23_009864 [Cyclotella cryptica] diamond 312 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32559913 32559913 PRJNA637219_S_NODE_10619_length_167_cov_0.864407_g10574_i0 PRJNA637219 10619 167 0.864407 1.44355969 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 57.4 4.09e-8   NR XP_002183677.1 556484 g10574 i0 70.3 8.64071856287425 37 11 66.5 0 165 55 168 204 XP_002183677.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1443 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32578899 32578899 PRJNA637219_S_NODE_9719_length_172_cov_1.243902_g9674_i0 PRJNA637219 9719 172 1.243902 2.13951144 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 55.5 5.89e-8   NR AID23596.1 2850 g9674 i0 56.9 0.88953488372093 51 21 89 1 20 172 64 113 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 153 55.5 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);;