contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA835051" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 826053 | 826053 | PRJNA835051_S_NODE_441_length_941_cov_7.863029_g291_i0 | PRJNA835051 | 441 | 941 | 7.863029 | 73.99110289 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 1700 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g291 | i0 | 99.256 | 8.56641870350691 | 941 | 7 | 100 | 0 | 1 | 941 | 3581 | 4521 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 8061 | 1700 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 2101248 | 2101248 | PRJNA835051_S_NODE_21722_length_271_cov_1.763158_g21426_i0 | PRJNA835051 | 21722 | 271 | 1.763158 | 4.77815818 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 484 | 2.07e-132 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g21426 | i0 | 98.893 | 7.9409594095941 | 271 | 3 | 100 | 0 | 1 | 271 | 1168 | 898 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2152 | 484 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 3377456 | 3377456 | PRJNA835051_S_NODE_8903_length_334_cov_7.082474_g8607_i0 | PRJNA835051 | 8903 | 334 | 7.082474 | 23.65546316 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 568 | 2.529999999999999e-157 | NTclustered | gi|1347731934|ref|NC_037053.1| | 172297 | g8607 | i0 | 97.305 | 6.98802395209581 | 334 | 9 | 100 | 0 | 1 | 334 | 3953 | 4286 | Bovine parvovirus 3 isolate ujs1794 nonstructural protein and structural protein genes, complete cds | blastn | 2334 | 568 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 3781259 | 3781259 | PRJNA835051_S_NODE_11323_length_316_cov_1.208791_g11027_i0 | PRJNA835051 | 11323 | 316 | 1.208791 | 3.81977956 | Copiparvovirus | 1511888 | Viruses | Viruses | 411 | 4.239999999999999e-110 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g11027 | i0 | 99.127 | 5.08860759493671 | 229 | 1 | 100 | 1 | 1 | 229 | 2650 | 2877 | Bosavirus MS-2016a, complete genome | blastn | 1608 | 411 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 4654541 | 4654541 | PRJNA835051_S_NODE_4904_length_392_cov_1.765043_g4611_i0 | PRJNA835051 | 4904 | 392 | 1.765043 | 6.91896856 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 725 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g4611 | i0 | 100 | 9.26020408163265 | 392 | 0 | 100 | 0 | 1 | 392 | 3194 | 3585 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 3630 | 725 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 7204842 | 7204842 | PRJNA835051_S_NODE_8766_length_335_cov_11.917808_g8470_i0 | PRJNA835051 | 8766 | 335 | 11.917808 | 39.9246568 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 619 | 6.91e-173 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g8470 | i0 | 100 | 9.69253731343283 | 335 | 0 | 100 | 0 | 1 | 335 | 2852 | 3186 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 3247 | 619 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 9753877 | 9753877 | PRJNA835051_S_NODE_28128_length_254_cov_2.189573_g27832_i0 | PRJNA835051 | 28128 | 254 | 2.189573 | 5.56151542 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g27832 | i0 | 100 | 0.885826771653543 | 29 | 0 | 11 | 0 | 224 | 252 | 29 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 225 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 11030183 | 11030183 | PRJNA835051_S_NODE_71809_length_192_cov_1.604027_g71513_i0 | PRJNA835051 | 71809 | 192 | 1.604027 | 3.07973184 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g71513 | i0 | 96.774 | 0.161458333333333 | 31 | 1 | 16 | 0 | 2 | 32 | 3116 | 3086 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 31 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 12304599 | 12304599 | PRJNA835051_S_NODE_11310_length_316_cov_1.648352_g11014_i0 | PRJNA835051 | 11310 | 316 | 1.648352 | 5.20879232 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.03 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g11014 | i0 | 92.105 | 0.120253164556962 | 38 | 2 | 12 | 1 | 279 | 316 | 37 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 38 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 13983221 | 13983221 | PRJNA835051_S_NODE_132511_length_150_cov_1.813084_g132215_i0 | PRJNA835051 | 132511 | 150 | 1.813084 | 2.719626 | Copiparvovirus | 1511888 | Viruses | Viruses | 278 | 1.85e-70 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g132215 | i0 | 100 | 5 | 150 | 0 | 100 | 0 | 1 | 150 | 3442 | 3293 | Bosavirus MS-2016a, complete genome | blastn | 750 | 278 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 16129000 | 16129000 | PRJNA835051_S_NODE_6633_length_360_cov_4.277603_g6337_i0 | PRJNA835051 | 6633 | 360 | 4.277603 | 15.3993708 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 477 | 4.749999999999998e-130 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g6337 | i0 | 99.617 | 7.575 | 261 | 1 | 73 | 0 | 1 | 261 | 263 | 3 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2727 | 477 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 17403932 | 17403932 | PRJNA835051_S_NODE_1354_length_601_cov_3.023297_g1103_i0 | PRJNA835051 | 1354 | 601 | 3.023297 | 18.17001497 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 996 | 0 | NTclustered | gi|2277478564|gb|MZ502233.1| | 172297 | g1103 | i0 | 98.923 | 8.7504159733777 | 557 | 6 | 93 | 0 | 22 | 578 | 2542 | 1986 | Bovine parvovirus 3 isolate BCS1/USA nonstructural protein and structural protein genes, complete cds | blastn | 5259 | 996 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 17806921 | 17806921 | PRJNA835051_S_NODE_21834_length_270_cov_13.973568_g21538_i0 | PRJNA835051 | 21834 | 270 | 13.973568 | 37.7286336 | Copiparvovirus | 1511888 | Viruses | Viruses | 455 | 1.6100000000000002e-123 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g21538 | i0 | 99.206 | 4.21851851851852 | 252 | 2 | 93 | 0 | 1 | 252 | 5302 | 5051 | Bosavirus MS-2016a, complete genome | blastn | 1139 | 455 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 19952181 | 19952181 | PRJNA835051_S_NODE_20176_length_276_cov_1.476395_g19880_i0 | PRJNA835051 | 20176 | 276 | 1.476395 | 4.0748502 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 440 | 4.6399999999999984e-119 | NTclustered | gi|2277478564|gb|MZ502233.1| | 172297 | g19880 | i0 | 99.18 | 5.36594202898551 | 244 | 2 | 100 | 0 | 1 | 244 | 254 | 11 | Bovine parvovirus 3 isolate BCS1/USA nonstructural protein and structural protein genes, complete cds | blastn | 1481 | 440 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 21227943 | 21227943 | PRJNA835051_S_NODE_3077_length_450_cov_4.380835_g2785_i0 | PRJNA835051 | 3077 | 450 | 4.380835 | 19.7137575 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 780 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g2785 | i0 | 99.765 | 9.88444444444444 | 425 | 1 | 94 | 0 | 26 | 450 | 2271 | 1847 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 4448 | 780 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 21228677 | 21228677 | PRJNA835051_S_NODE_87757_length_178_cov_2.251852_g87461_i0 | PRJNA835051 | 87757 | 178 | 2.251852 | 4.00829656 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 329 | 6.21e-86 | NTclustered | gi|2277478564|gb|MZ502233.1| | 172297 | g87461 | i0 | 100 | 8.91011235955056 | 178 | 0 | 100 | 0 | 1 | 178 | 1045 | 1222 | Bovine parvovirus 3 isolate BCS1/USA nonstructural protein and structural protein genes, complete cds | blastn | 1586 | 329 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 22503085 | 22503085 | PRJNA835051_S_NODE_59698_length_205_cov_0.882716_g59402_i0 | PRJNA835051 | 59698 | 205 | 0.882716 | 1.8095678 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g59402 | i0 | 100 | 0.141463414634146 | 29 | 0 | 14 | 0 | 177 | 205 | 29 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 |
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);;