RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB55122" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 15 ✖

tax_clade 1

bioproject 1

  • PRJEB55122 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
121281 121281 PRJEB55122_P_NODE_39381_length_166_cov_0.888889_g38984_i0 PRJEB55122 39381 166 0.888889 1.47555574 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 150 4.79e-32   NTclustered gi|2795036611|ref|XM_067936479.1| 4785 g38984 i0 88.095 6.25903614457831 126 15 76 0 41 166 141 266 Phytophthora cinnamomi acyl-CoA desaturase (IUM83_11890), partial mRNA blastn 1039 150 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
1395752 1395752 PRJEB55122_P_NODE_42622_length_163_cov_0.912281_g42225_i0 PRJEB55122 42622 163 0.912281 1.48701803 Phytophthora capsici 4784 SAR_Eukaryotes SAR_Eukaryotes 122 1.0199999999999999e-23   NTclustered gi|1122816947|gb|BT032032.2| 4784 g42225 i0 82.27 8.87730061349693 141 25 87 0 5 145 913 1053 Phytophthora capsici clone CBOT121-E08 mRNA sequence blastn 1447 122 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
3542321 3542321 PRJEB55122_P_NODE_37903_length_168_cov_0.873950_g37506_i0 PRJEB55122 37903 168 0.87395 1.468236 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 211 2.2e-50   NTclustered gi|2794920858|ref|XM_067880618.1| 164328 g37506 i0 90.123 350.732142857143 162 16 96 0 7 168 62 223 Phytophthora ramorum Ubiquitin-40S ribosomal protein S27a (KRP23_10197), partial mRNA blastn 58923 211 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
4819722 4819722 PRJEB55122_P_NODE_35284_length_173_cov_1.258065_g34887_i0 PRJEB55122 35284 173 1.258065 2.17645245 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 228 2.2499999999999995e-55   NTclustered gi|2795044194|ref|XM_067924716.1| 4785 g34887 i0 91.975 10.5375722543353 162 13 94 0 1 162 162 1 Phytophthora cinnamomi 60S ribosomal protein L38 (IUM83_00903), partial mRNA blastn 1823 230 0.991304347826087 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
7773430 7773430 PRJEB55122_P_NODE_29907_length_192_cov_1.454545_g29510_i0 PRJEB55122 29907 192 1.454545 2.7927264 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 270 4.19e-68   NTclustered gi|937408816|ref|NC_027966.1| 114742 g29510 i0 92.147 88.53125 191 15 99 0 2 192 10093 10283 Pythium insidiosum mitochondrial DNA, complete genome blastn 16998 270 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
12470738 12470738 PRJEB55122_P_NODE_19070_length_256_cov_2.357488_g18673_i0 PRJEB55122 19070 256 2.357488 6.03516928 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 418 1.9899999999999994e-112   NTclustered gi|1770692515|ref|NC_045089.1| 555429 g18673 i0 96.094 103.359375 256 10 100 0 1 256 1029 774 Phytophthora sansomeana mitochondrion, complete genome blastn 26460 420 0.995238095238095 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sansomeana
16294455 16294455 PRJEB55122_P_NODE_30053_length_191_cov_3.225352_g29656_i0 PRJEB55122 30053 191 3.225352 6.16042232 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 353 4.02e-93   NTclustered gi|505574757|gb|AY598617.2| 65069 g29656 i0 100 100 191 0 100 0 1 191 1632 1442 Pythium acanthicum strain CBS 377.34 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19100 353 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium acanthicum
17569602 17569602 PRJEB55122_P_NODE_24054_length_220_cov_1.473684_g23657_i0 PRJEB55122 24054 220 1.473684 3.2421048 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 224 3.9e-54   NTclustered gi|813102101|ref|XM_012338325.1| 695850 g23657 i0 85.253 74.9318181818182 217 32 99 0 4 220 1349 1133 Saprolegnia parasitica CBS 223.65 ATP synthase subunit beta partial mRNA blastn 16485 224 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
21393875 21393875 PRJEB55122_P_NODE_29137_length_195_cov_1.506849_g28740_i0 PRJEB55122 29137 195 1.506849 2.93835555 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 211 2.63e-50   NTclustered gi|2795042812|ref|XM_067924392.1| 4785 g28740 i0 86.154 7.01025641025641 195 27 100 0 1 195 539 733 Phytophthora cinnamomi 60S ribosomal protein L7a-2 (IUM83_00609), partial mRNA blastn 1367 211 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
21797593 21797593 PRJEB55122_P_NODE_26858_length_205_cov_1.852564_g26461_i0 PRJEB55122 26858 205 1.852564 3.7977562 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 267 5.87e-67   NTclustered gi|695405931|ref|XM_009525669.1| 67593 g26461 i0 90.547 80.8829268292683 201 19 98 0 3 203 564 364 Phytophthora sojae hypothetical protein partial mRNA blastn 16581 267 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
21798070 21798070 PRJEB55122_P_NODE_42918_length_162_cov_2.017699_g42521_i0 PRJEB55122 42918 162 2.017699 3.26867238 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 300 4.36e-77   NTclustered gi|937408816|ref|NC_027966.1| 114742 g42521 i0 100 103.851851851852 162 0 100 0 1 162 9927 9766 Pythium insidiosum mitochondrial DNA, complete genome blastn 16824 300 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
23073073 23073073 PRJEB55122_P_NODE_31999_length_184_cov_1.585185_g31602_i0 PRJEB55122 31999 184 1.585185 2.9167404 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 217 5.26e-52   NTclustered gi|2794909608|ref|XM_067890891.1| 164328 g31602 i0 89.474 14.5652173913043 171 18 93 0 14 184 435 265 Phytophthora ramorum 60S ribosomal protein L27 (KRP23_5783), partial mRNA blastn 2680 217 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
23073297 23073297 PRJEB55122_P_NODE_39599_length_166_cov_0.888889_g39202_i0 PRJEB55122 39599 166 0.888889 1.47555574 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 150 4.79e-32   NTclustered gi|695433768|ref|XM_009532964.1| 67593 g39202 i0 89.344 2.05421686746988 122 9 72 4 8 127 154 273 Phytophthora sojae hypothetical protein mRNA blastn 341 150 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
25217859 25217859 PRJEB55122_P_NODE_30800_length_189_cov_1.114286_g30403_i0 PRJEB55122 30800 189 1.114286 2.10600054 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 309 8.72e-80   NTclustered gi|2651589115|gb|PP108238.1| 4785 g30403 i0 96.774 101.698412698413 186 5 98 1 3 188 23177 23361 Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome blastn 19221 311 0.993569131832797 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
25217866 25217866 PRJEB55122_P_NODE_35360_length_173_cov_0.895161_g34963_i0 PRJEB55122 35360 173 0.895161 1.54862853 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 226 8.089999999999997e-55   NTclustered gi|813233307|ref|XM_012358054.1| 695850 g34963 i0 90.173 54.7861271676301 173 17 100 0 1 173 103 275 Saprolegnia parasitica CBS 223.65 40S ribosomal protein S15a partial mRNA blastn 9478 226 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);;