RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 24 ✖

tax_clade 1

bioproject 1

  • PRJEB14664 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
5123712 5123712 PRJEB14664_P_NODE_8285_length_275_cov_2.795833_g8155_i0 PRJEB14664 8285 275 2.795833 7.68854075 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 154 2.58e-41   NR XP_008610586.1 1156394 g8155 i0 79.1 4.96363636363636 91 19 99.3 0 2 274 21 111 XP_008610586.1 hypothetical protein SDRG_06578 [Saprolegnia diclina VS20] diamond 1365 154 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
6399415 6399415 PRJEB14664_P_NODE_5546_length_356_cov_3.242991_g5416_i0 PRJEB14664 5546 356 3.242991 11.54504796 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 95.5 1.88e-20   NR DAZ92868.1 4803 g5416 i0 72.2 3.59831460674157 72 19 59.8 1 142 354 3 74 DAZ92868.1 TPA: hypothetical protein N0F65_003047 [Lagenidium giganteum] diamond 1281 95.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
8948278 8948278 PRJEB14664_P_NODE_8208_length_277_cov_1.822314_g8078_i0 PRJEB14664 8208 277 1.822314 5.04780978 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 126 1.61e-34   NR RHY32762.1 157072 g8078 i0 68.7 23.5992779783394 83 26 89.9 0 26 274 1 83 RHY32762.1 hypothetical protein DYB32_002271, partial [Aphanomyces invadans] diamond 6537 127 0.992125984251969 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
10223869 10223869 PRJEB14664_P_NODE_1009_length_918_cov_2.166478_g932_i0 PRJEB14664 1009 918 2.166478 19.88826804 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 431 3.68e-142   NR DBA01072.1 4803 g932 i0 68 29.9019607843137 306 97 100 1 918 1 295 599 DBA01072.1 TPA: hypothetical protein N0F65_002682 [Lagenidium giganteum] diamond 27450 432 0.997685185185185 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
11499268 11499268 PRJEB14664_P_NODE_2830_length_539_cov_3.565476_g2711_i0 PRJEB14664 2830 539 3.565476 19.21791564 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 170 2.91e-50   NR DBA01302.1 4803 g2711 i0 59.2 7.92022263450835 142 52 76.3 2 60 470 42 182 DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum] diamond 4269 171 0.994152046783626 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
16598016 16598016 PRJEB14664_P_NODE_1594_length_730_cov_2.912230_g1495_i0 PRJEB14664 1594 730 2.91223 21.259279 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 216 1.44e-67   NR RHY03263.1 112090 g1495 i0 57.6 1.3972602739726 170 72 69.9 0 688 179 2 171 RHY03263.1 hypothetical protein DYB36_008331, partial [Aphanomyces astaci] diamond 1020 216 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
16598023 16598023 PRJEB14664_P_NODE_1654_length_719_cov_2.154971_g1553_i0 PRJEB14664 1654 719 2.154971 15.49424149 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 182 1.2899999999999997e-54   NR RHY06028.1 112090 g1553 i0 71.9 0.504867872044506 121 34 50.5 0 25 387 19 139 RHY06028.1 hypothetical protein DYB25_001794 [Aphanomyces astaci] diamond 363 182 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
26805091 26805091 PRJEB14664_P_NODE_14101_length_191_cov_1.282051_g13971_i0 PRJEB14664 14101 191 1.282051 2.44871741 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.9 6.73e-16   NR TMW61137.1 41045 g13971 i0 61.9 8.05759162303665 63 23 99 1 1 189 423 484 TMW61137.1 hypothetical protein Poli38472_013600 [Pythium oligandrum] diamond 1539 80.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
27570124 27570124 PRJEB14664_P_NODE_17284_length_166_cov_1.221374_g17154_i0 PRJEB14664 17284 166 1.221374 2.02748084 Nothophytophthora sp. Chile5 2483409 SAR_Eukaryotes SAR_Eukaryotes 70.1 2.95e-12   NR RLN26948.1 2483409 g17154 i0 63 4.98795180722892 46 17 83.1 0 13 150 343 388 RLN26948.1 hypothetical protein BBJ28_00002485 [Nothophytophthora sp. Chile5] diamond 828 70.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp. Chile5
27728436 27728436 PRJEB14664_P_NODE_20124_length_151_cov_1.379310_g19994_i0 PRJEB14664 20124 151 1.37931 2.0827581 Phytophthora pseudosyringae 221518 SAR_Eukaryotes SAR_Eukaryotes 83.6 2.43e-17   NR KAG7382094.1 221518 g19994 i0 72 5.96026490066225 50 14 99.3 0 1 150 116 165 KAG7382094.1 hypothetical protein PHYPSEUDO_005308 [Phytophthora pseudosyringae] diamond 900 83.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora pseudosyringae
28889847 28889847 PRJEB14664_P_NODE_5628_length_352_cov_4.037855_g5498_i0 PRJEB14664 5628 352 4.037855 14.2132496 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 133 2.04e-33   NR DAZ98414.1 4803 g5498 i0 63.5 3.16193181818182 96 35 81.8 0 22 309 586 681 DAZ98414.1 TPA: hypothetical protein N0F65_000128 [Lagenidium giganteum] diamond 1113 134 0.992537313432836 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
28959689 28959689 PRJEB14664_P_NODE_7268_length_300_cov_1.811321_g7138_i0 PRJEB14664 7268 300 1.811321 5.433963 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.11e-22   NR TMW64003.1 41045 g7138 i0 62.2 1.8 90 34 90 0 31 300 1 90 TMW64003.1 hypothetical protein Poli38472_014708 [Pythium oligandrum] diamond 540 95.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
29685314 29685314 PRJEB14664_P_NODE_1970_length_656_cov_2.739130_g1863_i0 PRJEB14664 1970 656 2.73913 17.9686928 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 202 7.16e-58   NR GLD99359.1 114742 g1863 i0 75.9 3.28810975609756 145 32 66.3 2 27 461 441 582 GLD99359.1 hypothetical protein PINS_up008078 [Pythium insidiosum] diamond 2157 202 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
29710483 29710483 PRJEB14664_P_NODE_1570_length_736_cov_3.517832_g1472_i0 PRJEB14664 1570 736 3.517832 25.89124352 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 374 8.649999999999997e-129   NR KAG6952591.1 29920 g1472 i0 74.9 5.9429347826087 235 58 95.4 1 10 711 1 235 KAG6952591.1 hypothetical protein JG687_00012914, partial [Phytophthora cactorum] diamond 4374 377 0.992042440318302 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
30500629 30500629 PRJEB14664_P_NODE_15633_length_178_cov_1.118881_g15503_i0 PRJEB14664 15633 178 1.118881 1.99160818 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00854   NR KAJ0412099.1 114742 g15503 i0 73.3 1.5 30 8 50.6 0 2 91 130 159 KAJ0412099.1 hypothetical protein ATCC90586_004019 [Pythium insidiosum] diamond 267 43.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
30532153 30532153 PRJEB14664_P_NODE_20233_length_150_cov_4.026087_g20103_i0 PRJEB14664 20233 150 4.026087 6.0391305 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 57 2.54e-9   NR XP_008610509.1 1156394 g20103 i0 61.4 5.32 44 16 88 1 13 144 1 43 XP_008610509.1 40S ribosomal protein S29 [Saprolegnia diclina VS20] diamond 798 57.4 0.993031358885017 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
30538531 30538531 PRJEB14664_P_NODE_12473_length_207_cov_1.627907_g12343_i0 PRJEB14664 12473 207 1.627907 3.36976749 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 84.3 5.01e-17   NR AIG56335.1 1202772 g12343 i0 66.1 4.17391304347826 56 19 81.2 0 175 8 189 244 AIG56335.1 secreted protein [Achlya hypogyna] diamond 864 84.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
30791334 30791334 PRJEB14664_P_NODE_14634_length_186_cov_1.589404_g14504_i0 PRJEB14664 14634 186 1.589404 2.95629144 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 122 8.919999999999999e-31   NR KAF0699183.1 120398 g14504 i0 96.8 1 62 2 100 0 1 186 407 468 KAF0699183.1 hypothetical protein As57867_010196 [Aphanomyces stellatus] diamond 186 122 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
31006135 31006135 PRJEB14664_P_NODE_3274_length_496_cov_2.299349_g3151_i0 PRJEB14664 3274 496 2.299349 11.40477104 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0137   NR DBA01073.1 4803 g3151 i0 50 2.89112903225806 36 18 21.8 0 380 487 99 134 DBA01073.1 TPA: hypothetical protein N0F65_002683 [Lagenidium giganteum] diamond 1434 45.8 0.991266375545852 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
31259003 31259003 PRJEB14664_P_NODE_20175_length_151_cov_1.034483_g20045_i0 PRJEB14664 20175 151 1.034483 1.56206933 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52 5.55e-6   NR KAK1928771.1 4793 g20045 i0 61.3 16.2317880794702 31 12 61.6 0 95 3 106 136 KAK1928771.1 Protein disulfide-isomerase 5-4 [Phytophthora citrophthora] diamond 2451 52.4 0.99236641221374 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
31455200 31455200 PRJEB14664_P_NODE_19116_length_156_cov_0.950413_g18986_i0 PRJEB14664 19116 156 0.950413 1.48264428 Saprolegnia parasitica CBS 223.65 695850 SAR_Eukaryotes SAR_Eukaryotes 70.5 1.5e-12   NR XP_012200822.1 695850 g18986 i0 78.6 1.61538461538462 42 9 80.8 0 30 155 116 157 XP_012200822.1 hypothetical protein SPRG_06613 [Saprolegnia parasitica CBS 223.65] diamond 252 70.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
31834493 31834493 PRJEB14664_P_NODE_10957_length_227_cov_1.250000_g10827_i0 PRJEB14664 10957 227 1.25 2.8375 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 72.8 3.98e-13   NR RHY29274.1 157072 g10827 i0 56.5 1.5726872246696 62 25 79.3 1 1 180 124 185 RHY29274.1 hypothetical protein DYB32_005283 [Aphanomyces invadans] diamond 357 72.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
31891575 31891575 PRJEB14664_P_NODE_7197_length_302_cov_1.498127_g7067_i0 PRJEB14664 7197 302 1.498127 4.52434354 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 64.7 2.9e-10   NR RLO03389.1 112090 g7067 i0 56 3.55629139072848 50 20 49.7 1 301 152 126 173 RLO03389.1 hypothetical protein DYB28_012908, partial [Aphanomyces astaci] diamond 1074 65.1 0.993855606758833 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
32467742 32467742 PRJEB14664_P_NODE_14619_length_186_cov_1.589404_g14489_i0 PRJEB14664 14619 186 1.589404 2.95629144 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00517   NR XP_008609660.1 1156394 g14489 i0 37.7 3.32258064516129 53 33 85.5 0 4 162 503 555 XP_008609660.1 hypothetical protein SDRG_05709 [Saprolegnia diclina VS20] diamond 618 44.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina

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