RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1192965", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 13 ✖

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA1192965 · 13 ✖

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
7973790 7973790 PRJNA1192965_P_NODE_4487_length_244_cov_1.801170_g4468_i0 PRJNA1192965 4487 244 1.80117 4.3948548 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 100 7.75e-17   NTclustered gi|675165376|ref|XM_008893325.1| 761204 g4468 i0 95.312 21.0245901639344 64 1 26 2 157 219 700 638 Phytophthora parasitica INRA-310 hypothetical protein mRNA blastn 5130 100 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
10524199 10524199 PRJNA1192965_P_NODE_1849_length_309_cov_0.978814_g1830_i0 PRJNA1192965 1849 309 0.978814 3.02453526 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 147 1.54e-38   NR KAF1778943.1 29920 g1830 i0 71.4 8.13592233009709 105 28 100 1 1 309 141 245 KAF1778943.1 50S ribosomal protein L30e-like [Phytophthora cactorum] diamond 2514 148 0.993243243243243 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
12521074 12521074 PRJNA1192965_P_NODE_3890_length_248_cov_0.880000_g3871_i0 PRJNA1192965 3890 248 0.88 2.1824 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 126 1.39e-33   NR KAH9084905.1 100861 g3871 i0 78.2 2.83064516129032 78 17 94.4 0 15 248 44 121 KAH9084905.1 hypothetical protein Ae201684P_002138 [Aphanomyces euteiches] diamond 702 126 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
13074110 13074110 PRJNA1192965_P_NODE_3891_length_248_cov_0.880000_g3872_i0 PRJNA1192965 3891 248 0.88 2.1824 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 97.4 2.25e-21   NR DAZ95965.1 4803 g3872 i0 69 7.65725806451613 71 22 85.9 0 35 247 509 579 DAZ95965.1 TPA: hypothetical protein N0F65_009266, partial [Lagenidium giganteum] diamond 1899 97.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
24546577 24546577 PRJNA1192965_P_NODE_860_length_411_cov_1.695266_g841_i0 PRJNA1192965 860 411 1.695266 6.96754326 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 191 1.61e-53   NR KAJ0406923.1 114742 g841 i0 65.4 4.96350364963504 136 47 99.3 0 2 409 289 424 KAJ0406923.1 hypothetical protein P43SY_001774 [Pythium insidiosum] diamond 2040 191 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
26616563 26616563 PRJNA1192965_P_NODE_5161_length_241_cov_0.916667_g5142_i0 PRJNA1192965 5161 241 0.916667 2.20916747 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.4e-6   NR KAE9355055.1 53985 g5142 i0 48.8 1.61825726141079 43 22 53.5 0 6 134 329 371 KAE9355055.1 hypothetical protein PF008_g4237 [Phytophthora fragariae] diamond 390 53.9 0.992578849721707 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
26945701 26945701 PRJNA1192965_P_NODE_662_length_461_cov_2.324742_g643_i0 PRJNA1192965 662 461 2.324742 10.71706062 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 103 6.11e-25   NR KAJ0400315.1 114742 g643 i0 50 2.55748373101952 134 60 84.6 3 21 410 2 132 KAJ0400315.1 hypothetical protein P43SY_002063 [Pythium insidiosum] diamond 1179 103 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
27849339 27849339 PRJNA1192965_P_NODE_1264_length_357_cov_1.419014_g1245_i0 PRJNA1192965 1264 357 1.419014 5.06587998 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.4200000000000002e-21   NR DAZ93587.1 4803 g1245 i0 64 4.42016806722689 75 27 63 0 3 227 62 136 DAZ93587.1 TPA: hypothetical protein N0F65_009935 [Lagenidium giganteum] diamond 1578 93.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
29851335 29851335 PRJNA1192965_P_NODE_4311_length_245_cov_1.453488_g4292_i0 PRJNA1192965 4311 245 1.453488 3.5610456 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00433   NR RHY01207.1 112090 g4292 i0 52.9 0.624489795918367 51 24 62.4 0 239 87 160 210 RHY01207.1 hypothetical protein DYB36_000251 [Aphanomyces astaci] diamond 153 45.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
29901972 29901972 PRJNA1192965_P_NODE_2851_length_264_cov_1.560209_g2832_i0 PRJNA1192965 2851 264 1.560209 4.11895176 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 93.6 6.4e-20   NR TMW62833.1 41045 g2832 i0 58.8 4.85227272727273 85 34 95.5 1 258 7 265 349 TMW62833.1 hypothetical protein Poli38472_005451 [Pythium oligandrum] diamond 1281 94.4 0.991525423728813 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
31715873 31715873 PRJNA1192965_P_NODE_3577_length_250_cov_0.870056_g3558_i0 PRJNA1192965 3577 250 0.870056 2.17514 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.63e-4   NR OQR82408.1 1202772 g3558 i0 36.1 0.864 72 41 80.4 2 203 3 578 649 OQR82408.1 methylcrotonoyl-CoA carboxylase subunit alpha [Achlya hypogyna] diamond 216 48.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
31987929 31987929 PRJNA1192965_P_NODE_5038_length_242_cov_0.911243_g5019_i0 PRJNA1192965 5038 242 0.911243 2.20520806 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 85.5 3.27e-17   NR KAG2782289.1 29920 g5019 i0 51.3 8.92561983471074 80 39 99.2 0 241 2 356 435 KAG2782289.1 Beta-xylosidase/alpha-L-arabinofuranosidase 2 [Phytophthora cactorum] diamond 2160 85.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
32777858 32777858 PRJNA1192965_P_NODE_4840_length_243_cov_0.905882_g4821_i0 PRJNA1192965 4840 243 0.905882 2.20129326 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0276   NR XP_012198918.1 695850 g4821 i0 50 1.03703703703704 42 21 51.9 0 114 239 424 465 XP_012198918.1 hypothetical protein SPRG_05017 [Saprolegnia parasitica CBS 223.65] diamond 252 43.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica

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