RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 25 ✖

tax_clade 1

bioproject 1

  • PRJNA946307 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
20053388 20053388 PRJNA946307_P_NODE_17916_length_303_cov_4.657480_g17045_i0 PRJNA946307 17916 303 4.65748 14.1121644 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 140 3.14e-36   NR KAH9105104.1 100861 g17045 i0 71.3 9.25742574257426 94 27 93.1 0 16 297 133 226 KAH9105104.1 hypothetical protein LEN26_014867 [Aphanomyces euteiches] diamond 2805 141 0.99290780141844 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
26645316 26645316 PRJNA946307_P_NODE_122821_length_174_cov_1.544000_g121947_i0 PRJNA946307 122821 174 1.544 2.68656 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 106 2.58e-25   NR CAI5731153.1 86335 g121947 i0 94.3 0.913793103448276 53 3 91.4 0 172 14 383 435 CAI5731153.1 unnamed protein product [Peronospora destructor] diamond 159 106 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
26962029 26962029 PRJNA946307_P_NODE_71102_length_199_cov_2.993333_g70228_i0 PRJNA946307 71102 199 2.993333 5.95673267 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 81.6 1.71e-16   NR XP_067819098.1 4779 g70228 i0 64.1 1.17587939698492 78 9 90.5 2 15 194 218 294 XP_067819098.1 hypothetical protein CCR75_002571 [Bremia lactucae] diamond 234 81.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
28667745 28667745 PRJNA946307_P_NODE_105607_length_181_cov_5.530303_g104733_i0 PRJNA946307 105607 181 5.530303 10.00984843 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.64e-8   NR CAI5722011.1 542832 g104733 i0 66.7 0.596685082872928 36 12 59.7 0 36 143 674 709 CAI5722011.1 unnamed protein product [Peronospora effusa] diamond 108 59.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28674403 28674403 PRJNA946307_P_NODE_152727_length_164_cov_1.660870_g151853_i0 PRJNA946307 152727 164 1.66087 2.7238268 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 79 2.18e-15   NR TMW57565.1 41045 g151853 i0 68 2.74390243902439 50 15 89.6 1 16 162 656 705 TMW57565.1 hypothetical protein Poli38472_003490 [Pythium oligandrum] diamond 450 79 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
28674413 28674413 PRJNA946307_P_NODE_54667_length_210_cov_2.906832_g53793_i0 PRJNA946307 54667 210 2.906832 6.1043472 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 57 2.27e-7   NR KAL4093759.1 164328 g53793 i0 89.3 1.6 28 3 40 0 17 100 1414 1441 KAL4093759.1 hypothetical protein PRIC1_011189 [Phytophthora ramorum] diamond 336 57 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
28762277 28762277 PRJNA946307_P_NODE_165567_length_160_cov_2.486486_g164693_i0 PRJNA946307 165567 160 2.486486 3.9783776 Phytophthora boehmeriae 109152 SAR_Eukaryotes SAR_Eukaryotes 52 6.36e-6   NR KAG7382833.1 109152 g164693 i0 51.2 1.6125 43 21 80.6 0 30 158 556 598 KAG7382833.1 ATPase Na K transporting alpha [Phytophthora boehmeriae] diamond 258 52 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora boehmeriae
28832087 28832087 PRJNA946307_P_NODE_120848_length_175_cov_1.349206_g119974_i0 PRJNA946307 120848 175 1.349206 2.3611105 Peronospora 70742 SAR_Eukaryotes SAR_Eukaryotes 53.5 7.47e-7   NR CAI5745699.1 86335 g119974 i0 89.3 0.96 28 3 48 0 46 129 1 28 CAI5745699.1 unnamed protein product [Peronospora destructor] diamond 168 53.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
28856947 28856947 PRJNA946307_P_NODE_49568_length_210_cov_3.484472_g48694_i0 PRJNA946307 49568 210 3.484472 7.3173912 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00812   NR OWY97293.1 4795 g48694 i0 57.6 1.88571428571429 33 14 47.1 0 209 111 99 131 OWY97293.1 hypothetical protein PHMEG_00032217, partial [Phytophthora megakarya] diamond 396 43.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
29053371 29053371 PRJNA946307_P_NODE_47608_length_210_cov_4.031056_g46734_i0 PRJNA946307 47608 210 4.031056 8.4652176 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00659   NR CAI5718701.1 86335 g46734 i0 67.7 1.32857142857143 31 10 44.3 0 203 111 201 231 CAI5718701.1 unnamed protein product [Peronospora destructor] diamond 279 44.7 0.991051454138702 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
29109787 29109787 PRJNA946307_P_NODE_141508_length_167_cov_0.864407_g140634_i0 PRJNA946307 141508 167 0.864407 1.44355969 Hyaloperonospora brassicae 162125 SAR_Eukaryotes SAR_Eukaryotes 91.7 7.74e-20   NR CAI5736234.1 162125 g140634 i0 90.2 0.916167664670659 51 5 91.6 0 167 15 209 259 CAI5736234.1 unnamed protein product [Hyaloperonospora brassicae] diamond 153 91.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae
29394003 29394003 PRJNA946307_P_NODE_84889_length_191_cov_2.007042_g84015_i0 PRJNA946307 84889 191 2.007042 3.83345022 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0191   NR TMW69051.1 41045 g84015 i0 29.9 1.20942408376963 77 35 91.1 1 17 190 950 1026 TMW69051.1 hypothetical protein Poli38472_001207 [Pythium oligandrum] diamond 231 42.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
29867469 29867469 PRJNA946307_P_NODE_138971_length_167_cov_3.059322_g138097_i0 PRJNA946307 138971 167 3.059322 5.10906774 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.06e-15   NR RMX64894.1 542832 g138097 i0 91.7 1.29341317365269 36 3 64.7 0 6 113 281 316 RMX64894.1 hypothetical protein DD238_004245 [Peronospora effusa] diamond 216 79.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
29874234 29874234 PRJNA946307_P_NODE_56691_length_210_cov_2.801242_g55817_i0 PRJNA946307 56691 210 2.801242 5.8826082 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 106 8.39e-27   NR KAH9160777.1 100861 g55817 i0 75 3.65714285714286 64 16 91.4 0 202 11 9 72 KAH9160777.1 hypothetical protein LEN26_001712, partial [Aphanomyces euteiches] diamond 768 106 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
30056909 30056909 PRJNA946307_P_NODE_52611_length_210_cov_3.031056_g51737_i0 PRJNA946307 52611 210 3.031056 6.3652176 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0116   NR OWY90245.1 4795 g51737 i0 43.9 0.585714285714286 41 23 58.6 0 36 158 159 199 OWY90245.1 hypothetical protein PHMEG_00041718 [Phytophthora megakarya] diamond 123 43.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
30120070 30120070 PRJNA946307_P_NODE_158592_length_163_cov_0.894737_g157718_i0 PRJNA946307 158592 163 0.894737 1.45842131 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 93.2 2.05e-20   NR KAL4129227.1 164328 g157718 i0 82.7 4.78527607361963 52 9 95.7 0 6 161 1349 1400 KAL4129227.1 hypothetical protein PRIC2_005237 [Phytophthora ramorum] diamond 780 93.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
30436448 30436448 PRJNA946307_P_NODE_146473_length_166_cov_0.871795_g145599_i0 PRJNA946307 146473 166 0.871795 1.4471797 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 72.8 3.35e-13   NR CAI5732022.1 134698 g145599 i0 69.8 0.957831325301205 53 16 95.8 0 160 2 2 54 CAI5732022.1 unnamed protein product [Peronospora farinosa] diamond 159 72.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
30468046 30468046 PRJNA946307_P_NODE_150393_length_165_cov_0.879310_g149519_i0 PRJNA946307 150393 165 0.87931 1.4508615 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 85.5 1.13e-17   NR CAI5732022.1 134698 g149519 i0 78 1.81818181818182 50 11 90.9 0 150 1 490 539 CAI5732022.1 unnamed protein product [Peronospora farinosa] diamond 300 85.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
31320952 31320952 PRJNA946307_P_NODE_71455_length_199_cov_2.873333_g70581_i0 PRJNA946307 71455 199 2.873333 5.71793267 Phytophthora nicotianae CJ 4792 SAR_Eukaryotes SAR_Eukaryotes 46.2 3.2e-4   NR ETP15289.1 1317063 g70581 i0 45.6 0.85929648241206 57 31 85.9 0 10 180 7 63 ETP15289.1 hypothetical protein F441_09885, partial [Phytophthora nicotianae CJ01A1] diamond 171 46.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
31700588 31700588 PRJNA946307_P_NODE_66817_length_199_cov_4.646667_g65943_i0 PRJNA946307 66817 199 4.646667 9.24686733 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 58.9 3.29e-8   NR RMX68219.1 542832 g65943 i0 92.9 0.844221105527638 28 2 42.2 0 100 17 88 115 RMX68219.1 hypothetical protein DD238_006533 [Peronospora effusa] diamond 168 58.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
31826894 31826894 PRJNA946307_P_NODE_49657_length_210_cov_3.484472_g48783_i0 PRJNA946307 49657 210 3.484472 7.3173912 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00272   NR CAH0489507.1 134698 g48783 i0 44.2 0.742857142857143 52 24 67.1 1 184 44 46 97 CAH0489507.1 unnamed protein product [Peronospora farinosa] diamond 156 44.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
32111815 32111815 PRJNA946307_P_NODE_153018_length_164_cov_1.347826_g152144_i0 PRJNA946307 153018 164 1.347826 2.21043464 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 85.1 6.72e-19   NR CAI5714983.1 86335 g152144 i0 83.7 2.6890243902439 49 8 89.6 0 149 3 81 129 CAI5714983.1 unnamed protein product [Peronospora destructor] diamond 441 85.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
32143524 32143524 PRJNA946307_P_NODE_66118_length_199_cov_5.646667_g65244_i0 PRJNA946307 66118 199 5.646667 11.23686733 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.41e-4   NR CAI5732022.1 134698 g65244 i0 72.4 0.437185929648241 29 8 43.7 0 2 88 592 620 CAI5732022.1 unnamed protein product [Peronospora farinosa] diamond 87 48.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
32813350 32813350 PRJNA946307_P_NODE_88900_length_189_cov_2.014286_g88026_i0 PRJNA946307 88900 189 2.014286 3.80700054 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 78.6 1.39e-15   NR ETK81789.1 4792 g88026 i0 69.2 3.0952380952381 65 10 87.3 1 23 187 69 133 ETK81789.1 diphthine synthase, partial [Phytophthora nicotianae] diamond 585 78.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
32869676 32869676 PRJNA946307_P_NODE_167640_length_158_cov_2.623853_g166766_i0 PRJNA946307 167640 158 2.623853 4.14568774 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 75.5 6.29e-15   NR CAI5701513.1 542832 g166766 i0 76.7 10.1582278481013 43 10 81.6 0 131 3 179 221 CAI5701513.1 unnamed protein product [Peronospora effusa] diamond 1605 75.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa

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