contig_metadata
23 rows where bioproject = "PRJNA741997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1198080 | 1198080 | PRJNA741997_P_NODE_19981_length_514_cov_2.185941_g18866_i0 | PRJNA741997 | 19981 | 514 | 2.185941 | 11.23573674 | Orthorubulavirus | 2560195 | Viruses | Viruses | 944 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g18866 | i0 | 99.806 | 80.7178988326848 | 515 | 0 | 100 | 1 | 1 | 514 | 439 | 953 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 41489 | 944 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 1997545 | 1997545 | PRJNA741997_P_NODE_51462_length_300_cov_1.352423_g50342_i0 | PRJNA741997 | 51462 | 300 | 1.352423 | 4.057269 | Virgaviridae sp. | 2795451 | Viruses | Viruses | 477 | 3.8899999999999985e-130 | NTclustered | gi|2798495991|gb|PP945375.1| | 2795451 | g50342 | i0 | 95.333 | 8.98333333333333 | 300 | 14 | 100 | 0 | 1 | 300 | 1354 | 1653 | Sclerotinia sclerotiorum virga-like virus 1 strain China-NX078 segment RNA1, complete sequence | blastn | 2695 | 477 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Virgaviridae sp. | |||
| 1997734 | 1997734 | PRJNA741997_P_NODE_81982_length_245_cov_1.377907_g80862_i0 | PRJNA741997 | 81982 | 245 | 1.377907 | 3.37587215 | Mitovirus sp. | 2587224 | Viruses | Viruses | 106 | 1.67e-18 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g80862 | i0 | 90.123 | 0.330612244897959 | 81 | 8 | 33 | 0 | 138 | 218 | 112 | 32 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 81 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 4549889 | 4549889 | PRJNA741997_P_NODE_26524_length_430_cov_1.294118_g25404_i0 | PRJNA741997 | 26524 | 430 | 1.294118 | 5.5647074 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 695 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g25404 | i0 | 95.814 | 3.00697674418605 | 430 | 18 | 100 | 0 | 1 | 430 | 3538 | 3109 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1293 | 695 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 7100380 | 7100380 | PRJNA741997_P_NODE_77626_length_248_cov_0.880000_g76506_i0 | PRJNA741997 | 77626 | 248 | 0.88 | 2.1824 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 431 | 2.47e-116 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g76506 | i0 | 97.984 | 3 | 248 | 5 | 100 | 0 | 1 | 248 | 4728 | 4481 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 744 | 431 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9649837 | 9649837 | PRJNA741997_P_NODE_25768_length_438_cov_1.175342_g24648_i0 | PRJNA741997 | 25768 | 438 | 1.175342 | 5.14799796 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 737 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g24648 | i0 | 97.032 | 2.99086757990868 | 438 | 13 | 100 | 0 | 1 | 438 | 7005 | 6568 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1310 | 737 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9649868 | 9649868 | PRJNA741997_P_NODE_31968_length_386_cov_0.993610_g30848_i0 | PRJNA741997 | 31968 | 386 | 0.99361 | 3.8353346 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 686 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g30848 | i0 | 98.705 | 2.98963730569948 | 386 | 5 | 100 | 0 | 1 | 386 | 6095 | 6480 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1154 | 686 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 10126790 | 10126790 | PRJNA741997_P_NODE_29808_length_401_cov_1.850610_g28688_i0 | PRJNA741997 | 29808 | 401 | 1.85061 | 7.4209461 | Orthorubulavirus | 2560195 | Viruses | Viruses | 736 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g28688 | i0 | 99.751 | 69.002493765586 | 401 | 1 | 100 | 0 | 1 | 401 | 4030 | 3630 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 27670 | 736 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16024094 | 16024094 | PRJNA741997_P_NODE_49993_length_305_cov_2.051724_g48873_i0 | PRJNA741997 | 49993 | 305 | 2.051724 | 6.2577582 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 514 | 3.02e-141 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g48873 | i0 | 97.049 | 3 | 305 | 9 | 100 | 0 | 1 | 305 | 7294 | 6990 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 915 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 19848328 | 19848328 | PRJNA741997_P_NODE_18576_length_538_cov_1.901075_g17462_i0 | PRJNA741997 | 18576 | 538 | 1.901075 | 10.2277835 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 798 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g17462 | i0 | 93.633 | 2.95910780669145 | 534 | 34 | 99 | 0 | 1 | 534 | 2560 | 3093 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1592 | 798 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21123977 | 21123977 | PRJNA741997_P_NODE_34337_length_371_cov_1.144295_g33217_i0 | PRJNA741997 | 34337 | 371 | 1.144295 | 4.24533445 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 636 | 7.659999999999999e-178 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g33217 | i0 | 97.574 | 3 | 371 | 9 | 100 | 0 | 1 | 371 | 5685 | 6055 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1113 | 636 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22399164 | 22399164 | PRJNA741997_P_NODE_80778_length_246_cov_0.890173_g79658_i0 | PRJNA741997 | 80778 | 246 | 0.890173 | 2.18982558 | Virgaviridae sp. | 2795451 | Viruses | Viruses | 399 | 6.889999999999999e-107 | NTclustered | gi|2798495991|gb|PP945375.1| | 2795451 | g79658 | i0 | 95.935 | 21.9878048780488 | 246 | 10 | 100 | 0 | 1 | 246 | 1104 | 859 | Sclerotinia sclerotiorum virga-like virus 1 strain China-NX078 segment RNA1, complete sequence | blastn | 5409 | 399 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Virgaviridae sp. | |||
| 22399182 | 22399182 | PRJNA741997_P_NODE_83118_length_245_cov_0.895349_g81998_i0 | PRJNA741997 | 83118 | 245 | 0.895349 | 2.19360505 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 425 | 1.1299999999999999e-114 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g81998 | i0 | 97.959 | 3 | 245 | 5 | 100 | 0 | 1 | 245 | 7733 | 7489 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 735 | 425 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23674714 | 23674714 | PRJNA741997_P_NODE_83679_length_244_cov_1.456140_g82559_i0 | PRJNA741997 | 83679 | 244 | 1.45614 | 3.5529816 | Ripothoz virus | 3131336 | Viruses | Viruses | 182 | 2.689999999999999e-41 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g82559 | i0 | 81.579 | 0.934426229508197 | 228 | 34 | 91 | 7 | 3 | 224 | 5046 | 5271 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 228 | 182 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 27621376 | 27621376 | PRJNA741997_P_NODE_71524_length_251_cov_1.185393_g70404_i0 | PRJNA741997 | 71524 | 251 | 1.185393 | 2.97533643 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 68.2 | 4.7e-11 | NR | UNY41988.1 | 3003959 | g70404 | i0 | 56.5 | 0.741035856573705 | 62 | 21 | 74.1 | 2 | 245 | 60 | 736 | 791 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 186 | 68.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27684722 | 27684722 | PRJNA741997_P_NODE_58264_length_282_cov_1.081340_g57144_i0 | PRJNA741997 | 58264 | 282 | 1.08134 | 3.0493788 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 86.3 | 3.06e-17 | NR | UNY41988.1 | 3003959 | g57144 | i0 | 42.6 | 1 | 94 | 53 | 98.9 | 1 | 281 | 3 | 2665 | 2758 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 282 | 86.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27842084 | 27842084 | PRJNA741997_P_NODE_59104_length_280_cov_1.178744_g57984_i0 | PRJNA741997 | 59104 | 280 | 1.178744 | 3.3004832 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 141 | 1.48e-36 | NR | XCM68142.1 | 3003959 | g57984 | i0 | 63.4 | 0.996428571428571 | 93 | 34 | 99.6 | 0 | 2 | 280 | 208 | 300 | XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 279 | 141 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28252627 | 28252627 | PRJNA741997_P_NODE_54006_length_291_cov_2.844037_g52886_i0 | PRJNA741997 | 54006 | 291 | 2.844037 | 8.27614767 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 104 | 1.54e-23 | NR | UNY41988.1 | 3003959 | g52886 | i0 | 54.3 | 0.969072164948454 | 94 | 43 | 96.9 | 0 | 9 | 290 | 2261 | 2354 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 282 | 104 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29673234 | 29673234 | PRJNA741997_P_NODE_62850_length_271_cov_1.575758_g61730_i0 | PRJNA741997 | 62850 | 271 | 1.575758 | 4.27030418 | Oidiodendron maius splipalmivirus 1 | 2769353 | Viruses | Viruses | 48.5 | 4.84e-4 | NR | UJT31791.1 | 2769353 | g61730 | i0 | 36.4 | 0.974169741697417 | 88 | 55 | 96.3 | 1 | 2 | 262 | 158 | 245 | UJT31791.1 hypothetical protein [Oidiodendron maius splipalmivirus 1] | diamond | 264 | 48.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Delepalmivirus | Delepalmivirus oidiodendri | ||
| 30715929 | 30715929 | PRJNA741997_P_NODE_32174_length_384_cov_1.839228_g31054_i0 | PRJNA741997 | 32174 | 384 | 1.839228 | 7.06263552 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 167 | 4.12e-45 | NR | UNY41988.1 | 3003959 | g31054 | i0 | 59.1 | 0.9921875 | 127 | 52 | 99.2 | 0 | 3 | 383 | 2432 | 2558 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 381 | 167 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30905737 | 30905737 | PRJNA741997_P_NODE_33894_length_373_cov_2.830000_g32774_i0 | PRJNA741997 | 33894 | 373 | 2.83 | 10.5559 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 147 | 2.72e-38 | NR | UNY41988.1 | 3003959 | g32774 | i0 | 52.8 | 0.989276139410188 | 123 | 58 | 98.9 | 0 | 2 | 370 | 1234 | 1356 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 369 | 147 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30937337 | 30937337 | PRJNA741997_P_NODE_30794_length_394_cov_1.439252_g29674_i0 | PRJNA741997 | 30794 | 394 | 1.439252 | 5.67065288 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 94.7 | 1.37e-19 | NR | UNY41988.1 | 3003959 | g29674 | i0 | 46.8 | 1.92639593908629 | 126 | 63 | 94.4 | 4 | 386 | 15 | 2815 | 2938 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 759 | 94.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31189570 | 31189570 | PRJNA741997_P_NODE_10895_length_765_cov_1.653179_g9884_i0 | PRJNA741997 | 10895 | 765 | 1.653179 | 12.64681935 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 337 | 1.63e-102 | NR | XCM68142.1 | 3003959 | g9884 | i0 | 66.5 | 0.972549019607843 | 248 | 82 | 96.9 | 1 | 763 | 23 | 1339 | 1586 | XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 744 | 337 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 |
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);;