RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1108009", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA1108009 · 16 ✖

analysis 1

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
213192 213192 PRJNA1108009_P_NODE_31921_length_238_cov_2.527273_g31603_i0 PRJNA1108009 31921 238 2.527273 6.01490974 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 109 1.18e-27   NR KAK1943090.1 4793 g31603 i0 69.7 4.62605042016807 76 19 95.8 1 229 2 36 107 KAK1943090.1 60S ribosomal protein L11-1 [Phytophthora citrophthora] diamond 1101 110 0.990909090909091 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
6123519 6123519 PRJNA1108009_P_NODE_20985_length_280_cov_1.115942_g20667_i0 PRJNA1108009 20985 280 1.115942 3.1246376 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 123 2.24e-30   NR KUF93227.1 4792 g20667 i0 69.6 56.1857142857143 92 24 98.6 1 278 3 527 614 KUF93227.1 hypothetical protein AM588_10007506 [Phytophthora nicotianae] diamond 15732 124 0.991935483870968 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
9140436 9140436 PRJNA1108009_P_NODE_16188_length_326_cov_1.169960_g15870_i0 PRJNA1108009 16188 326 1.1699600000000001 3.8140696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 184 7.12e-57   NR KAI9994045.1 4787 g15870 i0 75.9 19.8773006134969 108 26 99.4 0 1 324 62 169 KAI9994045.1 hypothetical protein PInf_016604 [Phytophthora infestans] diamond 6480 184 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
10416280 10416280 PRJNA1108009_P_NODE_17069_length_316_cov_1.090535_g16751_i0 PRJNA1108009 17069 316 1.090535 3.4460906 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 112 4.06e-27   NR XP_067790198.1 4785 g16751 i0 70.7 0.712025316455696 75 20 69.3 1 265 47 19 93 XP_067790198.1 glyceraldehyde-3-phosphate dehydrogenase [Phytophthora cinnamomi] diamond 225 112 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
16790053 16790053 PRJNA1108009_P_NODE_20154_length_286_cov_1.502347_g19836_i0 PRJNA1108009 20154 286 1.502347 4.29671242 Globisporangium splendens 82926 SAR_Eukaryotes SAR_Eukaryotes 113 7.77e-27   NR KAF1334384.1 82926 g19836 i0 49.5 2.98951048951049 95 48 99.7 0 2 286 487 581 KAF1334384.1 Atypical/abc1/abc1-a protein kinase, partial [Globisporangium splendens] diamond 855 113 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
18064777 18064777 PRJNA1108009_P_NODE_28255_length_246_cov_0.890173_g27937_i0 PRJNA1108009 28255 246 0.890173 2.18982558 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.34e-12   NR RHY74090.1 112090 g27937 i0 53.6 2.52439024390244 69 26 78 2 245 54 88 155 RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci] diamond 621 69.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
24438909 24438909 PRJNA1108009_P_NODE_22940_length_264_cov_1.209424_g22622_i0 PRJNA1108009 22940 264 1.209424 3.19287936 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 115 4.62e-28   NR KAF1316791.1 82926 g22622 i0 63.2 6.92045454545455 87 29 98.9 2 263 3 392 475 KAF1316791.1 Protein disulfide-isomerase domain, partial [Globisporangium splendens] diamond 1827 116 0.991379310344828 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
26624493 26624493 PRJNA1108009_P_NODE_22541_length_267_cov_1.257732_g22223_i0 PRJNA1108009 22541 267 1.257732 3.35814444 Peronospora belbahrii 622444 SAR_Eukaryotes SAR_Eukaryotes 65.5 4.79e-10   NR CAH0477563.1 622444 g22223 i0 42.1 1.73033707865169 76 43 85.4 1 20 247 432 506 CAH0477563.1 unnamed protein product [Peronospora belbahrii] diamond 462 65.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii
26687825 26687825 PRJNA1108009_P_NODE_20541_length_283_cov_1.466667_g20223_i0 PRJNA1108009 20541 283 1.466667 4.15066761 Peronospora belbahrii 622444 SAR_Eukaryotes SAR_Eukaryotes 62 2.86e-9   NR CAH0481426.1 622444 g20223 i0 47.4 0.604240282685512 57 30 60.4 0 278 108 17 73 CAH0481426.1 unnamed protein product [Peronospora belbahrii] diamond 171 62 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii
27162323 27162323 PRJNA1108009_P_NODE_30642_length_242_cov_1.650888_g30324_i0 PRJNA1108009 30642 242 1.650888 3.99514896 Phytophthora lilii 2077276 SAR_Eukaryotes SAR_Eukaryotes 47 0.0012   NR GMF65463.1 2077276 g30324 i0 33.8 0.991735537190083 80 49 99.2 2 1 240 261 336 GMF65463.1 unnamed protein product [Phytophthora lilii] diamond 240 47 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lilii
27185289 27185289 PRJNA1108009_P_NODE_22782_length_265_cov_1.572917_g22464_i0 PRJNA1108009 22782 265 1.572917 4.16823005 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00392   NR KAH9106235.1 100861 g22464 i0 50 1.89056603773585 42 21 47.5 0 128 3 243 284 KAH9106235.1 hypothetical protein AeMF1_018114 [Aphanomyces euteiches] diamond 501 45.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
27983640 27983640 PRJNA1108009_P_NODE_18645_length_300_cov_1.295154_g18327_i0 PRJNA1108009 18645 300 1.295154 3.885462 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 61.6 2.6e-9   NR KAF0732248.1 100861 g18327 i0 47.3 3.75 91 45 91 2 26 298 16 103 KAF0732248.1 hypothetical protein Ae201684_010540 [Aphanomyces euteiches] diamond 1125 61.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28511713 28511713 PRJNA1108009_P_NODE_18327_length_303_cov_1.339130_g18009_i0 PRJNA1108009 18327 303 1.33913 4.0575639 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 78.2 2.61e-14   NR KAJ8520718.1 4785 g18009 i0 45.3 8.32673267326733 106 49 98 2 301 5 294 397 KAJ8520718.1 hypothetical protein ON010_g17911 [Phytophthora cinnamomi] diamond 2523 78.6 0.994910941475827 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
28764241 28764241 PRJNA1108009_P_NODE_19667_length_290_cov_1.364055_g19349_i0 PRJNA1108009 19667 290 1.364055 3.9557595 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.07e-13   NR OQS02393.1 74557 g19349 i0 53.5 1.57241379310345 71 31 72.4 2 212 3 176 245 OQS02393.1 hypothetical protein THRCLA_05230 [Thraustotheca clavata] diamond 456 77 0.990909090909091 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
31006872 31006872 PRJNA1108009_P_NODE_31134_length_242_cov_0.911243_g30816_i0 PRJNA1108009 31134 242 0.911243 2.20520806 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 56.6 4.62e-7   NR KAF0738685.1 112090 g30816 i0 53.2 3.52066115702479 47 21 57 1 227 90 184 230 KAF0738685.1 hypothetical protein AaE_008852 [Aphanomyces astaci] diamond 852 56.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31828801 31828801 PRJNA1108009_P_NODE_6157_length_562_cov_2.141104_g5845_i0 PRJNA1108009 6157 562 2.141104 12.03300448 root 1 Root_unresolved Root_unresolved 173 2.74e-49   NR TMW61715.1 41045 g5845 i0 50 13.9483985765125 174 79 91.3 3 513 1 1 169 TMW61715.1 hypothetical protein Poli38472_010778 [Pythium oligandrum] diamond 7839 173 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum

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