contig_metadata
15 rows where bioproject = "PRJEB48872" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5178446 | 5178446 | PRJEB48872_P_NODE_389665_length_235_cov_1.882653_g373853_i0 | PRJEB48872 | 389665 | 235 | 1.882653 | 4.42423455 | Escherichia phage Ec_YwIITB1 | 3366621 | Viruses | Viruses | 209 | 1.18e-49 | NTclustered | gi|2870405014|gb|PQ356294.1| | 3366621 | g373853 | i0 | 83.043 | 97.8723404255319 | 230 | 39 | 98 | 0 | 2 | 231 | 128953 | 129182 | Escherichia phage Ec_YwIITB1, complete genome | blastn | 23000 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Escherichia phage Ec_YwIITB1 | ||
| 6465855 | 6465855 | PRJEB48872_P_NODE_630586_length_162_cov_1.333333_g614774_i0 | PRJEB48872 | 630586 | 162 | 1.333333 | 2.15999946 | Pahexavirus P101A | 1982267 | Viruses | Viruses | 294 | 2.03e-75 | NTclustered | gi|408905836|ref|NC_018841.1| | 1229786 | g614774 | i0 | 99.383 | 98.4444444444444 | 162 | 1 | 100 | 0 | 1 | 162 | 25819 | 25980 | Propionibacterium phage P101A, complete genome | blastn | 15948 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P101A | ||||
| 9017330 | 9017330 | PRJEB48872_P_NODE_681448_length_153_cov_1.078947_g665636_i0 | PRJEB48872 | 681448 | 153 | 1.078947 | 1.65078891 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 239 | 8.96e-59 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g665636 | i0 | 94.771 | 1 | 153 | 8 | 100 | 0 | 1 | 153 | 86342 | 86494 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 153 | 239 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 12826240 | 12826240 | PRJEB48872_P_NODE_320091_length_273_cov_3.991453_g304279_i0 | PRJEB48872 | 320091 | 273 | 3.991453 | 10.89666669 | Orthoflavivirus denguei | 3052464 | Viruses | Viruses | 488 | 1.6099999999999996e-133 | NTclustered | gi|437772|emb|X72849.1| | 11060 | g304279 | i0 | 98.901 | 99.8681318681319 | 273 | 3 | 100 | 0 | 1 | 273 | 374 | 102 | Dengue-2 virus mRNA for premembrane and membrane proteins | blastn | 27264 | 488 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 15018509 | 15018509 | PRJEB48872_P_NODE_423092_length_220_cov_4.038674_g407280_i0 | PRJEB48872 | 423092 | 220 | 4.038674 | 8.8850828 | root | 1 | Root_unresolved | Root_unresolved | 340 | 3.71e-89 | NTclustered | gi|2461903820|gb|OQ652965.1| | 11060 | g407280 | i0 | 100 | 83.5090909090909 | 184 | 0 | 84 | 0 | 37 | 220 | 1080 | 897 | Dengue virus type 2 isolate DENV2_YN_017, complete genome | blastn | 18372 | 340 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 16293489 | 16293489 | PRJEB48872_P_NODE_612873_length_166_cov_0.897638_g597061_i0 | PRJEB48872 | 612873 | 166 | 0.897638 | 1.49007908 | Pahexavirus | 1982251 | Viruses | Viruses | 257 | 2.7400000000000003e-64 | NTclustered | gi|408905836|ref|NC_018841.1| | 1229786 | g597061 | i0 | 94.578 | 98.3132530120482 | 166 | 9 | 100 | 0 | 1 | 166 | 10609 | 10774 | Propionibacterium phage P101A, complete genome | blastn | 16320 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P101A | ||||
| 17938502 | 17938502 | PRJEB48872_P_NODE_614155_length_165_cov_1.952381_g598343_i0 | PRJEB48872 | 614155 | 165 | 1.952381 | 3.22142865 | Mimiviridae sp. ChoanoV1 | 2596887 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|1717455947|gb|MK250087.1| | 2596887 | g598343 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 43 | 70 | 7801 | 7774 | Mimiviridae sp. ChoanoV1 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Schizomimiviridae | Mimiviridae sp. ChoanoV1 | |||
| 18842477 | 18842477 | PRJEB48872_P_NODE_697875_length_150_cov_1.315315_g682063_i0 | PRJEB48872 | 697875 | 150 | 1.315315 | 1.9729725 | Pahexavirus | 1982251 | Viruses | Viruses | 259 | 6.71e-65 | NTclustered | gi|408905834|ref|NC_018839.1| | 1229784 | g682063 | i0 | 98.63 | 94.1 | 146 | 2 | 97 | 0 | 5 | 150 | 7992 | 7847 | Propionibacterium phage P14.4, complete genome | blastn | 14115 | 261 | 0.992337164750958 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P144 | ||||
| 20117168 | 20117168 | PRJEB48872_P_NODE_346196_length_257_cov_4.243119_g330384_i0 | PRJEB48872 | 346196 | 257 | 4.243119 | 10.90481583 | root | 1 | Root_unresolved | Root_unresolved | 464 | 2.5299999999999998e-126 | NTclustered | gi|259496212|gb|GQ868591.1| | 11060 | g330384 | i0 | 99.222 | 100.603112840467 | 257 | 2 | 100 | 0 | 1 | 257 | 529 | 273 | Dengue virus 2 isolate DENV-2/TH/BID-V3357/1964, complete genome | blastn | 25855 | 464 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 20117179 | 20117179 | PRJEB48872_P_NODE_362476_length_248_cov_3.971292_g346664_i0 | PRJEB48872 | 362476 | 248 | 3.971292 | 9.84880416 | root | 1 | Root_unresolved | Root_unresolved | 453 | 5.2600000000000005e-123 | NTclustered | gi|224383579|gb|FJ687445.1| | 11060 | g346664 | i0 | 99.597 | 100 | 248 | 1 | 100 | 0 | 1 | 248 | 265 | 18 | Dengue virus 2 isolate DENV-2/TH/BID-V2290/2001, complete genome | blastn | 24800 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 20117263 | 20117263 | PRJEB48872_P_NODE_538716_length_183_cov_1.388889_g522904_i0 | PRJEB48872 | 538716 | 183 | 1.388889 | 2.54166687 | Pahexavirus | 1982251 | Viruses | Viruses | 305 | 1.08e-78 | NTclustered | gi|1631925795|ref|NC_041954.1| | 1655013 | g522904 | i0 | 96.721 | 100.453551912568 | 183 | 6 | 100 | 0 | 1 | 183 | 20677 | 20859 | Propionibacterium phage Keiki, complete genome | blastn | 18383 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus keiki | ||||
| 22667616 | 22667616 | PRJEB48872_P_NODE_492558_length_196_cov_1.458599_g476746_i0 | PRJEB48872 | 492558 | 196 | 1.458599 | 2.85885404 | Pahexavirus | 1982251 | Viruses | Viruses | 357 | 3.2099999999999996e-94 | NTclustered | gi|945393407|gb|KT934381.1| | 1747271 | g476746 | i0 | 99.49 | 98.1632653061225 | 196 | 1 | 100 | 0 | 1 | 196 | 21157 | 20962 | Propionibacterium phage PA1-14, complete genome | blastn | 19240 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage PA1-14 | ||||
| 28454904 | 28454904 | PRJEB48872_P_NODE_672226_length_154_cov_1.965217_g656414_i0 | PRJEB48872 | 672226 | 154 | 1.965217 | 3.02643418 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 54.3 | 9.25e-7 | NR | WAK72431.1 | 2809572 | g656414 | i0 | 60 | 2.35714285714286 | 40 | 16 | 77.9 | 0 | 121 | 2 | 200 | 239 | WAK72431.1 MAG: RNA-dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 363 | 54.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 32088240 | 32088240 | PRJEB48872_P_NODE_589098_length_171_cov_1.174242_g573286_i0 | PRJEB48872 | 589098 | 171 | 1.174242 | 2.00795382 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 52.8 | 4.19e-6 | NR | AAK29054.1 | 1891767 | g573286 | i0 | 72.2 | 0.631578947368421 | 36 | 10 | 63.2 | 0 | 108 | 1 | 494 | 529 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 108 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 32436604 | 32436604 | PRJEB48872_P_NODE_543559_length_181_cov_21.380282_g527747_i0 | PRJEB48872 | 543559 | 181 | 21.380282 | 38.69831042 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 58.2 | 3.33e-8 | NR | DAC81394.1 | 2609864 | g527747 | i0 | 69.4 | 0.596685082872928 | 36 | 11 | 59.7 | 0 | 72 | 179 | 7 | 42 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 108 | 58.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;