contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA724039" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3262333 | 3262333 | PRJNA724039_S_NODE_10983_length_195_cov_0.987342_g10776_i0 | PRJNA724039 | 10983 | 195 | 0.987342 | 1.9253169 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.26e-28 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g10776 | i0 | 85.401 | 68.2 | 137 | 16 | 69 | 4 | 35 | 169 | 41659 | 41793 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 13299 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 7090014 | 7090014 | PRJNA724039_S_NODE_7426_length_245_cov_3.745192_g7219_i0 | PRJNA724039 | 7426 | 245 | 3.745192 | 9.1757204 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.65e-19 | NTclustered | gi|2431515601|ref|NC_070108.1| | 230839 | g7219 | i0 | 80.282 | 61.3632653061225 | 142 | 28 | 58 | 0 | 54 | 195 | 2157 | 2016 | Peronosclerospora sorghi isolate P6 mitochondrion, complete genome | blastn | 15034 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 8364579 | 8364579 | PRJNA724039_S_NODE_8007_length_234_cov_3.629442_g7800_i0 | PRJNA724039 | 8007 | 234 | 3.629442 | 8.49289428 | Phytophthora sp. ML-2023a | 3044284 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.62e-28 | NTclustered | gi|2500404807|gb|OQ735416.1| | 3044284 | g7800 | i0 | 82.609 | 3.27350427350427 | 161 | 23 | 67 | 5 | 38 | 194 | 5943 | 6102 | Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome | blastn | 766 | 137 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. ML-2023a | ||
| 23664301 | 23664301 | PRJNA724039_S_NODE_8119_length_232_cov_5.317949_g7912_i0 | PRJNA724039 | 8119 | 232 | 5.317949 | 12.33764168 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.56e-23 | NTclustered | gi|269812125|gb|GU138663.1| | 2052682 | g7912 | i0 | 76.923 | 16.4137931034483 | 234 | 42 | 98 | 10 | 1 | 228 | 34664 | 34891 | Pythium ultimum culture-collection CBS:398.51 mitochondrion, complete genome | blastn | 3808 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 24145750 | 24145750 | PRJNA724039_S_NODE_8659_length_223_cov_4.225806_g8452_i0 | PRJNA724039 | 8659 | 223 | 4.225806 | 9.42354738 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.4900000000000004e-21 | NTclustered | gi|58202010|gb|AY898628.1| | 4787 | g8452 | i0 | 91.765 | 39.2511210762332 | 85 | 4 | 38 | 3 | 2 | 85 | 2385 | 2467 | Phytophthora infestans haplotype IIb mitochondrion, complete genome | blastn | 8753 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 24937768 | 24937768 | PRJNA724039_S_NODE_7220_length_250_cov_1.737089_g7013_i0 | PRJNA724039 | 7220 | 250 | 1.737089 | 4.3427225 | Synchrospora medusiformis | 3033745 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.62e-58 | NTclustered | gi|2499019046|gb|OQ605381.1| | 3033745 | g7013 | i0 | 84 | 98.512 | 250 | 38 | 99 | 2 | 1 | 249 | 573 | 325 | Synchrospora medusiformis isolate PA228 beta-tubulin (btub) gene, partial cds | blastn | 24628 | 239 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Synchrospora | Synchrospora medusiformis |
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);;