RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 32 ✖

bioproject 1

  • PRJNA1010662 · 32 ✖

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
3981386 3981386 PRJNA1010662_P_NODE_8124_length_199_cov_2.413333_g8065_i0 PRJNA1010662 8124 199 2.413333 4.80253267 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 111 2.81e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g8065 i0 85.714 1.05527638190955 105 15 53 0 50 154 321 425 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11633476 11633476 PRJNA1010662_P_NODE_16850_length_162_cov_0.911504_g16791_i0 PRJNA1010662 16850 162 0.911504 1.47663648 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|224013023|ref|XM_002295128.1| 296543 g16791 i0 100 0.901234567901235 30 0 19 0 21 50 1711 1740 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 146 56.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
12908537 12908537 PRJNA1010662_P_NODE_13171_length_168_cov_0.865546_g13112_i0 PRJNA1010662 13171 168 0.865546 1.45411728 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 79.7 4.82e-16   NR GKY90625.1 2872254 g13112 i0 74.5 3.92857142857143 55 14 98.2 0 2 166 18 72 GKY90625.1 cell division protein kinase 1 [Mayamaea pseudoterrestris] diamond 660 79.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
18006678 18006678 PRJNA1010662_P_NODE_5335_length_234_cov_1.118919_g5276_i0 PRJNA1010662 5335 234 1.118919 2.61827046 Sundstroemia setigera 3005 SAR_Eukaryotes SAR_Eukaryotes 191 4.26e-44   NTclustered gi|2172620428|ref|NC_059919.1| 3005 g5276 i0 85.792 81.6880341880342 183 23 77 3 43 223 24963 24782 Rhizosolenia setigera isolate CNS00456 mitochondrion, complete genome blastn 19115 191 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
20127910 20127910 PRJNA1010662_P_NODE_8876_length_192_cov_2.132867_g8817_i0 PRJNA1010662 8876 192 2.132867 4.09510464 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 99 3.1e-22   NR KAL3779050.1 29204 g8817 i0 78.1 7 64 14 100 0 192 1 420 483 KAL3779050.1 hypothetical protein HJC23_005990 [Cyclotella cryptica] diamond 1344 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
20556015 20556015 PRJNA1010662_P_NODE_1237_length_459_cov_1.617073_g1178_i0 PRJNA1010662 1237 459 1.617073 7.42236507 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 318 3.9799999999999996e-82   NTclustered gi|657012367|gb|KF302531.1| 2850 g1178 i0 83.976 32.9259259259259 337 48 73 6 118 451 16 349 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 15113 318 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
21831627 21831627 PRJNA1010662_P_NODE_13218_length_167_cov_3.084746_g13159_i0 PRJNA1010662 13218 167 3.084746 5.15152582 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.37e-19   NR GKY99276.1 2872254 g13159 i0 80 0.988023952095808 55 11 98.8 0 167 3 290 344 GKY99276.1 hypothetical protein MPSEU_000882700 [Mayamaea pseudoterrestris] diamond 165 90.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
25227667 25227667 PRJNA1010662_P_NODE_1300_length_449_cov_2.827500_g1241_i0 PRJNA1010662 1300 449 2.8275 12.695475 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 228 8.6e-70   NR GKZ00886.1 2872254 g1241 i0 71.1 7.94432071269488 149 43 99.6 0 1 447 306 454 GKZ00886.1 hypothetical protein MPSEU_001040300 [Mayamaea pseudoterrestris] diamond 3567 228 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26717582 26717582 PRJNA1010662_P_NODE_9021_length_191_cov_2.147887_g8962_i0 PRJNA1010662 9021 191 2.147887 4.10246417 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 80.1 6.99e-17   NR CAB9514451.1 568900 g8962 i0 70.5 0.691099476439791 44 13 69.1 0 1 132 136 179 CAB9514451.1 EFh [Seminavis robusta] diamond 132 80.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27319145 27319145 PRJNA1010662_P_NODE_12723_length_168_cov_1.747899_g12664_i0 PRJNA1010662 12723 168 1.747899 2.93647032 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 59.3 1.75e-8   NR KAK1739882.1 267567 g12664 i0 46.7 2.07142857142857 60 27 98.2 1 168 4 165 224 KAK1739882.1 ribonuclease T2 family protein [Skeletonema marinoi] diamond 348 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27729890 27729890 PRJNA1010662_P_NODE_14504_length_165_cov_1.750000_g14445_i0 PRJNA1010662 14504 165 1.75 2.8875 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.71e-15   NR GKY99949.1 2872254 g14445 i0 70.4 2.94545454545455 54 16 98.2 0 3 164 5 58 GKY99949.1 hypothetical protein MPSEU_000948500 [Mayamaea pseudoterrestris] diamond 486 76.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27855768 27855768 PRJNA1010662_P_NODE_13405_length_167_cov_1.135593_g13346_i0 PRJNA1010662 13405 167 1.135593 1.89644031 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.13e-9   NR EJK47776.1 159749 g13346 i0 55.8 0.934131736526946 52 22 91.6 1 2 154 367 418 EJK47776.1 hypothetical protein THAOC_33484 [Thalassiosira oceanica] diamond 156 62.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28013903 28013903 PRJNA1010662_P_NODE_8445_length_196_cov_2.802721_g8386_i0 PRJNA1010662 8445 196 2.802721 5.49333316 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.13e-21   NR KAI2505670.1 210448 g8386 i0 79.2 5.70918367346939 53 11 81.1 0 37 195 6 58 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 1119 94.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28518990 28518990 PRJNA1010662_P_NODE_15627_length_164_cov_0.886957_g15568_i0 PRJNA1010662 15627 164 0.886957 1.45460948 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 47 4.09e-4   NR GFH53639.1 426638 g15568 i0 59.5 0.676829268292683 37 15 67.7 0 111 1 594 630 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 111 47 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28645305 28645305 PRJNA1010662_P_NODE_6287_length_219_cov_2.035294_g6228_i0 PRJNA1010662 6287 219 2.035294 4.45729386 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 89 1.26e-19   NR GFH59886.1 426638 g6228 i0 69.1 0.931506849315068 68 21 93.2 0 205 2 50 117 GFH59886.1 hypothetical protein CTEN210_16362 [Chaetoceros tenuissimus] diamond 204 89 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28961176 28961176 PRJNA1010662_P_NODE_10988_length_178_cov_0.937984_g10929_i0 PRJNA1010662 10988 178 0.937984 1.66961152 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 55.8 3.15e-7   NR CAJ1963562.1 2856 g10929 i0 44.8 2.91573033707865 58 32 97.8 0 5 178 214 271 CAJ1963562.1 unnamed protein product [Cylindrotheca closterium] diamond 519 55.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29119033 29119033 PRJNA1010662_P_NODE_11229_length_176_cov_1.598425_g11170_i0 PRJNA1010662 11229 176 1.598425 2.813228 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 67 2.94e-11   NR KAL3827427.1 382380 g11170 i0 69.6 4.36363636363636 46 14 78.4 0 153 16 88 133 KAL3827427.1 hypothetical protein ACHAXA_003161 [Cyclostephanos tholiformis] diamond 768 67 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
29245126 29245126 PRJNA1010662_P_NODE_16049_length_163_cov_0.912281_g15990_i0 PRJNA1010662 16049 163 0.912281 1.48701803 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 59.3 1.81e-8   NR KAK1743064.1 267567 g15990 i0 53.7 2.98159509202454 54 24 99.4 1 162 1 351 403 KAK1743064.1 GABA-B receptor-like protein [Skeletonema marinoi] diamond 486 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29245128 29245128 PRJNA1010662_P_NODE_16489_length_162_cov_1.353982_g16430_i0 PRJNA1010662 16489 162 1.353982 2.19345084 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 62 1.94e-9   NR GFH53639.1 426638 g16430 i0 59.1 0.814814814814815 44 18 81.5 0 133 2 395 438 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 132 62 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29529355 29529355 PRJNA1010662_P_NODE_7350_length_207_cov_1.778481_g7291_i0 PRJNA1010662 7350 207 1.778481 3.68145567 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 60.5 9.41e-10   NR OEU21323.1 635003 g7291 i0 47.4 1.63768115942029 57 30 82.6 0 172 2 14 70 OEU21323.1 S60 ribosomal protein L31 [Fragilariopsis cylindrus CCMP1102] diamond 339 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
29553070 29553070 PRJNA1010662_P_NODE_4330_length_254_cov_2.439024_g4271_i0 PRJNA1010662 4330 254 2.439024 6.19512096 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.7 2.98e-21   NR EJK48333.1 159749 g4271 i0 61 1.81889763779528 77 30 90.9 0 253 23 64 140 EJK48333.1 hypothetical protein THAOC_32880, partial [Thalassiosira oceanica] diamond 462 91.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29686826 29686826 PRJNA1010662_P_NODE_15390_length_164_cov_0.904348_g15331_i0 PRJNA1010662 15390 164 0.904348 1.48313072 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.16e-15   NR XP_002185632.1 556484 g15331 i0 71.4 1.02439024390244 56 14 98.8 1 164 3 481 536 XP_002185632.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 168 79.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29710827 29710827 PRJNA1010662_P_NODE_13190_length_168_cov_0.865546_g13131_i0 PRJNA1010662 13190 168 0.865546 1.45411728 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.09e-11   NR CAB9516552.1 568900 g13131 i0 53.6 4 56 26 100 0 1 168 348 403 CAB9516552.1 Nucleotide-diphospho-sugar transferase [Seminavis robusta] diamond 672 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29900800 29900800 PRJNA1010662_P_NODE_8271_length_198_cov_1.744966_g8212_i0 PRJNA1010662 8271 198 1.744966 3.45503268 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 4.34e-28   NR AID23530.1 2850 g8212 i0 75.8 29 66 16 100 0 198 1 11 76 AID23530.1 40S ribosomal protein, partial [Phaeodactylum tricornutum] diamond 5742 107 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30658939 30658939 PRJNA1010662_P_NODE_6933_length_212_cov_0.957055_g6874_i0 PRJNA1010662 6933 212 0.957055 2.0289566 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.8000000000000001e-22   NR KAI2494985.1 210448 g6874 i0 65.7 12.8632075471698 70 24 99.1 0 2 211 150 219 KAI2494985.1 3-hydroxyacyl-CoA dehydrogenase [Fragilaria crotonensis] diamond 2727 97.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30848551 30848551 PRJNA1010662_P_NODE_11594_length_174_cov_1.240000_g11535_i0 PRJNA1010662 11594 174 1.24 2.1576 root 1 Root_unresolved Root_unresolved 52 7.79e-6   NR KAL3826897.1 382380 g11535 i0 41.5 2.74137931034483 53 31 91.4 0 16 174 185 237 KAL3826897.1 hypothetical protein ACHAXA_000865 [Cyclostephanos tholiformis] diamond 477 52.4 0.99236641221374 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30919364 30919364 PRJNA1010662_P_NODE_10594_length_180_cov_1.572519_g10535_i0 PRJNA1010662 10594 180 1.572519 2.8305341999999998 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00176   NR CAB9518259.1 568900 g10535 i0 40.4 0.95 57 33 93.3 1 8 175 52 108 CAB9518259.1 protocatechuate 3,4-dioxygenase [Seminavis robusta] diamond 171 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31456716 31456716 PRJNA1010662_P_NODE_13316_length_167_cov_1.669492_g13257_i0 PRJNA1010662 13316 167 1.669492 2.78805164 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 66.2 6.81e-11   NR CAB9499310.1 568900 g13257 i0 58.2 2.89221556886228 55 23 98.8 0 167 3 808 862 CAB9499310.1 PHD and ring finger domains 1 [Seminavis robusta] diamond 483 66.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31646211 31646211 PRJNA1010662_P_NODE_14317_length_166_cov_0.880342_g14258_i0 PRJNA1010662 14317 166 0.880342 1.46136772 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 78.2 4.23e-15   NR KAL3823068.1 382380 g14258 i0 69.8 1.89759036144578 53 16 95.8 0 7 165 282 334 KAL3823068.1 hypothetical protein ACHAXA_011120 [Cyclostephanos tholiformis] diamond 315 78.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
31867658 31867658 PRJNA1010662_P_NODE_15597_length_164_cov_0.886957_g15538_i0 PRJNA1010662 15597 164 0.886957 1.45460948 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 62 2.02e-9   NR XP_002182908.1 556484 g15538 i0 78.4 1.48170731707317 37 8 67.7 0 131 21 1 37 XP_002182908.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 243 62 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32564139 32564139 PRJNA1010662_P_NODE_16559_length_162_cov_0.920354_g16500_i0 PRJNA1010662 16559 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.86e-6   NR KAI2504666.1 210448 g16500 i0 44.7 3.85185185185185 47 26 87 0 3 143 298 344 KAI2504666.1 casein kinase II subunit beta [Fragilaria crotonensis] diamond 624 53.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32752840 32752840 PRJNA1010662_P_NODE_4000_length_263_cov_1.542056_g3941_i0 PRJNA1010662 4000 263 1.542056 4.05560728 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 83.6 2e-16   NR KAG7338941.1 303405 g3941 i0 52 0.855513307984791 75 36 85.6 0 227 3 22 96 KAG7338941.1 ATP synthase F1 subcomplex delta subunit [Nitzschia inconspicua] diamond 225 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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