RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJEB81463", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 30 ✖

tax_clade 1

  • Sar · 30 ✖

bioproject 1

  • PRJEB81463 · 30 ✖

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
17991819 17991819 PRJEB81463_P_NODE_1035_length_975_cov_3.594235_g838_i0 PRJEB81463 1035 975 3.594235 35.04379125 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 478 2.879999999999999e-166   NR BAH30211.1 33640 g838 i0 73.8 20.9784615384615 324 84 99.7 1 974 3 54 376 BAH30211.1 methionine S-adenosyl transferase [Asterionellopsis glacialis] diamond 20454 481 0.993762993762994 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
23092462 23092462 PRJEB81463_P_NODE_26159_length_245_cov_0.883721_g25887_i0 PRJEB81463 26159 245 0.883721 2.16511645 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 1.56e-32   NR KAL3760802.1 259834 g25887 i0 72.8 5.95102040816327 81 22 99.2 0 243 1 242 322 KAL3760802.1 hypothetical protein ACHAWU_007868 [Discostella pseudostelligera] diamond 1458 127 0.992125984251969 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
26590807 26590807 PRJEB81463_P_NODE_13681_length_284_cov_1.298578_g13409_i0 PRJEB81463 13681 284 1.298578 3.68796152 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 51.2 8.01e-6   NR OEU22076.1 635003 g13409 i0 32.9 0.802816901408451 76 49 79.2 2 245 21 29 103 OEU22076.1 cytochrome c oxidase subunit H [Fragilariopsis cylindrus CCMP1102] diamond 228 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
26963498 26963498 PRJEB81463_P_NODE_21662_length_251_cov_0.876404_g21390_i0 PRJEB81463 21662 251 0.876404 2.19977404 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 100 4.25e-23   NR CAJ1936680.1 2856 g21390 i0 53.2 2.83266932270916 79 37 94.4 0 2 238 25 103 CAJ1936680.1 unnamed protein product [Cylindrotheca closterium] diamond 711 101 0.99009900990099 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27255477 27255477 PRJEB81463_P_NODE_12223_length_292_cov_1.420091_g11951_i0 PRJEB81463 12223 292 1.420091 4.14666572 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 73.9 7.37e-13   NR KAL3757761.1 259834 g11951 i0 47.2 0.914383561643836 89 46 90.4 1 264 1 615 703 KAL3757761.1 hypothetical protein ACHAWU_000402 [Discostella pseudostelligera] diamond 267 73.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27255479 27255479 PRJEB81463_P_NODE_15063_length_277_cov_1.289216_g14791_i0 PRJEB81463 15063 277 1.289216 3.57112832 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.57e-7   NR CAB9522282.1 568900 g14791 i0 38.1 0.682310469314079 63 39 68.2 0 16 204 199 261 CAB9522282.1 transcription complex subunit 6-like [Seminavis robusta] diamond 189 58.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27413809 27413809 PRJEB81463_P_NODE_11083_length_305_cov_2.534483_g10811_i0 PRJEB81463 11083 305 2.534483 7.73017315 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 59.7 8.84e-9   NR XP_002183665.1 556484 g10811 i0 51.9 0.531147540983607 54 26 53.1 0 7 168 66 119 XP_002183665.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 162 59.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27508428 27508428 PRJEB81463_P_NODE_13183_length_287_cov_0.953271_g12911_i0 PRJEB81463 13183 287 0.953271 2.73588777 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 97.8 2.9e-21   NR KAG7357601.1 303405 g12911 i0 58.9 2.28919860627178 73 30 76.3 0 276 58 1269 1341 KAG7357601.1 reverse transcriptase RNA-dependent DNA polymerase [Nitzschia inconspicua] diamond 657 97.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27571407 27571407 PRJEB81463_P_NODE_27664_length_243_cov_0.905882_g27392_i0 PRJEB81463 27664 243 0.905882 2.20129326 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 108 2.69e-25   NR KAL3771149.1 259834 g27392 i0 62.8 1.92592592592593 78 29 96.3 0 4 237 2145 2222 KAL3771149.1 hypothetical protein ACHAWU_004772 [Discostella pseudostelligera] diamond 468 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27855533 27855533 PRJEB81463_P_NODE_25445_length_245_cov_3.540698_g25173_i0 PRJEB81463 25445 245 3.540698 8.6747101 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 101 1.7799999999999995e-23   NR GAX16483.1 1519565 g25173 i0 67.9 0.991836734693878 81 25 99.2 1 244 2 211 290 GAX16483.1 adenosine kinase [Fistulifera solaris] diamond 243 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28550404 28550404 PRJEB81463_P_NODE_11227_length_303_cov_2.386957_g10955_i0 PRJEB81463 11227 303 2.386957 7.23247971 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 59.3 5.46e-8   NR KAL3810700.1 382380 g10955 i0 29.9 2.11881188118812 117 64 98 1 299 3 97 213 KAL3810700.1 hypothetical protein ACHAXA_004646 [Cyclostephanos tholiformis] diamond 642 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28929131 28929131 PRJEB81463_P_NODE_18868_length_258_cov_1.686486_g18596_i0 PRJEB81463 18868 258 1.686486 4.35113388 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 99.8 1.84e-25   NR CAB9524812.1 568900 g18596 i0 67.7 0.720930232558139 62 20 72.1 0 43 228 5 66 CAB9524812.1 This is a component of the ubiquinol-cytochrome c reductase complex (complex III or cytochrome b-c1 complex) [Seminavis robusta] diamond 186 99.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28929143 28929143 PRJEB81463_P_NODE_9288_length_330_cov_3.023346_g9016_i0 PRJEB81463 9288 330 3.023346 9.9770418 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 97.1 3.24e-23   NR CAJ1944271.1 2856 g9016 i0 46.4 4.96363636363636 112 57 99.1 1 328 2 11 122 CAJ1944271.1 unnamed protein product [Cylindrotheca closterium] diamond 1638 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29276280 29276280 PRJEB81463_P_NODE_25089_length_246_cov_0.901734_g24817_i0 PRJEB81463 25089 246 0.901734 2.21826564 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 77.8 1.15e-14   NR GFH45569.1 426638 g24817 i0 55.7 0.963414634146341 79 33 93.9 2 234 4 173 251 GFH45569.1 hypothetical protein CTEN210_02043 [Chaetoceros tenuissimus] diamond 237 77.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30027110 30027110 PRJEB81463_P_NODE_7051_length_377_cov_3.871711_g6779_i0 PRJEB81463 7051 377 3.871711 14.59635047 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 111 1.7e-25   NR VEU42420.1 183589 g6779 i0 59.1 4.3209549071618 110 38 82.8 4 315 4 610 718 VEU42420.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1629 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30097367 30097367 PRJEB81463_P_NODE_24872_length_246_cov_1.699422_g24600_i0 PRJEB81463 24872 246 1.699422 4.18057812 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0149   NR GAX23797.1 1519565 g24600 i0 57.8 0.548780487804878 45 15 50 1 98 220 148 192 GAX23797.1 hypothetical protein FisN_12Hh379 [Fistulifera solaris] diamond 135 43.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30121603 30121603 PRJEB81463_P_NODE_10472_length_312_cov_3.221757_g10200_i0 PRJEB81463 10472 312 3.221757 10.05188184 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 100 4.11e-22   NR KAG7366293.1 303405 g10200 i0 87.8 0.942307692307692 49 6 47.1 0 312 166 214 262 KAG7366293.1 endo-1,4-beta-xylanase A precursor [Nitzschia inconspicua] diamond 294 101 0.99009900990099 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30287471 30287471 PRJEB81463_P_NODE_25372_length_246_cov_0.895954_g25100_i0 PRJEB81463 25372 246 0.895954 2.20404684 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 100 4.3499999999999997e-23   NR KAI2490239.1 210448 g25100 i0 54.3 0.98780487804878 81 37 98.8 0 3 245 230 310 KAI2490239.1 PAP fibrillin [Fragilaria crotonensis] diamond 243 100 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30319199 30319199 PRJEB81463_P_NODE_11772_length_296_cov_2.699552_g11500_i0 PRJEB81463 11772 296 2.699552 7.99067392 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 88.2 3.3e-18   NR GKY94348.1 2872254 g11500 i0 48.3 0.881756756756757 87 42 85.1 1 43 294 37 123 GKY94348.1 hypothetical protein MPSEU_000400700 [Mayamaea pseudoterrestris] diamond 261 88.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30343460 30343460 PRJEB81463_P_NODE_15172_length_276_cov_1.945813_g14900_i0 PRJEB81463 15172 276 1.945813 5.37044388 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 125 2.9799999999999997e-31   NR OEU21617.1 635003 g14900 i0 65.9 17.0869565217391 91 31 98.9 0 275 3 391 481 OEU21617.1 transketolase [Fragilariopsis cylindrus CCMP1102] diamond 4716 126 0.992063492063492 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
30343462 30343462 PRJEB81463_P_NODE_30152_length_217_cov_7.215278_g29880_i0 PRJEB81463 30152 217 7.215278 15.65715326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.48e-16   NR GFH52366.1 426638 g29880 i0 67.9 1.3963133640553 53 15 70.5 1 214 62 113 165 GFH52366.1 small subunit ribosomal protein S11e [Chaetoceros tenuissimus] diamond 303 80.1 0.990012484394507 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30974973 30974973 PRJEB81463_P_NODE_16994_length_267_cov_1.247423_g16722_i0 PRJEB81463 16994 267 1.247423 3.33061941 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 90.1 1.09e-18   NR CAB9519296.1 568900 g16722 i0 57.1 2.25842696629213 70 30 78.7 0 15 224 643 712 CAB9519296.1 Protein of unknown function (DUF1336) [Seminavis robusta] diamond 603 90.5 0.995580110497237 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31013722 31013722 PRJEB81463_P_NODE_12315_length_292_cov_0.799087_g12043_i0 PRJEB81463 12315 292 0.799087 2.33333404 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 121 1.79e-29   NR KAL3793153.1 29204 g12043 i0 84.7 0.73972602739726 72 11 74 0 216 1 35 106 KAL3793153.1 hypothetical protein HJC23_005655 [Cyclotella cryptica] diamond 216 121 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31234792 31234792 PRJEB81463_P_NODE_21655_length_251_cov_0.876404_g21383_i0 PRJEB81463 21655 251 0.876404 2.19977404 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 73.6 5.75e-13   NR KAL3937944.1 3061772 g21383 i0 49.4 0.99203187250996006 83 23 99.2 2 251 3 489 552 KAL3937944.1 MAG: hypothetical protein SGBAC_007046 [Bacillariaceae sp.] diamond 249 73.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31480998 31480998 PRJEB81463_P_NODE_17016_length_267_cov_1.201031_g16744_i0 PRJEB81463 17016 267 1.201031 3.20675277 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 121 1.5999999999999998e-32   NR EJK66874.1 159749 g16744 i0 65.1 5.7977528089887604 86 30 96.6 0 266 9 72 157 EJK66874.1 hypothetical protein THAOC_12157 [Thalassiosira oceanica] diamond 1548 121 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31583051 31583051 PRJEB81463_P_NODE_19756_length_254_cov_1.718232_g19484_i0 PRJEB81463 19756 254 1.718232 4.36430928 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0434   NR KAG7355327.1 303405 g19484 i0 39.3 0.720472440944882 61 27 70.9 2 37 216 729 780 KAG7355327.1 NLI interacting factor-like phosphatase [Nitzschia inconspicua] diamond 183 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31709403 31709403 PRJEB81463_P_NODE_20737_length_252_cov_1.162011_g20465_i0 PRJEB81463 20737 252 1.162011 2.92826772 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00262   NR KAK1738354.1 267567 g20465 i0 57.9 0.452380952380952 38 15 44 1 252 142 656 693 KAK1738354.1 subtilase family serine peptidase [Skeletonema marinoi] diamond 114 46.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31835719 31835719 PRJEB81463_P_NODE_8337_length_348_cov_2.243636_g8065_i0 PRJEB81463 8337 348 2.243636 7.80785328 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.0199   NR CAB9513789.1 568900 g8065 i0 34.1 0.732758620689655 85 50 71.6 3 85 333 1231 1311 CAB9513789.1 lectin domain family 4 member M [Seminavis robusta] diamond 255 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32689475 32689475 PRJEB81463_P_NODE_15020_length_277_cov_1.514706_g14748_i0 PRJEB81463 15020 277 1.514706 4.19573562 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 101 9.85e-23   NR EJK60894.1 159749 g14748 i0 51.1 0.996389891696751 92 44 98.6 1 275 3 120 211 EJK60894.1 hypothetical protein THAOC_18690, partial [Thalassiosira oceanica] diamond 276 101 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32783929 32783929 PRJEB81463_P_NODE_23720_length_248_cov_0.891429_g23448_i0 PRJEB81463 23720 248 0.891429 2.21074392 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 54.3 3.35e-6   NR KAG7339802.1 303405 g23448 i0 41.9 4.35483870967742 74 39 85.9 2 31 243 613 685 KAG7339802.1 hypothetical protein IV203_028263 [Nitzschia inconspicua] diamond 1080 54.3 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);;