RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA801875" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA801875 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3352007 3352007 PRJNA801875_P_NODE_783_length_478_cov_14.155756_g681_i0 PRJNA801875 783 478 14.155756 67.66451368 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 5.45e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g681 i0 80.533 70.7698744769875 375 65 77 4 27 394 68 441 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
6325748 6325748 PRJNA801875_P_NODE_405_length_702_cov_3.307346_g310_i0 PRJNA801875 405 702 3.307346 23.21756892 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 303 1.75e-77   NTclustered gi|2314988661|ref|NC_067066.1| 4793 g310 i0 79.458 64.6994301994302 443 80 63 8 264 702 22803 22368 Phytophthora citrophthora voucher CBS950_87 mitochondrion, complete genome blastn 45419 303 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
9729184 9729184 PRJNA801875_P_NODE_668_length_526_cov_7.668024_g566_i0 PRJNA801875 668 526 7.668024 40.33380624 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 176 2.93e-39   NTclustered gi|1490229970|gb|MH094138.1| 29920 g566 i0 90.299 25.9315589353612 134 13 25 0 3 136 542 675 Phytophthora cactorum isolate KRJ1 ATP synthase protein 9 (atp9) gene, partial cds; NADH dehydrogenase subunit 9 (nad9) gene, complete cds; and apocytochrome b (cob) gene, partial cds; mitochondrial blastn 13640 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
21203437 21203437 PRJNA801875_P_NODE_1217_length_365_cov_1.466667_g1114_i0 PRJNA801875 1217 365 1.466667 5.35333455 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 315 4e-81   NTclustered gi|59894163|gb|AY729864.1| 74557 g1114 i0 82.418 87.2164383561644 364 60 99 4 1 362 1211 850 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 31834 315 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
21203441 21203441 PRJNA801875_P_NODE_177_length_1039_cov_1.976096_g112_i0 PRJNA801875 177 1039 1.976096 20.53163744 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 514 1.12e-140   NTclustered gi|166044823|emb|CU351082.1| 100861 g112 i0 79.524 24.0365736284889 757 127 72 12 287 1039 84 816 Aphanomyces euteiches cDNA blastn 24974 514 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
22478084 22478084 PRJNA801875_P_NODE_1218_length_364_cov_8.951368_g1115_i0 PRJNA801875 1218 364 8.951368 32.58297952 Phytophthora sp. ML-2023a 3044284 SAR_Eukaryotes SAR_Eukaryotes 113 1.56e-20   NTclustered gi|2500404807|gb|OQ735416.1| 3044284 g1115 i0 76.733 50.6593406593407 202 47 55 0 33 234 15901 15700 Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome blastn 18440 113 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sp. ML-2023a

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