contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 525381 | 525381 | PRJNA556992_P_NODE_204521_length_324_cov_17.725100_g202333_i0 | PRJNA556992 | 204521 | 324 | 17.7251 | 57.429324 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 573 | 5.249999999999999e-159 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g202333 | i0 | 98.758 | 60.7561728395062 | 322 | 4 | 99 | 0 | 2 | 323 | 1937 | 1616 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 19685 | 573 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 3073391 | 3073391 | PRJNA556992_P_NODE_1056883_length_223_cov_4.746667_g1054693_i0 | PRJNA556992 | 1056883 | 223 | 4.746667 | 10.58506741 | Cressdnaviricota sp. | 2748378 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|2896101054|gb|PQ792386.1| | 2748378 | g1054693 | i0 | 100 | 0.125560538116592 | 28 | 0 | 13 | 0 | 43 | 70 | 1198 | 1171 | MAG: Cressdnaviricota sp. isolate Splant072_cress9 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Cressdnaviricota sp. | ||||||
| 3074088 | 3074088 | PRJNA556992_P_NODE_1113083_length_209_cov_11.522059_g1110892_i0 | PRJNA556992 | 1113083 | 209 | 11.522059 | 24.08110331 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 387 | 4.42e-103 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g1110892 | i0 | 100 | 3.97607655502392 | 209 | 0 | 100 | 0 | 1 | 209 | 1266 | 1058 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 831 | 387 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 4350022 | 4350022 | PRJNA556992_P_NODE_1087004_length_216_cov_4.097902_g1084813_i0 | PRJNA556992 | 1087004 | 216 | 4.097902 | 8.85146832 | Gammapapillomavirus 8 | 1175850 | Viruses | Viruses | 372 | 1.29e-98 | NTclustered | gi|343411609|gb|HM999999.1| | 1070420 | g1084813 | i0 | 97.685 | 1 | 216 | 5 | 100 | 0 | 1 | 216 | 3666 | 3451 | Human papillomavirus type 147 isolate GH659, complete genome | blastn | 216 | 372 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 8 | ||
| 4354503 | 4354503 | PRJNA556992_P_NODE_329244_length_285_cov_1.132075_g327055_i0 | PRJNA556992 | 329244 | 285 | 1.132075 | 3.22641375 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 510 | 3.61e-140 | NTclustered | gi|58430757|dbj|AB201226.1| | 260717 | g327055 | i0 | 98.947 | 12.4771929824561 | 285 | 3 | 100 | 0 | 1 | 285 | 2295 | 2011 | Human papillomavirus type 94 DNA, nearly complete genome, Korean variant | blastn | 3556 | 510 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 8177518 | 8177518 | PRJNA556992_P_NODE_159927_length_351_cov_2.766187_g157739_i0 | PRJNA556992 | 159927 | 351 | 2.766187 | 9.70931637 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 599 | 9.45e-167 | NTclustered | gi|2756421315|gb|PP744650.1| | 2202565 | g157739 | i0 | 97.199 | 3557.74358974359 | 357 | 4 | 100 | 1 | 1 | 351 | 1374 | 1730 | MAG: Genomoviridae sp. isolate 171_106887 genomic sequence | blastn | 1248768 | 599 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 10737229 | 10737229 | PRJNA556992_P_NODE_788169_length_246_cov_4.208092_g785979_i0 | PRJNA556992 | 788169 | 246 | 4.208092 | 10.35190632 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 433 | 6.79e-117 | NTclustered | gi|1273499042|gb|MF588683.1| | 333924 | g785979 | i0 | 98.374 | 2 | 246 | 4 | 100 | 0 | 1 | 246 | 4744 | 4499 | Betapapillomavirus 2 isolate Beta02_m292c88, complete genome | blastn | 492 | 433 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 10739652 | 10739652 | PRJNA556992_P_NODE_988529_length_231_cov_7.462025_g986339_i0 | PRJNA556992 | 988529 | 231 | 7.462025 | 17.23727775 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 427 | 2.9399999999999998e-115 | NTclustered | gi|2756421460|gb|PP744699.1| | 2202565 | g986339 | i0 | 100 | 54.6969696969697 | 231 | 0 | 100 | 0 | 1 | 231 | 1774 | 2004 | MAG: Genomoviridae sp. isolate 321_31078 genomic sequence | blastn | 12635 | 427 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 12006821 | 12006821 | PRJNA556992_P_NODE_374410_length_279_cov_2.398058_g372221_i0 | PRJNA556992 | 374410 | 279 | 2.398058 | 6.69058182 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 503 | 5.9e-138 | NTclustered | gi|1273498994|gb|MF588677.1| | 337051 | g372221 | i0 | 99.281 | 2.89964157706093 | 278 | 2 | 99 | 0 | 1 | 278 | 5312 | 5589 | Betapapillomavirus 1 isolate Beta01_HIVGc36, complete genome | blastn | 809 | 503 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 13276522 | 13276522 | PRJNA556992_P_NODE_10551_length_1023_cov_21.089474_g9067_i0 | PRJNA556992 | 10551 | 1023 | 21.089474 | 215.74531902 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 1410 | 0 | NTclustered | gi|2756421285|gb|PP744640.1| | 2202565 | g9067 | i0 | 100 | 49.6080156402737 | 763 | 0 | 100 | 0 | 261 | 1023 | 2200 | 1438 | MAG: Genomoviridae sp. isolate 128_116004 genomic sequence | blastn | 50749 | 1410 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 13281126 | 13281126 | PRJNA556992_P_NODE_315051_length_286_cov_8.319249_g312862_i0 | PRJNA556992 | 315051 | 286 | 8.319249 | 23.79305214 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 501 | 2.18e-137 | NTclustered | gi|2742830632|gb|PP793069.1| | 2202565 | g312862 | i0 | 98.252 | 2 | 286 | 5 | 100 | 0 | 1 | 286 | 409 | 124 | MAG: Genomoviridae sp. isolate 028_4104, partial genome | blastn | 572 | 501 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 13287639 | 13287639 | PRJNA556992_P_NODE_829451_length_244_cov_2.883041_g827261_i0 | PRJNA556992 | 829451 | 244 | 2.883041 | 7.03462004 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1200175664|gb|KY969593.1| | 31547 | g827261 | i0 | 100 | 0.245901639344262 | 30 | 0 | 12 | 0 | 23 | 52 | 5585 | 5556 | Human papillomavirus 20 strain HPV-20/Lancaster/2015, complete genome | blastn | 60 | 56.5 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 13879512 | 13879512 | PRJNA556992_P_NODE_24511_length_689_cov_4.285714_g22495_i0 | PRJNA556992 | 24511 | 689 | 4.285714 | 29.52856946 | Genomoviridae | 1910928 | Viruses | Viruses | 1251 | 0 | NTclustered | gi|2080100107|gb|MZ244272.1| | 1983771 | g22495 | i0 | 99.419 | 31.088534107402 | 689 | 4 | 100 | 0 | 1 | 689 | 1732 | 1044 | MAG: Gemycircularvirus sp. isolate 336genomoc1, complete genome | blastn | 21420 | 1256 | 0.996019108280255 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemycircularvirus | Gemycircularvirus sp. | ||
| 14554620 | 14554620 | PRJNA556992_P_NODE_215952_length_318_cov_25.983673_g213764_i0 | PRJNA556992 | 215952 | 318 | 25.983673 | 82.62808014 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 579 | 1.1099999999999996e-160 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g213764 | i0 | 99.684 | 3.90880503144654 | 316 | 1 | 99 | 0 | 1 | 316 | 690 | 1005 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 1243 | 579 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 14557185 | 14557185 | PRJNA556992_P_NODE_396712_length_277_cov_1.446078_g394523_i0 | PRJNA556992 | 396712 | 277 | 1.446078 | 4.00563606 | Blatella germanica densoviruses-like virus 1 | 2776787 | Viruses | Viruses | 490 | 4.56e-134 | NTclustered | gi|1917254128|gb|MN851295.1| | 2776787 | g394523 | i0 | 98.556 | 30.8736462093863 | 277 | 4 | 100 | 0 | 1 | 277 | 131 | 407 | Blatella germanica densoviruses-like virus 1 isolate EuB-PV1 nonstructural protein genes, complete cds | blastn | 8552 | 490 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Blatella germanica densoviruses-like virus 1 | |||
| 16429980 | 16429980 | PRJNA556992_P_NODE_71033_length_451_cov_20.973545_g68858_i0 | PRJNA556992 | 71033 | 451 | 20.973545 | 94.59068795 | Gemykibivirus | 1941236 | Viruses | Viruses | 811 | 0 | NTclustered | gi|745699253|gb|KP133078.1| | 1588761 | g68858 | i0 | 99.113 | 31.9866962305987 | 451 | 4 | 100 | 0 | 1 | 451 | 1076 | 1526 | Gemycircularvirus BZ1, complete genome | blastn | 14426 | 811 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemykibivirus | Gemykibivirus humas2 | ||
| 17100823 | 17100823 | PRJNA556992_P_NODE_1115214_length_209_cov_5.375000_g1113023_i0 | PRJNA556992 | 1115214 | 209 | 5.375 | 11.23375 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 237 | 4.71e-58 | NTclustered | gi|2756421318|gb|PP744651.1| | 2202565 | g1113023 | i0 | 96.503 | 2.22488038277512 | 143 | 5 | 100 | 0 | 1 | 143 | 143 | 1 | MAG: Genomoviridae sp. isolate 171_3642 genomic sequence | blastn | 465 | 237 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 17108764 | 17108764 | PRJNA556992_P_NODE_627454_length_256_cov_5.693989_g625265_i0 | PRJNA556992 | 627454 | 256 | 5.693989 | 14.57661184 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 468 | 1.95e-127 | NTclustered | gi|2756421460|gb|PP744699.1| | 2202565 | g625265 | i0 | 99.609 | 7.80859375 | 256 | 1 | 100 | 0 | 1 | 256 | 1347 | 1092 | MAG: Genomoviridae sp. isolate 321_31078 genomic sequence | blastn | 1999 | 468 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 18385995 | 18385995 | PRJNA556992_P_NODE_870755_length_242_cov_2.254438_g868565_i0 | PRJNA556992 | 870755 | 242 | 2.254438 | 5.45573996 | Epsilonpolyomavirus bovis | 1891754 | Viruses | Viruses | 58.4 | 4.69e-4 | NTclustered | gi|954182136|gb|KU170643.1| | 1561702 | g868565 | i0 | 100 | 0.128099173553719 | 31 | 0 | 13 | 0 | 115 | 145 | 138 | 108 | Bovine polyomavirus 1 isolate #7535, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Epsilonpolyomavirus | Epsilonpolyomavirus bovis | ||
| 20251234 | 20251234 | PRJNA556992_P_NODE_1135396_length_204_cov_14.389313_g1133205_i0 | PRJNA556992 | 1135396 | 204 | 14.389313 | 29.35419852 | Arfiviricetes | 2732423 | Viruses | Viruses | 377 | 2.59e-100 | NTclustered | gi|2626080284|gb|OR270688.1| | 1954248 | g1133205 | i0 | 100 | 6 | 204 | 0 | 100 | 0 | 1 | 204 | 1029 | 826 | MAG: Circoviridae sp. isolate GL83, complete genome | blastn | 1224 | 377 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard | ||
| 22803839 | 22803839 | PRJNA556992_P_NODE_552918_length_262_cov_23.047619_g550729_i0 | PRJNA556992 | 552918 | 262 | 23.047619 | 60.38476178 | Gemykibivirus | 1941236 | Viruses | Viruses | 483 | 7.149999999999997e-132 | NTclustered | gi|745699259|gb|KP133080.1| | 1588763 | g550729 | i0 | 100 | 31.706106870229 | 261 | 0 | 99 | 0 | 1 | 261 | 118 | 378 | Gemycircularvirus NP, complete genome | blastn | 8307 | 483 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemykibivirus | Gemykibivirus humas2 | ||
| 24761283 | 24761283 | PRJNA556992_P_NODE_949240_length_235_cov_11.969136_g947050_i0 | PRJNA556992 | 949240 | 235 | 11.969136 | 28.1274696 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 435 | 1.79e-117 | NTclustered | gi|2756421460|gb|PP744699.1| | 2202565 | g947050 | i0 | 100 | 37.1446808510638 | 235 | 0 | 100 | 0 | 1 | 235 | 1547 | 1781 | MAG: Genomoviridae sp. isolate 321_31078 genomic sequence | blastn | 8729 | 435 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. |
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);;