contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA870096" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3401113 | 3401113 | PRJNA870096_S_NODE_63283_length_220_cov_1.949153_g61619_i0 | PRJNA870096 | 63283 | 220 | 1.949153 | 4.2881366 | Alphapapillomavirus 7 | 337042 | Viruses | Viruses | 387 | 4.7e-103 | NTclustered | gi|1258167396|gb|MF288663.1| | 333761 | g61619 | i0 | 99.528 | 96.3636363636364 | 212 | 1 | 96 | 0 | 1 | 212 | 2342 | 2131 | Human papillomavirus 18 isolate C415154_R1_1138896_N-P, complete genome | blastn | 21200 | 387 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 7 | ||
| 4678433 | 4678433 | PRJNA870096_S_NODE_3664_length_972_cov_2.202368_g2762_i0 | PRJNA870096 | 3664 | 972 | 2.202368 | 21.40701696 | Alphapapillomavirus 7 | 337042 | Viruses | Viruses | 1781 | 0 | NTclustered | gi|1258167396|gb|MF288663.1| | 333761 | g2762 | i0 | 100 | 99.1769547325103 | 964 | 0 | 99 | 0 | 1 | 964 | 2143 | 1180 | Human papillomavirus 18 isolate C415154_R1_1138896_N-P, complete genome | blastn | 96400 | 1781 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 7 | ||
| 5065329 | 5065329 | PRJNA870096_S_NODE_139644_length_152_cov_1.165138_g137980_i0 | PRJNA870096 | 139644 | 152 | 1.165138 | 1.77100976 | Dependoparvovirus | 10803 | Viruses | Viruses | 267 | 4.08e-67 | NTclustered | gi|2766605|gb|AF028704.1|AF028704 | 68558 | g137980 | i0 | 100 | 79.0723684210526 | 144 | 0 | 95 | 0 | 9 | 152 | 1876 | 2019 | Adeno-associated virus 6, complete genome | blastn | 12019 | 267 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Dependoparvovirus | Dependoparvovirus primate1 | ||
| 5953672 | 5953672 | PRJNA870096_S_NODE_62945_length_221_cov_1.342697_g61281_i0 | PRJNA870096 | 62945 | 221 | 1.342697 | 2.96736037 | Simian Adeno-associated virus | 1917081 | Viruses | Viruses | 364 | 2.2199999999999998e-96 | NTclustered | gi|1104766984|gb|KT984498.1| | 1917081 | g61281 | i0 | 97.642 | 96.579185520362 | 212 | 5 | 96 | 0 | 1 | 212 | 2666 | 2455 | Simian Adeno-associated virus isolate Cg34 nonstructural protein and capsid protein genes, complete cds | blastn | 21344 | 364 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Dependoparvovirus | Simian Adeno-associated virus | ||
| 10165894 | 10165894 | PRJNA870096_S_NODE_55508_length_236_cov_1.134715_g53844_i0 | PRJNA870096 | 55508 | 236 | 1.134715 | 2.6779274 | Dependoparvovirus | 10803 | Viruses | Viruses | 414 | 2.34e-111 | NTclustered | gi|77380105|gb|DQ180604.1| | 348794 | g53844 | i0 | 99.559 | 91.8813559322034 | 227 | 1 | 96 | 0 | 10 | 236 | 1978 | 2204 | Adeno-associated virus VR-195 Rep78 (rep78) and capsid protein (cap) genes, complete cds | blastn | 21684 | 414 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Dependoparvovirus | Adeno-associated virus VR-195 | ||
| 22526326 | 22526326 | PRJNA870096_S_NODE_126098_length_159_cov_1.017241_g124434_i0 | PRJNA870096 | 126098 | 159 | 1.017241 | 1.61741319 | Alphapapillomavirus 7 | 337042 | Viruses | Viruses | 267 | 4.3199999999999996e-67 | NTclustered | gi|1258167963|gb|MF288726.1| | 333761 | g124434 | i0 | 98.667 | 94.3396226415094 | 150 | 2 | 94 | 0 | 10 | 159 | 1097 | 1246 | Human papillomavirus 18 isolate 1314304_N-P, complete genome | blastn | 15000 | 267 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 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);;