contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Oomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 628311 | 628311 | PRJNA662254_P_NODE_41921_length_259_cov_1.618280_g41270_i0 | PRJNA662254 | 41921 | 259 | 1.61828 | 4.1913452 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 7.679999999999999e-72 | NTclustered | gi|166052031|emb|CU356341.1| | 100861 | g41270 | i0 | 86.434 | 99.6138996138996 | 258 | 35 | 99 | 0 | 1 | 258 | 466 | 209 | Aphanomyces euteiches cDNA | blastn | 25800 | 283 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13382308 | 13382308 | PRJNA662254_P_NODE_24571_length_333_cov_1.176923_g23920_i0 | PRJNA662254 | 24571 | 333 | 1.176923 | 3.91915359 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 3.76e-56 | NTclustered | gi|166035018|emb|CU349244.1| | 100861 | g23920 | i0 | 80.592 | 87.3153153153153 | 304 | 55 | 91 | 4 | 1 | 302 | 485 | 786 | Aphanomyces euteiches cDNA | blastn | 29076 | 231 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 15931079 | 15931079 | PRJNA662254_P_NODE_17993_length_386_cov_1.463259_g17342_i0 | PRJNA662254 | 17993 | 386 | 1.463259 | 5.64817974 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 9.21e-78 | NTclustered | gi|166039230|emb|CU355280.1| | 100861 | g17342 | i0 | 81.122 | 78.3497409326425 | 392 | 62 | 100 | 11 | 1 | 386 | 664 | 279 | Aphanomyces euteiches cDNA | blastn | 30243 | 303 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19755204 | 19755204 | PRJNA662254_P_NODE_28696_length_310_cov_0.864979_g28045_i0 | PRJNA662254 | 28696 | 310 | 0.864979 | 2.6814349 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 9.43e-72 | NTclustered | gi|673029803|ref|XM_008870641.1| | 157072 | g28045 | i0 | 85.145 | 85.7612903225806 | 276 | 41 | 89 | 0 | 1 | 276 | 287 | 12 | Aphanomyces invadans histone mRNA | blastn | 26586 | 283 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 19755272 | 19755272 | PRJNA662254_P_NODE_50716_length_248_cov_1.045714_g50065_i0 | PRJNA662254 | 50716 | 248 | 1.045714 | 2.59337072 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|669150485|ref|XM_008612583.1| | 1156394 | g50065 | i0 | 100 | 0.120967741935484 | 30 | 0 | 12 | 0 | 206 | 235 | 931 | 960 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 23580909 | 23580909 | PRJNA662254_P_NODE_28759_length_309_cov_1.644068_g28108_i0 | PRJNA662254 | 28759 | 309 | 1.644068 | 5.08017012 | Phytophthora sp. | 89336 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.99e-83 | NTclustered | gi|1233049813|gb|KX251484.1| | 89336 | g28108 | i0 | 85.484 | 96.1197411003236 | 310 | 39 | 98 | 1 | 1 | 304 | 777 | 1086 | Phytophthora sp. isolate 48H2(authentic) heat shock protein 90 gene, partial cds | blastn | 29701 | 322 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. | ||
| 24854517 | 24854517 | PRJNA662254_P_NODE_32180_length_293_cov_1.340909_g31529_i0 | PRJNA662254 | 32180 | 293 | 1.340909 | 3.92886337 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.51e-57 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g31529 | i0 | 84.979 | 104.242320819113 | 233 | 34 | 79 | 1 | 55 | 286 | 299 | 67 | Aphanomyces astaci polyubiquitin mRNA | blastn | 30543 | 235 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
Advanced export
JSON shape: default, array, newline-delimited
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);;