contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA591000" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3115859 | 3115859 | PRJNA591000_P_NODE_3083_length_791_cov_2.599738_g2356_i0 | PRJNA591000 | 3083 | 791 | 2.599738 | 20.56392758 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 78.7 | 1.31e-9 | NTclustered | gi|1839169250|emb|LR796625.1| | 2100421 | g2356 | i0 | 81.553 | 2.88116308470291 | 103 | 12 | 13 | 5 | 609 | 709 | 8428 | 8331 | uncultured Caudovirales phage genome assembly | blastn | 2279 | 78.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 3115860 | 3115860 | PRJNA591000_P_NODE_7923_length_495_cov_1.291845_g6421_i0 | PRJNA591000 | 7923 | 495 | 1.291845 | 6.39463275 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 224 | 9.68e-54 | NTclustered | gi|1990397702|gb|MW347122.1| | 2832643 | g6421 | i0 | 88.649 | 3.75757575757576 | 185 | 19 | 37 | 2 | 312 | 495 | 1135 | 1318 | MAG: Caudoviricetes sp. isolate 2wh-TERL-59 terminase large subunit gene, complete cds | blastn | 1860 | 224 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9493346 | 9493346 | PRJNA591000_P_NODE_9688_length_451_cov_1.018957_g8130_i0 | PRJNA591000 | 9688 | 451 | 1.018957 | 4.59549607 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 97.1 | 1.99e-15 | NTclustered | gi|1862810748|emb|LR798302.1| | 2100421 | g8130 | i0 | 84.694 | 0.452328159645233 | 98 | 13 | 33 | 2 | 304 | 400 | 11973 | 12069 | uncultured Caudovirales phage genome assembly | blastn | 204 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 10769212 | 10769212 | PRJNA591000_P_NODE_1389_length_1022_cov_7.524673_g985_i0 | PRJNA591000 | 1389 | 1022 | 7.524673 | 76.90215806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 409 | 5.34e-109 | NTclustered | gi|2906148703|gb|PQ646410.1| | 2832643 | g985 | i0 | 87.052 | 0.710371819960861 | 363 | 25 | 69 | 12 | 7 | 358 | 28716 | 29067 | MAG: Caudoviricetes sp. isolate k127_2521799 genomic sequence | blastn | 726 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14593769 | 14593769 | PRJNA591000_P_NODE_4432_length_696_cov_5.185907_g3512_i0 | PRJNA591000 | 4432 | 696 | 5.185907 | 36.09391272 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 544 | 9.4e-150 | NTclustered | gi|1839161151|emb|LR796480.1| | 2100421 | g3512 | i0 | 83.91 | 0.830459770114943 | 578 | 83 | 82 | 8 | 30 | 602 | 28331 | 28903 | uncultured Caudovirales phage genome assembly | blastn | 578 | 544 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 15867603 | 15867603 | PRJNA591000_P_NODE_7793_length_499_cov_1.814894_g6303_i0 | PRJNA591000 | 7793 | 499 | 1.814894 | 9.05632106 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 169 | 4.64e-37 | NTclustered | gi|2906150100|gb|PQ646500.1| | 2832643 | g6303 | i0 | 98.936 | 0.663326653306613 | 94 | 1 | 63 | 0 | 356 | 449 | 24427 | 24520 | MAG: Caudoviricetes sp. isolate k127_1563711 genomic sequence | blastn | 331 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17142574 | 17142574 | PRJNA591000_P_NODE_4854_length_669_cov_2.282812_g3835_i0 | PRJNA591000 | 4854 | 669 | 2.282812 | 15.27201228 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 654 | 0 | NTclustered | gi|1839145648|emb|LR796254.1| | 2100421 | g3835 | i0 | 87.5 | 3.39461883408072 | 568 | 70 | 85 | 1 | 99 | 665 | 23882 | 24449 | uncultured Caudovirales phage genome assembly | blastn | 2271 | 654 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 22242050 | 22242050 | PRJNA591000_P_NODE_238_length_1641_cov_4.411290_g166_i0 | PRJNA591000 | 238 | 1641 | 4.41129 | 72.3892689 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 119 | 1.6400000000000002e-21 | NTclustered | gi|1839211469|emb|LR797431.1| | 2100421 | g166 | i0 | 94.805 | 0.137111517367459 | 77 | 2 | 5 | 2 | 790 | 865 | 3548 | 3473 | uncultured Caudovirales phage genome assembly | blastn | 225 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 22242053 | 22242053 | PRJNA591000_P_NODE_4158_length_713_cov_2.390351_g3280_i0 | PRJNA591000 | 4158 | 713 | 2.390351 | 17.04320263 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 178 | 1.13e-39 | NTclustered | gi|2906153628|gb|PQ646739.1| | 2832643 | g3280 | i0 | 83.59 | 0.273492286115007 | 195 | 26 | 27 | 6 | 117 | 308 | 6710 | 6901 | MAG: Caudoviricetes sp. isolate k127_1962688 genomic sequence | blastn | 195 | 178 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22242057 | 22242057 | PRJNA591000_P_NODE_7698_length_502_cov_2.665962_g6214_i0 | PRJNA591000 | 7698 | 502 | 2.665962 | 13.38312924 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 115 | 6.170000000000001e-21 | NTclustered | gi|1839167580|emb|LR796595.1| | 2100421 | g6214 | i0 | 86.916 | 1.94422310756972 | 107 | 8 | 21 | 1 | 30 | 136 | 16998 | 17098 | uncultured Caudovirales phage genome assembly | blastn | 976 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 23517306 | 23517306 | PRJNA591000_P_NODE_10739_length_433_cov_64.930693_g9164_i0 | PRJNA591000 | 10739 | 433 | 64.930693 | 281.14990069 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 171 | 1.1099999999999998e-37 | NTclustered | gi|2054795364|tpg|BK050006.1| | 2832643 | g9164 | i0 | 79.747 | 1.50577367205543 | 237 | 47 | 96 | 1 | 9 | 245 | 4682 | 4447 | MAG TPA_asm: Caudoviricetes sp. isolate ctR266, partial genome | blastn | 652 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23517310 | 23517310 | PRJNA591000_P_NODE_9539_length_454_cov_1.145882_g7983_i0 | PRJNA591000 | 9539 | 454 | 1.145882 | 5.20230428 | Mylasvirus persius | 1914020 | Viruses | Viruses | 54.7 | 0.012 | NTclustered | gi|939535554|ref|NC_021529.2| | 115992 | g7983 | i0 | 96.97 | 0.0726872246696035 | 33 | 0 | 7 | 1 | 324 | 355 | 54597 | 54565 | Vibrio phage nt-1, complete genome | blastn | 33 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Mylasvirus | Mylasvirus persius | ||
| 24791105 | 24791105 | PRJNA591000_P_NODE_2060_length_901_cov_2.598624_g1523_i0 | PRJNA591000 | 2060 | 901 | 2.598624 | 23.41360224 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 87.9 | 2.49e-12 | NTclustered | gi|1839169475|emb|LR796626.1| | 2100421 | g1523 | i0 | 81.481 | 1.1165371809101 | 108 | 18 | 24 | 2 | 792 | 898 | 23520 | 23626 | uncultured Caudovirales phage genome assembly | blastn | 1006 | 87.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;