RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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

  • PRJNA1118794 · 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
1505857 1505857 PRJNA1118794_P_NODE_74162_length_241_cov_0.916667_g73412_i0 PRJNA1118794 74162 241 0.916667 2.20916747 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 147 9.67e-31   NTclustered gi|669160265|ref|XM_008617473.1| 1156394 g73412 i0 85.714 11.4356846473029 140 18 58 2 7 145 340 202 Saprolegnia diclina VS20 ADP-ribosylation factor 1 mRNA blastn 2756 147 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
2781050 2781050 PRJNA1118794_P_NODE_23803_length_318_cov_1.885714_g23053_i0 PRJNA1118794 23803 318 1.885714 5.99657052 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 169 2.8399999999999997e-37   NTclustered gi|669165645|ref|XM_008620163.1| 1156394 g23053 i0 78.467 2.85220125786164 274 47 84 10 29 296 372 105 Saprolegnia diclina VS20 caltractin mRNA blastn 907 169 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
2781568 2781568 PRJNA1118794_P_NODE_6743_length_541_cov_1.893162_g6004_i0 PRJNA1118794 6743 541 1.893162 10.24200642 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 296 2.22e-75   NTclustered gi|698822976|ref|XM_009846215.1| 112090 g6004 i0 78.243 65.4288354898336 478 92 87 9 19 491 57 527 Aphanomyces astaci 40S ribosomal protein S13 mRNA blastn 35397 296 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
9158274 9158274 PRJNA1118794_P_NODE_23908_length_318_cov_1.253061_g23158_i0 PRJNA1118794 23908 318 1.253061 3.98473398 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 276 1.62e-69   NTclustered gi|2795031183|ref|XM_067929373.1| 4785 g23158 i0 82.39 14.6666666666667 318 54 99 2 2 318 740 1056 Phytophthora cinnamomi V-type ATPase, A subunit (IUM83_05246), partial mRNA blastn 4664 276 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
9953245 9953245 PRJNA1118794_P_NODE_70728_length_242_cov_0.911243_g69978_i0 PRJNA1118794 70728 242 0.911243 2.20520806 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 237 5.61e-58   NTclustered gi|158905788|gb|EU199087.1| 480030 g69978 i0 84.937 88.0454545454545 239 31 98 5 1 237 4 239 Pythium sp. CHE-287 translation elongation factor 1 alpha gene, partial cds blastn 21307 239 0.99163179916318 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium sp. CHE-287
11709763 11709763 PRJNA1118794_P_NODE_67710_length_243_cov_0.905882_g66960_i0 PRJNA1118794 67710 243 0.905882 2.20129326 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|673048262|ref|XM_008879870.1| 157072 g66960 i0 100 0.230452674897119 28 0 12 0 105 132 1265 1292 Aphanomyces invadans hypothetical protein mRNA blastn 56 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
14259778 14259778 PRJNA1118794_P_NODE_46352_length_255_cov_1.659341_g45602_i0 PRJNA1118794 46352 255 1.659341 4.23131955 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 62.1 3.85e-5   NTclustered gi|667482100|gb|KM038165.1| 74557 g45602 i0 100 0.349019607843137 33 0 13 0 197 229 282 250 Thraustotheca clavata isolate S_THRCLA_07855 secreted protein gene, complete cds blastn 89 62.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
15533005 15533005 PRJNA1118794_P_NODE_16513_length_363_cov_1.062069_g15763_i0 PRJNA1118794 16513 363 1.062069 3.85531047 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 283 1.12e-71   NTclustered gi|813224847|ref|XM_012356389.1| 695850 g15763 i0 81.662 34.931129476584 349 56 95 8 1 345 351 7 Saprolegnia parasitica CBS 223.65 Ras-like protein Rac1 partial mRNA blastn 12680 283 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
15533540 15533540 PRJNA1118794_P_NODE_5693_length_591_cov_1.046332_g4957_i0 PRJNA1118794 5693 591 1.046332 6.18382212 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 276 3.1899999999999996e-69   NTclustered gi|166041070|emb|CU355542.1| 100861 g4957 i0 77.062 42.3705583756345 497 103 83 9 99 591 120 609 Aphanomyces euteiches cDNA blastn 25041 276 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16807594 16807594 PRJNA1118794_P_NODE_23354_length_321_cov_0.927419_g22604_i0 PRJNA1118794 23354 321 0.927419 2.97701499 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 139 2.25e-28   NTclustered gi|2795057653|ref|XM_067945046.1| 4785 g22604 i0 75.758 30.2398753894081 297 60 91 11 1 291 1348 1638 Phytophthora cinnamomi Calreticulin precursor (IUM83_19977), partial mRNA blastn 9707 139 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
18082202 18082202 PRJNA1118794_P_NODE_27175_length_304_cov_1.255411_g26425_i0 PRJNA1118794 27175 304 1.255411 3.81644944 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 204 7.39e-48   NTclustered gi|2795029237|ref|XM_067937609.1| 4785 g26425 i0 82.833 20.5625 233 35 76 5 75 304 49 279 Phytophthora cinnamomi 40S ribosomal protein S14 (IUM83_12961), partial mRNA blastn 6251 204 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
18876642 18876642 PRJNA1118794_P_NODE_38235_length_272_cov_2.608040_g37485_i0 PRJNA1118794 38235 272 2.60804 7.0938688 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 448 2.72e-121   NTclustered gi|189084716|gb|BT032234.1| 4784 g37485 i0 96.337 100.378676470588 273 8 99 1 2 272 290 18 Phytophthora capsici clone CBOT157-J12 mRNA sequence blastn 27303 448 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
20631507 20631507 PRJNA1118794_P_NODE_18097_length_351_cov_1.107914_g17347_i0 PRJNA1118794 18097 351 1.107914 3.88877814 Phytophthora erythroseptica 111171 SAR_Eukaryotes SAR_Eukaryotes 337 8.18e-88   NTclustered gi|1938229372|dbj|LC595861.1| 111171 g17347 i0 85.987 78.2307692307692 314 44 89 0 20 333 1 314 Phytophthora erythroseptica WPC P0340 btub gene for beta-tubulin, partial cds blastn 27459 337 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora erythroseptica
21907397 21907397 PRJNA1118794_P_NODE_22238_length_326_cov_1.822134_g21488_i0 PRJNA1118794 22238 326 1.822134 5.94015684 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 222 2.21e-53   NTclustered gi|2795061008|ref|XM_067940276.1| 4785 g21488 i0 82.8 31.5184049079755 250 41 76 2 2 250 181 429 Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA blastn 10275 222 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
23182660 23182660 PRJNA1118794_P_NODE_18619_length_347_cov_1.755474_g17869_i0 PRJNA1118794 18619 347 1.755474 6.09149478 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 263 1.39e-65   NTclustered gi|669141935|ref|XM_008608308.1| 1156394 g17869 i0 81.024 86.2853025936599 332 62 95 1 1 331 466 135 Saprolegnia diclina VS20 tubulin alpha partial mRNA blastn 29941 263 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina

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