RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA1186363 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
319893 319893 PRJNA1186363_P_NODE_42881_length_244_cov_0.912281_g41993_i0 PRJNA1186363 42881 244 0.912281 2.22596564 Phytophthora ilicis 89335 SAR_Eukaryotes SAR_Eukaryotes 137 5.91e-28   NTclustered gi|1233049659|gb|KX250947.1| 89335 g41993 i0 82.716 65.9385245901639 162 20 65 6 38 195 328 485 Phytophthora ilicis isolate 34D6 heat shock protein 90 gene, partial cds blastn 16089 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ilicis
1594384 1594384 PRJNA1186363_P_NODE_23962_length_375_cov_1.132450_g23074_i0 PRJNA1186363 23962 375 1.13245 4.2466875 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 252 3.28e-62   NTclustered gi|673020003|ref|XM_008865741.1| 157072 g23074 i0 81.877 4.94933333333333 309 46 81 8 1 304 1780 2083 Aphanomyces invadans hsp81-like protein mRNA blastn 1856 252 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
5422890 5422890 PRJNA1186363_P_NODE_33465_length_288_cov_1.744186_g32577_i0 PRJNA1186363 33465 288 1.744186 5.02325568 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 148 3.3e-31   NTclustered gi|166043101|emb|CU357747.1| 100861 g32577 i0 84.314 3.64583333333333 153 22 53 2 4 155 742 893 Aphanomyces euteiches cDNA blastn 1050 148 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
15622527 15622527 PRJNA1186363_P_NODE_31213_length_306_cov_1.673820_g30325_i0 PRJNA1186363 31213 306 1.67382 5.1218892 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 226 1.59e-54   NTclustered gi|673024575|ref|XM_008868027.1| 157072 g30325 i0 88.021 45.5326797385621 192 21 62 2 116 306 2388 2198 Aphanomyces invadans tubulin beta chain mRNA blastn 13933 226 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
15622593 15622593 PRJNA1186363_P_NODE_43153_length_243_cov_0.917647_g42265_i0 PRJNA1186363 43153 243 0.917647 2.22988221 Globisporangium ultimum 2052682 SAR_Eukaryotes SAR_Eukaryotes 250 7.2399999999999995e-62   NTclustered gi|752272461|gb|KJ639290.1| 115421 g42265 i0 85.654 86.358024691358 237 34 98 0 1 237 259 495 Pythium ultimum var. sporangiiferum strain DAOM BR805 beta-tubulin (Btub) gene, partial cds blastn 20985 250 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium ultimum
17619814 17619814 PRJNA1186363_P_NODE_7854_length_752_cov_1.553756_g7035_i0 PRJNA1186363 7854 752 1.553756 11.68424512 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 520 1.72e-142   NTclustered gi|59894163|gb|AY729864.1| 74557 g7035 i0 79.679 15.3271276595745 748 131 99 14 1 745 525 1254 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 11526 520 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
18171336 18171336 PRJNA1186363_P_NODE_26655_length_347_cov_0.941606_g25767_i0 PRJNA1186363 26655 347 0.941606 3.26737282 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 252 3.02e-62   NTclustered gi|166035797|emb|CU352010.1| 100861 g25767 i0 82.155 2.27953890489914 297 49 85 4 47 341 270 564 Aphanomyces euteiches cDNA blastn 791 252 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21996401 21996401 PRJNA1186363_P_NODE_20758_length_413_cov_1.835294_g19870_i0 PRJNA1186363 20758 413 1.835294 7.57976422 Globisporangium ultimum 2052682 SAR_Eukaryotes SAR_Eukaryotes 375 2.0699999999999997e-99   NTclustered gi|1780534031|gb|MK753001.1| 2052683 g19870 i0 83.051 89.4503631961259 413 70 100 0 1 413 925 1337 Globisporangium ultimum var. ultimum isolate KSSO_5-45 beta-tubulin mRNA, complete cds blastn 36943 375 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium ultimum
21996530 21996530 PRJNA1186363_P_NODE_42538_length_244_cov_2.011696_g41650_i0 PRJNA1186363 42538 244 2.011696 4.90853824 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.32e-4   NTclustered gi|675193124|ref|XM_008907199.1| 761204 g41650 i0 97.143 0.524590163934426 35 1 14 0 1 35 335 301 Phytophthora parasitica INRA-310 hypothetical protein partial mRNA blastn 128 60.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae

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