RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 20 ✖

tax_clade 1

bioproject 1

  • PRJEB12982 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
2260964 2260964 PRJEB12982_P_NODE_16842_length_167_cov_0.864407_g16679_i0 PRJEB12982 16842 167 0.864407 1.44355969 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 97.8 5.08e-22   NR OQR95437.1 74557 g16679 i0 79.2 3.8622754491018 53 11 95.2 0 165 7 101 153 OQR95437.1 tubulin polyglutamylase [Thraustotheca clavata] diamond 645 97.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
8948008 8948008 PRJEB12982_P_NODE_4428_length_359_cov_2.025806_g4265_i0 PRJEB12982 4428 359 2.025806 7.27264354 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 196 2.2899999999999995e-55   NR XP_008610586.1 1156394 g4265 i0 80.2 9.72701949860724 116 23 96.9 0 350 3 1 116 XP_008610586.1 hypothetical protein SDRG_06578 [Saprolegnia diclina VS20] diamond 3492 196 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
16597908 16597908 PRJEB12982_P_NODE_9094_length_236_cov_1.363636_g8931_i0 PRJEB12982 9094 236 1.363636 3.21818096 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 136 3.27e-36   NR AIG55510.1 74557 g8931 i0 75.6 9.86440677966102 78 19 99.2 0 235 2 127 204 AIG55510.1 secreted protein [Thraustotheca clavata] diamond 2328 136 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
22662607 22662607 PRJEB12982_P_NODE_10778_length_215_cov_1.060241_g10615_i0 PRJEB12982 10778 215 1.060241 2.27951815 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 112 1.3100000000000002e-27   NR XP_008620512.1 1156394 g10615 i0 71.8 2.97209302325581 71 20 99.1 0 2 214 12 82 XP_008620512.1 N-ethylmaleimide reductase [Saprolegnia diclina VS20] diamond 639 112 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
27412533 27412533 PRJEB12982_P_NODE_19903_length_163_cov_0.894737_g19740_i0 PRJEB12982 19903 163 0.894737 1.45842131 Phytophthora palmivora 4796 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.00929   NR POM57615.1 4796 g19740 i0 38.9 1.98773006134969 54 31 99.4 1 1 162 268 319 POM57615.1 Serine protease family S09X [Phytophthora palmivora] diamond 324 43.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
27633426 27633426 PRJEB12982_P_NODE_15784_length_173_cov_1.645161_g15621_i0 PRJEB12982 15784 173 1.645161 2.84612853 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.8e-4   NR KAF0725889.1 100861 g15621 i0 43.9 1.76878612716763 57 31 97.1 1 1 168 14 70 KAF0725889.1 hypothetical protein Ae201684_015740 [Aphanomyces euteiches] diamond 306 48.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28170084 28170084 PRJEB12982_P_NODE_16626_length_168_cov_1.176471_g16463_i0 PRJEB12982 16626 168 1.176471 1.97647128 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 46.2 8.02e-4   NR KAH9103141.1 100861 g16463 i0 45 0.714285714285714 40 22 71.4 0 2 121 985 1024 KAH9103141.1 hypothetical protein AeMF1_020439 [Aphanomyces euteiches] diamond 120 46.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28327805 28327805 PRJEB12982_P_NODE_18486_length_165_cov_0.879310_g18323_i0 PRJEB12982 18486 165 0.87931 1.4508615 Phytophthora pseudosyringae 221518 SAR_Eukaryotes SAR_Eukaryotes 58.2 9.57e-9   NR KAG7384545.1 221518 g18323 i0 54.7 3.85454545454545 53 24 96.4 0 2 160 67 119 KAG7384545.1 60S ribosomal protein L14 [Phytophthora pseudosyringae] diamond 636 58.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora pseudosyringae
28416472 28416472 PRJEB12982_P_NODE_9326_length_232_cov_2.355191_g9163_i0 PRJEB12982 9326 232 2.355191 5.46404312 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 133 2.3299999999999997e-37   NR KAG1694345.1 4784 g9163 i0 80.5 5.97413793103448 77 15 99.6 0 2 232 73 149 KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici] diamond 1386 134 0.992537313432836 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
28542855 28542855 PRJEB12982_P_NODE_13507_length_190_cov_1.446809_g13344_i0 PRJEB12982 13507 190 1.446809 2.7489371 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 116 9.86e-29   NR KAH9108398.1 100861 g13344 i0 87.1 2.93684210526316 62 8 97.9 0 3 188 389 450 KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] diamond 558 116 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28794990 28794990 PRJEB12982_P_NODE_13927_length_187_cov_1.108696_g13764_i0 PRJEB12982 13927 187 1.108696 2.07326152 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 60.5 9.58e-9   NR KAG1705338.1 4784 g13764 i0 46.6 4.66844919786096 58 30 93 1 181 8 270 326 KAG1705338.1 hypothetical protein DVH05_004269 [Phytophthora capsici] diamond 873 60.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
28921363 28921363 PRJEB12982_P_NODE_15048_length_178_cov_2.240310_g14885_i0 PRJEB12982 15048 178 2.24031 3.9877518 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.84e-5   NR KAF0732339.1 100861 g14885 i0 78.6 3.50561797752809 28 6 47.2 0 177 94 94 121 KAF0732339.1 hypothetical protein Ae201684_010625 [Aphanomyces euteiches] diamond 624 48.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
30664950 30664950 PRJEB12982_P_NODE_19133_length_164_cov_0.886957_g18970_i0 PRJEB12982 19133 164 0.886957 1.45460948 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 111 6.96e-27   NR CAI5747462.1 86335 g18970 i0 98.1 1.9390243902439 53 1 97 0 1 159 105 157 CAI5747462.1 unnamed protein product [Peronospora destructor] diamond 318 111 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
30728094 30728094 PRJEB12982_P_NODE_8114_length_252_cov_2.009852_g7951_i0 PRJEB12982 8114 252 2.009852 5.06482704 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 82.4 6.92e-18   NR KAL0583057.1 65357 g7951 i0 48.2 1.91666666666667 83 43 98.8 0 2 250 40 122 KAL0583057.1 hypothetical protein ABG067_007023 [Albugo candida] diamond 483 82.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
30822943 30822943 PRJEB12982_P_NODE_21034_length_161_cov_0.910714_g20871_i0 PRJEB12982 21034 161 0.910714 1.46624954 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 60.1 9.23e-9   NR RQM29494.1 112090 g20871 i0 54.7 4.63975155279503 64 18 98.8 2 160 2 474 537 RQM29494.1 hypothetical protein B5M09_012001, partial [Aphanomyces astaci] diamond 747 60.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31296918 31296918 PRJEB12982_P_NODE_18615_length_165_cov_0.879310_g18452_i0 PRJEB12982 18615 165 0.87931 1.4508615 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.04e-16   NR KAG9409925.1 112091 g18452 i0 74.1 3.92727272727273 54 14 98.2 0 164 3 294 347 KAG9409925.1 G protein-activated inward rectifier potassium channel 2 [Aphanomyces cochlioides] diamond 648 82.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
31328559 31328559 PRJEB12982_P_NODE_19756_length_163_cov_0.894737_g19593_i0 PRJEB12982 19756 163 0.894737 1.45842131 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.12e-17   NR KAG9404282.1 112091 g19593 i0 77.4 3.90184049079755 53 12 97.5 0 3 161 245 297 KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] diamond 636 84.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
32018131 32018131 PRJEB12982_P_NODE_8538_length_245_cov_1.301020_g8375_i0 PRJEB12982 8538 245 1.30102 3.187499 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.9 1.81e-17   NR DBA04160.1 4803 g8375 i0 50.7 6.79591836734694 69 28 84.5 1 3 209 335 397 DBA04160.1 TPA: hypothetical protein N0F65_004268 [Lagenidium giganteum] diamond 1665 85.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
32113170 32113170 PRJEB12982_P_NODE_17578_length_166_cov_0.871795_g17415_i0 PRJEB12982 17578 166 0.871795 1.4471797 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.48e-14   NR KAJ8525479.1 4785 g17415 i0 61.5 12.1626506024096 52 20 94 0 5 160 27 78 KAJ8525479.1 hypothetical protein ON010_g15634 [Phytophthora cinnamomi] diamond 2019 76.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
32556370 32556370 PRJEB12982_P_NODE_4719_length_346_cov_1.202020_g4556_i0 PRJEB12982 4719 346 1.20202 4.1589892 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.17e-18   NR GLD95430.1 114742 g4556 i0 74.1 2.52312138728324 58 15 50.3 0 175 2 16 73 GLD95430.1 hypothetical protein PINS_up004074 [Pythium insidiosum] diamond 873 92 0.992391304347826 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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