RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 22 ✖

tax_clade 1

bioproject 1

  • PRJDB12578 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
15306530 15306530 PRJDB12578_S_NODE_210813_length_163_cov_0.912281_g187755_i0 PRJDB12578 210813 163 0.912281 1.48701803 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 101 2.93e-23   NR KAG7357284.1 303405 g187755 i0 96.2 0.975460122699387 53 2 97.5 0 3 161 341 393 KAG7357284.1 chaperone protein DnaK [Nitzschia inconspicua] diamond 159 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
22959481 22959481 PRJDB12578_S_NODE_77599_length_414_cov_1.690411_g54545_i0 PRJDB12578 77599 414 1.690411 6.99830154 Fragilariopsis 186035 SAR_Eukaryotes SAR_Eukaryotes 249 2.61e-80   NR OEU13573.1 635003 g54545 i0 88.4 5 138 16 100 0 414 1 91 228 OEU13573.1 glyceraldehyde-3-phosphate dehydrogenase [Fragilariopsis cylindrus CCMP1102] diamond 2070 249 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
26588895 26588895 PRJDB12578_S_NODE_120321_length_243_cov_0.927835_g97263_i0 PRJDB12578 120321 243 0.927835 2.25463905 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 105 2.6e-25   NR KAG7362055.1 303405 g97263 i0 59.5 0.975308641975309 79 31 97.5 1 1 237 103 180 KAG7362055.1 hypothetical protein IV203_025721 [Nitzschia inconspicua] diamond 237 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
26715446 26715446 PRJDB12578_S_NODE_198121_length_167_cov_1.313559_g175063_i0 PRJDB12578 198121 167 1.313559 2.19364353 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.62e-20   NR KAL3903650.1 3061772 g175063 i0 76.4 0.988023952095808 55 11 98.8 1 166 2 96 148 KAL3903650.1 MAG: hypothetical protein SGILL_010367, partial [Bacillariaceae sp.] diamond 165 93.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26747087 26747087 PRJDB12578_S_NODE_109381_length_265_cov_1.462963_g86323_i0 PRJDB12578 109381 265 1.462963 3.87685195 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.84e-5   NR KAL3908733.1 3061772 g86323 i0 45.6 0.894339622641509 79 36 86 3 4 231 235 309 KAL3908733.1 MAG: hypothetical protein SGILL_008372 [Bacillariaceae sp.] diamond 237 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26874482 26874482 PRJDB12578_S_NODE_136261_length_218_cov_1.633136_g113203_i0 PRJDB12578 136261 218 1.633136 3.56023648 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52 1.39e-5   NR KAL3908733.1 3061772 g113203 i0 48.1 2.13302752293578 77 33 96.3 3 7 216 70 146 KAL3908733.1 MAG: hypothetical protein SGILL_008372 [Bacillariaceae sp.] diamond 465 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26905834 26905834 PRJDB12578_S_NODE_113202_length_257_cov_1.000000_g90144_i0 PRJDB12578 113202 257 1 2.57 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 155 7.41e-47   NR KAG7369272.1 303405 g90144 i0 85.9 0.992217898832685 85 12 99.2 0 257 3 1 85 KAG7369272.1 hypothetical protein IV203_032015 [Nitzschia inconspicua] diamond 255 155 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
26905848 26905848 PRJDB12578_S_NODE_203762_length_165_cov_1.344828_g180704_i0 PRJDB12578 203762 165 1.344828 2.2189662 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 72.4 3.06e-13   NR KAL3908733.1 3061772 g180704 i0 64.8 0.981818181818182 54 19 98.2 0 163 2 141 194 KAL3908733.1 MAG: hypothetical protein SGILL_008372 [Bacillariaceae sp.] diamond 162 72.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27253538 27253538 PRJDB12578_S_NODE_214703_length_162_cov_0.902655_g191645_i0 PRJDB12578 214703 162 0.902655 1.4623011 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 46.2 7.64e-4   NR KAL3924258.1 3061772 g191645 i0 41.4 1.07407407407407 58 25 90.7 1 147 1 394 451 KAL3924258.1 MAG: hypothetical protein SGILL_001156 [Bacillariaceae sp.] diamond 174 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27279491 27279491 PRJDB12578_S_NODE_198943_length_167_cov_0.881356_g175885_i0 PRJDB12578 198943 167 0.881356 1.47186452 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 112 3.9e-27   NR VEU43953.1 183589 g175885 i0 98.2 2.96407185628743 55 1 98.8 0 3 167 771 825 VEU43953.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 495 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28043156 28043156 PRJDB12578_S_NODE_211365_length_163_cov_0.903509_g188307_i0 PRJDB12578 211365 163 0.903509 1.47271967 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 77 5.68e-15   NR XP_002178995.1 556484 g188307 i0 66.7 1.98773006134969 54 18 99.4 0 2 163 32 85 XP_002178995.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 324 77 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28731958 28731958 PRJDB12578_S_NODE_170027_length_185_cov_1.875000_g146969_i0 PRJDB12578 170027 185 1.875 3.46875 Fragilariopsis 186035 SAR_Eukaryotes SAR_Eukaryotes 70.9 2.02e-12   NR OEU18919.1 635003 g146969 i0 58.3 1.96216216216216 60 24 97.3 1 183 4 75 133 OEU18919.1 hypothetical protein FRACYDRAFT_268491, partial [Fragilariopsis cylindrus CCMP1102] diamond 363 71.6 0.990223463687151 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28832388 28832388 PRJDB12578_S_NODE_173968_length_182_cov_1.714286_g150910_i0 PRJDB12578 173968 182 1.714286 3.12000052 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0272   NR KAG7345154.1 303405 g150910 i0 60.6 0.543956043956044 33 10 49.5 1 125 36 1 33 KAG7345154.1 LITAF-like zinc ribbon domain containing protein [Nitzschia inconspicua] diamond 99 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28832390 28832390 PRJDB12578_S_NODE_178408_length_179_cov_1.200000_g155350_i0 PRJDB12578 178408 179 1.2 2.148 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 109 2.6e-26   NR KAG7349726.1 303405 g155350 i0 84.7 0.988826815642458 59 9 98.9 0 1 177 216 274 KAG7349726.1 acetylornithine aminotransferase [Nitzschia inconspicua] diamond 177 109 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29369260 29369260 PRJDB12578_S_NODE_131369_length_225_cov_0.869318_g108311_i0 PRJDB12578 131369 225 0.869318 1.9559655 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 53.1 5.67e-6   NR VEU39735.1 183589 g108311 i0 48.1 0.693333333333333 52 27 69.3 0 216 61 155 206 VEU39735.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 156 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29495526 29495526 PRJDB12578_S_NODE_211190_length_163_cov_0.903509_g188132_i0 PRJDB12578 211190 163 0.903509 1.47271967 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 87.8 5.41e-19   NR KAG7362220.1 303405 g188132 i0 75.5 0.901840490797546 49 12 90.2 0 2 148 250 298 KAG7362220.1 hypothetical protein IV203_025886 [Nitzschia inconspicua] diamond 147 87.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30380351 30380351 PRJDB12578_S_NODE_89293_length_335_cov_1.986014_g66235_i0 PRJDB12578 89293 335 1.986014 6.6531469 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 125 6.109999999999999e-31   NR KAG7354148.1 303405 g66235 i0 51.7 1.03880597014925 116 47 96.7 3 11 334 329 443 KAG7354148.1 hypothetical protein IV203_003504 [Nitzschia inconspicua] diamond 348 125 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31011837 31011837 PRJDB12578_S_NODE_207655_length_164_cov_0.904348_g184597_i0 PRJDB12578 207655 164 0.904348 1.48313072 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 92 5.45e-20   NR KAG7369202.1 303405 g184597 i0 75.9 0.98780487804878 54 13 98.8 0 164 3 398 451 KAG7369202.1 tetratricopeptide repeat protein [Nitzschia inconspicua] diamond 162 92 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31385494 31385494 PRJDB12578_S_NODE_166876_length_188_cov_1.115108_g143818_i0 PRJDB12578 166876 188 1.115108 2.09640304 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 117 8.39e-29   NR KAI2505061.1 210448 g143818 i0 98.4 7.91489361702128 62 1 98.9 0 1 186 387 448 KAI2505061.1 Heat shock protein [Fragilaria crotonensis] diamond 1488 117 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31549605 31549605 PRJDB12578_S_NODE_204796_length_165_cov_0.896552_g181738_i0 PRJDB12578 204796 165 0.896552 1.4793108 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.17e-4   NR CAB9530430.1 568900 g181738 i0 55.1 0.890909090909091 49 21 89.1 1 164 18 758 805 CAB9530430.1 Gamma-aminobutyric acid (GABA) B receptor [Seminavis robusta] diamond 147 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31606758 31606758 PRJDB12578_S_NODE_208096_length_164_cov_0.904348_g185038_i0 PRJDB12578 208096 164 0.904348 1.48313072 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 52.4 5.05e-6   NR KAI2505061.1 210448 g185038 i0 74.1 1.97560975609756 54 12 95.1 2 162 7 601 654 KAI2505061.1 Heat shock protein [Fragilaria crotonensis] diamond 324 52.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32144576 32144576 PRJDB12578_S_NODE_147498_length_206_cov_0.866242_g124440_i0 PRJDB12578 147498 206 0.866242 1.78445852 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 107 2.86e-25   NR KAG7374615.1 303405 g124440 i0 86.8 2.97087378640777 68 9 99 0 205 2 984 1051 KAG7374615.1 NADP transhydrogenase subunit alpha [Nitzschia inconspicua] diamond 612 108 0.990740740740741 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);;