contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177086 | 177086 | PRJNA1059246_P_NODE_39161_length_341_cov_1.500000_g38535_i0 | PRJNA1059246 | 39161 | 341 | 1.5 | 5.115 | Ripigleb virus | 3130924 | Viruses | Viruses | 383 | 1.01e-101 | NTclustered | gi|2717321151|gb|PP173226.1| | 3130924 | g38535 | i0 | 87.842 | 214.24926686217 | 329 | 37 | 96 | 2 | 1 | 328 | 8521 | 8195 | MAG: Ripigleb virus isolate KCAP3_k141_261307 genomic sequence | blastn | 73059 | 383 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Ripigleb virus | |||
| 1451492 | 1451492 | PRJNA1059246_P_NODE_23982_length_458_cov_1.600000_g23358_i0 | PRJNA1059246 | 23982 | 458 | 1.6 | 7.328 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 846 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g23358 | i0 | 100 | 5.95414847161572 | 458 | 0 | 100 | 0 | 1 | 458 | 5005 | 4548 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 2727 | 846 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 1451986 | 1451986 | PRJNA1059246_P_NODE_6082_length_1003_cov_2.043011_g5635_i0 | PRJNA1059246 | 6082 | 1003 | 2.043011 | 20.49140033 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1847 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g5635 | i0 | 99.9 | 54.8683948155533 | 1003 | 1 | 100 | 0 | 1 | 1003 | 7281 | 6279 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 55033 | 1847 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 4003503 | 4003503 | PRJNA1059246_P_NODE_38924_length_342_cov_2.252788_g38298_i0 | PRJNA1059246 | 38924 | 342 | 2.252788 | 7.70453496 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 632 | 9.079999999999999e-177 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g38298 | i0 | 100 | 40 | 342 | 0 | 100 | 0 | 1 | 342 | 5644 | 5985 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 13680 | 632 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 4003543 | 4003543 | PRJNA1059246_P_NODE_42604_length_323_cov_1.900000_g41978_i0 | PRJNA1059246 | 42604 | 323 | 1.9 | 6.137 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 592 | 1.4499999999999999e-164 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g41978 | i0 | 99.69 | 5.95665634674923 | 323 | 1 | 100 | 0 | 1 | 323 | 3097 | 3419 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 1924 | 592 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 4003651 | 4003651 | PRJNA1059246_P_NODE_4_length_8291_cov_108.076661_g3_i0 | PRJNA1059246 | 4 | 8291 | 108.076661 | 8960.63596351 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13477 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g3 | i0 | 96.021 | 3.05391388252322 | 8293 | 321 | 99 | 7 | 1 | 8289 | 8295 | 8 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25320 | 13477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5279841 | 5279841 | PRJNA1059246_P_NODE_40125_length_336_cov_1.171103_g39499_i0 | PRJNA1059246 | 40125 | 336 | 1.171103 | 3.93490608 | Ripothoz virus | 3131336 | Viruses | Viruses | 316 | 1.02e-81 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g39499 | i0 | 84.83 | 45.2142857142857 | 323 | 39 | 95 | 8 | 17 | 336 | 5301 | 5616 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 15192 | 316 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 6555172 | 6555172 | PRJNA1059246_P_NODE_52626_length_281_cov_1.480769_g52000_i0 | PRJNA1059246 | 52626 | 281 | 1.480769 | 4.16096089 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g52000 | i0 | 100 | 4 | 281 | 0 | 100 | 0 | 1 | 281 | 1340 | 1620 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 1124 | 520 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 10380239 | 10380239 | PRJNA1059246_P_NODE_27989_length_417_cov_1.790698_g27364_i0 | PRJNA1059246 | 27989 | 417 | 1.790698 | 7.46721066 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 771 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g27364 | i0 | 100 | 43.0023980815348 | 417 | 0 | 100 | 0 | 1 | 417 | 2408 | 1992 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 17932 | 771 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 11655243 | 11655243 | PRJNA1059246_P_NODE_12310_length_678_cov_1.365289_g11731_i0 | PRJNA1059246 | 12310 | 678 | 1.365289 | 9.25665942 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1253 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g11731 | i0 | 100 | 65.1799410029498 | 678 | 0 | 100 | 0 | 1 | 678 | 4338 | 3661 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 44192 | 1253 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 14205450 | 14205450 | PRJNA1059246_P_NODE_16372_length_574_cov_1.834331_g15762_i0 | PRJNA1059246 | 16372 | 574 | 1.834331 | 10.52905994 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 1061 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g15762 | i0 | 100 | 42.5087108013937 | 574 | 0 | 100 | 0 | 1 | 574 | 5111 | 5684 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 24400 | 1061 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 14205813 | 14205813 | PRJNA1059246_P_NODE_45592_length_309_cov_1.711864_g44966_i0 | PRJNA1059246 | 45592 | 309 | 1.711864 | 5.28965976 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 560 | 3.88e-155 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g44966 | i0 | 99.353 | 93.326860841424 | 309 | 2 | 100 | 0 | 1 | 309 | 961 | 653 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 28838 | 560 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti | ||
| 19302552 | 19302552 | PRJNA1059246_P_NODE_20176_length_506_cov_3.173210_g19558_i0 | PRJNA1059246 | 20176 | 506 | 3.17321 | 16.0564426 | Cardiovirus rueckerti | 3427730 | Viruses | Viruses | 935 | 0 | NTclustered | gi|1943777380|gb|MT250508.1| | 12104 | g19558 | i0 | 100 | 79.7529644268775 | 506 | 0 | 100 | 0 | 1 | 506 | 7277 | 7782 | Encephalomyocarditis virus isolate FRA/SIG/1/2013, complete genome | blastn | 40355 | 935 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Cardiovirus | Cardiovirus rueckerti |
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);;