contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA169559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364820 | 364820 | PRJNA169559_P_NODE_13881_length_450_cov_7.273159_g11965_i0 | PRJNA169559 | 13881 | 450 | 7.273159 | 32.7292155 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.8799999999999996e-55 | NTclustered | gi|813133999|ref|XM_012342618.1| | 695850 | g11965 | i0 | 82.222 | 7.79777777777778 | 270 | 44 | 60 | 4 | 73 | 340 | 72 | 339 | Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA | blastn | 3509 | 230 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10569064 | 10569064 | PRJNA169559_P_NODE_27709_length_278_cov_1.951807_g25633_i0 | PRJNA169559 | 27709 | 278 | 1.951807 | 5.42602346 | Phytophthora hydrogena | 1286608 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.44e-37 | NTclustered | gi|1233050041|gb|KX252277.1| | 1286608 | g25633 | i0 | 84.524 | 60.2482014388489 | 168 | 26 | 60 | 0 | 1 | 168 | 181 | 14 | Phytophthora hydrogena isolate 44G8(authentic) heat shock protein 90 gene, partial cds | blastn | 16749 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora hydrogena | ||
| 11843697 | 11843697 | PRJNA169559_P_NODE_45370_length_210_cov_5.149171_g43293_i0 | PRJNA169559 | 45370 | 210 | 5.149171 | 10.8132591 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.8e-17 | NTclustered | gi|669149541|ref|XM_008612111.1| | 1156394 | g43293 | i0 | 81.538 | 16.4761904761905 | 130 | 18 | 60 | 5 | 63 | 189 | 441 | 315 | Saprolegnia diclina VS20 50S ribosomal protein L40e mRNA | blastn | 3460 | 102 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 18216910 | 18216910 | PRJNA169559_P_NODE_9175_length_561_cov_2.494361_g7480_i0 | PRJNA169559 | 9175 | 561 | 2.494361 | 13.99336521 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 3.28e-9 | NTclustered | gi|2794885173|ref|XM_067884476.1| | 164328 | g7480 | i0 | 94 | 1.14081996434938 | 50 | 3 | 9 | 0 | 466 | 515 | 1970 | 2019 | Phytophthora ramorum Senescence-specific cysteine protease SAG12 (KRP23_1382), partial mRNA | blastn | 640 | 76.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 18906306 | 18906306 | PRJNA169559_P_NODE_5435_length_728_cov_2.690987_g4058_i0 | PRJNA169559 | 5435 | 728 | 2.690987 | 19.59038536 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 1.04e-109 | NTclustered | gi|2795021761|ref|XM_067936233.1| | 4785 | g4058 | i0 | 81.569 | 64.9478021978022 | 510 | 82 | 69 | 10 | 59 | 562 | 1143 | 640 | Phytophthora cinnamomi proline-tRNA ligase (IUM83_11660), partial mRNA | blastn | 47282 | 411 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 23316959 | 23316959 | PRJNA169559_P_NODE_13979_length_449_cov_2.757143_g12061_i0 | PRJNA169559 | 13979 | 449 | 2.757143 | 12.37957207 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 3.2e-38 | NTclustered | gi|813117120|ref|XM_012340152.1| | 695850 | g12061 | i0 | 80.603 | 26.9198218262806 | 232 | 38 | 51 | 6 | 59 | 288 | 1703 | 1477 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 12087 | 172 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;