contig_metadata
15 rows where bioproject = "PRJNA1204310", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2880029 | 2880029 | PRJNA1204310_P_NODE_33123_length_324_cov_1.864542_g32826_i0 | PRJNA1204310 | 33123 | 324 | 1.864542 | 6.04111608 | Iflavirus sp. | 1916690 | Viruses | Viruses | 571 | 1.8899999999999993e-158 | NTclustered | gi|2895513727|tpg|BK068484.1| | 1916690 | g32826 | i0 | 98.457 | 35.4351851851852 | 324 | 5 | 100 | 0 | 1 | 324 | 9283 | 8960 | TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds | blastn | 11481 | 571 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 7982934 | 7982934 | PRJNA1204310_P_NODE_48087_length_263_cov_1.642105_g47790_i0 | PRJNA1204310 | 48087 | 263 | 1.642105 | 4.31873615 | Iflavirus sp. | 1916690 | Viruses | Viruses | 442 | 1.2199999999999994e-119 | NTclustered | gi|2895513727|tpg|BK068484.1| | 1916690 | g47790 | i0 | 96.958 | 7.97338403041825 | 263 | 8 | 100 | 0 | 1 | 263 | 5488 | 5750 | TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds | blastn | 2097 | 442 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 10533351 | 10533351 | PRJNA1204310_P_NODE_49769_length_256_cov_1.704918_g49472_i0 | PRJNA1204310 | 49769 | 256 | 1.704918 | 4.36459008 | Iflavirus sp. | 1916690 | Viruses | Viruses | 435 | 1.98e-117 | NTclustered | gi|2895513723|tpg|BK068482.1| | 1916690 | g49472 | i0 | 97.266 | 6.99609375 | 256 | 7 | 100 | 0 | 1 | 256 | 1547 | 1292 | TPA_asm: Iflavirus sp. isolate WUR11 polyprotein gene, complete cds | blastn | 1791 | 435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 13082447 | 13082447 | PRJNA1204310_P_NODE_21031_length_396_cov_0.866873_g20734_i0 | PRJNA1204310 | 21031 | 396 | 0.866873 | 3.43281708 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 643 | 4.919999999999999e-180 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g20734 | i0 | 95.96 | 3 | 396 | 16 | 100 | 0 | 1 | 396 | 7046 | 7441 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1188 | 643 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14357647 | 14357647 | PRJNA1204310_P_NODE_13412_length_483_cov_1.056098_g13115_i0 | PRJNA1204310 | 13412 | 483 | 1.056098 | 5.10095334 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g13115 | i0 | 96.273 | 3 | 483 | 18 | 100 | 0 | 1 | 483 | 4430 | 3948 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1449 | 793 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14358304 | 14358304 | PRJNA1204310_P_NODE_39732_length_294_cov_1.085973_g39435_i0 | PRJNA1204310 | 39732 | 294 | 1.085973 | 3.19276062 | Iflavirus sp. | 1916690 | Viruses | Viruses | 516 | 8.05e-142 | NTclustered | gi|2895513721|tpg|BK068481.1| | 1916690 | g39435 | i0 | 98.299 | 9.3265306122449 | 294 | 5 | 100 | 0 | 1 | 294 | 3172 | 2879 | TPA_asm: Iflavirus sp. isolate WUR10 polyprotein gene, complete cds | blastn | 2742 | 516 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 15632292 | 15632292 | PRJNA1204310_P_NODE_47453_length_266_cov_1.212435_g47156_i0 | PRJNA1204310 | 47453 | 266 | 1.212435 | 3.2250771 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 481 | 2.62e-131 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g47156 | i0 | 99.248 | 3.00375939849624 | 266 | 2 | 100 | 0 | 1 | 266 | 641 | 376 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 799 | 481 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 16347455 | 16347455 | PRJNA1204310_P_NODE_21553_length_391_cov_2.207547_g21256_i0 | PRJNA1204310 | 21553 | 391 | 2.207547 | 8.63150877 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 157 | 2.37e-44 | NR | QDH91349.1 | 1955170 | g21256 | i0 | 63.6 | 0.989769820971867 | 129 | 44 | 96.7 | 1 | 391 | 14 | 155 | 283 | QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.] | diamond | 387 | 157 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 18180976 | 18180976 | PRJNA1204310_P_NODE_44455_length_277_cov_1.549020_g44158_i0 | PRJNA1204310 | 44455 | 277 | 1.54902 | 4.2907854 | Iflavirus sp. | 1916690 | Viruses | Viruses | 466 | 7.68e-127 | NTclustered | gi|2895513725|tpg|BK068483.1| | 1916690 | g44158 | i0 | 97.101 | 8.94945848375451 | 276 | 8 | 99 | 0 | 1 | 276 | 8143 | 7868 | TPA_asm: Iflavirus sp. isolate WUR12 polyprotein gene, complete cds | blastn | 2479 | 466 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 19455875 | 19455875 | PRJNA1204310_P_NODE_6696_length_665_cov_1.471284_g6416_i0 | PRJNA1204310 | 6696 | 665 | 1.471284 | 9.7840386 | Iflavirus sp. | 1916690 | Viruses | Viruses | 1157 | 0 | NTclustered | gi|2895513727|tpg|BK068484.1| | 1916690 | g6416 | i0 | 98.045 | 7.97894736842105 | 665 | 13 | 100 | 0 | 1 | 665 | 5739 | 6403 | TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds | blastn | 5306 | 1157 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 23281496 | 23281496 | PRJNA1204310_P_NODE_43039_length_283_cov_0.952381_g42742_i0 | PRJNA1204310 | 43039 | 283 | 0.952381 | 2.69523823 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 451 | 2.1999999999999995e-122 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g42742 | i0 | 95.406 | 3 | 283 | 13 | 100 | 0 | 1 | 283 | 5061 | 5343 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 849 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24554786 | 24554786 | PRJNA1204310_P_NODE_14120_length_472_cov_0.892231_g13823_i0 | PRJNA1204310 | 14120 | 472 | 0.892231 | 4.21133032 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 806 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g13823 | i0 | 97.458 | 3 | 472 | 12 | 100 | 0 | 1 | 472 | 6524 | 6053 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1416 | 806 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 28967553 | 28967553 | PRJNA1204310_P_NODE_5748_length_713_cov_13.000000_g5479_i0 | PRJNA1204310 | 5748 | 713 | 13 | 92.69 | Durnavirales sp. | 2809355 | Viruses | Viruses | 112 | 8.899999999999999e-25 | NR | WRQ64726.1 | 2809355 | g5479 | i0 | 33 | 0.85413744740533 | 203 | 132 | 84.2 | 4 | 107 | 706 | 11 | 212 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 609 | 112 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 29724895 | 29724895 | PRJNA1204310_P_NODE_830_length_1501_cov_16.655462_g731_i0 | PRJNA1204310 | 830 | 1501 | 16.655462 | 249.99848462 | Durnavirales sp. | 2809355 | Viruses | Viruses | 295 | 1.32e-90 | NR | WRQ64726.1 | 2809355 | g731 | i0 | 35.7 | 0.939373750832778 | 470 | 296 | 92.9 | 6 | 107 | 1501 | 11 | 479 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 1410 | 295 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 30041027 | 30041027 | PRJNA1204310_P_NODE_831_length_1501_cov_9.115546_g731_i1 | PRJNA1204310 | 831 | 1501 | 9.115546 | 136.82434546 | Durnavirales sp. | 2809355 | Viruses | Viruses | 294 | 3.69e-90 | NR | WRQ64726.1 | 2809355 | g731 | i1 | 35.7 | 0.939373750832778 | 470 | 296 | 92.9 | 6 | 107 | 1501 | 11 | 479 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 1410 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales 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);;