RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 26 ✖

bioproject 1

  • PRJEB6584 · 26 ✖

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
25525581 25525581 PRJEB6584p_S_NODE_529_length_346_cov_4.623794_g498_i0 PRJEB6584 529 346 4.623794 15.99832724 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 176 1.86e-39   NTclustered gi|2074156200|gb|MW413905.1| 216802 g498 i0 76.638 77.3757225433526 351 62 98 16 8 346 24229 24571 Guinardia delicatula mitochondrion, complete genome blastn 26772 176 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
25796386 25796386 PRJEB6584o_S_NODE_14171_length_234_cov_4.889447_g14063_i0 PRJEB6584 14171 234 4.889447 11.44130598 Skeletonema menzelii 216823 SAR_Eukaryotes SAR_Eukaryotes 150 7.22e-32   NTclustered gi|2739942921|dbj|LC814781.1| 216823 g14063 i0 81.771 33.4188034188034 192 24 78 10 9 190 32240 32430 Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome blastn 7820 150 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema menzelii
25797114 25797114 PRJEB6584o_S_NODE_50771_length_166_cov_3.908397_g50663_i0 PRJEB6584 50771 166 3.908397 6.48793902 Pseudo-nitzschia sabit 1664502 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.07e-8   NTclustered gi|2852238230|gb|PQ498358.1| 1664502 g50663 i0 100 12.9518072289157 39 0 23 0 128 166 19660 19698 Pseudo-nitzschia sabit isolate CNS00609 mitochondrion, complete genome blastn 2150 73.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia sabit
26024283 26024283 PRJEB6584m_S_NODE_228_length_333_cov_1.728188_g216_i0 PRJEB6584 228 333 1.728188 5.75486604 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 171 8.3e-38   NTclustered gi|2739942924|dbj|LC814784.1| 41457 g216 i0 77.399 78.8918918918919 323 49 93 18 23 333 33435 33745 Skeletonema pseudocostatum NIES-2843 mitochondrial DNA, complete genome blastn 26271 171 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
26067981 26067981 PRJEB6584e_S_NODE_5_length_1260_cov_257.115102_g4_i0 PRJEB6584 5 1260 257.115102 3239.6502852 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 235 1.19e-56   NTclustered gi|2074156200|gb|MW413905.1| 216802 g4 i0 78.534 34.6253968253968 382 65 30 14 117 489 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43628 235 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26067989 26067989 PRJEB6584f_S_NODE_37_length_1238_cov_53.682461_g36_i0 PRJEB6584 37 1238 53.682461000000004 664.58886718 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 235 1.17e-56   NTclustered gi|2074156200|gb|MW413905.1| 216802 g36 i0 78.534 35.2374798061389 382 64 30 15 188 559 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43624 235 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26068066 26068066 PRJEB6584h_S_NODE_653_length_441_cov_6.871921_g593_i0 PRJEB6584 653 441 6.871921 30.30517161 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 75 9.1e-9   NTclustered gi|1125788738|ref|NC_032171.1| 1115533 g593 i0 84.211 1.20861678004535 76 12 17 0 228 303 28713 28638 Didymosphenia geminata mitochondrion, complete genome blastn 533 75 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
26340085 26340085 PRJEB6584f_S_NODE_6767_length_153_cov_1.016949_g6761_i0 PRJEB6584 6767 153 1.016949 1.55593197 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 104 3.41e-18   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g6761 i0 85.714 0.993464052287582 98 14 64 0 1 98 328 425 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 152 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26432027 26432027 PRJEB6584e_S_NODE_2903_length_175_cov_2.185714_g2888_i0 PRJEB6584 2903 175 2.185714 3.8249995 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 101 2.1e-25   NR GFH52366.1 426638 g2888 i0 79.3 4.97142857142857 58 12 99.4 0 2 175 60 117 GFH52366.1 small subunit ribosomal protein S11e [Chaetoceros tenuissimus] diamond 870 101 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
26476372 26476372 PRJEB6584f_S_NODE_40_length_949_cov_17.973742_g36_i1 PRJEB6584 40 949 17.973742 170.57081158 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 235 8.88e-57   NTclustered gi|2074156200|gb|MW413905.1| 216802 g36 i1 78.534 46.5384615384615 382 64 39 15 261 632 24229 24602 Guinardia delicatula mitochondrion, complete genome blastn 44165 235 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26476699 26476699 PRJEB6584l_S_NODE_3464_length_298_cov_3.049430_g3312_i0 PRJEB6584 3464 298 3.04943 9.0873014 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 137 7.43e-28   NTclustered gi|2026158947|ref|NC_054334.1| 444606 g3312 i0 76.596 77.3489932885906 282 47 92 15 25 297 29910 30181 Eucampia zodiacus strain CNS00060 mitochondrion, complete genome blastn 23050 137 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
32929261 32929261 PRJEB6584o_S_NODE_10777_length_266_cov_7.164502_g10669_i0 PRJEB6584 10777 266 7.164502 19.05757532 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.66e-8   NR KAI2504781.1 210448 g10669 i0 54 1.12781954887218 50 23 56.4 0 61 210 8 57 KAI2504781.1 small subunit ribosomal protein S12 [Fragilaria crotonensis] diamond 300 56.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32963320 32963320 PRJEB6584a_S_NODE_6274_length_171_cov_2.448529_g6254_i0 PRJEB6584 6274 171 2.448529 4.18698459 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 57.8 2.86e-9   NR EJK58442.1 159749 g6254 i0 75 0.701754385964912 40 10 70.2 0 146 27 24 63 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 120 57.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
33025726 33025726 PRJEB6584j_S_NODE_28268_length_155_cov_1.541667_g28239_i0 PRJEB6584 28268 155 1.541667 2.38958385 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.19e-11   NR KAG7352108.1 303405 g28239 i0 70.5 5.26451612903226 44 13 85.2 0 1 132 847 890 KAG7352108.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Nitzschia inconspicua] diamond 816 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
33031608 33031608 PRJEB6584d_S_NODE_7332_length_221_cov_2.715054_g7264_i0 PRJEB6584 7332 221 2.715054 6.00026934 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 61.6 6.32e-9   NR GAX12401.1 1519565 g7264 i0 51.4 1.95475113122172 72 27 97.7 1 219 4 4238 4301 GAX12401.1 midasin [Fistulifera solaris] diamond 432 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
33031865 33031865 PRJEB6584o_S_NODE_1868_length_487_cov_479.619469_g1779_i0 PRJEB6584 1868 487 479.619469 2335.74681403 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 112 4.42e-28   NR KAL3928702.1 3061772 g1779 i0 68 0.924024640657084 75 24 46.2 0 450 226 90 164 KAL3928702.1 MAG: hypothetical protein SGBAC_012534 [Bacillariaceae sp.] diamond 450 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
33049216 33049216 PRJEB6584p_S_NODE_28709_length_172_cov_2.532847_g28678_i0 PRJEB6584 28709 172 2.532847 4.35649684 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00247   NR EJK58442.1 159749 g28678 i0 87 0.401162790697674 23 3 40.1 0 138 70 24 46 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 69 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
33065626 33065626 PRJEB6584f_S_NODE_6701_length_154_cov_1.680672_g6695_i0 PRJEB6584 6701 154 1.680672 2.58823488 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 57 1.53e-8   NR YP_010134151.1 138539 g6695 i0 53.2 3.6038961038961 47 22 91.6 0 142 2 1 47 YP_010134151.1 ribosomal protein L14 [Navicula veneta] diamond 555 57 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
33116807 33116807 PRJEB6584e_S_NODE_2991_length_173_cov_2.789855_g2976_i0 PRJEB6584 2991 173 2.789855 4.82644915 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.93e-11   NR KAL3928702.1 3061772 g2976 i0 77.8 0.624277456647399 36 8 62.4 0 2 109 129 164 KAL3928702.1 MAG: hypothetical protein SGBAC_012534 [Bacillariaceae sp.] diamond 108 65.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
33116814 33116814 PRJEB6584f_S_NODE_6159_length_161_cov_1.222222_g6153_i0 PRJEB6584 6159 161 1.222222 1.96777742 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.32e-5   NR KAL3786977.1 29204 g6153 i0 65.7 1.86335403726708 35 12 65.2 0 2 106 691 725 KAL3786977.1 hypothetical protein HJC23_005488 [Cyclotella cryptica] diamond 300 50.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
33116815 33116815 PRJEB6584g_S_NODE_9711_length_180_cov_2.482759_g9699_i0 PRJEB6584 9711 180 2.482759 4.4689662 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00267   NR EJK58442.1 159749 g9699 i0 87 0.383333333333333 23 3 38.3 0 83 15 24 46 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 69 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
33134023 33134023 PRJEB6584j_S_NODE_28279_length_155_cov_1.000000_g28250_i0 PRJEB6584 28279 155 1 1.55 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 80.9 2.95e-18   NR AID23594.1 2850 g28250 i0 84 0.967741935483871 50 8 96.8 0 6 155 24 73 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 150 80.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
33134413 33134413 PRJEB6584o_S_NODE_39839_length_172_cov_2.080292_g39731_i0 PRJEB6584 39839 172 2.080292 3.57810224 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 79 1.38e-16   NR KAG7353494.1 303405 g39731 i0 73.5 14.4593023255814 49 13 85.5 0 169 23 125 173 KAG7353494.1 acyl carrier protein [Nitzschia inconspicua] diamond 2487 79 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
33134482 33134482 PRJEB6584o_S_NODE_5951_length_338_cov_7.363036_g5843_i0 PRJEB6584 5951 338 7.363036 24.88706168 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.6400000000000001e-22   NR AID23573.1 2850 g5843 i0 82.4 0.905325443786982 51 9 45.3 0 3 155 61 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 306 94.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
33162073 33162073 PRJEB6584o_S_NODE_7208_length_315_cov_3.435714_g7100_i0 PRJEB6584 7208 315 3.435714 10.8224991 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.87e-6   NR VEU39975.1 183589 g7100 i0 58.8 0.933333333333333 51 20 47.6 1 1 150 330 380 VEU39975.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 294 55.5 0.992792792792793 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
33167976 33167976 PRJEB6584j_S_NODE_3144_length_226_cov_4.136126_g3115_i0 PRJEB6584 3144 226 4.136126 9.34764476 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 72.8 2.83e-14   NR KAL3762786.1 2934178 g3115 i0 60 0.730088495575221 55 22 73 0 224 60 76 130 KAL3762786.1 hypothetical protein ACHAW5_001314 [Stephanodiscus triporus] diamond 165 72.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus

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