contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA682370" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3215003 | 3215003 | PRJNA682370_S_NODE_15043_length_184_cov_3.677852_g14431_i0 | PRJNA682370 | 15043 | 184 | 3.677852 | 6.76724768 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 115 | 1.97e-21 | NTclustered | gi|2324087489|ref|XM_051530053.1| | 90255 | g14431 | i0 | 79.878 | 2.60869565217391 | 164 | 27 | 88 | 5 | 20 | 180 | 261 | 421 | Cokeromyces recurvatus rab11 protein (BX663DRAFT_527546), mRNA | blastn | 480 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 4492075 | 4492075 | PRJNA682370_S_NODE_11864_length_210_cov_1.502857_g11252_i0 | PRJNA682370 | 11864 | 210 | 1.502857 | 3.1559997 | Rhizopus delemar | 936053 | Fungi | Fungi | 154 | 4.9100000000000005e-33 | NTclustered | gi|2797465563|ref|XM_067662873.1| | 246409 | g11252 | i0 | 79.904 | 12.052380952381 | 209 | 42 | 99 | 0 | 2 | 210 | 365 | 157 | Rhizopus delemar RA 99-880 40S ribosomal protein uS4 (RO3G_08283), partial mRNA | blastn | 2531 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 10868248 | 10868248 | PRJNA682370_S_NODE_17329_length_172_cov_1.656934_g16717_i0 | PRJNA682370 | 17329 | 172 | 1.656934 | 2.84992648 | Mycotypha africana | 64632 | Fungi | Fungi | 115 | 1.81e-21 | NTclustered | gi|2432570701|ref|XM_053083359.1| | 64632 | g16717 | i0 | 85.586 | 1.63372093023256 | 111 | 15 | 64 | 1 | 6 | 115 | 1287 | 1397 | Mycotypha africana V-type proton ATPase catalytic subunit A (BDF20DRAFT_907251), partial mRNA | blastn | 281 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 17242337 | 17242337 | PRJNA682370_S_NODE_3094_length_469_cov_4.658986_g2490_i0 | PRJNA682370 | 3094 | 469 | 4.658986 | 21.85064434 | Rhizopus microsporus | 58291 | Fungi | Fungi | 250 | 1.51e-61 | NTclustered | gi|1331189772|ref|XM_023607192.1| | 1340429 | g2490 | i0 | 87.5 | 35.8528784648188 | 216 | 27 | 46 | 0 | 1 | 216 | 196 | 411 | Rhizopus microsporus ATCC 52813 uncharacterized protein (RHIMIDRAFT_211203), mRNA | blastn | 16815 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus |
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);;