RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA478247" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA478247 · 12 ✖

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
5551414 5551414 PRJNA478247_P_NODE_245_length_1003_cov_2.543121_g187_i0 PRJNA478247 245 1003 2.543121 25.50750363 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 305 9.08e-95   NR P41753.1 4767 g187 i0 69.2 49.2771684945165 224 69 67 0 722 51 396 619 P41753.1 RecName: Full=Heat shock 70 kDa protein [Achlya klebsiana] diamond 49425 307 0.993485342019544 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya klebsiana
5551423 5551423 PRJNA478247_P_NODE_765_length_479_cov_4.708889_g660_i0 PRJNA478247 765 479 4.708889 22.55557831 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 216 6.99e-69   NR XP_067819212.1 4779 g660 i0 76.2 9.48225469728601 151 33 94.6 2 453 1 19 166 XP_067819212.1 hypothetical protein CCR75_006450 [Bremia lactucae] diamond 4542 217 0.995391705069124 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
8100853 8100853 PRJNA478247_P_NODE_167_length_1159_cov_2.791150_g123_i0 PRJNA478247 167 1159 2.79115 32.3494285 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 386 3.25e-129   NR TMW60420.1 41045 g123 i0 71.4 12.3675582398619 262 72 67 1 791 15 122 383 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 14334 386 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
12576132 12576132 PRJNA478247_P_NODE_750_length_487_cov_3.886463_g645_i0 PRJNA478247 750 487 3.886463 18.92707481 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 209 3.3499999999999997e-66   NR GLD99505.1 114742 g645 i0 70.1 5.56878850102669 144 41 88.7 1 16 447 16 157 GLD99505.1 hypothetical protein PINS_up008231 [Pythium insidiosum] diamond 2712 211 0.990521327014218 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
14476325 14476325 PRJNA478247_P_NODE_1612_length_289_cov_2.030769_g1506_i0 PRJNA478247 1612 289 2.030769 5.86892241 Peronospora belbahrii 622444 SAR_Eukaryotes SAR_Eukaryotes 161 4.31e-48   NR CAH0477327.1 622444 g1506 i0 78.9 31.5570934256055 95 20 98.6 0 3 287 46 140 CAH0477327.1 unnamed protein product [Peronospora belbahrii] diamond 9120 161 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii
14476331 14476331 PRJNA478247_P_NODE_472_length_657_cov_2.380573_g379_i0 PRJNA478247 472 657 2.380573 15.64036461 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 314 1.29e-103   NR TMW60420.1 41045 g379 i0 71.4 9.04566210045662 220 60 99.1 1 6 656 140 359 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 5943 314 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
26981297 26981297 PRJNA478247_P_NODE_702_length_505_cov_3.798319_g597_i0 PRJNA478247 702 505 3.798319 19.18151095 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 144 1.7e-40   NR KAJ0400417.1 114742 g597 i0 52.4 1.63960396039604 143 68 85 0 485 57 13 155 KAJ0400417.1 hypothetical protein P43SY_001695 [Pythium insidiosum] diamond 828 144 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28608276 28608276 PRJNA478247_P_NODE_567_length_596_cov_3.783069_g466_i0 PRJNA478247 567 596 3.783069 22.54709124 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 248 1.19e-80   NR GLD96523.1 114742 g466 i0 66.9 9.18120805369128 181 60 91.1 0 18 560 1 181 GLD96523.1 hypothetical protein PINS_up005206 [Pythium insidiosum] diamond 5472 248 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31197780 31197780 PRJNA478247_P_NODE_1995_length_247_cov_2.399083_g1889_i0 PRJNA478247 1995 247 2.399083 5.92573501 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.15e-12   NR KAI9998526.1 4787 g1889 i0 51.6 10.336032388664 62 29 74.1 1 183 1 9 70 KAI9998526.1 hypothetical protein PInf_002917 [Phytophthora infestans] diamond 2553 68.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
31577819 31577819 PRJNA478247_P_NODE_3176_length_168_cov_2.568345_g3070_i0 PRJNA478247 3176 168 2.568345 4.3148196 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 2.05e-22   NR XP_067819212.1 4779 g3070 i0 80 27.4107142857143 55 11 98.2 0 166 2 30 84 XP_067819212.1 hypothetical protein CCR75_006450 [Bremia lactucae] diamond 4605 93.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
31656329 31656329 PRJNA478247_P_NODE_2777_length_191_cov_1.592593_g2671_i0 PRJNA478247 2777 191 1.592593 3.04185263 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 60.8 6.54e-9   NR KAG9410398.1 112091 g2671 i0 65.1 0.675392670157068 43 15 67.5 0 129 1 6 48 KAG9410398.1 60S acidic ribosomal protein P0 [Aphanomyces cochlioides] diamond 129 60.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
31988903 31988903 PRJNA478247_P_NODE_858_length_448_cov_4.947494_g753_i0 PRJNA478247 858 448 4.947494 22.16477312 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 176 2.31e-53   NR KAG1707364.1 4784 g753 i0 73.8 23.7120535714286 122 30 81 2 419 57 59 179 KAG1707364.1 40S ribosomal protein S20 [Phytophthora capsici] diamond 10623 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici

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