RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 17 ✖

tax_clade 1

bioproject 1

  • PRJEB50332 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
2669526 2669526 PRJEB50332_P_NODE_1883_length_409_cov_1.821839_g1802_i0 PRJEB50332 1883 409 1.821839 7.45132151 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 65.5 2.54e-9   NR OWZ20071.1 4795 g1802 i0 50.7 3.18337408312958 71 32 52.1 1 408 196 99 166 OWZ20071.1 hypothetical protein PHMEG_0005576 [Phytophthora megakarya] diamond 1302 65.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
17970993 17970993 PRJEB50332_P_NODE_155_length_1226_cov_2.453219_g119_i0 PRJEB50332 155 1226 2.453219 30.07646494 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 540 1.45e-189   NR TMW60420.1 41045 g119 i0 68.5 21.3009787928222 394 110 96.4 3 1 1182 4 383 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 26115 543 0.994475138121547 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
21796197 21796197 PRJEB50332_P_NODE_5538_length_262_cov_2.124378_g5456_i0 PRJEB50332 5538 262 2.124378 5.56587036 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.74e-18   NR KAF0750677.1 112090 g5456 i0 67.6 0.847328244274809 74 17 76.7 3 201 1 1 74 KAF0750677.1 hypothetical protein AaE_006624 [Aphanomyces astaci] diamond 222 87.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
23943608 23943608 PRJEB50332_P_NODE_5999_length_254_cov_1.010363_g5917_i0 PRJEB50332 5999 254 1.010363 2.56632202 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 156 1.89e-42   NR TMW61573.1 41045 g5917 i0 92.9 2.97637795275591 84 6 99.2 0 252 1 180 263 TMW61573.1 hypothetical protein Poli38472_012764 [Pythium oligandrum] diamond 756 157 0.993630573248408 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
27058419 27058419 PRJEB50332_P_NODE_17362_length_203_cov_0.915493_g17280_i0 PRJEB50332 17362 203 0.915493 1.85845079 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 119 1.6e-30   NR RHY08334.1 112090 g17280 i0 79.1 3.96059113300493 67 14 99 0 202 2 193 259 RHY08334.1 hypothetical protein DYB25_003472 [Aphanomyces astaci] diamond 804 119 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
27318153 27318153 PRJEB50332_P_NODE_12443_length_211_cov_1.420000_g12361_i0 PRJEB50332 12443 211 1.42 2.9962 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 90.1 5.2e-19   NR DAZ95514.1 4803 g12361 i0 61.8 2.90047393364929 68 26 96.7 0 204 1 1378 1445 DAZ95514.1 TPA: LOW QUALITY PROTEIN: hypothetical protein N0F65_001853, partial [Lagenidium giganteum] diamond 612 90.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
28549673 28549673 PRJEB50332_P_NODE_4767_length_278_cov_1.304147_g4685_i0 PRJEB50332 4767 278 1.304147 3.62552866 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0157   NR KAH9158171.1 100861 g4685 i0 35 4.99640287769784 60 39 64.7 0 11 190 257 316 KAH9158171.1 hypothetical protein AeRB84_000004 [Aphanomyces euteiches] diamond 1389 44.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
29016689 29016689 PRJEB50332_P_NODE_5568_length_262_cov_1.268657_g5486_i0 PRJEB50332 5568 262 1.268657 3.32388134 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 63.5 2.16e-9   NR RHY69310.1 112090 g5486 i0 41.8 2.77099236641221 79 42 90.5 2 242 6 468 542 RHY69310.1 hypothetical protein DYB34_009213 [Aphanomyces astaci] diamond 726 63.9 0.993740219092332 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
29048058 29048058 PRJEB50332_P_NODE_11708_length_215_cov_1.681818_g11626_i0 PRJEB50332 11708 215 1.681818 3.6159087 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 110 2.55e-26   NR XP_024572062.1 4781 g11626 i0 74.3 14.6651162790698 70 18 97.7 0 213 4 435 504 XP_024572062.1 trna wybutosine-synthesizing protein 1 homolog [Plasmopara halstedii] diamond 3153 111 0.990990990990991 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
30121461 30121461 PRJEB50332_P_NODE_6092_length_252_cov_1.670157_g6010_i0 PRJEB50332 6092 252 1.670157 4.20879564 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 7.140000000000001e-27   NR KAI9907086.1 230839 g6010 i0 80 4.26190476190476 70 14 83.3 0 249 40 88 157 KAI9907086.1 hypothetical protein PsorP6_004328 [Peronosclerospora sorghi] diamond 1074 107 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronosclerospora Peronosclerospora sorghi
30374813 30374813 PRJEB50332_P_NODE_10532_length_221_cov_2.031250_g10450_i0 PRJEB50332 10532 221 2.03125 4.4890625 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 108 4.16e-28   NR KAG1703166.1 4784 g10450 i0 71.6 5.93212669683258 74 20 99.1 1 1 219 23 96 KAG1703166.1 hypothetical protein DVH05_008077 [Phytophthora capsici] diamond 1311 109 0.990825688073395 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
30570406 30570406 PRJEB50332_P_NODE_9013_length_230_cov_1.449704_g8931_i0 PRJEB50332 9013 230 1.449704 3.3343192 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 67 7.19e-11   NR KAH9184750.1 100861 g8931 i0 52.1 0.952173913043478 73 33 92.6 1 215 3 130 202 KAH9184750.1 hypothetical protein AeNC1_013271, partial [Aphanomyces euteiches] diamond 219 67 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
30602123 30602123 PRJEB50332_P_NODE_9293_length_228_cov_1.754491_g9211_i0 PRJEB50332 9293 228 1.754491 4.00023948 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 71.2 1.72e-12   NR KAF0750677.1 112090 g9211 i0 54.7 0.986842105263158 75 31 94.7 2 221 6 155 229 KAF0750677.1 hypothetical protein AaE_006624 [Aphanomyces astaci] diamond 225 71.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31360870 31360870 PRJEB50332_P_NODE_17476_length_202_cov_2.297872_g17394_i0 PRJEB50332 17476 202 2.297872 4.64170144 Albugo laibachii Nc14 890382 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00244   NR CCA25018.1 890382 g17394 i0 37.7 1.75247524752475 53 31 75.7 1 199 47 420 472 CCA25018.1 Rab7 family GTPase putative [Albugo laibachii Nc14] diamond 354 45.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
31765119 31765119 PRJEB50332_P_NODE_5017_length_272_cov_2.279621_g4935_i0 PRJEB50332 5017 272 2.279621 6.20056912 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62 8.83e-9   NR KAI9996507.1 4787 g4935 i0 59.6 10.9963235294118 52 21 57.4 0 13 168 684 735 KAI9996507.1 hypothetical protein PInf_014235 [Phytophthora infestans] diamond 2991 62 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
32025053 32025053 PRJEB50332_P_NODE_4218_length_290_cov_2.122271_g4136_i0 PRJEB50332 4218 290 2.122271 6.1545859 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 62.8 5.78e-9   NR KAJ0404901.1 114742 g4136 i0 60.4 2.48275862068966 48 19 49.7 0 2 145 486 533 KAJ0404901.1 hypothetical protein P43SY_001813 [Pythium insidiosum] diamond 720 62.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
32594524 32594524 PRJEB50332_P_NODE_14440_length_208_cov_0.884354_g14358_i0 PRJEB50332 14440 208 0.884354 1.83945632 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 48.1 2.81e-4   NR XP_009825362.1 112090 g14358 i0 50 3 52 25 73.6 1 203 51 368 419 XP_009825362.1 hypothetical protein H257_03107 [Aphanomyces astaci] diamond 624 48.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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