contig_metadata
16 rows where bioproject = "PRJNA564013", tax_kingdom = "Shotokuvirae" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3098270 | 3098270 | PRJNA564013_P_NODE_140403_length_360_cov_16.528428_g137555_i0 | PRJNA564013 | 140403 | 360 | 16.528428 | 59.5023408 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g137555 | i0 | 100 | 0.0777777777777778 | 28 | 0 | 8 | 0 | 1 | 28 | 3116 | 3089 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 3102690 | 3102690 | PRJNA564013_P_NODE_357043_length_193_cov_13.393939_g354191_i0 | PRJNA564013 | 357043 | 193 | 13.393939 | 25.85030227 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g354191 | i0 | 100 | 0.145077720207254 | 28 | 0 | 15 | 0 | 166 | 193 | 3089 | 3116 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 4379919 | 4379919 | PRJNA564013_P_NODE_59764_length_517_cov_29.625000_g56974_i0 | PRJNA564013 | 59764 | 517 | 29.625 | 153.16125 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g56974 | i0 | 100 | 0.0560928433268859 | 29 | 0 | 6 | 0 | 1 | 29 | 3116 | 3088 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 6929857 | 6929857 | PRJNA564013_P_NODE_356646_length_194_cov_2.511278_g353794_i0 | PRJNA564013 | 356646 | 194 | 2.511278 | 4.87187932 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g353794 | i0 | 100 | 0.144329896907216 | 28 | 0 | 14 | 0 | 167 | 194 | 28 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 8199390 | 8199390 | PRJNA564013_P_NODE_107147_length_399_cov_5.446746_g104308_i0 | PRJNA564013 | 107147 | 399 | 5.446746 | 21.73251654 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.038 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g104308 | i0 | 100 | 0.0701754385964912 | 28 | 0 | 7 | 0 | 1 | 28 | 3116 | 3089 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 8199746 | 8199746 | PRJNA564013_P_NODE_122027_length_380_cov_9.103448_g119182_i0 | PRJNA564013 | 122027 | 380 | 9.103448 | 34.5931024 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.036 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g119182 | i0 | 100 | 0.0736842105263158 | 28 | 0 | 7 | 0 | 1 | 28 | 3115 | 3088 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 9481648 | 9481648 | PRJNA564013_P_NODE_99088_length_411_cov_16.988571_g96254_i0 | PRJNA564013 | 99088 | 411 | 16.988571 | 69.82302681 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.039 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g96254 | i0 | 100 | 0.0681265206812652 | 28 | 0 | 7 | 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 | |||
| 10753756 | 10753756 | PRJNA564013_P_NODE_232589_length_276_cov_4.986047_g229737_i0 | PRJNA564013 | 232589 | 276 | 4.986047 | 13.76148972 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 422 | 1.68e-113 | NTclustered | gi|1200175664|gb|KY969593.1| | 31547 | g229737 | i0 | 97.561 | 1.78260869565217 | 246 | 6 | 89 | 0 | 22 | 267 | 5782 | 5537 | Human papillomavirus 20 strain HPV-20/Lancaster/2015, complete genome | blastn | 492 | 422 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 10754591 | 10754591 | PRJNA564013_P_NODE_277449_length_240_cov_6.318436_g274597_i0 | PRJNA564013 | 277449 | 240 | 6.318436 | 15.1642464 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g274597 | i0 | 96.875 | 0.133333333333333 | 32 | 0 | 13 | 1 | 210 | 240 | 3085 | 3116 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 32 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 12025954 | 12025954 | PRJNA564013_P_NODE_119850_length_383_cov_2.913043_g117006_i0 | PRJNA564013 | 119850 | 383 | 2.913043 | 11.15695469 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 636 | 7.929999999999998e-178 | NTclustered | gi|186461194|gb|EU410348.1| | 518629 | g117006 | i0 | 99.153 | 0.924281984334204 | 354 | 2 | 92 | 1 | 14 | 367 | 3754 | 3402 | Human papillomavirus type 110, complete genome | blastn | 354 | 636 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 14576240 | 14576240 | PRJNA564013_P_NODE_136352_length_364_cov_21.960396_g133504_i0 | PRJNA564013 | 136352 | 364 | 21.960396 | 79.93584144 | Gammapapillomavirus 12 | 1513257 | Viruses | Viruses | 534 | 2.8099999999999996e-147 | NTclustered | gi|409183149|gb|JX444072.1| | 1315266 | g133504 | i0 | 100 | 4.52197802197802 | 289 | 0 | 79 | 0 | 53 | 341 | 1266 | 978 | Human papillomavirus type 165 isolate KC7, complete genome | blastn | 1646 | 534 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 12 | ||
| 15853583 | 15853583 | PRJNA564013_P_NODE_305633_length_222_cov_1.664596_g302781_i0 | PRJNA564013 | 305633 | 222 | 1.664596 | 3.69540312 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g302781 | i0 | 100 | 0.130630630630631 | 29 | 0 | 13 | 0 | 2 | 30 | 3 | 31 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 15853842 | 15853842 | PRJNA564013_P_NODE_319693_length_213_cov_14.480263_g316841_i0 | PRJNA564013 | 319693 | 213 | 14.480263 | 30.84296019 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g316841 | i0 | 100 | 0.136150234741784 | 29 | 0 | 14 | 0 | 1 | 29 | 2 | 30 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 18401246 | 18401246 | PRJNA564013_P_NODE_22675_length_780_cov_8.657858_g20326_i0 | PRJNA564013 | 22675 | 780 | 8.657858 | 67.5312924 | Gammapapillomavirus 12 | 1513257 | Viruses | Viruses | 1332 | 0 | NTclustered | gi|409183149|gb|JX444072.1| | 1315266 | g20326 | i0 | 99.454 | 2.82179487179487 | 733 | 4 | 94 | 0 | 26 | 758 | 3455 | 2723 | Human papillomavirus type 165 isolate KC7, complete genome | blastn | 2201 | 1332 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 12 | ||
| 23501844 | 23501844 | PRJNA564013_P_NODE_234899_length_274_cov_4.812207_g232047_i0 | PRJNA564013 | 234899 | 274 | 4.812207 | 13.18544718 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g232047 | i0 | 96.875 | 0.116788321167883 | 32 | 1 | 12 | 0 | 243 | 274 | 3085 | 3116 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 32 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 31374976 | 31374976 | PRJNA564013_P_NODE_273976_length_243_cov_2.197802_g271124_i0 | PRJNA564013 | 273976 | 243 | 2.197802 | 5.34065886 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 50.1 | 9.48e-5 | NR | AAK29054.1 | 1891767 | g271124 | i0 | 57.1 | 0.432098765432099 | 35 | 15 | 43.2 | 0 | 125 | 229 | 503 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 105 | 50.1 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae |
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);;