RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 16 ✖

tax_clade 1

bioproject 1

  • PRJEB6584 · 16 ✖

analysis 1

  • diamond · 16 ✖

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