RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJDB3785" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 13 ✖

tax_clade 1

bioproject 1

  • PRJDB3785 · 13 ✖

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
8824 8824 PRJDB3785_S_NODE_21001_length_174_cov_1.224000_g20848_i0 PRJDB3785 21001 174 1.224 2.12976 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 94.4 5.53e-21   NR KAI2507236.1 210448 g20848 i0 79.6 2.82758620689655 54 11 93.1 0 172 11 45 98 KAI2507236.1 DnaJ C terminal domain-containing protein [Fragilaria crotonensis] diamond 492 94.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
3835026 3835026 PRJDB3785_S_NODE_23784_length_166_cov_0.940171_g23631_i0 PRJDB3785 23784 166 0.940171 1.56068386 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 96.3 4.82e-22   NR CAJ1946716.1 2856 g23631 i0 87.2 28.1204819277108 47 6 84.9 0 164 24 191 237 CAJ1946716.1 unnamed protein product [Cylindrotheca closterium] diamond 4668 96.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
14036820 14036820 PRJDB3785_S_NODE_17492_length_188_cov_1.446043_g17339_i0 PRJDB3785 17492 188 1.446043 2.71856084 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.46e-4   NTclustered gi|224008227|ref|XM_002293037.1| 296543 g17339 i0 100 0.632978723404255 31 0 16 0 158 188 560 590 Thalassiosira pseudonana CCMP1335 predicted protein mRNA blastn 119 58.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
21383358 21383358 PRJDB3785_S_NODE_7897_length_267_cov_1.633028_g7744_i0 PRJDB3785 7897 267 1.633028 4.36018476 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 113 2.0800000000000004e-27   NR KAG7348031.1 303405 g7744 i0 63.6 4.8876404494382 88 32 98.9 0 267 4 139 226 KAG7348031.1 50S ribosomal protein L3 [Nitzschia inconspicua] diamond 1305 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
26804941 26804941 PRJDB3785_S_NODE_9041_length_251_cov_1.287129_g8888_i0 PRJDB3785 9041 251 1.287129 3.23069379 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 119 8.599999999999999e-33   NR CAJ1936351.1 2856 g8888 i0 74.6 5.15139442231076 71 18 84.9 0 213 1 6 76 CAJ1936351.1 unnamed protein product [Cylindrotheca closterium] diamond 1293 119 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27279508 27279508 PRJDB3785_S_NODE_16103_length_195_cov_1.047945_g15950_i0 PRJDB3785 16103 195 1.047945 2.04349275 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.35e-16   NR VEU38730.1 183589 g15950 i0 59.4 4.89230769230769 64 26 98.5 0 193 2 48 111 VEU38730.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 954 83.2 0.990384615384615 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27532101 27532101 PRJDB3785_S_NODE_14983_length_201_cov_0.815789_g14830_i0 PRJDB3785 14983 201 0.815789 1.63973589 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 89 2.24e-19   NR EJK48596.1 159749 g14830 i0 66.1 8.98507462686567 59 18 85.1 1 201 31 163 221 EJK48596.1 hypothetical protein THAOC_32592 [Thalassiosira oceanica] diamond 1806 89 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28485277 28485277 PRJDB3785_S_NODE_7307_length_278_cov_1.227074_g7154_i0 PRJDB3785 7307 278 1.227074 3.41126572 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 122 1.57e-33   NR GKY93202.1 2872254 g7154 i0 61.4 5.63309352517986 88 34 95 0 264 1 3 90 GKY93202.1 hypothetical protein MPSEU_000288000 [Mayamaea pseudoterrestris] diamond 1566 122 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28769301 28769301 PRJDB3785_S_NODE_21887_length_171_cov_1.221311_g21734_i0 PRJDB3785 21887 171 1.221311 2.08844181 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.7e-16   NR GKY99949.1 2872254 g21734 i0 70.9 6.75438596491228 55 16 96.5 0 167 3 9 63 GKY99949.1 hypothetical protein MPSEU_000948500 [Mayamaea pseudoterrestris] diamond 1155 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29937751 29937751 PRJDB3785_S_NODE_10391_length_235_cov_1.155914_g10238_i0 PRJDB3785 10391 235 1.155914 2.7163979 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 73.2 5.21e-14   NR KAG7356899.1 303405 g10238 i0 56.2 3.76595744680851 73 32 93.2 0 219 1 89 161 KAG7356899.1 ATP synthase F0F1 subunit epsilon [Nitzschia inconspicua] diamond 885 73.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31581180 31581180 PRJDB3785_S_NODE_7056_length_283_cov_0.940171_g6903_i0 PRJDB3785 7056 283 0.940171 2.66068393 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 53.9 6.86e-6   NR GAX25719.1 1519565 g6903 i0 40.3 0.657243816254417 62 35 63.6 1 247 68 367 428 GAX25719.1 solute carrier family 30 (zinc transporter), member 2 [Fistulifera solaris] diamond 186 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32118954 32118954 PRJDB3785_S_NODE_14938_length_201_cov_1.078947_g14785_i0 PRJDB3785 14938 201 1.078947 2.16868347 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 49.3 9.91e-5   NR KAK1738756.1 267567 g14785 i0 57.5 0.597014925373134 40 15 56.7 1 200 87 118 157 KAK1738756.1 hypothetical protein QTG54_010786 [Skeletonema marinoi] diamond 120 49.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32435550 32435550 PRJDB3785_S_NODE_14039_length_206_cov_1.566879_g13886_i0 PRJDB3785 14039 206 1.566879 3.22777074 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 86.3 6.03e-19   NR CAB9521408.1 568900 g13886 i0 66.7 1.66019417475728 57 19 83 0 20 190 148 204 CAB9521408.1 40S ribosomal protein S8 [Seminavis robusta] diamond 342 86.3 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);;