contig_metadata
14 rows where bioproject = "PRJNA559720" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 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);;