RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA473824", 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 · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA473824 · 21 ✖

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
1096676 1096676 PRJNA473824_P_NODE_74601_length_173_cov_3.661765_g73963_i0 PRJNA473824 74601 173 3.661765 6.33485345 root 1 Root_unresolved Root_unresolved 141 3.01e-29   NTclustered gi|166046654|emb|CU367771.1| 100861 g73963 i0 100 6.58959537572254 76 0 88 0 98 173 320 245 Aphanomyces euteiches cDNA blastn 1140 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2996789 2996789 PRJNA473824_P_NODE_111283_length_173_cov_2.500000_g110645_i0 PRJNA473824 111283 173 2.5 4.325 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 211 2.27e-50   NTclustered gi|166044664|emb|CU367573.1| 100861 g110645 i0 87.861 51.150289017341 173 10 100 1 1 173 532 371 Aphanomyces euteiches cDNA blastn 8849 211 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2997625 2997625 PRJNA473824_P_NODE_38423_length_195_cov_4.202532_g37785_i0 PRJNA473824 38423 195 4.202532 8.1949374 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 148 2.0899999999999996e-31   NTclustered gi|166044510|emb|CU367419.1| 100861 g37785 i0 100 37.1333333333333 80 0 41 0 1 80 366 445 Aphanomyces euteiches cDNA blastn 7241 148 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
4274069 4274069 PRJNA473824_P_NODE_48884_length_176_cov_5.935252_g48246_i0 PRJNA473824 48884 176 5.935252 10.44604352 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 231 1.78e-56   NTclustered gi|166044543|emb|CU367452.1| 100861 g48246 i0 86.932 53.9772727272727 176 21 100 1 1 176 561 388 Aphanomyces euteiches cDNA blastn 9500 231 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
4924375 4924375 PRJNA473824_P_NODE_140284_length_151_cov_5.605263_g139646_i0 PRJNA473824 140284 151 5.605263 8.46394713 root 1 Root_unresolved Root_unresolved 148 1.5299999999999999e-31   NTclustered gi|166046556|emb|CU367673.1| 100861 g139646 i0 90.164 29.6953642384106 122 0 73 1 1 110 54 175 Aphanomyces euteiches cDNA blastn 4484 148 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
7474653 7474653 PRJNA473824_P_NODE_70466_length_173_cov_3.889706_g69828_i0 PRJNA473824 70466 173 3.889706 6.72919138 root 1 Root_unresolved Root_unresolved 141 3.01e-29   NTclustered gi|166044630|emb|CU367539.1| 100861 g69828 i0 100 26.5491329479769 76 0 44 0 1 76 114 39 Aphanomyces euteiches cDNA blastn 4593 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
10024517 10024517 PRJNA473824_P_NODE_138128_length_151_cov_6.824561_g137490_i0 PRJNA473824 138128 151 6.824561 10.30508711 root 1 Root_unresolved Root_unresolved 141 2.56e-29   NTclustered gi|166044496|emb|CU367405.1| 100861 g137490 i0 97.59 30.5960264900662 83 1 54 1 70 151 702 784 Aphanomyces euteiches cDNA blastn 4620 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12575119 12575119 PRJNA473824_P_NODE_119930_length_171_cov_2.500000_g119292_i0 PRJNA473824 119930 171 2.5 4.275 root 1 Root_unresolved Root_unresolved 141 2.97e-29   NTclustered gi|166044656|emb|CU367565.1| 100861 g119292 i0 100 57.8187134502924 76 0 88 0 1 76 185 260 Aphanomyces euteiches cDNA blastn 9887 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12575590 12575590 PRJNA473824_P_NODE_55010_length_173_cov_5.786765_g54372_i0 PRJNA473824 55010 173 5.786765 10.01110345 root 1 Root_unresolved Root_unresolved 141 3.01e-29   NTclustered gi|166045068|emb|CU367574.1| 100861 g54372 i0 100 17.1387283236994 76 0 88 0 1 76 231 306 Aphanomyces euteiches cDNA blastn 2965 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
13199779 13199779 PRJNA473824_P_NODE_111511_length_173_cov_2.492647_g110873_i0 PRJNA473824 111511 173 2.492647 4.31227931 Phytophthora asparagi 631358 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.004   NTclustered gi|2314988779|ref|NC_067069.1| 631358 g110873 i0 79.747 0.456647398843931 79 12 44 3 1 76 4640 4563 Phytophthora asparagi voucher CBS132095 mitochondrion, complete genome blastn 79 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora asparagi
15124201 15124201 PRJNA473824_P_NODE_171212_length_150_cov_2.991150_g170574_i0 PRJNA473824 171212 150 2.99115 4.486725 root 1 Root_unresolved Root_unresolved 143 7.049999999999998e-30   NTclustered gi|166044555|emb|CU367464.1| 100861 g170574 i0 100 69.86 77 0 51 0 1 77 147 71 Aphanomyces euteiches cDNA blastn 10479 143 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17673769 17673769 PRJNA473824_P_NODE_119194_length_171_cov_5.037313_g118556_i0 PRJNA473824 119194 171 5.037313 8.61380523 root 1 Root_unresolved Root_unresolved 141 2.97e-29   NTclustered gi|166044468|emb|CU367377.1| 100861 g118556 i0 100 55.5964912280702 76 0 86 0 1 76 562 487 Aphanomyces euteiches cDNA blastn 9507 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17674129 17674129 PRJNA473824_P_NODE_43054_length_186_cov_3.469799_g42416_i0 PRJNA473824 43054 186 3.469799 6.45382614 root 1 Root_unresolved Root_unresolved 344 2.34e-90   NTclustered gi|166046666|emb|CU367776.1| 100861 g42416 i0 100 98.9731182795699 186 0 100 0 1 186 428 243 Aphanomyces euteiches cDNA blastn 18409 344 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17674212 17674212 PRJNA473824_P_NODE_55794_length_173_cov_5.588235_g55156_i0 PRJNA473824 55794 173 5.588235 9.66764655 root 1 Root_unresolved Root_unresolved 134 5.050000000000001e-27   NTclustered gi|166044662|emb|CU367571.1| 100861 g55156 i0 98.667 21.9595375722543 75 1 86 0 99 173 541 615 Aphanomyces euteiches cDNA blastn 3799 135 0.992592592592593 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18948205 18948205 PRJNA473824_P_NODE_83495_length_173_cov_3.264706_g82857_i0 PRJNA473824 83495 173 3.264706 5.64794138 root 1 Root_unresolved Root_unresolved 141 3.01e-29   NTclustered gi|166046519|emb|CU367636.1| 100861 g82857 i0 100 48.7398843930636 76 0 88 0 1 76 549 624 Aphanomyces euteiches cDNA blastn 8432 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21498171 21498171 PRJNA473824_P_NODE_170877_length_150_cov_3.106195_g170239_i0 PRJNA473824 170877 150 3.106195 4.6592925 root 1 Root_unresolved Root_unresolved 141 2.53e-29   NTclustered gi|166044558|emb|CU367467.1| 100861 g170239 i0 100 65.9533333333333 76 0 100 0 1 76 453 528 Aphanomyces euteiches cDNA blastn 9893 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
25322507 25322507 PRJNA473824_P_NODE_164460_length_150_cov_4.876106_g163822_i0 PRJNA473824 164460 150 4.876106 7.314159 root 1 Root_unresolved Root_unresolved 141 2.53e-29   NTclustered gi|166046579|emb|CU367696.1| 100861 g163822 i0 100 14.3133333333333 76 0 51 0 75 150 62 137 Aphanomyces euteiches cDNA blastn 2147 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
25322768 25322768 PRJNA473824_P_NODE_46420_length_180_cov_4.524476_g45782_i0 PRJNA473824 46420 180 4.524476 8.1440568 root 1 Root_unresolved Root_unresolved 327 2.2699999999999996e-85   NTclustered gi|166044652|emb|CU367561.1| 100861 g45782 i0 99.444 99.6444444444444 180 1 100 0 1 180 361 182 Aphanomyces euteiches cDNA blastn 17936 327 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
27265953 27265953 PRJNA473824_P_NODE_163063_length_150_cov_5.902655_g162425_i0 PRJNA473824 163063 150 5.902655 8.8539825 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 68.6 8e-12   NR RMX68316.1 542832 g162425 i0 77.1 0.96 48 8 90 1 149 15 632 679 RMX68316.1 hypothetical protein DD238_005319 [Peronospora effusa] diamond 144 68.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28339552 28339552 PRJNA473824_P_NODE_40166_length_192_cov_1.006452_g39528_i0 PRJNA473824 40166 192 1.006452 1.93238784 Phytophthora oleae 2107226 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0485   NR KAL3662092.1 2107226 g39528 i0 45.1 1.59375 51 24 79.7 1 181 29 156 202 KAL3662092.1 hypothetical protein V7S43_012896 [Phytophthora oleae] diamond 306 41.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora oleae
32352779 32352779 PRJNA473824_P_NODE_159359_length_151_cov_2.964912_g158721_i0 PRJNA473824 159359 151 2.964912 4.47701712 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.09e-21   NR XP_067786121.1 4785 g158721 i0 88.9 3.21854304635762 54 2 99.3 1 151 2 652 705 XP_067786121.1 Ribonucleoside-diphosphate reductase large subunit [Phytophthora cinnamomi] diamond 486 96.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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