contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA546018" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 511018 | 511018 | PRJNA546018_S_NODE_37901_length_251_cov_1.694737_g37576_i0 | PRJNA546018 | 37901 | 251 | 1.694737 | 4.25378987 | Anas platyrhynchos papillomavirus 2 | 2855326 | Viruses | Viruses | 63.9 | 1.05e-5 | NTclustered | gi|2063549401|gb|MW888448.1| | 2855326 | g37576 | i0 | 97.368 | 0.422310756972112 | 38 | 0 | 15 | 1 | 208 | 244 | 1688 | 1725 | Anas platyrhynchos papillomavirus 2, complete genome | blastn | 106 | 63.9 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Anas platyrhynchos papillomavirus 2 | |||
| 3061822 | 3061822 | PRJNA546018_S_NODE_31303_length_280_cov_1.598174_g30978_i0 | PRJNA546018 | 31303 | 280 | 1.598174 | 4.4748872 | Taupapillomavirus 3 | 1961786 | Viruses | Viruses | 512 | 9.85e-141 | NTclustered | gi|2282111583|gb|ON226485.1| | 1336600 | g30978 | i0 | 99.643 | 6.92142857142857 | 280 | 1 | 100 | 0 | 1 | 280 | 6155 | 6434 | Felis catus papillomavirus 3 strain China/SMU-D21/2019, complete genome | blastn | 1938 | 512 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Taupapillomavirus | Taupapillomavirus 3 | ||
| 17697180 | 17697180 | PRJNA546018_S_NODE_37474_length_253_cov_1.140625_g37149_i0 | PRJNA546018 | 37474 | 253 | 1.140625 | 2.88578125 | Papillomaviridae | 151340 | Viruses | Viruses | 468 | 1.92e-127 | NTclustered | gi|69205080|gb|DQ085788.1| | 181667 | g37149 | i0 | 100 | 10 | 253 | 0 | 100 | 0 | 1 | 253 | 375 | 123 | Feline papillomavirus isolate FeSCC5 early protein 1 (E1) gene, partial cds | blastn | 2530 | 468 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Lambdapapillomavirus | Lambdapapillomavirus 1 | ||
| 18362554 | 18362554 | PRJNA546018_S_NODE_34975_length_262_cov_4.597015_g34650_i0 | PRJNA546018 | 34975 | 262 | 4.597015 | 12.0441793 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g34650 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 18362595 | 18362595 | PRJNA546018_S_NODE_37095_length_254_cov_2.020725_g36770_i0 | PRJNA546018 | 37095 | 254 | 2.020725 | 5.1326415 | Genomoviridae sp. ctD6S1 | 2828011 | Viruses | Viruses | 353 | 5.65e-93 | NTclustered | gi|2052881324|tpg|BK032821.1| | 2828011 | g36770 | i0 | 100 | 2.90157480314961 | 191 | 0 | 88 | 0 | 48 | 238 | 34 | 224 | MAG TPA_asm: Genomoviridae sp. ctD6S1, partial genome | blastn | 737 | 353 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. ctD6S1 | |||
| 18970827 | 18970827 | PRJNA546018_S_NODE_52715_length_209_cov_1.317568_g52390_i0 | PRJNA546018 | 52715 | 209 | 1.317568 | 2.75371712 | Epsilonpolyomavirus | 2842669 | Viruses | Viruses | 387 | 4.42e-103 | NTclustered | gi|2277478276|gb|MZ520135.1| | 1561702 | g52390 | i0 | 100 | 14.0143540669856 | 209 | 0 | 100 | 0 | 1 | 209 | 598 | 806 | Bovine polyomavirus 1 isolate FBS2/USA, complete genome | blastn | 2929 | 387 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Epsilonpolyomavirus | Epsilonpolyomavirus bovis | ||
| 19637635 | 19637635 | PRJNA546018_S_NODE_76_length_4942_cov_7.581251_g28_i0 | PRJNA546018 | 76 | 4942 | 7.581251 | 374.66542442 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 8983 | 0 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g28 | i0 | 99.474 | 9.05281262646702 | 4942 | 26 | 100 | 0 | 1 | 4942 | 168 | 5109 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 44739 | 8983 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 20912797 | 20912797 | PRJNA546018_S_NODE_19597_length_366_cov_3.400000_g19272_i0 | PRJNA546018 | 19597 | 366 | 3.4 | 12.444 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g19272 | i0 | 100 | 0.0792349726775956 | 29 | 0 | 8 | 0 | 338 | 366 | 29 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 20913501 | 20913501 | PRJNA546018_S_NODE_8757_length_592_cov_20.290019_g8443_i0 | PRJNA546018 | 8757 | 592 | 20.290019 | 120.11691248 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 488 | 3.769999999999999e-133 | NTclustered | gi|1333742271|gb|MG026728.1| | 172297 | g8443 | i0 | 98.551 | 7.69763513513514 | 276 | 4 | 93 | 0 | 1 | 276 | 5058 | 5333 | Bovine parvovirus 3 isolate ujs497 nonstructural protein and structural protein genes, complete cds | blastn | 4557 | 488 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 24071181 | 24071181 | PRJNA546018_S_NODE_36199_length_258_cov_0.989848_g35874_i0 | PRJNA546018 | 36199 | 258 | 0.989848 | 2.55380784 | Gammapapillomavirus | 325455 | Viruses | Viruses | 466 | 7.08e-127 | NTclustered | gi|1559669533|gb|MH777373.2| | 10566 | g35874 | i0 | 99.225 | 3.4922480620155 | 258 | 2 | 100 | 0 | 1 | 258 | 6493 | 6236 | MAG: Human papillomavirus isolate HPV-mSK_234, complete genome | blastn | 901 | 470 | 0.991489361702128 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus |
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);;