contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA666695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1907673 | 1907673 | PRJNA666695_S_NODE_180382_length_158_cov_2.752137_g179288_i0 | PRJNA666695 | 180382 | 158 | 2.752137 | 4.34837646 | Bosavirus sp. | 2340908 | Viruses | Viruses | 292 | 7.07e-75 | NTclustered | gi|1761171183|gb|MN180054.1| | 2340908 | g179288 | i0 | 100 | 6 | 158 | 0 | 100 | 0 | 1 | 158 | 558 | 401 | Bosavirus sp. strain VRI_1, complete genome | blastn | 948 | 292 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Bosavirus sp. | ||
| 7540841 | 7540841 | PRJNA666695_S_NODE_32146_length_347_cov_6.977124_g31052_i0 | PRJNA666695 | 32146 | 347 | 6.977124 | 24.21062028 | Copiparvovirus | 1511888 | Viruses | Viruses | 625 | 1.5399999999999999e-174 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g31052 | i0 | 99.135 | 4.49567723342939 | 347 | 3 | 100 | 0 | 1 | 347 | 5356 | 5010 | Bosavirus MS-2016a, complete genome | blastn | 1560 | 625 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 12112786 | 12112786 | PRJNA666695_S_NODE_91230_length_229_cov_2.675532_g90136_i0 | PRJNA666695 | 91230 | 229 | 2.675532 | 6.12696828 | Copiparvovirus ungulate1 | 3052142 | Viruses | Viruses | 390 | 3.81e-104 | NTclustered | gi|2277478546|gb|MZ502227.1| | 172296 | g90136 | i0 | 97.38 | 12.1441048034935 | 229 | 6 | 100 | 0 | 1 | 229 | 5278 | 5050 | Bovine parvovirus - 2 isolate FBS2/USA nonstructural protein and structural protein genes, complete cds | blastn | 2781 | 390 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate1 | ||
| 12112881 | 12112881 | PRJNA666695_S_NODE_95490_length_224_cov_3.726776_g94396_i0 | PRJNA666695 | 95490 | 224 | 3.726776 | 8.34797824 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 409 | 1.03e-109 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g94396 | i0 | 99.554 | 9.00446428571429 | 224 | 1 | 100 | 0 | 1 | 224 | 1994 | 2217 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2017 | 409 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 14662045 | 14662045 | PRJNA666695_S_NODE_72352_length_253_cov_2.816038_g71258_i0 | PRJNA666695 | 72352 | 253 | 2.816038 | 7.12457614 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g71258 | i0 | 100 | 0.889328063241107 | 29 | 0 | 11 | 0 | 223 | 251 | 29 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 225 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 18485093 | 18485093 | PRJNA666695_S_NODE_55095_length_282_cov_5.958506_g54001_i0 | PRJNA666695 | 55095 | 282 | 5.958506 | 16.80298692 | TTV-like mini virus | 93678 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|2164984279|gb|MN769747.1| | 93678 | g54001 | i0 | 100 | 0.099290780141844 | 28 | 0 | 10 | 0 | 116 | 143 | 94 | 67 | MAG: TTV-like mini virus isolate SAfiA-810-50, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Commensaviricota | Cardeaviricetes | Sanitavirales | Anelloviridae | Betatorquevirus | TTV-like mini virus | ||
| 19757980 | 19757980 | PRJNA666695_S_NODE_15636_length_456_cov_5.486747_g14545_i0 | PRJNA666695 | 15636 | 456 | 5.486747 | 25.01956632 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 821 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g14545 | i0 | 99.123 | 8.97368421052632 | 456 | 4 | 100 | 0 | 1 | 456 | 3342 | 3797 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 4092 | 821 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 |
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);;