contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124866 | 124866 | PRJEB58983_P_NODE_24181_length_269_cov_1.204082_g23766_i0 | PRJEB58983 | 24181 | 269 | 1.204082 | 3.23898058 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 204 | 6.43e-48 | NTclustered | gi|82398540|gb|DQ273807.1| | 34480 | g23766 | i0 | 81.648 | 1137.4126394052 | 267 | 29 | 98 | 11 | 6 | 269 | 2838 | 2589 | Basidiobolus ranarum isolate AFTOL-ID 301 28S ribosomal RNA gene, partial sequence | blastn | 305964 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 11603711 | 11603711 | PRJEB58983_P_NODE_8970_length_415_cov_4.052632_g8556_i0 | PRJEB58983 | 8970 | 415 | 4.052632 | 16.8184228 | Piptocephalis corymbifera | 78917 | Fungi | Fungi | 71.3 | 1.1e-7 | NTclustered | gi|311235601|ref|NG_027616.1| | 78917 | g8556 | i0 | 88.333 | 0.44578313253012 | 60 | 6 | 14 | 1 | 22 | 80 | 3175 | 3234 | Piptocephalis corymbifera NRRL 2385 28S rRNA gene, partial sequence; from reference material | blastn | 185 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis corymbifera | |
| 15427535 | 15427535 | PRJEB58983_P_NODE_3753_length_633_cov_5.328571_g3348_i0 | PRJEB58983 | 3753 | 633 | 5.328571 | 33.72985443 | Microconidiobolus nodosus | 1167817 | Fungi | Fungi | 204 | 1.6399999999999998e-47 | NTclustered | gi|2032035993|gb|MW795365.1| | 1167817 | g3348 | i0 | 79.421 | 36.0679304897314 | 311 | 46 | 48 | 14 | 18 | 323 | 11329 | 11032 | Microconidiobolus nodosus strain ATCC 16577 mitochondrion, complete genome | blastn | 22831 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Microconidiobolus | Microconidiobolus nodosus | |
| 15427559 | 15427559 | PRJEB58983_P_NODE_5033_length_546_cov_4.630021_g4621_i0 | PRJEB58983 | 5033 | 546 | 4.630021 | 25.27991466 | Entomophthoraceae sp. ARSEF 7942 | 423453 | Fungi | Fungi | 215 | 6.47e-51 | NTclustered | gi|145307981|gb|EF392517.1| | 423453 | g4621 | i0 | 88.333 | 22.7490842490842 | 180 | 20 | 33 | 1 | 19 | 197 | 196 | 17 | Entomophthoraceae sp. ARSEF 7942 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 12421 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthoraceae sp. ARSEF 7942 |
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);;