contig_metadata
4 rows where bioproject = "PRJNA674050", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10847522 | 10847522 | PRJNA674050_P_NODE_16829_length_269_cov_1.392857_g16626_i0 | PRJNA674050 | 16829 | 269 | 1.392857 | 3.74678533 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 409 | 1.27e-109 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g16626 | i0 | 94.052 | 3.00371747211896 | 269 | 16 | 100 | 0 | 1 | 269 | 3534 | 3802 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 808 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 24870211 | 24870211 | PRJNA674050_P_NODE_32580_length_246_cov_0.895954_g32377_i0 | PRJNA674050 | 32580 | 246 | 0.895954 | 2.20404684 | Orthonoravirus melanogastri | 3060507 | Viruses | Viruses | 438 | 1.4599999999999996e-118 | NTclustered | gi|822478482|gb|KP970089.1| | 3071212 | g32377 | i0 | 98.78 | 38.7276422764228 | 246 | 3 | 100 | 0 | 1 | 246 | 4039 | 4284 | Nora virus isolate IM13 gp1 (gp1) gene, partial cds; replication polyprotein (gp2) and gp3 (gp3) genes, complete cds; and capsid protein (gp4) gene, partial cds | blastn | 9527 | 438 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Noraviridae | Orthonoravirus | Orthonoravirus melanogastri | ||
| 24870557 | 24870557 | PRJNA674050_P_NODE_42260_length_198_cov_10.832000_g42057_i0 | PRJNA674050 | 42260 | 198 | 10.832 | 21.44736 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 111 | 2.79e-20 | NTclustered | gi|2155033579|emb|OV039277.1| | 2697049 | g42057 | i0 | 100 | 25.6464646464646 | 60 | 0 | 88 | 0 | 126 | 185 | 30567 | 30508 | Severe acute respiratory syndrome coronavirus 2 isolate 165 genome assembly, chromosome: 165 | blastn | 5078 | 111 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 31504047 | 31504047 | PRJNA674050_P_NODE_7936_length_316_cov_1.238683_g7733_i0 | PRJNA674050 | 7936 | 316 | 1.238683 | 3.91423828 | Xiangshan picorna-like virus 7 | 2886223 | Viruses | Viruses | 87 | 1.6e-17 | NR | WNK16389.1 | 2886223 | g7733 | i0 | 42.3 | 0.987341772151899 | 104 | 60 | 98.7 | 0 | 315 | 4 | 211 | 314 | WNK16389.1 MAG: RNA-dependent RNA polymerase, partial [Xiangshan picorna-like virus 7] | diamond | 312 | 87 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Xiangshan picorna-like virus 7 |
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);;