RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA763718 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
2020213 2020213 PRJNA763718_S_NODE_2602_length_282_cov_2.579592_g2394_i0 PRJNA763718 2602 282 2.579592 7.27444944 Thraustochytriidae sp. HU1 363907 SAR_Eukaryotes SAR_Eukaryotes 152 3.4e-45   NR ABC85732.1 363907 g2394 i0 78.5 4.9468085106383 93 20 98.9 0 280 2 45 137 ABC85732.1 elongation factor 1-alpha, partial [Thraustochytriidae sp. HU1] diamond 1395 152 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae   Thraustochytriidae sp. HU1
3295438 3295438 PRJNA763718_S_NODE_2423_length_293_cov_1.343750_g2215_i0 PRJNA763718 2423 293 1.34375 3.9371875 Schizochytrium sp. TIO11 1907177 SAR_Eukaryotes SAR_Eukaryotes 107 2.1e-25   NR ANO44452.1 1868228 g2215 i0 61 0.839590443686007 82 32 84 0 247 2 287 368 ANO44452.1 cytochrome b [Schizochytrium sp. TIO1101] diamond 246 107 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Schizochytrium Schizochytrium sp. TIO1101
14773119 14773119 PRJNA763718_S_NODE_4072_length_218_cov_1.204420_g3864_i0 PRJNA763718 4072 218 1.20442 2.6256356 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 128 9.82e-33   NR EWM21100.1 72520 g3864 i0 80.3 7.81651376146789 71 14 97.7 0 3 215 368 438 EWM21100.1 s-adenosyl homocysteine hydrolase [Nannochloropsis gaditana] diamond 1704 129 0.992248062015504 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
21146731 21146731 PRJNA763718_S_NODE_6157_length_176_cov_1.366906_g5949_i0 PRJNA763718 6157 176 1.366906 2.40575456 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 95.1 8.189999999999999e-23   NR KAG1707364.1 4784 g5949 i0 81 16.8068181818182 58 11 98.9 0 176 3 86 143 KAG1707364.1 40S ribosomal protein S20 [Phytophthora capsici] diamond 2958 95.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
23697149 23697149 PRJNA763718_S_NODE_8799_length_150_cov_0.911504_g8591_i0 PRJNA763718 8799 150 0.911504 1.367256 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 85.9 2.14e-18   NR GBG33967.1 2315210 g8591 i0 90 1 50 5 100 0 150 1 149 198 GBG33967.1 Peroxisomal multifunctional enzyme type 2 [Hondaea fermentalgiana] diamond 150 85.9 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
28262817 28262817 PRJNA763718_S_NODE_8546_length_152_cov_0.956522_g8338_i0 PRJNA763718 8546 152 0.956522 1.45391344 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.97e-13   NR GBG31765.1 2315210 g8338 i0 72 13.5592105263158 50 14 98.7 0 152 3 769 818 GBG31765.1 V-type proton ATPase 116 kDa subunit a isoform 1 [Hondaea fermentalgiana] diamond 2061 73.2 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
28916162 28916162 PRJNA763718_S_NODE_7748_length_158_cov_2.024793_g7540_i0 PRJNA763718 7748 158 2.024793 3.19917294 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 66.6 4.34e-11   NR GBG31409.1 2315210 g7540 i0 63.6 0.835443037974684 44 16 83.5 0 155 24 494 537 GBG31409.1 ADP-ribosylation factor [Hondaea fermentalgiana] diamond 132 66.6 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
29579208 29579208 PRJNA763718_S_NODE_4370_length_210_cov_1.624277_g4162_i0 PRJNA763718 4370 210 1.624277 3.4109817 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.65e-19   NR GBG29256.1 2315210 g4162 i0 75.9 2.31428571428571 54 13 77.1 0 209 48 52 105 GBG29256.1 Non-specific lipid-transfer protein [Hondaea fermentalgiana] diamond 486 85.1 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
30599812 30599812 PRJNA763718_S_NODE_6473_length_172_cov_1.081481_g6265_i0 PRJNA763718 6473 172 1.081481 1.86014732 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 80.1 5.93e-17   NR RHX98215.1 112090 g6265 i0 70 8.26744186046512 50 15 87.2 0 3 152 31 80 RHX98215.1 hypothetical protein DYB36_009520, partial [Aphanomyces astaci] diamond 1422 80.9 0.990111248454882 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31073950 31073950 PRJNA763718_S_NODE_5575_length_185_cov_1.574324_g5367_i0 PRJNA763718 5575 185 1.574324 2.9124994 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00679   NR XP_002185608.1 556484 g5367 i0 52.1 2.33513513513514 48 20 77.8 1 182 39 665 709 XP_002185608.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 432 44.3 0.99097065462754 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31199840 31199840 PRJNA763718_S_NODE_4855_length_199_cov_1.679012_g4647_i0 PRJNA763718 4855 199 1.679012 3.34123388 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 46.6 5.15e-4   NR KAF0727141.1 100861 g4647 i0 42 7.49246231155779 50 28 73.9 1 4 150 116 165 KAF0727141.1 hypothetical protein Ae201684_014778 [Aphanomyces euteiches] diamond 1491 46.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
31295096 31295096 PRJNA763718_S_NODE_6215_length_175_cov_2.057971_g6007_i0 PRJNA763718 6215 175 2.057971 3.60144925 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 87.4 1.45e-19   NR CAK9033624.1 1381693 g6007 i0 86.7 5.45142857142857 45 6 77.1 0 173 39 162 206 CAK9033624.1 ADP-ribosylation factor, partial [Durusdinium trenchii] diamond 954 87.8 0.995444191343964 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
31317126 31317126 PRJNA763718_S_NODE_6235_length_175_cov_1.340580_g6027_i0 PRJNA763718 6235 175 1.34058 2.346015 Thraustochytrium sp. LLF1b 1112570 SAR_Eukaryotes SAR_Eukaryotes 72 3.61e-13   NR DAC74094.1 1112570 g6027 i0 60.7 0.96 56 21 94.3 1 166 2 222 277 DAC74094.1 TPA_exp: guanine nucleotide-binding protein subunit beta protein [Thraustochytrium sp. LLF1b] diamond 168 72 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Thraustochytrium Thraustochytrium sp. LLF1b
31759903 31759903 PRJNA763718_S_NODE_4537_length_206_cov_1.372781_g4329_i0 PRJNA763718 4537 206 1.372781 2.82792886 Labyrinthula sp. 1678526 SAR_Eukaryotes SAR_Eukaryotes 71.6 5.14e-13   NR QOW07447.1 1678526 g4329 i0 53.7 0.975728155339806 67 31 97.6 0 4 204 109 175 QOW07447.1 ATP synthase F0 subunit a, partial [Labyrinthula sp.] diamond 201 71.6 1 Eukaryota Sar     Bigyra Labyrinthulida Labyrinthulaceae Labyrinthula Labyrinthula sp.
32202915 32202915 PRJNA763718_S_NODE_7378_length_162_cov_1.224000_g7170_i0 PRJNA763718 7378 162 1.224 1.98288 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.86e-12   NR GBG31676.1 2315210 g7170 i0 64.6 0.888888888888889 48 17 88.9 0 147 4 222 269 GBG31676.1 Protein disulfide-isomerase [Hondaea fermentalgiana] diamond 144 69.7 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana

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