contig_metadata
21 rows where bioproject = "PRJNA559720" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 543493 | 543493 | PRJNA559720_P_NODE_1_length_6062_cov_6.049257_g0_i0 | PRJNA559720 | 1 | 6062 | 6.049257 | 366.70595934 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 11040 | 0 | NTclustered | gi|872708292|emb|LN794199.1| | 28354 | g0 | i0 | 99.587 | 46.8073243154075 | 6053 | 25 | 99 | 0 | 10 | 6062 | 6065 | 13 | Plantago asiatica mosaic virus, complete genome, isolate Concador | blastn | 283746 | 11040 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 1819267 | 1819267 | PRJNA559720_P_NODE_6362_length_406_cov_1.279279_g6223_i0 | PRJNA559720 | 6362 | 406 | 1.279279 | 5.19387274 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 265 | 4.6e-66 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g6223 | i0 | 98.667 | 0.369458128078818 | 150 | 1 | 37 | 1 | 1 | 150 | 957 | 1105 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 150 | 265 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 1819275 | 1819275 | PRJNA559720_P_NODE_6882_length_389_cov_0.971519_g6743_i0 | PRJNA559720 | 6882 | 389 | 0.971519 | 3.77920891 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 536 | 8.419999999999997e-148 | NTclustered | gi|2245485800|gb|ON162018.1| | 1530251 | g6743 | i0 | 91.517 | 1.86889460154242 | 389 | 33 | 100 | 0 | 1 | 389 | 1058 | 670 | MAG: Picornaviridae sp. isolate 161-k141_128852 RNA dependent RNA polymerase gene, partial cds | blastn | 727 | 536 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 3094410 | 3094410 | PRJNA559720_P_NODE_103_length_1803_cov_2.732948_g87_i0 | PRJNA559720 | 103 | 1803 | 2.732948 | 49.27505244 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1044 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g87 | i0 | 96.1 | 0.793677204658902 | 641 | 23 | 79 | 2 | 3 | 642 | 5968 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1431 | 1044 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 5647467 | 5647467 | PRJNA559720_P_NODE_9125_length_327_cov_0.909449_g8986_i0 | PRJNA559720 | 9125 | 327 | 0.909449 | 2.97389823 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 518 | 2.5199999999999998e-142 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8986 | i0 | 96.203 | 0.9663608562691132 | 316 | 12 | 97 | 0 | 12 | 327 | 2548 | 2233 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 316 | 518 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 6921505 | 6921505 | PRJNA559720_P_NODE_1326_length_836_cov_1.437746_g1241_i0 | PRJNA559720 | 1326 | 836 | 1.437746 | 12.01955656 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 1284 | 0 | NTclustered | gi|2245485797|gb|ON162017.1| | 1530251 | g1241 | i0 | 94.378 | 1 | 836 | 47 | 100 | 0 | 1 | 836 | 1358 | 2193 | MAG: Picornaviridae sp. isolate 161-k141_121922 RNA dependent RNA polymerase and capsid protein genes, partial cds | blastn | 836 | 1284 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 9472229 | 9472229 | PRJNA559720_P_NODE_9988_length_308_cov_1.710638_g9849_i0 | PRJNA559720 | 9988 | 308 | 1.710638 | 5.26876504 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 259 | 1.5800000000000002e-64 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g9849 | i0 | 97.987 | 0.483766233766234 | 149 | 3 | 48 | 0 | 160 | 308 | 639 | 491 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 149 | 259 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15846281 | 15846281 | PRJNA559720_P_NODE_1133_length_887_cov_1.783784_g1053_i0 | PRJNA559720 | 1133 | 887 | 1.783784 | 15.82216408 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 352 | 1.52e-111 | NR | URG14823.1 | 1530251 | g1053 | i0 | 55.2 | 1.00450958286359 | 297 | 131 | 99.8 | 1 | 885 | 1 | 360 | 656 | URG14823.1 MAG: capsid protein [Picornaviridae sp.] | diamond | 891 | 352 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 18395400 | 18395400 | PRJNA559720_P_NODE_14355_length_248_cov_0.880000_g14216_i0 | PRJNA559720 | 14355 | 248 | 0.88 | 2.1824 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 368 | 1.96e-97 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g14216 | i0 | 98.104 | 0.850806451612903 | 211 | 4 | 85 | 0 | 1 | 211 | 1652 | 1442 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 211 | 368 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 18395507 | 18395507 | PRJNA559720_P_NODE_8375_length_345_cov_1.507353_g8236_i0 | PRJNA559720 | 8375 | 345 | 1.507353 | 5.20036785 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 394 | 4.71e-105 | NTclustered | gi|2245485797|gb|ON162017.1| | 1530251 | g8236 | i0 | 87.464 | 1.5768115942029 | 343 | 42 | 99 | 1 | 2 | 344 | 1107 | 766 | MAG: Picornaviridae sp. isolate 161-k141_121922 RNA dependent RNA polymerase and capsid protein genes, partial cds | blastn | 544 | 394 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 20945749 | 20945749 | PRJNA559720_P_NODE_3497_length_554_cov_1.372141_g3369_i0 | PRJNA559720 | 3497 | 554 | 1.372141 | 7.60166114 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 625 | 2.5599999999999995e-174 | NTclustered | gi|2245485800|gb|ON162018.1| | 1530251 | g3369 | i0 | 89.537 | 0.897111913357401 | 497 | 46 | 89 | 5 | 1 | 494 | 496 | 3 | MAG: Picornaviridae sp. isolate 161-k141_128852 RNA dependent RNA polymerase gene, partial cds | blastn | 497 | 625 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 23495994 | 23495994 | PRJNA559720_P_NODE_779_length_1010_cov_5.160085_g719_i0 | PRJNA559720 | 779 | 1010 | 5.160085 | 52.1168585 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1666 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g719 | i0 | 96.429 | 0.998019801980198 | 1008 | 36 | 99 | 0 | 1 | 1008 | 5981 | 6988 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1008 | 1666 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 27584436 | 27584436 | PRJNA559720_P_NODE_1684_length_768_cov_2.746763_g1579_i0 | PRJNA559720 | 1684 | 768 | 2.746763 | 21.09513984 | Liverwort associated bunyavirus 4 | 2933082 | Viruses | Viruses | 50.8 | 0.00406 | NR | CAI5383880.1 | 2933082 | g1579 | i0 | 30.4 | 0.48828125 | 125 | 78 | 47.7 | 2 | 369 | 4 | 179 | 297 | CAI5383880.1 RNA-dependent RNA polymerase, partial [Liverwort associated bunyavirus 4] | diamond | 375 | 50.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Liverwort associated bunyavirus 4 | ||||
| 28815561 | 28815561 | PRJNA559720_P_NODE_10908_length_291_cov_0.967890_g10769_i0 | PRJNA559720 | 10908 | 291 | 0.96789 | 2.8165599 | Burswood narna-like virus | 3118308 | Viruses | Viruses | 75.5 | 2.05e-13 | NR | WVL03117.1 | 3118308 | g10769 | i0 | 44.8 | 0.989690721649485 | 96 | 42 | 99 | 1 | 2 | 289 | 606 | 690 | WVL03117.1 RdRp [Burswood narna-like virus] | diamond | 288 | 75.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Burswood narna-like virus | |||
| 28815565 | 28815565 | PRJNA559720_P_NODE_13908_length_250_cov_0.870056_g13769_i0 | PRJNA559720 | 13908 | 250 | 0.870056 | 2.17514 | Aulacomnium heterostichum bunyavirus 1 | 2933070 | Viruses | Viruses | 57.4 | 2.94e-7 | NR | CAI5383856.1 | 2933070 | g13769 | i0 | 43.1 | 1.788 | 72 | 38 | 84 | 2 | 247 | 38 | 1560 | 1630 | CAI5383856.1 RNA-dependent RNA polymerase [Aulacomnium heterostichum bunyavirus 1] | diamond | 447 | 57.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Aulacomnium heterostichum bunyavirus 1 | ||||
| 29163417 | 29163417 | PRJNA559720_P_NODE_13269_length_254_cov_1.276243_g13130_i0 | PRJNA559720 | 13269 | 254 | 1.276243 | 3.24165722 | Phytophthora cinnamomi ormycovirus 7-5 | 3239326 | Viruses | Viruses | 45.1 | 0.00636 | NR | XDO01624.1 | 3239326 | g13130 | i0 | 34.5 | 0.992125984251969 | 84 | 55 | 99.2 | 0 | 253 | 2 | 320 | 403 | XDO01624.1 hypothetical protein [Phytophthora cinnamomi ormycovirus 7-5] | diamond | 252 | 45.1 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Alphaormycoviridae | Phormycovirus | Phormycovirus phytophthorae | |||
| 30363736 | 30363736 | PRJNA559720_P_NODE_4132_length_511_cov_1.582192_g3998_i0 | PRJNA559720 | 4132 | 511 | 1.582192 | 8.08500112 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 188 | 1.2e-51 | NR | AVM87439.1 | 3063761 | g3998 | i0 | 51.4 | 1.01565557729941 | 173 | 77 | 97.5 | 1 | 498 | 1 | 933 | 1105 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 519 | 188 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 30363743 | 30363743 | PRJNA559720_P_NODE_8832_length_334_cov_0.885057_g8693_i0 | PRJNA559720 | 8832 | 334 | 0.885057 | 2.95609038 | Neofusicoccum parvum narnavirus 1 | 2587532 | Viruses | Viruses | 59.7 | 1.19e-7 | NR | WAK75278.1 | 2587532 | g8693 | i0 | 36 | 1.79640718562874 | 100 | 61 | 89.8 | 1 | 29 | 328 | 2 | 98 | WAK75278.1 MAG: RNA-dependent RNA polymerase, partial [Neofusicoccum parvum narnavirus 1] | diamond | 600 | 59.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Neofusicoccum parvum narnavirus 1 | ||
| 30647415 | 30647415 | PRJNA559720_P_NODE_2893_length_605_cov_1.563910_g2771_i0 | PRJNA559720 | 2893 | 605 | 1.56391 | 9.4616555000000009 | Ustilaginoidea virens narna-like virus 3 | 2972018 | Viruses | Viruses | 69.3 | 7.97e-10 | NR | UVX28911.1 | 2972018 | g2771 | i0 | 32.3 | 0.813223140495868 | 164 | 92 | 74.4 | 6 | 2 | 451 | 839 | 997 | UVX28911.1 MAG: RNA dependent RNA polymerase [Ustilaginoidea virens narna-like virus 3] | diamond | 492 | 69.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Ustilaginoidea virens narna-like virus 3 | |||
| 30837234 | 30837234 | PRJNA559720_P_NODE_16014_length_242_cov_0.911243_g15875_i0 | PRJNA559720 | 16014 | 242 | 0.911243 | 2.20520806 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 102 | 2.7499999999999995e-23 | NR | YP_010796394.1 | RQ13 | g15875 | i0 | 57 | 1.94628099173554 | 79 | 34 | 97.9 | 0 | 238 | 2 | 2244 | 2322 | YP_010796394.1 polyprotein [Wenling triplecross lizardfish picornavirus] | diamond | 471 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Symapivirus | Zebrafish jaw picornavirus | ||
| 32671017 | 32671017 | PRJNA559720_P_NODE_4300_length_502_cov_2.771562_g4163_i0 | PRJNA559720 | 4300 | 502 | 2.771562 | 13.91324124 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 205 | 3.999999999999999e-58 | NR | URG14823.1 | 1530251 | g4163 | i0 | 70.5 | 0.872509960159363 | 146 | 43 | 87.3 | 0 | 1 | 438 | 729 | 874 | URG14823.1 MAG: capsid protein [Picornaviridae sp.] | diamond | 438 | 205 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae 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);;