contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 874704 | 874704 | PRJNA900028_P_NODE_142081_length_165_cov_1.318966_g141332_i0 | PRJNA900028 | 142081 | 165 | 1.318966 | 2.1762939 | Human papillomavirus | 10566 | Viruses | Viruses | 224 | 2.76e-54 | NTclustered | gi|1480689150|gb|MH777368.1| | 10566 | g141332 | i0 | 100 | 3.92121212121212 | 121 | 0 | 100 | 0 | 45 | 165 | 1 | 121 | MAG: Human papillomavirus isolate HPV-mSK_229, complete genome | blastn | 647 | 224 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 875831 | 875831 | PRJNA900028_P_NODE_6281_length_429_cov_1.342105_g5538_i0 | PRJNA900028 | 6281 | 429 | 1.342105 | 5.75763045 | Gemykrogvirus | 1985367 | Viruses | Viruses | 734 | 0 | NTclustered | gi|2045610848|gb|MW183017.1| | 1985367 | g5538 | i0 | 98.558 | 11.8414918414918 | 416 | 5 | 97 | 1 | 1 | 416 | 1699 | 2113 | MAG: Gemykrogvirus isolate thr147gen1, complete genome | blastn | 5080 | 734 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemykrogvirus | |||
| 3426236 | 3426236 | PRJNA900028_P_NODE_37123_length_225_cov_1.738636_g36374_i0 | PRJNA900028 | 37123 | 225 | 1.738636 | 3.911931 | Betapapillomavirus 5 | 334209 | Viruses | Viruses | 411 | 2.869999999999999e-110 | NTclustered | gi|1031620547|gb|KR816172.1| | 1851127 | g36374 | i0 | 99.556 | 1 | 225 | 1 | 100 | 0 | 1 | 225 | 5219 | 5443 | Human papillomavirus type 185 isolate ACS003, complete genome | blastn | 225 | 411 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 5 | ||
| 5978461 | 5978461 | PRJNA900028_P_NODE_194085_length_161_cov_0.910714_g193336_i0 | PRJNA900028 | 194085 | 161 | 0.910714 | 1.46624954 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|238623465|emb|FM955842.1| | 587351 | g193336 | i0 | 99.379 | 5.63975155279503 | 161 | 1 | 100 | 0 | 1 | 161 | 4007 | 4167 | Human papillomavirus type 113, complete genome | blastn | 908 | 292 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 11077903 | 11077903 | PRJNA900028_P_NODE_11929_length_328_cov_0.913978_g11181_i0 | PRJNA900028 | 11929 | 328 | 0.913978 | 2.99784784 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 606 | 5.249999999999998e-169 | NTclustered | gi|186461194|gb|EU410348.1| | 518629 | g11181 | i0 | 100 | 12.9817073170732 | 328 | 0 | 100 | 0 | 1 | 328 | 6613 | 6940 | Human papillomavirus type 110, complete genome | blastn | 4258 | 606 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 15273199 | 15273199 | PRJNA900028_P_NODE_35832_length_228_cov_0.860335_g35083_i0 | PRJNA900028 | 35832 | 228 | 0.860335 | 1.9615638 | Genomoviridae | 1910928 | Viruses | Viruses | 422 | 1.34e-113 | NTclustered | gi|2045610848|gb|MW183017.1| | 1985367 | g35083 | i0 | 100 | 7 | 228 | 0 | 100 | 0 | 1 | 228 | 1019 | 792 | MAG: Gemykrogvirus isolate thr147gen1, complete genome | blastn | 1596 | 422 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Gemykrogvirus | |||
| 18726599 | 18726599 | PRJNA900028_P_NODE_19215_length_275_cov_1.743363_g18466_i0 | PRJNA900028 | 19215 | 275 | 1.743363 | 4.79424825 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 508 | 1.2499999999999999e-139 | NTclustered | gi|186461194|gb|EU410348.1| | 518629 | g18466 | i0 | 100 | 4.83636363636364 | 275 | 0 | 100 | 0 | 1 | 275 | 2568 | 2294 | Human papillomavirus type 110, complete genome | blastn | 1330 | 508 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 22552663 | 22552663 | PRJNA900028_P_NODE_62578_length_194_cov_1.758621_g61829_i0 | PRJNA900028 | 62578 | 194 | 1.758621 | 3.41172474 | Betapapillomavirus 2 | 333924 | Viruses | Viruses | 322 | 1.16e-83 | NTclustered | gi|238623465|emb|FM955842.1| | 587351 | g61829 | i0 | 96.875 | 0.989690721649485 | 192 | 6 | 99 | 0 | 3 | 194 | 2422 | 2231 | Human papillomavirus type 113, complete genome | blastn | 192 | 322 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 2 | ||
| 25100344 | 25100344 | PRJNA900028_P_NODE_108200_length_172_cov_1.243902_g107451_i0 | PRJNA900028 | 108200 | 172 | 1.243902 | 2.13951144 | Human papillomavirus | 10566 | Viruses | Viruses | 318 | 1.2899999999999999e-82 | NTclustered | gi|1559669482|gb|MH777320.2| | 10566 | g107451 | i0 | 100 | 4 | 172 | 0 | 100 | 0 | 1 | 172 | 6071 | 5900 | MAG: Human papillomavirus isolate HPV-mSK_178, complete genome | blastn | 688 | 318 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 25101577 | 25101577 | PRJNA900028_P_NODE_44620_length_214_cov_1.818182_g43871_i0 | PRJNA900028 | 44620 | 214 | 1.818182 | 3.89090948 | Betapapillomavirus 5 | 334209 | Viruses | Viruses | 390 | 3.519999999999999e-104 | NTclustered | gi|1031620547|gb|KR816172.1| | 1851127 | g43871 | i0 | 99.533 | 1 | 214 | 1 | 100 | 0 | 1 | 214 | 1968 | 1755 | Human papillomavirus type 185 isolate ACS003, complete genome | blastn | 214 | 390 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Betapapillomavirus | Betapapillomavirus 5 | ||
| 25472110 | 25472110 | PRJNA900028_P_NODE_53580_length_204_cov_0.987097_g52831_i0 | PRJNA900028 | 53580 | 204 | 0.987097 | 2.01367788 | Gammapapillomavirus | 325455 | Viruses | Viruses | 366 | 5.599999999999998e-97 | NTclustered | gi|1559669553|gb|MH972562.2| | 10566 | g52831 | i0 | 99.02 | 2 | 204 | 2 | 100 | 0 | 1 | 204 | 4646 | 4849 | MAG: Human papillomavirus isolate HPV-mSK_101, complete genome | blastn | 408 | 366 | 1 | 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);;