contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1894204 | 1894204 | PRJNA642647_P_NODE_3122_length_199_cov_1.395062_g3072_i0 | PRJNA642647 | 3122 | 199 | 1.395062 | 2.77617338 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 254 | 4.41e-63 | NTclustered | gi|1996919084|gb|MW347895.1| | 2832643 | g3072 | i0 | 90.206 | 0.974874371859296 | 194 | 19 | 97 | 0 | 3 | 196 | 994 | 1187 | MAG: Caudoviricetes sp. isolate 5cz-TERL-29 terminase large subunit gene, partial cds | blastn | 194 | 254 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1894226 | 1894226 | PRJNA642647_P_NODE_6182_length_154_cov_0.931624_g6132_i0 | PRJNA642647 | 6182 | 154 | 0.931624 | 1.43470096 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 148 | 1.57e-31 | NTclustered | gi|1839137169|emb|LR796172.1| | 2100421 | g6132 | i0 | 85.034 | 1.66883116883117 | 147 | 20 | 95 | 2 | 9 | 154 | 57033 | 57178 | uncultured Caudovirales phage genome assembly | blastn | 257 | 148 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 4445692 | 4445692 | PRJNA642647_P_NODE_4984_length_166_cov_2.953488_g4934_i0 | PRJNA642647 | 4984 | 166 | 2.953488 | 4.90279008 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 82.4 | 1.77e-11 | NTclustered | gi|2054781069|tpg|BK049728.1| | 2832643 | g4934 | i0 | 91.525 | 0.710843373493976 | 59 | 5 | 36 | 0 | 4 | 62 | 12905 | 12847 | MAG TPA_asm: Caudoviricetes sp. isolate ctQaT6, partial genome | blastn | 118 | 82.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4445700 | 4445700 | PRJNA642647_P_NODE_5724_length_159_cov_2.442623_g5674_i0 | PRJNA642647 | 5724 | 159 | 2.442623 | 3.88377057 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 115 | 1.66e-21 | NTclustered | gi|1839163678|emb|LR796526.1| | 2100421 | g5674 | i0 | 81.884 | 0.867924528301887 | 138 | 23 | 86 | 2 | 20 | 156 | 26641 | 26505 | uncultured Caudovirales phage genome assembly | blastn | 138 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 5721539 | 5721539 | PRJNA642647_P_NODE_5325_length_165_cov_1.187500_g5275_i0 | PRJNA642647 | 5325 | 165 | 1.1875 | 1.959375 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 99 | 1.75e-16 | NTclustered | gi|1862940404|emb|LR797819.1| | 2100421 | g5275 | i0 | 83.486 | 0.660606060606061 | 109 | 14 | 65 | 3 | 28 | 134 | 21635 | 21529 | uncultured Caudovirales phage genome assembly | blastn | 109 | 99 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 6996529 | 6996529 | PRJNA642647_P_NODE_1826_length_257_cov_3.181818_g1776_i0 | PRJNA642647 | 1826 | 257 | 3.181818 | 8.17727226 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 5.72e-93 | NTclustered | gi|2914869935|gb|OR222861.1| | 2832643 | g1776 | i0 | 91.765 | 9.57587548638132 | 255 | 19 | 99 | 2 | 4 | 257 | 2225 | 1972 | MAG: Caudoviricetes sp. isolate MSP0489 genomic sequence | blastn | 2461 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6996532 | 6996532 | PRJNA642647_P_NODE_1986_length_246_cov_2.325359_g1936_i0 | PRJNA642647 | 1986 | 246 | 2.325359 | 5.72038314 | Pseudomonas phage HU1 | 2056127 | Viruses | Viruses | 361 | 3.25e-95 | NTclustered | gi|1717782427|dbj|AP019415.2| | 2056127 | g1936 | i0 | 93.089 | 1 | 246 | 17 | 100 | 0 | 1 | 246 | 30235 | 30480 | Pseudomonas phage HU1 HU1 DNA, complete genome | blastn | 246 | 361 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage HU1 | |||||
| 8271309 | 8271309 | PRJNA642647_P_NODE_6227_length_153_cov_1.387931_g6177_i0 | PRJNA642647 | 6227 | 153 | 1.387931 | 2.12353443 | Pseudomonas phage HU1 | 2056127 | Viruses | Viruses | 165 | 1.54e-36 | NTclustered | gi|1717782427|dbj|AP019415.2| | 2056127 | g6177 | i0 | 90 | 0.849673202614379 | 130 | 10 | 85 | 1 | 24 | 153 | 40059 | 40185 | Pseudomonas phage HU1 HU1 DNA, complete genome | blastn | 130 | 165 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage HU1 | |||||
| 9546608 | 9546608 | PRJNA642647_P_NODE_6548_length_151_cov_1.675439_g6498_i0 | PRJNA642647 | 6548 | 151 | 1.675439 | 2.52991289 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.13e-62 | NTclustered | gi|2914869935|gb|OR222861.1| | 2832643 | g6498 | i0 | 96.711 | 2.71523178807947 | 152 | 4 | 100 | 1 | 1 | 151 | 2314 | 2465 | MAG: Caudoviricetes sp. isolate MSP0489 genomic sequence | blastn | 410 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14646926 | 14646926 | PRJNA642647_P_NODE_4992_length_166_cov_2.953488_g4942_i0 | PRJNA642647 | 4992 | 166 | 2.953488 | 4.90279008 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 130 | 6.240000000000001e-26 | NTclustered | gi|2488155595|emb|OX382876.1| | 2100421 | g4942 | i0 | 97.368 | 2.68072289156627 | 76 | 2 | 46 | 0 | 91 | 166 | 24919 | 24994 | MAG: uncultured Caudovirales phage genome assembly, chromosome: HRS-ES12-C366 | blastn | 445 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 15920858 | 15920858 | PRJNA642647_P_NODE_4453_length_172_cov_1.140741_g4403_i0 | PRJNA642647 | 4453 | 172 | 1.140741 | 1.96207452 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 122 | 1.0799999999999999e-23 | NTclustered | gi|2488155014|emb|OX382754.1| | 2100421 | g4403 | i0 | 81.699 | 2.31976744186047 | 153 | 23 | 88 | 5 | 4 | 155 | 2584 | 2732 | MAG: uncultured Caudovirales phage genome assembly, chromosome: HRS-ES5-C98 | blastn | 399 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 23570689 | 23570689 | PRJNA642647_P_NODE_1379_length_297_cov_7.757692_g1329_i0 | PRJNA642647 | 1379 | 297 | 7.757692 | 23.04034524 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 346 | 1.1299999999999999e-90 | NTclustered | gi|2914869935|gb|OR222861.1| | 2832643 | g1329 | i0 | 96.635 | 1.7037037037037 | 208 | 7 | 70 | 0 | 1 | 208 | 10234 | 10027 | MAG: Caudoviricetes sp. isolate MSP0489 genomic sequence | blastn | 506 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;