RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA414036 · 18 ✖

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
1693656 1693656 PRJNA414036_P_NODE_69542_length_184_cov_10.510067_g67803_i0 PRJNA414036 69542 184 10.510067 19.33852328 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 65.8 2.02e-6   NTclustered gi|325186956|emb|FR824170.1| 890382 g67803 i0 91.489 0.255434782608696 47 4 26 0 138 184 23545 23499 Albugo laibachii Nc14, genomic contig CONTIG_125_NC14_v4_70474_256 blastn 47 65.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
27012210 27012210 PRJNA414036_P_NODE_2962_length_584_cov_10.597450_g2371_i0 PRJNA414036 2962 584 10.59745 61.889108 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.83e-11   NR KAJ8569249.1 4785 g2371 i0 38.3 1.20719178082192 115 71 59.1 0 174 518 14 128 KAJ8569249.1 hypothetical protein ON010_g6011 [Phytophthora cinnamomi] diamond 705 73.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
27408500 27408500 PRJNA414036_P_NODE_27183_length_289_cov_4.102362_g25448_i0 PRJNA414036 27183 289 4.102362 11.85582618 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.06e-9   NR XP_009824718.1 112090 g25448 i0 70.5 0.892733564013841 44 13 45.7 0 3 134 47 90 XP_009824718.1 hypothetical protein H257_02672 [Aphanomyces astaci] diamond 258 61.6 0.993506493506494 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
27629461 27629461 PRJNA414036_P_NODE_28384_length_282_cov_8.906883_g26649_i0 PRJNA414036 28384 282 8.906883 25.11741006 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00151   NR XP_024579212.1 4781 g26649 i0 56.3 273.478723404255 80 35 85.1 0 31 270 1860 1939 XP_024579212.1 pre-mrna-processing-splicing factor 8 [Plasmopara halstedii] diamond 77121 47.8 0.99163179916318 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
27644438 27644438 PRJNA414036_P_NODE_16344_length_368_cov_8.195195_g14645_i0 PRJNA414036 16344 368 8.195195 30.1583176 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 95.1 7.31e-20   NR KAJ8566653.1 4785 g14645 i0 42.5 0.978260869565217 120 69 97.8 0 2 361 1193 1312 KAJ8566653.1 hypothetical protein ON010_g6469 [Phytophthora cinnamomi] diamond 360 95.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
27676027 27676027 PRJNA414036_P_NODE_12644_length_404_cov_6.750678_g11027_i0 PRJNA414036 12644 404 6.750678 27.27273912 Peronosclerospora sorghi 230839 SAR_Eukaryotes SAR_Eukaryotes 62.4 1e-8   NR KAI9911590.1 230839 g11027 i0 41.8 0.727722772277228 98 55 72 2 104 394 119 215 KAI9911590.1 hypothetical protein PsorP6_009854 [Peronosclerospora sorghi] diamond 294 62.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronosclerospora Peronosclerospora sorghi
27739288 27739288 PRJNA414036_P_NODE_72044_length_178_cov_4.447552_g70305_i0 PRJNA414036 72044 178 4.447552 7.91664256 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00235   NR KAJ8538981.1 4785 g70305 i0 41.3 0.775280898876405 46 27 77.5 0 146 9 495 540 KAJ8538981.1 hypothetical protein ON010_g12890 [Phytophthora cinnamomi] diamond 138 45.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
28686416 28686416 PRJNA414036_P_NODE_5847_length_502_cov_5.074946_g4795_i0 PRJNA414036 5847 502 5.074946 25.47622892 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.27e-4   NR KAJ8566515.1 4785 g4795 i0 42.2 0.382470119521912 64 37 38.2 0 202 11 864 927 KAJ8566515.1 hypothetical protein ON010_g6611 [Phytophthora cinnamomi] diamond 192 52.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
28970371 28970371 PRJNA414036_P_NODE_1028_length_724_cov_14.066763_g717_i1 PRJNA414036 1028 724 14.066763 101.84336412 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.0145   NR KAJ8535323.1 4785 g717 i1 41.3 0.625690607734807 75 44 31.1 0 490 714 167 241 KAJ8535323.1 hypothetical protein ON010_g13416 [Phytophthora cinnamomi] diamond 453 48.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
29128440 29128440 PRJNA414036_P_NODE_29329_length_277_cov_16.504132_g27594_i0 PRJNA414036 29329 277 16.504132 45.71644564 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 54.3 2.16e-6   NR KAJ8577208.1 4785 g27594 i0 58.8 0.552346570397112 51 21 55.2 0 199 47 135 185 KAJ8577208.1 hypothetical protein ON010_g2004 [Phytophthora cinnamomi] diamond 153 54.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
29917724 29917724 PRJNA414036_P_NODE_2591_length_602_cov_5.456790_g2060_i0 PRJNA414036 2591 602 5.45679 32.8498758 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.018   NR KAJ8578318.1 4785 g2060 i0 33.9 0.617940199335548 124 81 61.3 1 379 11 269 392 KAJ8578318.1 hypothetical protein ON010_g886 [Phytophthora cinnamomi] diamond 372 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30170206 30170206 PRJNA414036_P_NODE_6072_length_497_cov_7.179654_g4983_i0 PRJNA414036 6072 497 7.179654 35.68288038 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 70.5 1.2e-10   NR KAJ8559202.1 4785 g4983 i0 66.7 0.271629778672032 45 15 27.2 0 213 347 928 972 KAJ8559202.1 hypothetical protein ON010_g8244 [Phytophthora cinnamomi] diamond 135 70.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30707405 30707405 PRJNA414036_P_NODE_6234_length_494_cov_5.424837_g5123_i0 PRJNA414036 6234 494 5.424837 26.79869478 Phytophthora fragariaefolia 1490495 SAR_Eukaryotes SAR_Eukaryotes 65.1 2.95e-9   NR GMF20350.1 1490495 g5123 i0 32.1 1.28744939271255 106 72 64.4 0 370 53 103 208 GMF20350.1 unnamed protein product [Phytophthora fragariaefolia] diamond 636 65.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariaefolia
31055300 31055300 PRJNA414036_P_NODE_40735_length_231_cov_6.086735_g38996_i0 PRJNA414036 40735 231 6.086735 14.06035785 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 65.1 4.15e-10   NR RHY34128.1 157072 g38996 i0 69.4 2.66233766233766 49 15 63.6 0 148 2 30 78 RHY34128.1 hypothetical protein DYB32_001110 [Aphanomyces invadans] diamond 615 65.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
31276178 31276178 PRJNA414036_P_NODE_9895_length_436_cov_11.014963_g8396_i0 PRJNA414036 9895 436 11.014963 48.02523868 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 51.6 2.45e-4   NR KAJ8575459.1 4785 g8396 i0 41.9 1.12844036697248 74 43 50.9 0 147 368 25 98 KAJ8575459.1 hypothetical protein ON010_g3753 [Phytophthora cinnamomi] diamond 492 51.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
31307793 31307793 PRJNA414036_P_NODE_875_length_749_cov_13.777311_g717_i0 PRJNA414036 875 749 13.777311 103.19205939 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.0157   NR KAJ8535323.1 4785 g717 i0 41.3 0.300400534045394 75 44 30 0 515 739 167 241 KAJ8535323.1 hypothetical protein ON010_g13416 [Phytophthora cinnamomi] diamond 225 48.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
32352061 32352061 PRJNA414036_P_NODE_12119_length_410_cov_7.794667_g2060_i2 PRJNA414036 12119 410 7.794667 31.9581347 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.0042   NR KAJ8578318.1 4785 g2060 i2 33.9 0.907317073170732 124 81 90 1 32 400 269 392 KAJ8578318.1 hypothetical protein ON010_g886 [Phytophthora cinnamomi] diamond 372 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
32541920 32541920 PRJNA414036_P_NODE_13739_length_393_cov_7.374302_g12088_i0 PRJNA414036 13739 393 7.374302 28.98100686 Peronosclerospora sorghi 230839 SAR_Eukaryotes SAR_Eukaryotes 62 1.24e-8   NR KAI9911590.1 230839 g12088 i0 42.6 0.717557251908397 94 52 71 2 105 383 123 215 KAI9911590.1 hypothetical protein PsorP6_009854 [Peronosclerospora sorghi] diamond 282 62 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronosclerospora Peronosclerospora sorghi

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