RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB39643 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
5160042 5160042 PRJEB39643_P_NODE_158945_length_211_cov_4.463768_g158751_i0 PRJEB39643 158945 211 4.463768 9.41855048 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 167 6.339999999999999e-37   NTclustered gi|698801103|ref|XM_009835279.1| 112090 g158751 i0 90 78.2369668246446 130 11 61 2 83 211 686 814 Aphanomyces astaci adenosylhomocysteinase 2 mRNA blastn 16508 167 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
8985035 8985035 PRJEB39643_P_NODE_30888_length_332_cov_2.378378_g30695_i0 PRJEB39643 30888 332 2.378378 7.89621496 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 132 3.91e-26   NTclustered gi|2795044301|ref|XM_067938081.1| 4785 g30695 i0 85.714 0.759036144578313 126 16 38 2 184 308 241 365 Phytophthora cinnamomi putative 3-oxo-5-alpha-steroid 4-dehydrogenase (IUM83_13408), partial mRNA blastn 252 132 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
13742994 13742994 PRJEB39643_P_NODE_56951_length_282_cov_1.473684_g56758_i0 PRJEB39643 56951 282 1.473684 4.15578888 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2795025916|ref|XM_067925126.1| 4785 g56758 i0 94.595 0.656028368794326 37 0 13 1 96 132 503 469 Phytophthora cinnamomi TKL protein kinase (IUM83_01283), partial mRNA blastn 185 56.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
16634221 16634221 PRJEB39643_P_NODE_12914_length_528_cov_3.323077_g12724_i0 PRJEB39643 12914 528 3.323077 17.54584656 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 246 2.2099999999999998e-60   NTclustered gi|698791735|ref|XM_009830598.1| 112090 g12724 i0 76.507 20.7083333333333 481 96 89 14 21 491 554 81 Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA blastn 10934 246 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
17567307 17567307 PRJEB39643_P_NODE_33994_length_319_cov_1.589431_g33801_i0 PRJEB39643 33994 319 1.589431 5.07028489 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.008   NTclustered gi|927372602|ref|NC_027859.1| 143453 g33801 i0 100 5.40752351097179 29 0 9 0 35 63 35444 35472 Pseudoperonospora cubensis mitochondrion, complete genome blastn 1725 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Pseudoperonospora Pseudoperonospora cubensis
21734008 21734008 PRJEB39643_P_NODE_11718_length_562_cov_5.680982_g11529_i0 PRJEB39643 11718 562 5.680982 31.92711884 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 300 1.79e-76   NTclustered gi|698822976|ref|XM_009846215.1| 112090 g11529 i0 78.556 63.085409252669 471 90 83 8 3 468 63 527 Aphanomyces astaci 40S ribosomal protein S13 mRNA blastn 35454 300 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
23941763 23941763 PRJEB39643_P_NODE_24799_length_367_cov_1.132653_g24606_i0 PRJEB39643 24799 367 1.132653 4.15683651 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.035   NTclustered gi|58202010|gb|AY898628.1| 4787 g24606 i0 100 1.71117166212534 28 0 8 0 106 133 25088 25115 Phytophthora infestans haplotype IIb mitochondrion, complete genome blastn 628 52.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans

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