contig_metadata
18 rows where bioproject = "PRJEB75017" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1409917 | 1409917 | PRJEB75017_P_NODE_15682_length_248_cov_1.782857_g15553_i0 | PRJEB75017 | 15682 | 248 | 1.782857 | 4.42148536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g15553 | i0 | 100 | 1 | 248 | 0 | 100 | 0 | 1 | 248 | 48557 | 48804 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 248 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2685390 | 2685390 | PRJEB75017_P_NODE_12583_length_263_cov_3.647368_g12454_i0 | PRJEB75017 | 12583 | 263 | 3.647368 | 9.59257784 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 486 | 5.5499999999999986e-133 | NTclustered | gi|2058015093|tpg|BK041823.1| | 2832643 | g12454 | i0 | 100 | 99.1901140684411 | 263 | 0 | 100 | 0 | 1 | 263 | 3157 | 2895 | MAG TPA_asm: Caudoviricetes sp. isolate ctkVl5, partial genome | blastn | 26087 | 486 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7787757 | 7787757 | PRJEB75017_P_NODE_2507_length_553_cov_1.156250_g2378_i0 | PRJEB75017 | 2507 | 553 | 1.15625 | 6.3940625 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1022 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g2378 | i0 | 100 | 1 | 553 | 0 | 100 | 0 | 1 | 553 | 23282 | 23834 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 553 | 1022 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9062587 | 9062587 | PRJEB75017_P_NODE_11908_length_270_cov_1.406091_g11779_i0 | PRJEB75017 | 11908 | 270 | 1.406091 | 3.7964457 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 494 | 3.4199999999999996e-135 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g11779 | i0 | 99.63 | 21.0037037037037 | 270 | 1 | 100 | 0 | 1 | 270 | 18821 | 18552 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 5671 | 494 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9062629 | 9062629 | PRJEB75017_P_NODE_17288_length_245_cov_0.906977_g17159_i0 | PRJEB75017 | 17288 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17159 | i0 | 100 | 1 | 245 | 0 | 100 | 0 | 1 | 245 | 40734 | 40978 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 245 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11613845 | 11613845 | PRJEB75017_P_NODE_17210_length_245_cov_0.906977_g17081_i0 | PRJEB75017 | 17210 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 425 | 1.1299999999999999e-114 | NTclustered | gi|2054564519|tpg|BK048315.1| | 2832643 | g17081 | i0 | 97.959 | 3.92244897959184 | 245 | 5 | 100 | 0 | 1 | 245 | 44153 | 43909 | MAG TPA_asm: Caudoviricetes sp. isolate ctdG41, partial genome | blastn | 961 | 425 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12888914 | 12888914 | PRJEB75017_P_NODE_17591_length_244_cov_0.912281_g17462_i0 | PRJEB75017 | 17591 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17462 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 19182 | 19425 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 244 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12888982 | 12888982 | PRJEB75017_P_NODE_8871_length_303_cov_1.265217_g8742_i0 | PRJEB75017 | 8871 | 303 | 1.265217 | 3.83360751 | Xanthomonas phage PBR31 | 2718947 | Viruses | Viruses | 209 | 1.58e-49 | NTclustered | gi|1822268303|gb|MT119766.1| | 2718947 | g8742 | i0 | 82.845 | 1.05610561056106 | 239 | 35 | 78 | 5 | 57 | 292 | 30529 | 30294 | Xanthomonas phage PBR31, complete genome | blastn | 320 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage PBR31 | |||||
| 14163700 | 14163700 | PRJEB75017_P_NODE_10272_length_286_cov_1.455399_g10143_i0 | PRJEB75017 | 10272 | 286 | 1.455399 | 4.16244114 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 529 | 1e-145 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g10143 | i0 | 100 | 1 | 286 | 0 | 100 | 0 | 1 | 286 | 17938 | 18223 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 286 | 529 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14163832 | 14163832 | PRJEB75017_P_NODE_9212_length_298_cov_2.702222_g9083_i0 | PRJEB75017 | 9212 | 298 | 2.702222 | 8.05262156 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 551 | 2.239999999999999e-152 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9083 | i0 | 100 | 1 | 298 | 0 | 100 | 0 | 1 | 298 | 46315 | 46612 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 298 | 551 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17573483 | 17573483 | PRJEB75017_P_NODE_9534_length_294_cov_1.058824_g9405_i0 | PRJEB75017 | 9534 | 294 | 1.058824 | 3.11294256 | Skunavirus | 1623305 | Viruses | Viruses | 544 | 3.69e-150 | NTclustered | gi|948516195|gb|KP793116.1| | 1636559 | g9405 | i0 | 100 | 97.1156462585034 | 294 | 0 | 100 | 0 | 1 | 294 | 18285 | 18578 | Lactococcus phage 936 group phage Phi13.16, complete genome | blastn | 28552 | 544 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Skunavirus | Lactococcus phage 936 group phage Phi13.16 | ||||
| 17986883 | 17986883 | PRJEB75017_P_NODE_11435_length_275_cov_1.158416_g11306_i0 | PRJEB75017 | 11435 | 275 | 1.158416 | 3.185644 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 508 | 1.2499999999999999e-139 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g11306 | i0 | 100 | 1 | 275 | 0 | 100 | 0 | 1 | 275 | 50453 | 50179 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 275 | 508 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17986901 | 17986901 | PRJEB75017_P_NODE_13335_length_256_cov_1.704918_g13206_i0 | PRJEB75017 | 13335 | 256 | 1.704918 | 4.36459008 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 473 | 4.189999999999999e-129 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g13206 | i0 | 100 | 1 | 256 | 0 | 100 | 0 | 1 | 256 | 22414 | 22159 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 256 | 473 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19260940 | 19260940 | PRJEB75017_P_NODE_16836_length_246_cov_0.901734_g16707_i0 | PRJEB75017 | 16836 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2914760312|gb|OR221747.1| | 2832643 | g16707 | i0 | 100 | 6.1260162601626 | 246 | 0 | 100 | 0 | 1 | 246 | 7404 | 7159 | MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence | blastn | 1507 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27413662 | 27413662 | PRJEB75017_P_NODE_14403_length_252_cov_0.871508_g14274_i0 | PRJEB75017 | 14403 | 252 | 0.871508 | 2.19620016 | Pseudomonas phage vB_PaeM_PA5oct | 2163605 | Viruses | Viruses | 83.6 | 6.18e-17 | NR | YP_010679021.1 | 2163605 | g14274 | i0 | 51.9 | 1.80952380952381 | 79 | 38 | 94 | 0 | 245 | 9 | 101 | 179 | YP_010679021.1 hypothetical protein PQE65_gp193 [Pseudomonas phage vB_PaeM_PA5oct] | diamond | 456 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arenbergviridae | Wroclawvirus | Wroclawvirus PA5oct | |||
| 27886960 | 27886960 | PRJEB75017_P_NODE_17085_length_245_cov_0.906977_g16956_i0 | PRJEB75017 | 17085 | 245 | 0.906977 | 2.22209365 | Vibrio phage VvAW1 | 1168281 | Viruses | Viruses | 77.8 | 7.2e-15 | NR | YP_007518375.1 | 1168281 | g16956 | i0 | 59.4 | 0.844897959183673 | 69 | 24 | 82 | 2 | 243 | 43 | 230 | 296 | YP_007518375.1 replication initiation protein [Vibrio phage VvAW1] | diamond | 207 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage VvAW1 | |||||
| 31962294 | 31962294 | PRJEB75017_P_NODE_16218_length_247_cov_0.896552_g16089_i0 | PRJEB75017 | 16218 | 247 | 0.896552 | 2.21448344 | Salicola phage SCTP-2 | 2015814 | Viruses | Viruses | 46.6 | 0.00154 | NR | ASV44093.1 | 2015814 | g16089 | i0 | 50 | 0.510121457489879 | 42 | 20 | 51 | 1 | 12 | 137 | 253 | 293 | ASV44093.1 dihydrofolate-thymadylate synthase-like protein [Salicola phage SCTP-2] | diamond | 126 | 46.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salicola phage SCTP-2 | |||||
| 32595140 | 32595140 | PRJEB75017_P_NODE_7920_length_319_cov_1.268293_g7791_i0 | PRJEB75017 | 7920 | 319 | 1.268293 | 4.04585467 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 64.3 | 1.27e-9 | NR | CAB4185846.1 | 2100421 | g7791 | i0 | 33.3 | 0.987460815047022 | 105 | 61 | 98.7 | 3 | 315 | 1 | 88 | 183 | CAB4185846.1 Glycosyltransferase, DXD sugar-binding motif [uncultured Caudovirales phage] | diamond | 315 | 64.3 | 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);;