contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA752278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 727121 | 727121 | PRJNA752278_P_NODE_2441_length_759_cov_2.053936_g2253_i0 | PRJNA752278 | 2441 | 759 | 2.053936 | 15.58937424 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 1402 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g2253 | i0 | 100 | 3.12252964426877 | 759 | 0 | 100 | 0 | 1 | 759 | 5304 | 4546 | Human papillomavirus type 65 complete genome | blastn | 2370 | 1402 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 2003851 | 2003851 | PRJNA752278_P_NODE_5782_length_555_cov_2.871369_g5580_i0 | PRJNA752278 | 5782 | 555 | 2.871369 | 15.93609795 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 1026 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g5580 | i0 | 100 | 1.9009009009009 | 555 | 0 | 100 | 0 | 1 | 555 | 7255 | 6701 | Human papillomavirus type 65 complete genome | blastn | 1055 | 1026 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 5830778 | 5830778 | PRJNA752278_P_NODE_2505_length_752_cov_1.949926_g2317_i0 | PRJNA752278 | 2505 | 752 | 1.949926 | 14.66344352 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 1389 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g2317 | i0 | 100 | 8.3563829787234 | 752 | 0 | 100 | 0 | 1 | 752 | 5440 | 6191 | Human papillomavirus type 65 complete genome | blastn | 6284 | 1389 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 5832019 | 5832019 | PRJNA752278_P_NODE_925_length_1102_cov_2.376093_g778_i0 | PRJNA752278 | 925 | 1102 | 2.376093 | 26.18454486 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 2030 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g778 | i0 | 99.909 | 5.3529945553539 | 1102 | 1 | 100 | 0 | 1 | 1102 | 898 | 1999 | Human papillomavirus type 65 complete genome | blastn | 5899 | 2030 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 8380058 | 8380058 | PRJNA752278_P_NODE_107287_length_236_cov_2.196319_g107084_i0 | PRJNA752278 | 107287 | 236 | 2.196319 | 5.18331284 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 436 | 4.999999999999999e-118 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g107084 | i0 | 100 | 2 | 236 | 0 | 100 | 0 | 1 | 236 | 2003 | 2238 | Human papillomavirus type 65 complete genome | blastn | 472 | 436 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 8381839 | 8381839 | PRJNA752278_P_NODE_9987_length_455_cov_1.816754_g9784_i0 | PRJNA752278 | 9987 | 455 | 1.816754 | 8.2662307 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 841 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g9784 | i0 | 100 | 5.84835164835165 | 455 | 0 | 100 | 0 | 1 | 455 | 345 | 799 | Human papillomavirus type 65 complete genome | blastn | 2661 | 841 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 9655466 | 9655466 | PRJNA752278_P_NODE_16688_length_379_cov_1.284314_g16485_i0 | PRJNA752278 | 16688 | 379 | 1.284314 | 4.86755006 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 701 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g16485 | i0 | 100 | 4.59630606860158 | 379 | 0 | 100 | 0 | 1 | 379 | 6219 | 6597 | Human papillomavirus type 65 complete genome | blastn | 1742 | 701 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 13480777 | 13480777 | PRJNA752278_P_NODE_15151_length_391_cov_2.584906_g14948_i0 | PRJNA752278 | 15151 | 391 | 2.584906 | 10.10698246 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 717 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g14948 | i0 | 99.744 | 5.26086956521739 | 391 | 1 | 100 | 0 | 1 | 391 | 3499 | 3109 | Human papillomavirus type 65 complete genome | blastn | 2057 | 717 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 14755946 | 14755946 | PRJNA752278_P_NODE_20932_length_349_cov_5.123188_g20729_i0 | PRJNA752278 | 20932 | 349 | 5.123188 | 17.87992612 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 640 | 5.529999999999999e-179 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g20729 | i0 | 99.714 | 1.00286532951289 | 350 | 0 | 100 | 1 | 1 | 349 | 4224 | 4573 | Human papillomavirus type 65 complete genome | blastn | 350 | 640 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 14756157 | 14756157 | PRJNA752278_P_NODE_2992_length_702_cov_2.106518_g2801_i0 | PRJNA752278 | 2992 | 702 | 2.106518 | 14.78775636 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 1286 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g2801 | i0 | 99.715 | 4.41737891737892 | 702 | 2 | 100 | 0 | 1 | 702 | 3500 | 4201 | Human papillomavirus type 65 complete genome | blastn | 3101 | 1286 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 19855095 | 19855095 | PRJNA752278_P_NODE_7016_length_516_cov_3.311512_g6813_i0 | PRJNA752278 | 7016 | 516 | 3.311512 | 17.08740192 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 953 | 0 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g6813 | i0 | 100 | 3.67441860465116 | 516 | 0 | 100 | 0 | 1 | 516 | 2529 | 3044 | Human papillomavirus type 65 complete genome | blastn | 1896 | 953 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 22405237 | 22405237 | PRJNA752278_P_NODE_61338_length_266_cov_2.279793_g61135_i0 | PRJNA752278 | 61338 | 266 | 2.279793 | 6.06424938 | Gammapapillomavirus 1 | 333926 | Viruses | Viruses | 492 | 1.2099999999999999e-134 | NTclustered | gi|312100|emb|X70829.1| | 28312 | g61135 | i0 | 100 | 5.32706766917293 | 266 | 0 | 100 | 0 | 1 | 266 | 2279 | 2544 | Human papillomavirus type 65 complete genome | blastn | 1417 | 492 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 1 | ||
| 24152741 | 24152741 | PRJNA752278_P_NODE_61479_length_266_cov_2.015544_g61276_i0 | PRJNA752278 | 61479 | 266 | 2.015544 | 5.36134704 | Viruses | 10239 | Viruses | Viruses | 492 | 1.2099999999999999e-134 | NTclustered | gi|2814138551|gb|PQ313133.1| | 1940570 | g61276 | i0 | 100 | 2 | 266 | 0 | 100 | 0 | 1 | 266 | 466 | 731 | Parvoviridae sp. isolate SpinColumn18, partial genome | blastn | 532 | 492 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvoviridae sp. | |||
| 25427300 | 25427300 | PRJNA752278_P_NODE_19120_length_361_cov_1.447917_g18917_i0 | PRJNA752278 | 19120 | 361 | 1.447917 | 5.22698037 | Viruses | 10239 | Viruses | Viruses | 446 | 1.34e-120 | NTclustered | gi|2045611283|gb|MW046548.1| | 2794472 | g18917 | i0 | 90.774 | 1.60664819944598 | 336 | 28 | 92 | 2 | 1 | 333 | 1222 | 1557 | MAG: Ciconia boyciana parvoviridae sp. isolate whs72par019 genomic sequence, sequence | blastn | 580 | 446 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Ciconia boyciana parvoviridae 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);;