contig_metadata
18 rows where bioproject = "PRJNA383995" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405293 | 405293 | PRJNA383995_P_NODE_5821_length_262_cov_0.957746_g5722_i0 | PRJNA383995 | 5821 | 262 | 0.957746 | 2.50929452 | Tequintavirus SP3 | 2733991 | Viruses | Viruses | 479 | 9.249999999999999e-131 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g5722 | i0 | 99.618 | 92.4083969465649 | 262 | 1 | 100 | 0 | 1 | 262 | 90628 | 90889 | Salmonella phage SP3, partial genome | blastn | 24211 | 479 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 405302 | 405302 | PRJNA383995_P_NODE_9941_length_207_cov_1.291139_g9842_i0 | PRJNA383995 | 9941 | 207 | 1.291139 | 2.67265773 | Salmonella phage SP1a | 2109652 | Viruses | Viruses | 383 | 5.65e-102 | NTclustered | gi|1251987296|gb|MF774690.1| | 2109652 | g9842 | i0 | 100 | 121.990338164251 | 207 | 0 | 100 | 0 | 1 | 207 | 1400 | 1194 | Salmonella phage SP1a clone contig.00004 genomic sequence, sequence | blastn | 25252 | 383 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Salmonella phage SP1a | |||
| 1680112 | 1680112 | PRJNA383995_P_NODE_22_length_2374_cov_5.199570_g15_i0 | PRJNA383995 | 22 | 2374 | 5.19957 | 123.4377918 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2676 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g15 | i0 | 93.775 | 0.868997472620051 | 1783 | 106 | 87 | 5 | 7 | 1787 | 7108 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2063 | 2676 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 1680113 | 1680113 | PRJNA383995_P_NODE_262_length_1018_cov_8.909185_g3_i4 | PRJNA383995 | 262 | 1018 | 8.909185 | 90.6955033 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 691 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3 | i4 | 94.432 | 0.546168958742633 | 449 | 25 | 55 | 0 | 385 | 833 | 2100 | 2548 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 556 | 691 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 1680119 | 1680119 | PRJNA383995_P_NODE_502_length_773_cov_4.640884_g427_i0 | PRJNA383995 | 502 | 773 | 4.640884 | 35.87403332 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1099 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g427 | i0 | 92.238 | 1 | 773 | 60 | 100 | 0 | 1 | 773 | 6960 | 6188 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 773 | 1099 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 1680127 | 1680127 | PRJNA383995_P_NODE_8302_length_224_cov_1.165714_g8203_i0 | PRJNA383995 | 8302 | 224 | 1.165714 | 2.61119936 | Tequintavirus SP3 | 2733991 | Viruses | Viruses | 409 | 1.03e-109 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g8203 | i0 | 100 | 99.1964285714286 | 221 | 0 | 99 | 0 | 4 | 224 | 19950 | 19730 | Salmonella phage SP3, partial genome | blastn | 22220 | 409 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 2351201 | 2351201 | PRJNA383995_P_NODE_5242_length_275_cov_0.783186_g5143_i0 | PRJNA383995 | 5242 | 275 | 0.783186 | 2.1537615 | Tequintavirus | 187218 | Viruses | Viruses | 470 | 5.89e-128 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g5143 | i0 | 97.455 | 101.021818181818 | 275 | 7 | 100 | 0 | 1 | 275 | 18526 | 18252 | Salmonella phage SP3, partial genome | blastn | 27781 | 470 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 4232376 | 4232376 | PRJNA383995_P_NODE_10984_length_198_cov_1.026846_g10885_i0 | PRJNA383995 | 10984 | 198 | 1.026846 | 2.03315508 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.21e-68 | NTclustered | gi|2914935757|gb|OR221655.1| | 2832643 | g10885 | i0 | 91.457 | 3.01010101010101 | 199 | 15 | 100 | 2 | 1 | 198 | 15025 | 14828 | MAG: Caudoviricetes sp. isolate MSP1392 genomic sequence | blastn | 596 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4232402 | 4232402 | PRJNA383995_P_NODE_4_length_3753_cov_6.712743_g3_i0 | PRJNA383995 | 4 | 3753 | 6.712743 | 251.92924479 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1228 | 0 | NR | WKU61618.1 | 3063761 | g3 | i0 | 57.6 | 1.01438848920863 | 1269 | 517 | 99.8 | 2 | 6 | 3752 | 586 | 1853 | WKU61618.1 polyprotein [Zebrafish picornavirus 2] | diamond | 3807 | 1228 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 7453780 | 7453780 | PRJNA383995_P_NODE_12266_length_187_cov_4.014493_g12167_i0 | PRJNA383995 | 12266 | 187 | 4.014493 | 7.50710191 | root | 1 | Root_unresolved | Root_unresolved | 337 | 3.95e-88 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g12167 | i0 | 100 | 97.3262032085562 | 182 | 0 | 97 | 0 | 1 | 182 | 15042 | 15223 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 18200 | 337 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 8058563 | 8058563 | PRJNA383995_P_NODE_16747_length_165_cov_0.879310_g16648_i0 | PRJNA383995 | 16747 | 165 | 0.87931 | 1.4508615 | Tequintavirus SP3 | 2733991 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|1842017380|ref|NC_048001.1| | 2053625 | g16648 | i0 | 100 | 55.1272727272727 | 165 | 0 | 100 | 0 | 1 | 165 | 3408 | 3244 | Salmonella phage SP3, partial genome | blastn | 9096 | 305 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Tequintavirus SP3 | ||
| 11883929 | 11883929 | PRJNA383995_P_NODE_10_length_2887_cov_8.181818_g3_i1 | PRJNA383995 | 10 | 2887 | 8.181818 | 236.20908566 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1112 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3 | i1 | 98.119 | 0.585382750259785 | 638 | 12 | 59 | 0 | 2086 | 2723 | 639 | 2 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1690 | 1112 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13158970 | 13158970 | PRJNA383995_P_NODE_11_length_2887_cov_7.657153_g3_i2 | PRJNA383995 | 11 | 2887 | 7.657153 | 221.06200711 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3 | i2 | 97.179 | 0.585382750259785 | 638 | 18 | 59 | 0 | 2086 | 2723 | 639 | 2 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1690 | 1079 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13159001 | 13159001 | PRJNA383995_P_NODE_18391_length_162_cov_0.902655_g18292_i0 | PRJNA383995 | 18391 | 162 | 0.902655 | 1.4623011 | Shewanella phage FishSpeaker | 2985553 | Viruses | Viruses | 244 | 2.07e-60 | NTclustered | gi|2316690595|gb|OP589283.1| | 2985553 | g18292 | i0 | 93.827 | 1 | 162 | 10 | 100 | 0 | 1 | 162 | 33343 | 33182 | Shewanella phage FishSpeaker, complete genome | blastn | 162 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shewanella phage FishSpeaker | |||||
| 13829266 | 13829266 | PRJNA383995_P_NODE_15231_length_167_cov_2.932203_g15132_i0 | PRJNA383995 | 15231 | 167 | 2.932203 | 4.89677901 | root | 1 | Root_unresolved | Root_unresolved | 309 | 7.53e-80 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g15132 | i0 | 100 | 100 | 167 | 0 | 100 | 0 | 1 | 167 | 18469 | 18303 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 16700 | 309 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15707990 | 15707990 | PRJNA383995_P_NODE_13_length_2638_cov_4.830823_g3_i3 | PRJNA383995 | 13 | 2638 | 4.830823 | 127.43711074 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 780 | 6.83e-254 | NR | AVM87439.1 | 3063761 | g3 | i3 | 45.4 | 1.07012888551933 | 941 | 400 | 99.8 | 10 | 2636 | 3 | 586 | 1475 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 2823 | 780 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 17653364 | 17653364 | PRJNA383995_P_NODE_11754_length_192_cov_1.055944_g11655_i0 | PRJNA383995 | 11754 | 192 | 1.055944 | 2.02741248 | Tequintavirus | 187218 | Viruses | Viruses | 339 | 1.13e-88 | NTclustered | gi|1779416030|emb|LR597659.1| | 2742946 | g11655 | i0 | 98.438 | 99.328125 | 192 | 3 | 100 | 0 | 1 | 192 | 70576 | 70767 | Escherichia phage T5_ev212 genome assembly, chromosome: 1 | blastn | 19071 | 339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Tequintavirus | Escherichia phage T5_ev212 | |||
| 23357348 | 23357348 | PRJNA383995_P_NODE_9919_length_207_cov_1.613924_g9820_i0 | PRJNA383995 | 9919 | 207 | 1.613924 | 3.34082268 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 335 | 1.6099999999999997e-87 | NTclustered | gi|2914885844|gb|OR222395.1| | 2832643 | g9820 | i0 | 97.449 | 1.80193236714976 | 196 | 5 | 95 | 0 | 1 | 196 | 26484 | 26289 | MAG: Caudoviricetes sp. isolate MSP1008 genomic sequence | blastn | 373 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;