contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 317930 | 317930 | PRJNA1180292_P_NODE_321_length_1200_cov_3.303461_g241_i0 | PRJNA1180292 | 321 | 1200 | 3.303461 | 39.641532 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1901 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g241 | i0 | 95.25 | 2.99916666666667 | 1200 | 57 | 100 | 0 | 1 | 1200 | 1985 | 3184 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 3599 | 1901 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 1592515 | 1592515 | PRJNA1180292_P_NODE_13222_length_235_cov_2.765432_g13090_i0 | PRJNA1180292 | 13222 | 235 | 2.765432 | 6.4987652 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 379 | 8.509999999999998e-101 | NTclustered | gi|2914920971|gb|OR221384.1| | 2832643 | g13090 | i0 | 95.745 | 1 | 235 | 10 | 100 | 0 | 1 | 235 | 6717 | 6951 | MAG: Caudoviricetes sp. isolate MSP1712 genomic sequence | blastn | 235 | 379 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2868642 | 2868642 | PRJNA1180292_P_NODE_11263_length_246_cov_0.901734_g11131_i0 | PRJNA1180292 | 11263 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2060016856|tpg|BK026970.1| | 2832643 | g11131 | i0 | 100 | 4.95121951219512 | 246 | 0 | 100 | 0 | 1 | 246 | 11088 | 11333 | MAG TPA_asm: Caudoviricetes sp. isolate ctskw4, partial genome | blastn | 1218 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2868701 | 2868701 | PRJNA1180292_P_NODE_5503_length_297_cov_2.732143_g5371_i0 | PRJNA1180292 | 5503 | 297 | 2.732143 | 8.11446471 | Rhizoctonia solani partitivirus 8 | 2600094 | Viruses | Viruses | 549 | 8.029999999999997e-152 | NTclustered | gi|1772832407|gb|MK809403.1| | 2600094 | g5371 | i0 | 100 | 1 | 297 | 0 | 100 | 0 | 1 | 297 | 2112 | 1816 | Rhizoctonia solani partitivirus 8 isolate YNBB-111-3 segment 2 hypothetical protein gene, complete cds | blastn | 297 | 549 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rhizoctonia solani partitivirus 8 | |||
| 4144772 | 4144772 | PRJNA1180292_P_NODE_3064_length_390_cov_3.646688_g2932_i0 | PRJNA1180292 | 3064 | 390 | 3.646688 | 14.2220832 | Ripothoz virus | 3131336 | Viruses | Viruses | 348 | 4.250000000000001e-91 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g2932 | i0 | 85.799 | 44.2897435897436 | 338 | 36 | 85 | 10 | 44 | 376 | 5301 | 5631 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 17273 | 348 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 4144802 | 4144802 | PRJNA1180292_P_NODE_5424_length_300_cov_1.022026_g5292_i0 | PRJNA1180292 | 5424 | 300 | 1.022026 | 3.066078 | Betapartitivirus rhiso | 3427259 | Viruses | Viruses | 551 | 2.259999999999999e-152 | NTclustered | gi|2323643540|gb|OK392631.1| | 46618 | g5292 | i0 | 99.667 | 2.94666666666667 | 300 | 1 | 100 | 0 | 1 | 300 | 2218 | 1919 | Rhizoctonia solani virus 717 isolate BS-5 putative coat protein gene, complete cds | blastn | 884 | 551 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Betapartitivirus | Betapartitivirus rhiso | ||
| 4869355 | 4869355 | PRJNA1180292_P_NODE_6304_length_280_cov_1.130435_g6172_i0 | PRJNA1180292 | 6304 | 280 | 1.130435 | 3.165218 | Orthorubulavirus | 2560195 | Viruses | Viruses | 518 | 2.12e-142 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g6172 | i0 | 100 | 69.95 | 280 | 0 | 100 | 0 | 1 | 280 | 1120 | 1399 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 19586 | 518 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 5420930 | 5420930 | PRJNA1180292_P_NODE_1205_length_631_cov_3.437276_g1074_i0 | PRJNA1180292 | 1205 | 631 | 3.437276 | 21.68921156 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 887 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1074 | i0 | 92.038 | 0.995245641838352 | 628 | 50 | 99 | 0 | 1 | 628 | 6919 | 6292 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 628 | 887 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 5420944 | 5420944 | PRJNA1180292_P_NODE_165_length_1590_cov_2.338167_g108_i0 | PRJNA1180292 | 165 | 1590 | 2.338167 | 37.1768553 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 2527 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g108 | i0 | 95.346 | 2.99748427672956 | 1590 | 74 | 100 | 0 | 1 | 1590 | 1939 | 350 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 4766 | 2527 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5420948 | 5420948 | PRJNA1180292_P_NODE_2085_length_471_cov_1.381910_g1953_i0 | PRJNA1180292 | 2085 | 471 | 1.38191 | 6.5087961 | Rhizoctonia solani partitivirus 8 | 2600094 | Viruses | Viruses | 870 | 0 | NTclustered | gi|1772832407|gb|MK809403.1| | 2600094 | g1953 | i0 | 100 | 1 | 471 | 0 | 100 | 0 | 1 | 471 | 19 | 489 | Rhizoctonia solani partitivirus 8 isolate YNBB-111-3 segment 2 hypothetical protein gene, complete cds | blastn | 471 | 870 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rhizoctonia solani partitivirus 8 | |||
| 6695817 | 6695817 | PRJNA1180292_P_NODE_9506_length_250_cov_0.881356_g9374_i0 | PRJNA1180292 | 9506 | 250 | 0.881356 | 2.20339 | uncultured virus | 340016 | Viruses | Viruses | 158 | 4.66e-34 | NTclustered | gi|1219813942|gb|KU970990.1| | 340016 | g9374 | i0 | 82.162 | 0.74 | 185 | 31 | 74 | 2 | 22 | 205 | 244 | 427 | Uncultured virus SERC_Contig_517506 co-chaperonin GroES (groES) gene, complete cds | blastn | 185 | 158 | 1 | Viruses | uncultured virus | ||||||||
| 7971072 | 7971072 | PRJNA1180292_P_NODE_11087_length_246_cov_0.901734_g10955_i0 | PRJNA1180292 | 11087 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 86.1 | 2.19e-12 | NTclustered | gi|2057958731|tpg|BK046342.1| | 2832643 | g10955 | i0 | 88 | 1.22357723577236 | 75 | 5 | 29 | 3 | 61 | 132 | 10991 | 11064 | MAG TPA_asm: Caudoviricetes sp. isolate ct8LU24, partial genome | blastn | 301 | 86.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11796507 | 11796507 | PRJNA1180292_P_NODE_5290_length_303_cov_1.278261_g5158_i0 | PRJNA1180292 | 5290 | 303 | 1.278261 | 3.87313083 | Rhizoctonia solani partitivirus 6 | 2600109 | Viruses | Viruses | 547 | 2.9499999999999986e-151 | NTclustered | gi|1772832397|gb|MK809398.1| | 2600109 | g5158 | i0 | 99.338 | 0.996699669966997 | 302 | 2 | 99 | 0 | 1 | 302 | 1616 | 1917 | Rhizoctonia solani partitivirus 6 isolate YNBB-111-1 segment 2 hypothetical protein gene, complete cds | blastn | 302 | 547 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rhizoctonia solani partitivirus 6 | |||
| 13071517 | 13071517 | PRJNA1180292_P_NODE_71_length_2248_cov_3.532874_g35_i0 | PRJNA1180292 | 71 | 2248 | 3.532874 | 79.41900752 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 3786 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g35 | i0 | 97.064 | 3.00133451957295 | 2248 | 66 | 100 | 0 | 1 | 2248 | 5693 | 7940 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 6747 | 3786 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14346888 | 14346888 | PRJNA1180292_P_NODE_1732_length_522_cov_1.875278_g1600_i0 | PRJNA1180292 | 1732 | 522 | 1.875278 | 9.78895116 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 726 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1600 | i0 | 91.778 | 1.00191570881226 | 523 | 41 | 100 | 2 | 1 | 522 | 6025 | 5504 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 523 | 726 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15620630 | 15620630 | PRJNA1180292_P_NODE_1813_length_510_cov_1.935927_g1681_i0 | PRJNA1180292 | 1813 | 510 | 1.935927 | 9.8732277 | Polycipiviridae sp. | 2496155 | Viruses | Viruses | 52.8 | 0.05 | NTclustered | gi|2756421824|gb|PP744841.1| | 2496155 | g1681 | i0 | 90.244 | 0.0803921568627451 | 41 | 3 | 8 | 1 | 51 | 90 | 9171 | 9211 | MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence | blastn | 41 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Polycipiviridae | Polycipiviridae sp. | |||
| 16894925 | 16894925 | PRJNA1180292_P_NODE_1154_length_648_cov_1.619130_g1023_i0 | PRJNA1180292 | 1154 | 648 | 1.61913 | 10.4919624 | Rhizoctonia solani partitivirus 8 | 2600094 | Viruses | Viruses | 1197 | 0 | NTclustered | gi|1772832407|gb|MK809403.1| | 2600094 | g1023 | i0 | 100 | 1 | 648 | 0 | 100 | 0 | 1 | 648 | 1600 | 953 | Rhizoctonia solani partitivirus 8 isolate YNBB-111-3 segment 2 hypothetical protein gene, complete cds | blastn | 648 | 1197 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rhizoctonia solani partitivirus 8 | |||
| 16894997 | 16894997 | PRJNA1180292_P_NODE_5614_length_294_cov_2.407240_g5482_i0 | PRJNA1180292 | 5614 | 294 | 2.40724 | 7.0772856 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 529 | 1.0299999999999996e-145 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g5482 | i0 | 98.99 | 4.36734693877551 | 297 | 0 | 100 | 1 | 1 | 294 | 8179 | 7883 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1284 | 529 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 18169503 | 18169503 | PRJNA1180292_P_NODE_3035_length_393_cov_1.156250_g2903_i0 | PRJNA1180292 | 3035 | 393 | 1.15625 | 4.5440625 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 621 | 2.2799999999999997e-173 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g2903 | i0 | 95.165 | 3.00254452926209 | 393 | 19 | 100 | 0 | 1 | 393 | 5546 | 5154 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1180 | 621 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 18169515 | 18169515 | PRJNA1180292_P_NODE_4975_length_312_cov_0.979079_g4843_i0 | PRJNA1180292 | 4975 | 312 | 0.979079 | 3.05472648 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 521 | 1.8499999999999998e-143 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g4843 | i0 | 96.795 | 1 | 312 | 10 | 100 | 0 | 1 | 312 | 6412 | 6723 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 312 | 521 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 19443868 | 19443868 | PRJNA1180292_P_NODE_5176_length_306_cov_1.515021_g5044_i0 | PRJNA1180292 | 5176 | 306 | 1.515021 | 4.63596426 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 499 | 8.4799999999999985e-137 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g5044 | i0 | 96.689 | 2.76143790849673 | 302 | 7 | 99 | 2 | 1 | 302 | 320 | 22 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 845 | 499 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24543811 | 24543811 | PRJNA1180292_P_NODE_120_length_1739_cov_3.683673_g76_i0 | PRJNA1180292 | 120 | 1739 | 3.683673 | 64.05907347 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 2808 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g76 | i0 | 95.805 | 3.00057504312823 | 1740 | 71 | 100 | 2 | 1 | 1739 | 5700 | 3962 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 5218 | 2808 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 |
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);;