contig_metadata
13 rows where analysis = "blastn", 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 |
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);;