contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA550047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 516928 | 516928 | PRJNA550047_P_NODE_483441_length_236_cov_5.687117_g481468_i0 | PRJNA550047 | 483441 | 236 | 5.687117 | 13.42159612 | Alphapapillomavirus 4 | 337043 | Viruses | Viruses | 431 | 2.33e-116 | NTclustered | gi|60882|emb|X55965.1| | 333753 | g481468 | i0 | 99.576 | 9.25423728813559 | 236 | 1 | 100 | 0 | 1 | 236 | 1474 | 1709 | Human papillomavirus type 57 complete DNA | blastn | 2184 | 431 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 4 | ||
| 1120754 | 1120754 | PRJNA550047_P_NODE_278101_length_299_cov_5.650442_g276132_i0 | PRJNA550047 | 278101 | 299 | 5.650442 | 16.89482158 | Alphapapillomavirus | 333750 | Viruses | Viruses | 542 | 1.35e-149 | NTclustered | gi|71061109|dbj|AB211993.1| | 325568 | g276132 | i0 | 99.331 | 13.0167224080268 | 299 | 2 | 100 | 0 | 1 | 299 | 6855 | 6557 | Human papillomavirus type 27b DNA, complete genome | blastn | 3892 | 547 | 0.990859232175503 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 4 | ||
| 1790217 | 1790217 | PRJNA550047_P_NODE_288542_length_298_cov_8.804444_g286573_i0 | PRJNA550047 | 288542 | 298 | 8.804444 | 26.23724312 | Betapapillomavirus 5 | 334209 | Viruses | Viruses | 416 | 8.529999999999998e-112 | NTclustered | gi|50253426|ref|NC_005134.2| | 247269 | g286573 | i0 | 91.456 | 6.13422818791946 | 316 | 7 | 99 | 1 | 3 | 298 | 1290 | 1605 | Human papillomavirus type 96, complete genome | blastn | 1828 | 416 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 5 | ||
| 1791540 | 1791540 | PRJNA550047_P_NODE_395662_length_266_cov_18.497409_g393690_i0 | PRJNA550047 | 395662 | 266 | 18.497409 | 49.20310794 | Human papillomavirus type 222 | 2200959 | Viruses | Viruses | 486 | 5.629999999999999e-133 | NTclustered | gi|1389447876|gb|MH172379.1| | 2200959 | g393690 | i0 | 99.624 | 3.13157894736842 | 266 | 1 | 100 | 0 | 1 | 266 | 5841 | 5576 | Human papillomavirus type 222 isolate CT17, complete genome | blastn | 833 | 486 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus type 222 | ||
| 5620201 | 5620201 | PRJNA550047_P_NODE_433505_length_252_cov_13.033520_g431533_i0 | PRJNA550047 | 433505 | 252 | 13.03352 | 32.8444704 | Human papillomavirus type 222 | 2200959 | Viruses | Viruses | 416 | 7.029999999999999e-112 | NTclustered | gi|1389447876|gb|MH172379.1| | 2200959 | g431533 | i0 | 96.429 | 2.74206349206349 | 252 | 9 | 100 | 0 | 1 | 252 | 4419 | 4168 | Human papillomavirus type 222 isolate CT17, complete genome | blastn | 691 | 416 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus type 222 | ||
| 8166000 | 8166000 | PRJNA550047_P_NODE_166647_length_345_cov_3.621324_g164687_i0 | PRJNA550047 | 166647 | 345 | 3.621324 | 12.4935678 | Alphapapillomavirus 4 | 337043 | Viruses | Viruses | 270 | 8.28e-68 | NTclustered | gi|396964|emb|X74473.1| | 333752 | g164687 | i0 | 99.329 | 4.17391304347826 | 149 | 1 | 87 | 0 | 197 | 345 | 4261 | 4113 | Human papillomavirus type 27 genomic DNA | blastn | 1440 | 270 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 4 | ||
| 8169266 | 8169266 | PRJNA550047_P_NODE_436847_length_251_cov_10.494382_g434875_i0 | PRJNA550047 | 436847 | 251 | 10.494382 | 26.34089882 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|396940|emb|X74470.1| | 10608 | g434875 | i0 | 99.203 | 1 | 251 | 2 | 100 | 0 | 1 | 251 | 5488 | 5738 | Human papillomavirus type 19 genomic DNA | blastn | 251 | 453 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 8169461 | 8169461 | PRJNA550047_P_NODE_452467_length_246_cov_8.144509_g450494_i0 | PRJNA550047 | 452467 | 246 | 8.144509 | 20.03549214 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|1020186|gb|U31781.1|HPU31781 | 37955 | g450494 | i0 | 100 | 12.280487804878 | 246 | 0 | 100 | 0 | 1 | 246 | 2511 | 2756 | Human papillomavirus type 23, complete genome | blastn | 3021 | 455 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 9442277 | 9442277 | PRJNA550047_P_NODE_235248_length_301_cov_3.842105_g233279_i0 | PRJNA550047 | 235248 | 301 | 3.842105 | 11.56473605 | Gammapapillomavirus 13 | 1513258 | Viruses | Viruses | 270 | 7.0999999999999986e-68 | NTclustered | gi|1273499340|gb|MF588721.1| | 1513258 | g233279 | i0 | 98.684 | 2.51495016611296 | 152 | 2 | 100 | 0 | 150 | 301 | 6121 | 5970 | Gammapapillomavirus 13 isolate Gamma13_EV03c45, complete genome | blastn | 757 | 270 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 13 | ||
| 12600785 | 12600785 | PRJNA550047_P_NODE_487470_length_234_cov_17.639752_g485497_i0 | PRJNA550047 | 487470 | 234 | 17.639752 | 41.27701968 | Gammapapillomavirus | 325455 | Viruses | Viruses | 433 | 6.41e-117 | NTclustered | gi|1273499700|gb|MF588777.1| | 1513264 | g485497 | i0 | 100 | 6 | 234 | 0 | 100 | 0 | 1 | 234 | 1371 | 1604 | Gammapapillomavirus 19 isolate iGamma19_m815c46 E2 (E2) and E4 (E4) genes, complete cds | blastn | 1404 | 433 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 19 | ||
| 13268049 | 13268049 | PRJNA550047_P_NODE_25591_length_447_cov_10.422460_g23677_i0 | PRJNA550047 | 25591 | 447 | 10.42246 | 46.5883962 | Human papillomavirus type 222 | 2200959 | Viruses | Viruses | 516 | 1.28e-141 | NTclustered | gi|1389447876|gb|MH172379.1| | 2200959 | g23677 | i0 | 99.645 | 1.95525727069351 | 282 | 1 | 98 | 0 | 166 | 447 | 4794 | 5075 | Human papillomavirus type 222 isolate CT17, complete genome | blastn | 874 | 516 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus type 222 | ||
| 13271395 | 13271395 | PRJNA550047_P_NODE_520671_length_223_cov_15.306667_g518698_i0 | PRJNA550047 | 520671 | 223 | 15.306667 | 34.13386741 | Alphapapillomavirus 2 | 337039 | Viruses | Viruses | 412 | 7.88e-111 | NTclustered | gi|9627257|ref|NC_001576.1| | 333759 | g518698 | i0 | 100 | 11.085201793722 | 223 | 0 | 100 | 0 | 1 | 223 | 730 | 508 | Human papillomavirus type 10 genomic DNA | blastn | 2472 | 412 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 2 | ||
| 13875614 | 13875614 | PRJNA550047_P_NODE_46811_length_349_cov_15.373188_g44852_i0 | PRJNA550047 | 46811 | 349 | 15.373188 | 53.65242612 | Viruses | 10239 | Viruses | Viruses | 606 | 5.61e-169 | NTclustered | gi|1559669707|gb|MH777252.2| | 10566 | g44852 | i0 | 98 | 6.61604584527221 | 350 | 5 | 100 | 2 | 1 | 349 | 1500 | 1848 | MAG: Human papillomavirus isolate HPV-mSK_110, complete genome | blastn | 2309 | 612 | 0.990196078431373 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 17094977 | 17094977 | PRJNA550047_P_NODE_519354_length_224_cov_6.264901_g517381_i0 | PRJNA550047 | 519354 | 224 | 6.264901 | 14.03337824 | Betapapillomavirus 3 | 334207 | Viruses | Viruses | 390 | 3.71e-104 | NTclustered | gi|2183144171|gb|OL700030.1| | 696746 | g517381 | i0 | 100 | 2.27232142857143 | 211 | 0 | 94 | 0 | 14 | 224 | 1 | 211 | Human papillomavirus 115 isolate XJ-ZS137-1, complete genome | blastn | 509 | 390 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 3 | ||
| 17698835 | 17698835 | PRJNA550047_P_NODE_293514_length_298_cov_4.226667_g291545_i0 | PRJNA550047 | 293514 | 298 | 4.226667 | 12.59546766 | Gammapapillomavirus | 325455 | Viruses | Viruses | 534 | 2.26e-147 | NTclustered | gi|1480688964|gb|MH777338.1| | 10566 | g291545 | i0 | 98.993 | 2.53355704697987 | 298 | 3 | 100 | 0 | 1 | 298 | 170 | 467 | MAG: Human papillomavirus isolate HPV-mSK_196, complete genome | blastn | 755 | 534 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 20915124 | 20915124 | PRJNA550047_P_NODE_15697_length_522_cov_9.280624_g13822_i0 | PRJNA550047 | 15697 | 522 | 9.280624 | 48.44485728 | Human papillomavirus | 10566 | Viruses | Viruses | 311 | 7.65e-80 | NTclustered | gi|1559669707|gb|MH777252.2| | 10566 | g13822 | i0 | 100 | 5.65134099616858 | 168 | 0 | 90 | 0 | 178 | 345 | 2993 | 3160 | MAG: Human papillomavirus isolate HPV-mSK_110, complete genome | blastn | 2950 | 311 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 20917773 | 20917773 | PRJNA550047_P_NODE_37737_length_384_cov_11.935691_g35790_i0 | PRJNA550047 | 37737 | 384 | 11.935691 | 45.83305344 | Gammapapillomavirus 19 | 1513264 | Viruses | Viruses | 368 | 3.1999999999999993e-97 | NTclustered | gi|1273499700|gb|MF588777.1| | 1513264 | g35790 | i0 | 99.505 | 2.76041666666667 | 202 | 1 | 92 | 0 | 2 | 203 | 1683 | 1884 | Gammapapillomavirus 19 isolate iGamma19_m815c46 E2 (E2) and E4 (E4) genes, complete cds | blastn | 1060 | 368 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 19 | ||
| 22194178 | 22194178 | PRJNA550047_P_NODE_516038_length_225_cov_8.401316_g514065_i0 | PRJNA550047 | 516038 | 225 | 8.401316 | 18.902961 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 366 | 6.29e-97 | NTclustered | gi|1020178|gb|U31780.1|HPU31780 | 37954 | g514065 | i0 | 96 | 15.9111111111111 | 225 | 9 | 100 | 0 | 1 | 225 | 2725 | 2501 | Human papillomavirus type 22, complete genome | blastn | 3580 | 366 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 23468480 | 23468480 | PRJNA550047_P_NODE_414639_length_259_cov_10.870968_g412667_i0 | PRJNA550047 | 414639 | 259 | 10.870968 | 28.15580712 | Betapapillomavirus 1 | 337051 | Viruses | Viruses | 401 | 2.0299999999999993e-107 | NTclustered | gi|1020194|gb|U31782.1|HPU31782 | 37956 | g412667 | i0 | 94.922 | 4.3011583011583 | 256 | 13 | 99 | 0 | 3 | 258 | 387 | 642 | Human papillomavirus type 24, complete genome | blastn | 1114 | 401 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 1 | ||
| 23470491 | 23470491 | PRJNA550047_P_NODE_576979_length_205_cov_6.780303_g575006_i0 | PRJNA550047 | 576979 | 205 | 6.780303 | 13.89962115 | Gammapapillomavirus 22 | 1961679 | Viruses | Viruses | 357 | 3.3899999999999996e-94 | NTclustered | gi|1273499483|gb|MF588739.1| | 1961679 | g575006 | i0 | 98.049 | 2 | 205 | 4 | 100 | 0 | 1 | 205 | 4162 | 4366 | Gammapapillomavirus 22 isolate Gamma22_TVMBSWc141, complete genome | blastn | 410 | 357 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 22 |
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);;