RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJEB10140 · 19 ✖

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
4810114 4810114 PRJEB10140_P_NODE_223224_length_181_cov_1.136364_g205915_i0 PRJEB10140 223224 181 1.136364 2.05681884 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.015   NTclustered gi|2739942906|dbj|LC814766.1| 2843 g205915 i0 100 0.92817679558011 28 0 15 0 48 75 21475 21502 Skeletonema costatum SCHP35 mitochondrial DNA, complete genome blastn 168 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
14039577 14039577 PRJEB10140_P_NODE_117612_length_311_cov_1.343511_g100306_i0 PRJEB10140 117612 311 1.343511 4.17831921 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 137 1.9e-35   NR KAI2498924.1 210448 g100306 i0 66 2.98070739549839 103 35 99.4 0 2 310 284 386 KAI2498924.1 chaperonin-like protein [Fragilaria crotonensis] diamond 927 138 0.992753623188406 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
16590065 16590065 PRJEB10140_P_NODE_48294_length_752_cov_3.675676_g32731_i0 PRJEB10140 48294 752 3.675676 27.64108352 Conticribra weissflogii 1577725 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.021   NTclustered gi|2102348258|gb|MW752443.1| 1577725 g32731 i0 100 0.038563829787234 29 0 4 0 470 498 125805 125777 Conticribra weissflogii isolate CNS00439 chloroplast, complete genome blastn 29 54.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Conticribra Conticribra weissflogii
26684310 26684310 PRJEB10140_P_NODE_251981_length_168_cov_0.873950_g234672_i0 PRJEB10140 251981 168 0.87395 1.468236 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 47 4.19e-4   NR OEU10963.1 635003 g234672 i0 71.4 1 28 8 50 0 166 83 166 193 OEU10963.1 hypothetical protein FRACYDRAFT_246064 [Fragilariopsis cylindrus CCMP1102] diamond 168 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
26773429 26773429 PRJEB10140_P_NODE_160901_length_233_cov_1.282609_g143593_i0 PRJEB10140 160901 233 1.282609 2.98847897 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 92.4 5.39e-22   NR GAX17897.1 1519565 g143593 i0 58.9 4.931330472103 73 28 94 1 233 15 23 93 GAX17897.1 large subunit ribosomal protein L14e [Fistulifera solaris] diamond 1149 92.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27126954 27126954 PRJEB10140_P_NODE_144922_length_255_cov_1.373786_g127614_i0 PRJEB10140 144922 255 1.373786 3.5031543 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 100 3.76e-25   NR KAL3940621.1 3061772 g127614 i0 57 1.01176470588235 86 35 98.8 1 3 254 22 107 KAL3940621.1 MAG: hypothetical protein SGBAC_004877 [Bacillariaceae sp.] diamond 258 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27285471 27285471 PRJEB10140_P_NODE_234783_length_174_cov_1.616000_g217474_i0 PRJEB10140 234783 174 1.616 2.81184 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 85.5 5.28e-18   NR CAB9522723.1 568900 g217474 i0 74.1 0.931034482758621 54 14 93.1 0 8 169 222 275 CAB9522723.1 Mitochondrial 2-oxoglutarate/malate carrier protein [Seminavis robusta] diamond 162 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27406060 27406060 PRJEB10140_P_NODE_134163_length_274_cov_1.333333_g116856_i0 PRJEB10140 134163 274 1.333333 3.65333242 root 1 Root_unresolved Root_unresolved 107 1.3299999999999999e-24   NR KAK1747669.1 267567 g116856 i0 57.1 2.97810218978102 91 39 99.6 0 274 2 41 131 KAK1747669.1 sodium/chloride-dependent transporter family protein [Skeletonema marinoi] diamond 816 107 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27406075 27406075 PRJEB10140_P_NODE_206223_length_191_cov_1.288732_g188914_i0 PRJEB10140 206223 191 1.288732 2.46147812 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 94.7 9.08e-21   NR EJK49760.1 159749 g188914 i0 61.9 2.93717277486911 63 24 99 0 190 2 664 726 EJK49760.1 hypothetical protein THAOC_31329 [Thalassiosira oceanica] diamond 561 94.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27664636 27664636 PRJEB10140_P_NODE_186964_length_206_cov_1.286624_g169655_i0 PRJEB10140 186964 206 1.286624 2.65044544 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0419   NR CAB9520716.1 568900 g169655 i0 39.1 0.669902912621359 46 26 67 1 54 191 41 84 CAB9520716.1 expressed unknown protein [Seminavis robusta] diamond 138 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28422476 28422476 PRJEB10140_P_NODE_268586_length_165_cov_0.896552_g251277_i0 PRJEB10140 268586 165 0.896552 1.4793108 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00506   NR CAB9512870.1 568900 g251277 i0 47.7 0.8 44 18 70.9 1 150 34 35 78 CAB9512870.1 expressed unknown protein [Seminavis robusta] diamond 132 43.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28895716 28895716 PRJEB10140_P_NODE_211728_length_187_cov_2.949275_g194419_i0 PRJEB10140 211728 187 2.949275 5.51514425 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.65e-6   NR KAL3789050.1 382360 g194419 i0 51.1 3 47 22 73.8 1 143 6 276 322 KAL3789050.1 hypothetical protein ACHAWO_004607 [Cyclotella atomus] diamond 561 53.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29331875 29331875 PRJEB10140_P_NODE_223009_length_181_cov_1.181818_g205700_i0 PRJEB10140 223009 181 1.181818 2.13909058 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.99e-15   NR KAL3765726.1 259834 g205700 i0 70 4.16022099447514 50 15 82.9 0 6 155 299 348 KAL3765726.1 hypothetical protein ACHAWU_009694 [Discostella pseudostelligera] diamond 753 80.1 0.990012484394507 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
30443554 30443554 PRJEB10140_P_NODE_38293_length_926_cov_7.515393_g24498_i0 PRJEB10140 38293 926 7.515393 69.59253918 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 56.6 7.61e-6   NR VEU40812.1 183589 g24498 i0 47.7 0.421166306695464 65 31 20.7 2 734 543 83 145 VEU40812.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 390 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30759373 30759373 PRJEB10140_P_NODE_200794_length_194_cov_5.206897_g183485_i0 PRJEB10140 200794 194 5.206897 10.10138018 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 64.7 2.69e-10   NR KAK1740922.1 267567 g183485 i0 45 1.87113402061856 60 33 92.8 0 183 4 177 236 KAK1740922.1 glycosyltransferase [Skeletonema marinoi] diamond 363 64.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31044040 31044040 PRJEB10140_P_NODE_257175_length_167_cov_0.881356_g239866_i0 PRJEB10140 257175 167 0.881356 1.47186452 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 60.8 5.4e-9   NR CAB9516456.1 568900 g239866 i0 56.9 0.916167664670659 51 21 89.8 1 2 151 438 488 CAB9516456.1 expressed unknown protein [Seminavis robusta] diamond 153 60.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31391615 31391615 PRJEB10140_P_NODE_289056_length_162_cov_0.920354_g271747_i0 PRJEB10140 289056 162 0.920354 1.49097348 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.25e-6   NR XP_002181892.1 556484 g271747 i0 48.1 3 54 22 88.9 1 158 15 239 292 XP_002181892.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 486 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31612857 31612857 PRJEB10140_P_NODE_276756_length_164_cov_0.904348_g259447_i0 PRJEB10140 276756 164 0.904348 1.48313072 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 78.2 4.07e-15   NR CAB9523716.1 568900 g259447 i0 63 0.98780487804878 54 20 98.8 0 162 1 269 322 CAB9523716.1 Receptor-type guanylate cyclase gcy [Seminavis robusta] diamond 162 78.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32340730 32340730 PRJEB10140_P_NODE_248919_length_168_cov_1.697479_g231610_i0 PRJEB10140 248919 168 1.697479 2.85176472 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 99 2.6299999999999998e-23   NR CAB9514175.1 568900 g231610 i0 76.8 1 56 13 100 0 1 168 59 114 CAB9514175.1 Desert hedgehog protein [Seminavis robusta] diamond 168 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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