contig_metadata
20 rows where bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 284672 | 284672 | PRJNA1137393_P_NODE_23141_length_193_cov_1.444444_g22625_i0 | PRJNA1137393 | 23141 | 193 | 1.444444 | 2.78777692 | Human papillomavirus | 10566 | Viruses | Viruses | 313 | 6.91e-81 | NTclustered | gi|1559669646|gb|MH777350.2| | 10566 | g22625 | i0 | 95.855 | 4.04145077720207 | 193 | 8 | 100 | 0 | 1 | 193 | 1405 | 1597 | MAG: Human papillomavirus isolate HPV-mSK_209, partial genome | blastn | 780 | 313 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 1559251 | 1559251 | PRJNA1137393_P_NODE_18182_length_208_cov_2.327044_g17666_i0 | PRJNA1137393 | 18182 | 208 | 2.327044 | 4.84025152 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 385 | 1.58e-102 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g17666 | i0 | 100 | 1.98076923076923 | 208 | 0 | 100 | 0 | 1 | 208 | 220 | 427 | Human papillomavirus type 28, complete genome | blastn | 412 | 385 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 1559270 | 1559270 | PRJNA1137393_P_NODE_26202_length_187_cov_3.434783_g25686_i0 | PRJNA1137393 | 26202 | 187 | 3.434783 | 6.42304421 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 340 | 3.0499999999999998e-89 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g25686 | i0 | 99.465 | 12.668449197861 | 187 | 1 | 100 | 0 | 1 | 187 | 7893 | 7707 | Human papillomavirus type 28, complete genome | blastn | 2369 | 340 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 1559294 | 1559294 | PRJNA1137393_P_NODE_31262_length_179_cov_2.000000_g30746_i0 | PRJNA1137393 | 31262 | 179 | 2 | 3.58 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 331 | 1.74e-86 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g30746 | i0 | 100 | 1.92737430167598 | 179 | 0 | 100 | 0 | 1 | 179 | 5327 | 5149 | Human papillomavirus type 28, complete genome | blastn | 345 | 331 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 5387844 | 5387844 | PRJNA1137393_P_NODE_10225_length_259_cov_1.709524_g9709_i0 | PRJNA1137393 | 10225 | 259 | 1.709524 | 4.42766716 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 479 | 9.13e-131 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g9709 | i0 | 100 | 2.00772200772201 | 259 | 0 | 100 | 0 | 1 | 259 | 1444 | 1702 | Human papillomavirus type 28, complete genome | blastn | 520 | 479 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 5387886 | 5387886 | PRJNA1137393_P_NODE_28325_length_184_cov_1.466667_g27809_i0 | PRJNA1137393 | 28325 | 184 | 1.466667 | 2.69866728 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 340 | 2.99e-89 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g27809 | i0 | 100 | 2 | 184 | 0 | 100 | 0 | 1 | 184 | 4970 | 5153 | Human papillomavirus type 28, complete genome | blastn | 368 | 340 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 6134980 | 6134980 | PRJNA1137393_P_NODE_70365_length_162_cov_0.920354_g69849_i0 | PRJNA1137393 | 70365 | 162 | 0.920354 | 1.49097348 | Gammapapillomavirus | 325455 | Viruses | Viruses | 300 | 4.36e-77 | NTclustered | gi|1559669523|gb|MH777364.2| | 10566 | g69849 | i0 | 100 | 2 | 162 | 0 | 100 | 0 | 1 | 162 | 3081 | 3242 | MAG: Human papillomavirus isolate HPV-mSK_225, complete genome | blastn | 324 | 300 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 6662495 | 6662495 | PRJNA1137393_P_NODE_10926_length_251_cov_2.198020_g10410_i0 | PRJNA1137393 | 10926 | 251 | 2.19802 | 5.5170302 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g10410 | i0 | 100 | 12.5896414342629 | 251 | 0 | 100 | 0 | 1 | 251 | 4549 | 4299 | Human papillomavirus type 28, complete genome | blastn | 3160 | 464 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 6662510 | 6662510 | PRJNA1137393_P_NODE_15986_length_217_cov_2.428571_g15470_i0 | PRJNA1137393 | 15986 | 217 | 2.428571 | 5.26999907 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 401 | 1.6499999999999994e-107 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g15470 | i0 | 100 | 3.90783410138249 | 217 | 0 | 100 | 0 | 1 | 217 | 3792 | 4008 | Human papillomavirus type 28, complete genome | blastn | 848 | 401 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 9212829 | 9212829 | PRJNA1137393_P_NODE_69188_length_162_cov_2.336283_g68672_i0 | PRJNA1137393 | 69188 | 162 | 2.336283 | 3.78477846 | Human papillomavirus | 10566 | Viruses | Viruses | 294 | 2.03e-75 | NTclustered | gi|1559669646|gb|MH777350.2| | 10566 | g68672 | i0 | 99.383 | 1 | 162 | 1 | 100 | 0 | 1 | 162 | 2958 | 2797 | MAG: Human papillomavirus isolate HPV-mSK_209, partial genome | blastn | 162 | 294 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 10488236 | 10488236 | PRJNA1137393_P_NODE_28769_length_183_cov_2.037313_g28253_i0 | PRJNA1137393 | 28769 | 183 | 2.037313 | 3.72828279 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 333 | 4.97e-87 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g28253 | i0 | 99.454 | 18.4207650273224 | 183 | 1 | 100 | 0 | 1 | 183 | 2556 | 2374 | Human papillomavirus type 28, complete genome | blastn | 3371 | 333 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 13038402 | 13038402 | PRJNA1137393_P_NODE_24051_length_191_cov_1.633803_g23535_i0 | PRJNA1137393 | 24051 | 191 | 1.633803 | 3.12056373 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 348 | 1.87e-91 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g23535 | i0 | 99.476 | 1 | 191 | 1 | 100 | 0 | 1 | 191 | 3559 | 3369 | Human papillomavirus type 28, complete genome | blastn | 191 | 348 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 14313732 | 14313732 | PRJNA1137393_P_NODE_60292_length_164_cov_2.382609_g59776_i0 | PRJNA1137393 | 60292 | 164 | 2.382609 | 3.90747876 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 289 | 9.59e-74 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g59776 | i0 | 100 | 3.07317073170732 | 156 | 0 | 95 | 0 | 9 | 164 | 997 | 842 | Human papillomavirus type 28, complete genome | blastn | 504 | 289 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 15587697 | 15587697 | PRJNA1137393_P_NODE_6353_length_340_cov_1.907216_g5837_i0 | PRJNA1137393 | 6353 | 340 | 1.907216 | 6.4845344 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 623 | 5.429999999999999e-174 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g5837 | i0 | 99.706 | 3.95 | 340 | 1 | 100 | 0 | 1 | 340 | 5685 | 5346 | Human papillomavirus type 28, complete genome | blastn | 1343 | 623 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 16861750 | 16861750 | PRJNA1137393_P_NODE_11754_length_243_cov_1.963918_g11238_i0 | PRJNA1137393 | 11754 | 243 | 1.963918 | 4.77232074 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g11238 | i0 | 100 | 9.0082304526749 | 243 | 0 | 100 | 0 | 1 | 243 | 3090 | 2848 | Human papillomavirus type 28, complete genome | blastn | 2189 | 449 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 19410584 | 19410584 | PRJNA1137393_P_NODE_13856_length_228_cov_1.977654_g13340_i0 | PRJNA1137393 | 13856 | 228 | 1.977654 | 4.50905112 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 422 | 1.34e-113 | NTclustered | gi|1020202|gb|U31783.1|HPU31783 | 37111 | g13340 | i0 | 100 | 8.32894736842105 | 228 | 0 | 100 | 0 | 1 | 228 | 6724 | 6951 | Human papillomavirus type 28, complete genome | blastn | 1899 | 422 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 21961608 | 21961608 | PRJNA1137393_P_NODE_63958_length_164_cov_0.904348_g63442_i0 | PRJNA1137393 | 63958 | 164 | 0.904348 | 1.48313072 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 303 | 3.42e-78 | NTclustered | gi|333086|gb|M22961.1|PPHDELCG | 333923 | g63442 | i0 | 100 | 16.6341463414634 | 164 | 0 | 100 | 0 | 1 | 164 | 969 | 1132 | Human papillomavirus type 5 DNA and naturally occurring deletions in the late region of the virus | blastn | 2728 | 303 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 28302087 | 28302087 | PRJNA1137393_P_NODE_74926_length_154_cov_2.257143_g74410_i0 | PRJNA1137393 | 74926 | 154 | 2.257143 | 3.47600022 | Ambidensovirus sp. | 2050976 | Viruses | Viruses | 57 | 1.03e-7 | NR | AWV66983.1 | 2050976 | g74410 | i0 | 54.3 | 0.896103896103896 | 46 | 21 | 89.6 | 0 | 139 | 2 | 271 | 316 | AWV66983.1 Non-structural ORF [Ambidensovirus sp.] | diamond | 138 | 57 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoambidensovirus | Protoambidensovirus incertum3 | ||
| 29912615 | 29912615 | PRJNA1137393_P_NODE_7371_length_311_cov_1.068702_g6855_i0 | PRJNA1137393 | 7371 | 311 | 1.068702 | 3.32366322 | Parvovirus panthera4442 | 3117168 | Viruses | Viruses | 50.8 | 1.15e-4 | NR | DBA46932.1 | 3117168 | g6855 | i0 | 46.9 | 0.472668810289389 | 49 | 25 | 46.3 | 1 | 144 | 1 | 103 | 151 | DBA46932.1 MAG TPA_asm: VP [Parvovirus panthera4442] | diamond | 147 | 50.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus panthera4442 | |||
| 31334214 | 31334214 | PRJNA1137393_P_NODE_60576_length_164_cov_1.669565_g60060_i0 | PRJNA1137393 | 60576 | 164 | 1.669565 | 2.7380866 | Ambidensovirus sp. | 2050976 | Viruses | Viruses | 58.5 | 3.35e-8 | NR | AWV66983.1 | 2050976 | g60060 | i0 | 45.1 | 1.82926829268293 | 51 | 28 | 93.3 | 0 | 1 | 153 | 368 | 418 | AWV66983.1 Non-structural ORF [Ambidensovirus sp.] | diamond | 300 | 58.5 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoambidensovirus | Protoambidensovirus incertum3 |
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);;