RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 19 ✖

tax_clade 1

bioproject 1

  • PRJEB75017 · 19 ✖

analysis 1

  • blastn · 19 ✖

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
2270664 2270664 PRJEB75017_P_NODE_10762_length_281_cov_2.129808_g10633_i0 PRJEB75017 10762 281 2.129808 5.98476048 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 296 1.08e-75   NTclustered gi|2795052452|ref|XM_067926699.1| 4785 g10633 i0 85.714 5.11032028469751 280 40 99 0 2 281 79 358 Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA blastn 1436 296 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
5237936 5237936 PRJEB75017_P_NODE_3785_length_450_cov_1.376658_g3656_i0 PRJEB75017 3785 450 1.376658 6.194961 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 361 6.38e-95   NTclustered gi|2794882649|ref|XM_067895061.1| 164328 g3656 i0 85.387 53.5844444444444 349 49 77 2 1 348 199 546 Phytophthora ramorum ADP-ribosylation factor (KRP23_969), partial mRNA blastn 24113 361 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
5237945 5237945 PRJEB75017_P_NODE_4445_length_415_cov_3.035088_g4316_i0 PRJEB75017 4445 415 3.035088 12.5956152 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 163 1.77e-35   NTclustered gi|669145241|ref|XM_008609961.1| 1156394 g4316 i0 77.133 16.4361445783133 293 59 70 8 68 356 132 420 Saprolegnia diclina VS20 50S ribosomal protein L22e mRNA blastn 6821 163 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
6513502 6513502 PRJEB75017_P_NODE_4146_length_430_cov_1.801120_g4017_i0 PRJEB75017 4146 430 1.80112 7.744816 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.012   NTclustered gi|673040756|ref|XM_008876117.1| 157072 g4017 i0 96.875 0.0744186046511628 32 1 7 0 208 239 1622 1591 Aphanomyces invadans hypothetical protein mRNA blastn 32 54.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
7787748 7787748 PRJEB75017_P_NODE_1947_length_622_cov_1.865209_g1820_i0 PRJEB75017 1947 622 1.865209 11.60159998 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 302 5.55e-77   NTclustered gi|2795021165|ref|XM_067935669.1| 4785 g1820 i0 80.653 51.3263665594855 398 69 63 7 1 394 1076 1469 Phytophthora cinnamomi ATP synthase subunit beta, mitochondrial (IUM83_11126), partial mRNA blastn 31925 302 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
7787804 7787804 PRJEB75017_P_NODE_6747_length_342_cov_1.460967_g6618_i0 PRJEB75017 6747 342 1.460967 4.99650714 Apodachlya brachynema 92981 SAR_Eukaryotes SAR_Eukaryotes 239 2.31e-58   NTclustered gi|59894139|gb|AY729852.1| 92981 g6618 i0 80.178 16.9707602339181 338 51 95 11 3 326 528 863 Apodachlya brachynema heat shock protein 90 gene, partial cds blastn 5804 239 1 Eukaryota Sar   Oomycota Saprolegniomycetes Leptomitales Leptomitaceae Apodachlya Apodachlya brachynema
9062668 9062668 PRJEB75017_P_NODE_3928_length_442_cov_2.067751_g3799_i0 PRJEB75017 3928 442 2.067751 9.13945942 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 171 1.13e-37   NTclustered gi|2795044192|ref|XM_067924787.1| 4785 g3799 i0 78.519 8.15610859728507 270 50 60 7 16 281 275 10 Phytophthora cinnamomi CMGC/CDK protein kinase (IUM83_00965), partial mRNA blastn 3605 171 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
10338417 10338417 PRJEB75017_P_NODE_2209_length_587_cov_1.198444_g2081_i0 PRJEB75017 2209 587 1.198444 7.03486628 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 250 1.92e-61   NTclustered gi|813219605|ref|XM_012355790.1| 695850 g2081 i0 82.095 29.1567291311755 296 49 50 3 239 532 1517 1224 Saprolegnia parasitica CBS 223.65 methylmalonate-semialdehyde dehydrogenase mRNA blastn 17115 250 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
11613896 11613896 PRJEB75017_P_NODE_6730_length_342_cov_4.617100_g6601_i0 PRJEB75017 6730 342 4.6171 15.790482 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 265 3.81e-66   NTclustered gi|675211346|ref|XM_008916310.1| 761204 g6601 i0 82.943 15.2076023391813 299 45 87 4 3 298 429 134 Phytophthora parasitica INRA-310 60S ribosomal protein L44 mRNA blastn 5201 265 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
12888887 12888887 PRJEB75017_P_NODE_12791_length_262_cov_0.978836_g12662_i0 PRJEB75017 12791 262 0.978836 2.56455032 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 106 1.81e-18   NTclustered gi|813170594|ref|XM_012348663.1| 695850 g12662 i0 82.906 0.572519083969466 117 20 45 0 119 235 1956 1840 Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA blastn 150 106 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
14163750 14163750 PRJEB75017_P_NODE_1652_length_673_cov_2.653333_g1526_i0 PRJEB75017 1652 673 2.653333 17.85693109 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 311 1e-79   NTclustered gi|2795033185|ref|XM_067927898.1| 4785 g1526 i0 78.395 4.34175334323923 486 99 72 6 59 541 61 543 Phytophthora cinnamomi ribosomal protein S4 (IUM83_03865), partial mRNA blastn 2922 311 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
15023496 15023496 PRJEB75017_P_NODE_8752_length_305_cov_1.163793_g8623_i0 PRJEB75017 8752 305 1.163793 3.54956865 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 152 2.73e-32   NTclustered gi|2795020654|ref|XM_067935541.1| 4785 g8623 i0 89.256 27.1311475409836 121 13 40 0 86 206 144 24 Phytophthora cinnamomi Heat shock protein 90-2 (IUM83_11008), partial mRNA blastn 8275 152 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
15437803 15437803 PRJEB75017_P_NODE_11713_length_272_cov_1.412060_g11584_i0 PRJEB75017 11713 272 1.41206 3.8408032 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 167 8.54e-37   NTclustered gi|669148871|ref|XM_008611776.1| 1156394 g11584 i0 82.383 74.9816176470588 193 32 71 2 24 215 1348 1157 Saprolegnia diclina VS20 3-oxoacid CoA transferase 1 mRNA blastn 20395 167 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
18847293 18847293 PRJEB75017_P_NODE_8775_length_304_cov_3.121212_g8646_i0 PRJEB75017 8775 304 3.121212 9.48848448 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 361 4.1399999999999997e-95   NTclustered gi|813150408|ref|XM_012345461.1| 695850 g8646 i0 88.197 203.805921052632 305 32 100 2 1 304 409 108 Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA blastn 61957 361 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
19260881 19260881 PRJEB75017_P_NODE_10056_length_288_cov_1.451163_g9927_i0 PRJEB75017 10056 288 1.451163 4.17934944 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 213 1.15e-50   NTclustered gi|669159445|ref|XM_008617063.1| 1156394 g9927 i0 81.343 59.1458333333333 268 44 92 6 22 286 1250 986 Saprolegnia diclina VS20 chaperone dnaK mRNA blastn 17034 213 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
19260983 19260983 PRJEB75017_P_NODE_456_length_1193_cov_2.125000_g387_i0 PRJEB75017 456 1193 2.125 25.35125 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 95.3 1.99e-14   NTclustered gi|669149903|ref|XM_008612292.1| 1156394 g387 i0 91.429 0.307627829002515 70 5 6 1 890 959 228 160 Saprolegnia diclina VS20 hypothetical protein mRNA blastn 367 95.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
20536326 20536326 PRJEB75017_P_NODE_5797_length_366_cov_1.228669_g5668_i0 PRJEB75017 5797 366 1.228669 4.49692854 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 267 1.14e-66   NTclustered gi|813142527|ref|XM_012343931.1| 695850 g5668 i0 80.109 22.8224043715847 367 66 99 5 1 364 911 549 Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA blastn 8353 267 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
21812121 21812121 PRJEB75017_P_NODE_1738_length_656_cov_1.970840_g1612_i0 PRJEB75017 1738 656 1.97084 12.9287104 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 375 3.409999999999999e-99   NTclustered gi|695375284|ref|XM_009517214.1| 67593 g1612 i0 79.732 43.467987804878 523 102 79 4 51 571 1 521 Phytophthora sojae hypothetical protein partial mRNA blastn 28515 375 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
24361235 24361235 PRJEB75017_P_NODE_720_length_987_cov_2.428884_g628_i0 PRJEB75017 720 987 2.428884 23.97308508 Globisporangium heterothallicum 2708265 SAR_Eukaryotes SAR_Eukaryotes 854 0   NTclustered gi|325053464|dbj|AB512850.1| 2708265 g628 i0 83.226 86.145896656535 936 151 95 6 10 942 933 1 Globisporangium heterothallicum gene for beta-tubulin, partial cds, strain: CBS 450.67 blastn 85026 854 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium heterothallicum

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