contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA900999" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4706699 | 4706699 | PRJNA900999_S_NODE_2084_length_270_cov_292674.510373_g2028_i0 | PRJNA900999 | 2084 | 270 | 292674.510373 | 790221.1780071 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 4.11e-5 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g2028 | i0 | 95 | 18.4259259259259 | 40 | 0 | 14 | 2 | 232 | 270 | 100125 | 100087 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 4975 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16180836 | 16180836 | PRJNA900999_S_NODE_6653_length_175_cov_4.315068_g6597_i0 | PRJNA900999 | 6653 | 175 | 4.315068 | 7.551369 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 217 | 4.94e-52 | NTclustered | gi|2914826682|gb|OR222326.1| | 2832643 | g6597 | i0 | 94.326 | 24.6342857142857 | 141 | 8 | 81 | 0 | 12 | 152 | 49563 | 49703 | MAG: Caudoviricetes sp. isolate MSP1075 genomic sequence | blastn | 4311 | 217 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17456321 | 17456321 | PRJNA900999_S_NODE_3194_length_232_cov_5.315271_g3138_i0 | PRJNA900999 | 3194 | 232 | 5.315271 | 12.33142872 | uncultured human fecal virus | 239364 | Viruses | Viruses | 429 | 8.2e-116 | NTclustered | gi|1569729598|gb|MK233924.1| | 239364 | g3138 | i0 | 100 | 249.068965517241 | 232 | 0 | 100 | 0 | 1 | 232 | 1288 | 1057 | Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence | blastn | 57784 | 429 | 1 | Viruses | uncultured human fecal virus | ||||||||
| 17456339 | 17456339 | PRJNA900999_S_NODE_4454_length_204_cov_34.440000_g4398_i0 | PRJNA900999 | 4454 | 204 | 34.44 | 70.2576 | Rheavirus sinusmexicani | 3047716 | Viruses | Viruses | 52.8 | 0.018 | NTclustered | gi|310830989|ref|NC_014637.1| | 693272 | g4398 | i0 | 100 | 0.137254901960784 | 28 | 0 | 14 | 0 | 100 | 127 | 471409 | 471436 | Cafeteria roenbergensis virus BV-PW1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Rheavirus | Rheavirus sinusmexicani | ||
| 17823515 | 17823515 | PRJNA900999_S_NODE_634_length_395_cov_8.956284_g579_i0 | PRJNA900999 | 634 | 395 | 8.956284 | 35.3773218 | Viruses | 10239 | Viruses | Viruses | 122 | 2.84e-23 | NTclustered | gi|2320152903|gb|ON746353.1| | 2972063 | g579 | i0 | 81.013 | 1.13924050632911 | 158 | 27 | 40 | 3 | 120 | 277 | 2394 | 2240 | MAG: Hulunbuir Botou tick virus 4 isolate TIGMIC 2 genomic sequence | blastn | 450 | 122 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 4 | |||
| 18729461 | 18729461 | PRJNA900999_S_NODE_1135_length_328_cov_239747.769231_g1079_i0 | PRJNA900999 | 1135 | 328 | 239747.769231 | 786372.68307768 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 5.13e-5 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g1079 | i0 | 95 | 16.0914634146341 | 40 | 0 | 12 | 2 | 1 | 39 | 100087 | 100125 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 5278 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20004678 | 20004678 | PRJNA900999_S_NODE_1796_length_284_cov_277038.768627_g1740_i0 | PRJNA900999 | 1796 | 284 | 277038.768627 | 786790.10290068 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 4.36e-5 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g1740 | i0 | 95 | 17.6197183098592 | 40 | 0 | 14 | 2 | 1 | 39 | 100087 | 100125 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 5004 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25104111 | 25104111 | PRJNA900999_S_NODE_4780_length_199_cov_5.776471_g4724_i0 | PRJNA900999 | 4780 | 199 | 5.776471 | 11.49517729 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g4724 | i0 | 100 | 14.572864321608 | 29 | 0 | 15 | 0 | 104 | 132 | 119274 | 119302 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox |
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);;