contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax_kingdom = "Helvetiavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11984637 | 11984637 | PRJNA533623_P_NODE_14830_length_612_cov_14.889292_g13133_i0 | PRJNA533623 | 14830 | 612 | 14.889292 | 91.12246704 | Hukuchivirus IN93 | 2844981 | Viruses | Viruses | 976 | 0 | NTclustered | gi|227215235|dbj|AB063393.2| | 1714273 | g13133 | i0 | 97.711 | 12.2271241830065 | 568 | 12 | 93 | 1 | 23 | 590 | 6241 | 5675 | Thermus thermophilus phage IN93 DNA, complete genome | blastn | 7483 | 976 | 1 | Viruses | Helvetiavirae | Dividoviricota | Laserviricetes | Halopanivirales | Matsushitaviridae | Hukuchivirus | Hukuchivirus IN93 | ||
| 13260867 | 13260867 | PRJNA533623_P_NODE_65851_length_233_cov_6.401163_g64070_i0 | PRJNA533623 | 65851 | 233 | 6.401163 | 14.91470979 | Hukuchivirus IN93 | 2844981 | Viruses | Viruses | 305 | 1.45e-78 | NTclustered | gi|227215235|dbj|AB063393.2| | 1714273 | g64070 | i0 | 91.441 | 4.01287553648069 | 222 | 19 | 95 | 0 | 12 | 233 | 10675 | 10454 | Thermus thermophilus phage IN93 DNA, complete genome | blastn | 935 | 305 | 1 | Viruses | Helvetiavirae | Dividoviricota | Laserviricetes | Halopanivirales | Matsushitaviridae | Hukuchivirus | Hukuchivirus IN93 | ||
| 14534757 | 14534757 | PRJNA533623_P_NODE_16672_length_576_cov_5.660194_g14948_i0 | PRJNA533623 | 16672 | 576 | 5.660194 | 32.60271744 | Hukuchivirus IN93 | 2844981 | Viruses | Viruses | 791 | 0 | NTclustered | gi|227215235|dbj|AB063393.2| | 1714273 | g14948 | i0 | 92.362 | 5.23611111111111 | 563 | 32 | 96 | 3 | 25 | 576 | 10019 | 10581 | Thermus thermophilus phage IN93 DNA, complete genome | blastn | 3016 | 791 | 1 | Viruses | Helvetiavirae | Dividoviricota | Laserviricetes | Halopanivirales | Matsushitaviridae | Hukuchivirus | Hukuchivirus IN93 | ||
| 17083922 | 17083922 | PRJNA533623_P_NODE_39674_length_346_cov_10.063158_g37900_i0 | PRJNA533623 | 39674 | 346 | 10.063158 | 34.81852668 | Hukuchivirus IN93 | 2844981 | Viruses | Viruses | 516 | 9.66e-142 | NTclustered | gi|227215235|dbj|AB063393.2| | 1714273 | g37900 | i0 | 97.674 | 4.97398843930636 | 301 | 6 | 87 | 1 | 47 | 346 | 7688 | 7988 | Thermus thermophilus phage IN93 DNA, complete genome | blastn | 1721 | 516 | 1 | Viruses | Helvetiavirae | Dividoviricota | Laserviricetes | Halopanivirales | Matsushitaviridae | Hukuchivirus | Hukuchivirus IN93 | ||
| 24731764 | 24731764 | PRJNA533623_P_NODE_12640_length_662_cov_15.256240_g10984_i0 | PRJNA533623 | 12640 | 662 | 15.25624 | 100.9963088 | Hukuchivirus IN93 | 2844981 | Viruses | Viruses | 689 | 0 | NTclustered | gi|227215235|dbj|AB063393.2| | 1714273 | g10984 | i0 | 87.196 | 6.30211480362538 | 617 | 65 | 91 | 10 | 59 | 662 | 9249 | 8634 | Thermus thermophilus phage IN93 DNA, complete genome | blastn | 4172 | 689 | 1 | Viruses | Helvetiavirae | Dividoviricota | Laserviricetes | Halopanivirales | Matsushitaviridae | Hukuchivirus | Hukuchivirus IN93 |
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);;