RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 23 ✖

tax_clade 1

bioproject 1

  • PRJEB14175 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
25509041 25509041 PRJEB14175_P_NODE_33793_length_641_cov_14.684483_g31660_i0 PRJEB14175 33793 641 14.684483 94.12753603 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 176 1.58e-52   NR RHY74090.1 112090 g31660 i0 62 2.0405616224649 142 48 64.1 2 53 463 15 155 RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci] diamond 1308 176 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
25512214 25512214 PRJEB14175_P_NODE_90057_length_381_cov_6.687500_g87791_i0 PRJEB14175 90057 381 6.6875 25.479375 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 65.9 5.45e-11   NR CCI50508.1 65357 g87791 i0 48.3 5.01574803149606 58 30 45.7 0 359 186 2 59 CCI50508.1 unnamed protein product [Albugo candida] diamond 1911 65.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
25776380 25776380 PRJEB14175_P_NODE_16939_length_879_cov_4.768949_g15234_i0 PRJEB14175 16939 879 4.768949 41.91906171 Nothophytophthora sp. Chile5 2483409 SAR_Eukaryotes SAR_Eukaryotes 290 3.9599999999999996e-94   NR RLN89259.1 2483409 g15234 i0 56.3 2.90443686006826 268 90 85 4 850 104 33 292 RLN89259.1 hypothetical protein BBJ28_00017776 [Nothophytophthora sp. Chile5] diamond 2553 290 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp. Chile5
26045269 26045269 PRJEB14175_P_NODE_101925_length_353_cov_10.003425_g99659_i0 PRJEB14175 101925 353 10.003425 35.31209025 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 102 8.22e-24   NR TYZ58406.1 1485010 g99659 i0 86.4 0.501416430594901 59 8 50.1 0 352 176 193 251 TYZ58406.1 hypothetical protein PybrP1_000088 [[Pythium] brassicae (nom. inval.)] diamond 177 102 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
32908790 32908790 PRJEB14175_P_NODE_170713_length_254_cov_0.994819_g168446_i0 PRJEB14175 170713 254 0.994819 2.52684026 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 58.2 8.91e-8   NR KAL0591678.1 65357 g168446 i0 70 1.41732283464567 40 9 43.7 1 116 6 102 141 KAL0591678.1 hypothetical protein ABG067_000820 [Albugo candida] diamond 360 58.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32922701 32922701 PRJEB14175_P_NODE_94817_length_369_cov_10.077922_g92551_i0 PRJEB14175 94817 369 10.077922 37.18753218 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 67.8 9.9e-12   NR XP_012212736.1 695850 g92551 i0 51.6 3.08943089430894 62 30 50.4 0 346 161 54 115 XP_012212736.1 hypothetical protein SPRG_17929, partial [Saprolegnia parasitica CBS 223.65] diamond 1140 67.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
32942466 32942466 PRJEB14175_P_NODE_104946_length_347_cov_5.797203_g102680_i0 PRJEB14175 104946 347 5.797203 20.11629441 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.72e-11   NR KAF0694104.1 120398 g102680 i0 44.9 0.596541786743516 69 37 58.8 1 41 244 137 205 KAF0694104.1 hypothetical protein As57867_014934 [Aphanomyces stellatus] diamond 207 69.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
32960085 32960085 PRJEB14175_P_NODE_150290_length_276_cov_7.265116_g148023_i0 PRJEB14175 150290 276 7.265116 20.05172016 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.41e-8   NR DAZ93337.1 4803 g148023 i0 75.7 0.402173913043478 37 9 40.2 0 227 117 284 320 DAZ93337.1 TPA: hypothetical protein N0F65_010803 [Lagenidium giganteum] diamond 111 61.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
32960672 32960672 PRJEB14175_P_NODE_21218_length_796_cov_6.336054_g19347_i0 PRJEB14175 21218 796 6.336054 50.43498984 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 386 6.4999999999999986e-130   NR CCI46605.1 65357 g19347 i0 100 0.776381909547739 206 0 77.6 0 619 2 1 206 CCI46605.1 unnamed protein product [Albugo candida] diamond 618 386 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32961481 32961481 PRJEB14175_P_NODE_58114_length_487_cov_13.070423_g55862_i0 PRJEB14175 58114 487 13.070423 63.65296001 Globisporangium splendens 82926 SAR_Eukaryotes SAR_Eukaryotes 157 2.1e-45   NR KAF1332339.1 82926 g55862 i0 62.3 5.61806981519507 138 44 81.9 2 483 85 58 192 KAF1332339.1 60s ribosomal protein l18-2, partial [Globisporangium splendens] diamond 2736 157 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
32961615 32961615 PRJEB14175_P_NODE_72138_length_433_cov_7.397849_g69879_i0 PRJEB14175 72138 433 7.397849 32.03268617 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 168 2.34e-45   NR DBA03030.1 4803 g69879 i0 59.5 2.54272517321016 131 53 90.8 0 25 417 732 862 DBA03030.1 TPA: hypothetical protein N0F65_003218 [Lagenidium giganteum] diamond 1101 168 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
32973860 32973860 PRJEB14175_P_NODE_127218_length_308_cov_1.939271_g124951_i0 PRJEB14175 127218 308 1.939271 5.97295468 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 110 1.72e-25   NR XP_002897902.1 403677 g124951 i0 64.6 3.87662337662338 99 29 92.5 3 307 23 479 575 XP_002897902.1 phosphatidylinositide phosphatase SAC1 [Phytophthora infestans T30-4] diamond 1194 110 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
32990954 32990954 PRJEB14175_P_NODE_128523_length_306_cov_2.555102_g126256_i0 PRJEB14175 128523 306 2.555102 7.81861212 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.2 2.96e-7   NR KAF1326544.1 82926 g126256 i0 61 4.37254901960784 41 16 40.2 0 285 163 432 472 KAF1326544.1 Ethanolamine kinase, partial [Globisporangium splendens] diamond 1338 58.5 0.994871794871795 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
33029024 33029024 PRJEB14175_P_NODE_234284_length_207_cov_1.746575_g232016_i0 PRJEB14175 234284 207 1.746575 3.61541025 Phytophthora idaei 53986 SAR_Eukaryotes SAR_Eukaryotes 49.3 8.06e-5   NR KAG3112475.1 53986 g232016 i0 69 4.6231884057971 29 9 42 0 7 93 123 151 KAG3112475.1 hypothetical protein PI125_g8193 [Phytophthora idaei] diamond 957 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora idaei
33029383 33029383 PRJEB14175_P_NODE_279372_length_170_cov_4.073394_g277104_i0 PRJEB14175 279372 170 4.073394 6.9247698 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 47.4 3.07e-4   NR GLD93472.1 114742 g277104 i0 66.7 6.88235294117647 36 9 58.2 1 59 157 180 215 GLD93472.1 hypothetical protein PINS_up002064 [Pythium insidiosum] diamond 1170 47.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
33059040 33059040 PRJEB14175_P_NODE_16653_length_886_cov_8.804848_g14957_i0 PRJEB14175 16653 886 8.804848 78.01095328 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 116 3.7100000000000005e-27   NR XP_067783574.1 4785 g14957 i0 61.5 4.40180586907449 91 34 30.8 1 863 591 99 188 XP_067783574.1 putative ubiquitin-conjugating enzyme E2 [Phytophthora cinnamomi] diamond 3900 116 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
33062166 33062166 PRJEB14175_P_NODE_133757_length_298_cov_5.105485_g131490_i0 PRJEB14175 133757 298 5.105485 15.2143453 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 67 2.07e-10   NR GLD93518.1 114742 g131490 i0 59.3 2.95973154362416 59 23 58.4 1 175 2 242 300 GLD93518.1 hypothetical protein PINS_up002110 [Pythium insidiosum] diamond 882 67 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
33113171 33113171 PRJEB14175_P_NODE_120087_length_319_cov_8.507752_g117821_i0 PRJEB14175 120087 319 8.507752 27.13972888 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 74.3 2.15e-13   NR TYZ60519.1 1485010 g117821 i0 86 0.404388714733542 43 6 40.4 0 311 183 213 255 TYZ60519.1 hypothetical protein PybrP1_009297 [[Pythium] brassicae (nom. inval.)] diamond 129 74.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
33127481 33127481 PRJEB14175_P_NODE_248063_length_204_cov_0.895105_g245795_i0 PRJEB14175 248063 204 0.895105 1.8260142 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00857   NR KAG1705682.1 4784 g245795 i0 43.9 1.69117647058824 57 30 80.9 1 21 185 284 340 KAG1705682.1 hypothetical protein DVH05_003383 [Phytophthora capsici] diamond 345 43.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
33144754 33144754 PRJEB14175_P_NODE_97551_length_363_cov_4.572848_g95285_i0 PRJEB14175 97551 363 4.572848 16.59943824 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 70.5 3.21e-12   NR KAJ8578288.1 4785 g95285 i0 81.6 2.19834710743802 38 7 31.4 0 23 136 144 181 KAJ8578288.1 hypothetical protein ON010_g916 [Phytophthora cinnamomi] diamond 798 70.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
33149239 33149239 PRJEB14175_P_NODE_84960_length_394_cov_7.705706_g82695_i0 PRJEB14175 84960 394 7.705706 30.36048164 Hyaloperonospora brassicae 162125 SAR_Eukaryotes SAR_Eukaryotes 64.3 3.71e-9   NR CAI5738496.1 162125 g82695 i0 88.2 0.517766497461929 34 4 25.9 0 376 275 264 297 CAI5738496.1 unnamed protein product [Hyaloperonospora brassicae] diamond 204 64.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae
33161261 33161261 PRJEB14175_P_NODE_137288_length_293_cov_4.581897_g135021_i0 PRJEB14175 137288 293 4.581897 13.42495821 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 59.3 5.58e-9   NR DAZ97219.1 4803 g135021 i0 54.2 6.62457337883959 48 22 49.1 0 121 264 51 98 DAZ97219.1 TPA: hypothetical protein N0F65_003850 [Lagenidium giganteum] diamond 1941 59.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
33178531 33178531 PRJEB14175_P_NODE_123440_length_314_cov_1.517787_g121174_i0 PRJEB14175 123440 314 1.517787 4.76585118 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 50.4 1.11e-4   NR XP_024583070.1 4781 g121174 i0 55.3 2.72292993630573 38 17 36.3 0 2 115 7 44 XP_024583070.1 wd domain-containing protein [Plasmopara halstedii] diamond 855 50.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii

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