contig_metadata
21 rows where bioproject = "PRJNA1186363" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1594427 | 1594427 | PRJNA1186363_P_NODE_2_length_8323_cov_9.857939_g1_i0 | PRJNA1186363 | 2 | 8323 | 9.857939 | 820.47626297 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13725 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g1 | i0 | 96.531 | 3.04613721014057 | 8302 | 277 | 99 | 10 | 7 | 8303 | 8298 | 3 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25353 | 13725 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5422948 | 5422948 | PRJNA1186363_P_NODE_43325_length_243_cov_0.917647_g42437_i0 | PRJNA1186363 | 43325 | 243 | 0.917647 | 2.22988221 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 405 | 1.46e-108 | NTclustered | gi|345645032|dbj|AB669182.1| | 12188 | g42437 | i0 | 96.708 | 13.6172839506173 | 243 | 8 | 100 | 0 | 1 | 243 | 2511 | 2753 | White clover mosaic virus genomic RNA, complete genome, strain: WClMV-RC | blastn | 3309 | 405 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 6697593 | 6697593 | PRJNA1186363_P_NODE_21886_length_399_cov_0.923313_g20998_i0 | PRJNA1186363 | 21886 | 399 | 0.923313 | 3.68401887 | Geminiviridae sp. | 2202566 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2302019654|gb|MT206033.1| | 2202566 | g20998 | i0 | 96.97 | 0.468671679197995 | 33 | 1 | 8 | 0 | 222 | 254 | 1983 | 2015 | MAG: Geminiviridae sp. isolate CN11_L17_1229, complete genome | blastn | 187 | 56.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Geminiviridae sp. | |||
| 7973038 | 7973038 | PRJNA1186363_P_NODE_35827_length_270_cov_2.319797_g34939_i0 | PRJNA1186363 | 35827 | 270 | 2.319797 | 6.2634519 | Mitovirus sp. | 2587224 | Viruses | Viruses | 226 | 1.38e-54 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g34939 | i0 | 87.817 | 0.72962962962963 | 197 | 19 | 73 | 3 | 1 | 197 | 5 | 196 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 197 | 226 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 8695009 | 8695009 | PRJNA1186363_P_NODE_40827_length_248_cov_0.891429_g39939_i0 | PRJNA1186363 | 40827 | 248 | 0.891429 | 2.21074392 | Ilzatvirus | 2560150 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1631945517|ref|NC_042111.1| | 2079584 | g39939 | i0 | 100 | 2.37096774193548 | 28 | 0 | 11 | 0 | 144 | 171 | 24213 | 24240 | Microbacterium phage Ilzat, complete genome | blastn | 588 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ilzatvirus | Ilzatvirus ilzat | ||||
| 9970072 | 9970072 | PRJNA1186363_P_NODE_12348_length_578_cov_1.544554_g11466_i0 | PRJNA1186363 | 12348 | 578 | 1.544554 | 8.92752212 | Moumouvirus | 3080801 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|441431943|ref|NC_020104.1| | 1269028 | g11466 | i0 | 100 | 0.103806228373702 | 30 | 0 | 5 | 0 | 246 | 275 | 220267 | 220238 | Acanthamoeba polyphaga moumouvirus, complete genome | blastn | 60 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus moumou | ||
| 11798294 | 11798294 | PRJNA1186363_P_NODE_16170_length_487_cov_1.693237_g15283_i0 | PRJNA1186363 | 16170 | 487 | 1.693237 | 8.24606419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.2 | 2.84e-4 | NTclustered | gi|2054751057|tpg|BK043420.1| | 2832643 | g15283 | i0 | 100 | 0.158110882956879 | 32 | 0 | 10 | 0 | 382 | 413 | 2643 | 2674 | MAG TPA_asm: Caudoviricetes sp. isolate ctwZF9, partial genome | blastn | 77 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11798398 | 11798398 | PRJNA1186363_P_NODE_32870_length_293_cov_1.250000_g31982_i0 | PRJNA1186363 | 32870 | 293 | 1.25 | 3.6625 | Mitovirus sp. | 2587224 | Viruses | Viruses | 274 | 5.33e-69 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g31982 | i0 | 91.878 | 0.672354948805461 | 197 | 14 | 67 | 2 | 97 | 293 | 196 | 2 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 197 | 274 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 13795361 | 13795361 | PRJNA1186363_P_NODE_21671_length_401_cov_1.820122_g20783_i0 | PRJNA1186363 | 21671 | 401 | 1.820122 | 7.29868922 | Alexandravirus | 2733088 | Viruses | Viruses | 52.8 | 0.038 | NTclustered | gi|2209260177|ref|NC_061443.1| | 2869547 | g20783 | i0 | 100 | 0.139650872817955 | 28 | 0 | 7 | 0 | 286 | 313 | 106892 | 106919 | Erwinia phage pEa_SNUABM_2, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Alexandravirus | Alexandravirus SNUABM2 | ||||
| 14348859 | 14348859 | PRJNA1186363_P_NODE_41432_length_247_cov_0.896552_g40544_i0 | PRJNA1186363 | 41432 | 247 | 0.896552 | 2.21448344 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 396 | 8.95e-106 | NTclustered | gi|2520252303|gb|OQ993368.1| | 12188 | g40544 | i0 | 95.547 | 8.99595141700405 | 247 | 11 | 100 | 0 | 1 | 247 | 684 | 930 | White clover mosaic virus isolate DSMZ PV-1074, complete genome | blastn | 2222 | 396 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 14348921 | 14348921 | PRJNA1186363_P_NODE_8832_length_706_cov_2.788310_g7980_i0 | PRJNA1186363 | 8832 | 706 | 2.78831 | 19.6854686 | Torque teno midi virus | 432261 | Viruses | Viruses | 56.5 | 0.005 | NTclustered | gi|2168962934|gb|MN778544.1| | 432261 | g7980 | i0 | 97.059 | 0.0481586402266289 | 34 | 0 | 5 | 1 | 511 | 543 | 2175 | 2142 | MAG: Torque teno midi virus isolate SAfiA-51-52 ORF1 gene, complete cds | blastn | 34 | 56.5 | 1 | Viruses | Shotokuvirae | Commensaviricota | Cardeaviricetes | Sanitavirales | Anelloviridae | Torque teno midi virus | |||
| 20721091 | 20721091 | PRJNA1186363_P_NODE_25577_length_357_cov_2.510563_g24689_i0 | PRJNA1186363 | 25577 | 357 | 2.510563 | 8.96270991 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2059591960|tpg|BK036906.1| | 2832643 | g24689 | i0 | 100 | 0.0812324929971989 | 29 | 0 | 8 | 0 | 45 | 73 | 19262 | 19234 | MAG TPA_asm: Caudoviricetes sp. isolate ctdMI12, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24545795 | 24545795 | PRJNA1186363_P_NODE_36980_length_262_cov_1.280423_g36092_i0 | PRJNA1186363 | 36980 | 262 | 1.280423 | 3.35470826 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 473 | 4.31e-129 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g36092 | i0 | 99.237 | 3 | 262 | 2 | 100 | 0 | 1 | 262 | 4485 | 4746 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 786 | 473 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 27767508 | 27767508 | PRJNA1186363_P_NODE_4_length_5539_cov_6.688621_g3_i0 | PRJNA1186363 | 4 | 5539 | 6.688621 | 370.48271719 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 2370 | 0 | NR | WWZ85593.1 | 3132542 | g3 | i0 | 64.5 | 0.997653005957754 | 1842 | 551 | 94.9 | 19 | 2 | 5260 | 1154 | 2981 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 5526 | 2370 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 27893446 | 27893446 | PRJNA1186363_P_NODE_305_length_2352_cov_2.802984_g235_i0 | PRJNA1186363 | 305 | 2352 | 2.802984 | 65.92618368 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 884 | 7.320000000000001e-289 | NR | WWZ85593.1 | 3132542 | g235 | i0 | 56.6 | 1.02040816326531 | 800 | 322 | 99.9 | 6 | 2 | 2350 | 330 | 1121 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 2400 | 884 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 28240676 | 28240676 | PRJNA1186363_P_NODE_30586_length_312_cov_0.828452_g29698_i0 | PRJNA1186363 | 30586 | 312 | 0.828452 | 2.58477024 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 91.7 | 5.4e-19 | NR | YP_010782554.1 | 2126985 | g29698 | i0 | 55.3 | 1.46153846153846 | 76 | 32 | 73.1 | 1 | 303 | 76 | 100 | 173 | YP_010782554.1 ubiquitin-conjugating enzyme [Tupanvirus soda lake] | diamond | 456 | 91.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 29819360 | 29819360 | PRJNA1186363_P_NODE_26291_length_350_cov_1.971119_g25403_i0 | PRJNA1186363 | 26291 | 350 | 1.971119 | 6.8989165 | Moumouvirus lavasanguinem | 3138182 | Viruses | Viruses | 43.1 | 0.0123 | NR | BFL60918.1 | 3138182 | g25403 | i0 | 43.1 | 0.437142857142857 | 51 | 29 | 43.7 | 0 | 265 | 113 | 5 | 55 | BFL60918.1 hypothetical protein MoumouF8_00015 [Moumouvirus lavasanguinem] | diamond | 153 | 43.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus sp. 'lavasanguinem' | ||
| 30672503 | 30672503 | PRJNA1186363_P_NODE_42413_length_245_cov_0.906977_g41525_i0 | PRJNA1186363 | 42413 | 245 | 0.906977 | 2.22209365 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 43.5 | 0.0197 | NR | YP_010803851.1 | 3060017 | g41525 | i0 | 42 | 0.612244897959184 | 50 | 28 | 60 | 1 | 213 | 67 | 22 | 71 | YP_010803851.1 R3H domain-containing protein [Fadolivirus algeromassiliense] | diamond | 150 | 43.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 31273010 | 31273010 | PRJNA1186363_P_NODE_2335_length_1302_cov_3.008137_g1938_i0 | PRJNA1186363 | 2335 | 1302 | 3.008137 | 39.16594374 | Pandoravirus massiliensis | 2060085 | Viruses | Viruses | 183 | 6.01e-48 | NR | UDO47403.1 | 2060085 | g1938 | i0 | 31.4 | 2.06221198156682 | 452 | 244 | 91 | 12 | 17 | 1201 | 59 | 501 | UDO47403.1 hypothetical protein [Pandoravirus massiliensis] | diamond | 2685 | 183 | 1 | Viruses | Pandoravirus | Pandoravirus massiliensis | |||||||
| 31778985 | 31778985 | PRJNA1186363_P_NODE_37397_length_259_cov_1.258065_g36509_i0 | PRJNA1186363 | 37397 | 259 | 1.258065 | 3.25838835 | Clandestinovirus | 2831644 | Viruses | Viruses | 98.2 | 4.39e-23 | NR | QYA18369.1 | 2831644 | g36509 | i0 | 57.1 | 0.810810810810811 | 70 | 30 | 81.1 | 0 | 48 | 257 | 137 | 206 | QYA18369.1 bifunctional linker histone H1/H5 [Clandestinovirus] | diamond | 210 | 98.2 | 1 | Viruses | Clandestinovirus | ||||||||
| 32127329 | 32127329 | PRJNA1186363_P_NODE_6418_length_839_cov_1.593995_g5664_i0 | PRJNA1186363 | 6418 | 839 | 1.593995 | 13.37361805 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 242 | 1.12e-68 | NR | WWZ85593.1 | 3132542 | g5664 | i0 | 47.1 | 1.00119189511323 | 280 | 125 | 99.4 | 4 | 3 | 836 | 72 | 330 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 840 | 242 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 |
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);;