RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJNA874604" 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

bioproject 1

  • PRJNA874604 · 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
2128344 2128344 PRJNA874604_P_NODE_99402_length_241_cov_0.916667_g99050_i0 PRJNA874604 99402 241 0.916667 2.20916747 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 164 3.71e-49   NR GKY92603.1 2872254 g99050 i0 92.4 12.7842323651452 79 6 98.3 0 241 5 132 210 GKY92603.1 hypothetical protein MPSEU_000230400 [Mayamaea pseudoterrestris] diamond 3081 164 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
3402328 3402328 PRJNA874604_P_NODE_28043_length_353_cov_2.200000_g27691_i0 PRJNA874604 28043 353 2.2 7.766 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 1.87e-37   NR EJK75259.1 159749 g27691 i0 63.1 1.80169971671388 103 37 86.7 1 337 32 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 636 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
3402512 3402512 PRJNA874604_P_NODE_37883_length_316_cov_0.950617_g37531_i0 PRJNA874604 37883 316 0.950617 3.00394972 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 114 8.48e-28   NR YP_010241711.1 3005 g37531 i0 83.9 16.4145569620253 62 10 58.9 0 129 314 6 67 YP_010241711.1 NADH dehydrogenase subunit 7 [Rhizosolenia setigera] diamond 5187 115 0.991304347826087 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
4680964 4680964 PRJNA874604_P_NODE_79684_length_248_cov_0.880000_g79332_i0 PRJNA874604 79684 248 0.88 2.1824 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 99.8 3.1e-23   NR OEU16167.1 635003 g79332 i0 61.3 3.54435483870968 75 29 90.7 0 2 226 133 207 OEU16167.1 kinase-like protein, partial [Fragilariopsis cylindrus CCMP1102] diamond 879 99.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
7230780 7230780 PRJNA874604_P_NODE_78566_length_248_cov_0.880000_g78214_i0 PRJNA874604 78566 248 0.88 2.1824 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 133 2.73e-34   NR GFH49462.1 426638 g78214 i0 74.4 4.94758064516129 82 21 99.2 0 3 248 295 376 GFH49462.1 glucose-6-phosphate isomerase [Chaetoceros tenuissimus] diamond 1227 133 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
16154257 16154257 PRJNA874604_P_NODE_27293_length_357_cov_1.485915_g26941_i0 PRJNA874604 27293 357 1.485915 5.30471655 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 112 9.35e-29   NR CAJ1966799.1 2856 g26941 i0 52.7 1.86554621848739 110 50 90.8 1 357 34 67 176 CAJ1966799.1 unnamed protein product [Cylindrotheca closterium] diamond 666 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
20364152 20364152 PRJNA874604_P_NODE_25756_length_365_cov_1.582192_g25404_i0 PRJNA874604 25756 365 1.582192 5.7750008 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 110 1.64e-28   NR KAK1748538.1 267567 g25404 i0 67.1 6.65753424657534 79 26 64.9 0 78 314 31 109 KAK1748538.1 cold shock domain-containing protein [Skeletonema marinoi] diamond 2430 111 0.990990990990991 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
21254681 21254681 PRJNA874604_P_NODE_80937_length_247_cov_0.885057_g80585_i0 PRJNA874604 80937 247 0.885057 2.18609079 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 82.8 2.43e-16   NR CAJ1955177.1 2856 g80585 i0 48.1 3.88663967611336 81 41 97.2 1 244 5 166 246 CAJ1955177.1 unnamed protein product [Cylindrotheca closterium] diamond 960 82.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
22528024 22528024 PRJNA874604_P_NODE_101958_length_226_cov_2.849673_g101606_i0 PRJNA874604 101958 226 2.849673 6.44026098 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 145 6.79e-42   NR KAI2510134.1 210448 g101606 i0 83.8 6.38495575221239 68 11 90.3 0 218 15 163 230 KAI2510134.1 Component of the ubiquinol-cytochrome c reductase complex (complex III or cytochrome b-c1 complex) [Fragilaria crotonensis] diamond 1443 145 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26706754 26706754 PRJNA874604_P_NODE_72881_length_250_cov_0.870056_g72529_i0 PRJNA874604 72881 250 0.870056 2.17514 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 67.8 3.45e-11   NR XP_002179290.1 556484 g72529 i0 43 5.736 79 45 94.8 0 4 240 70 148 XP_002179290.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 1434 67.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26770394 26770394 PRJNA874604_P_NODE_84541_length_246_cov_0.890173_g84189_i0 PRJNA874604 84541 246 0.890173 2.18982558 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 80.9 1.4e-15   NR XP_002183669.1 556484 g84189 i0 48.1 1.9390243902439 81 42 98.8 0 3 245 197 277 XP_002183669.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 477 80.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27023559 27023559 PRJNA874604_P_NODE_59262_length_267_cov_1.587629_g58910_i0 PRJNA874604 59262 267 1.587629 4.23896943 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 95.9 1.91e-21   NR VEU33335.1 183589 g58910 i0 65.2 2.30337078651685 66 23 74.2 0 69 266 14 79 VEU33335.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 615 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27339841 27339841 PRJNA874604_P_NODE_57803_length_270_cov_1.172589_g57451_i0 PRJNA874604 57803 270 1.172589 3.1659903 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 60.1 6.78e-9   NR KAI2503517.1 210448 g57451 i0 31.4 0.955555555555556 86 55 95.6 1 263 6 32 113 KAI2503517.1 polyketide cyclase / dehydrase [Fragilaria crotonensis] diamond 258 60.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27844736 27844736 PRJNA874604_P_NODE_27284_length_357_cov_1.549296_g26932_i0 PRJNA874604 27284 357 1.549296 5.53098672 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 97.8 8.769999999999998e-24   NR AID23594.1 2850 g26932 i0 74.6 0.529411764705882 63 14 51.3 1 1 183 30 92 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 189 97.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27844758 27844758 PRJNA874604_P_NODE_88344_length_245_cov_0.895349_g87992_i0 PRJNA874604 88344 245 0.895349 2.19360505 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0396   NR KAG7367541.1 303405 g87992 i0 32.6 1.0530612244898 86 50 95.5 3 9 242 1609 1694 KAG7367541.1 formin homology 2 domain containing protein [Nitzschia inconspicua] diamond 258 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28105442 28105442 PRJNA874604_P_NODE_75105_length_249_cov_0.875000_g74753_i0 PRJNA874604 75105 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 91.3 2.8e-19   NR OEU21846.1 635003 g74753 i0 67.8 4.26506024096386 59 19 71.1 0 178 2 161 219 OEU21846.1 condensing enzyme [Fragilariopsis cylindrus CCMP1102] diamond 1062 91.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28286740 28286740 PRJNA874604_P_NODE_22806_length_383_cov_1.293548_g22454_i0 PRJNA874604 22806 383 1.293548 4.95428884 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 127 2.8e-31   NR KAG7374009.1 303405 g22454 i0 58.7 2.5378590078329 104 41 81.5 2 70 381 78 179 KAG7374009.1 serine carboxypeptidase [Nitzschia inconspicua] diamond 972 127 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28791962 28791962 PRJNA874604_P_NODE_69447_length_251_cov_0.865169_g69095_i0 PRJNA874604 69447 251 0.865169 2.17157419 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 109 1.14e-25   NR CAB9517290.1 568900 g69095 i0 66.7 1.00398406374502 84 27 99.2 1 251 3 918 1001 CAB9517290.1 Ubiquitin-activating enzyme E1 1 [Seminavis robusta] diamond 252 109 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28799972 28799972 PRJNA874604_P_NODE_62627_length_261_cov_1.638298_g62275_i0 PRJNA874604 62627 261 1.638298 4.27595778 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 165 4.8199999999999996e-46   NR VEU45305.1 183589 g62275 i0 94.3 14 87 5 100 0 261 1 392 478 VEU45305.1 unnamed protein product, partial [Pseudo-nitzschia multistriata] diamond 3654 165 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29234262 29234262 PRJNA874604_P_NODE_77489_length_248_cov_0.880000_g77137_i0 PRJNA874604 77489 248 0.88 2.1824 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 65.9 2.75e-10   NR CAB9519027.1 568900 g77137 i0 46.2 0.943548387096774 78 41 94.4 1 14 247 77 153 CAB9519027.1 Inherit from euNOG: Crinkler (CRN) family protein [Seminavis robusta] diamond 234 65.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29494834 29494834 PRJNA874604_P_NODE_30790_length_341_cov_1.455224_g30438_i0 PRJNA874604 30790 341 1.455224 4.96231384 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 120 5.310000000000001e-29   NR KAL3797964.1 29204 g30438 i0 87.5 3.94134897360704 64 8 56.3 0 1 192 461 524 KAL3797964.1 hypothetical protein HJC23_013202 [Cyclotella cryptica] diamond 1344 121 0.991735537190083 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29770790 29770790 PRJNA874604_P_NODE_84111_length_246_cov_0.890173_g83759_i0 PRJNA874604 84111 246 0.890173 2.18982558 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.59e-16   NR VEU36975.1 183589 g83759 i0 65.5 1.41463414634146 58 20 70.7 0 176 3 399 456 VEU36975.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 348 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30655436 30655436 PRJNA874604_P_NODE_30973_length_340_cov_1.775281_g30621_i0 PRJNA874604 30973 340 1.775281 6.0359554 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 163 5.929999999999999e-47   NR CAB9517289.1 568900 g30621 i0 70.5 0.988235294117647 112 33 98.8 0 338 3 110 221 CAB9517289.1 Phosphate carrier protein, mitochondrial [Seminavis robusta] diamond 336 163 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30750405 30750405 PRJNA874604_P_NODE_66154_length_255_cov_1.428571_g65802_i0 PRJNA874604 66154 255 1.428571 3.64285605 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.82e-5   NR KAI2489437.1 210448 g65802 i0 41.3 2.77647058823529 80 36 89.4 3 19 246 904 976 KAI2489437.1 hypothetical protein MHU86_25149 [Fragilaria crotonensis] diamond 708 52.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31034986 31034986 PRJNA874604_P_NODE_74695_length_249_cov_0.875000_g74343_i0 PRJNA874604 74695 249 0.875 2.17875 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 47 0.00126   NR KAG7363991.1 303405 g74343 i0 61.3 1.12048192771084 31 12 37.3 0 247 155 623 653 KAG7363991.1 villin headpiece domain containing protein [Nitzschia inconspicua] diamond 279 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31350887 31350887 PRJNA874604_P_NODE_59516_length_267_cov_1.190722_g59164_i0 PRJNA874604 59516 267 1.190722 3.17922774 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 94 4.08e-20   NR KAL3923689.1 3061772 g59164 i0 48.8 1.84269662921348 82 42 92.1 0 248 3 54 135 KAL3923689.1 MAG: hypothetical protein SGILL_001510 [Bacillariaceae sp.] diamond 492 94 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31382543 31382543 PRJNA874604_P_NODE_84896_length_246_cov_0.890173_g84544_i0 PRJNA874604 84896 246 0.890173 2.18982558 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 75.9 8.19e-14   NR KAG7338083.1 303405 g84544 i0 45 0.975609756097561 80 42 97.6 1 6 245 181 258 KAG7338083.1 lecithin:cholesterol acyltransferase [Nitzschia inconspicua] diamond 240 75.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31825052 31825052 PRJNA874604_P_NODE_30197_length_343_cov_2.585185_g29845_i0 PRJNA874604 30197 343 2.585185 8.86718455 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 143 4.3e-41   NR CAB9498408.1 568900 g29845 i0 61.1 0.988338192419825 113 43 98 1 337 2 29 141 CAB9498408.1 60S ribosomal protein L14 [Seminavis robusta] diamond 339 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31920168 31920168 PRJNA874604_P_NODE_66177_length_255_cov_1.373626_g65825_i0 PRJNA874604 66177 255 1.373626 3.5027463 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 65.5 4.27e-10   NR CAJ1954434.1 2856 g65825 i0 45.8 3.49411764705882 72 38 83.5 1 4 216 39 110 CAJ1954434.1 unnamed protein product [Cylindrotheca closterium] diamond 891 65.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32592648 32592648 PRJNA874604_P_NODE_38659_length_313_cov_1.591667_g38307_i0 PRJNA874604 38659 313 1.591667 4.98191771 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.94e-5   NR KAG7346634.1 303405 g38307 i0 59.5 1.83067092651757 42 17 40.3 0 313 188 979 1020 KAG7346634.1 WW domain containing protein [Nitzschia inconspicua] diamond 573 53.1 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);;