contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA1008624" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153971 | 153971 | PRJNA1008624_P_NODE_1401_length_733_cov_2.558480_g1242_i0 | PRJNA1008624 | 1401 | 733 | 2.55848 | 18.7536584 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 876 | 0 | NTclustered | gi|2053033389|tpg|BK024106.1| | 2832643 | g1242 | i0 | 96.591 | 11.0763983628922 | 528 | 18 | 72 | 0 | 186 | 713 | 1 | 528 | MAG TPA_asm: Caudoviricetes sp. isolate ct1083, partial genome | blastn | 8119 | 876 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 154607 | 154607 | PRJNA1008624_P_NODE_481_length_1183_cov_3.948854_g407_i0 | PRJNA1008624 | 481 | 1183 | 3.948854 | 46.71494282 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1149 | 0 | NTclustered | gi|2053033389|tpg|BK024106.1| | 2832643 | g407 | i0 | 91.538 | 10.6754015215554 | 839 | 63 | 99 | 6 | 4 | 839 | 1229 | 2062 | MAG TPA_asm: Caudoviricetes sp. isolate ct1083, partial genome | blastn | 12629 | 1149 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1429179 | 1429179 | PRJNA1008624_P_NODE_2_length_8456_cov_7.761151_g1_i0 | PRJNA1008624 | 2 | 8456 | 7.761151 | 656.28292856 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 12558 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g1 | i0 | 99.393 | 1.13256859035005 | 6924 | 26 | 99 | 3 | 1549 | 8456 | 12330 | 5407 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 9577 | 12558 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6532067 | 6532067 | PRJNA1008624_P_NODE_12426_length_237_cov_1.962766_g12238_i0 | PRJNA1008624 | 12426 | 237 | 1.962766 | 4.65175542 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 287 | 5.359999999999999e-73 | NTclustered | gi|2053033389|tpg|BK024106.1| | 2832643 | g12238 | i0 | 89.13 | 0.970464135021097 | 230 | 25 | 97 | 0 | 4 | 233 | 1122 | 893 | MAG TPA_asm: Caudoviricetes sp. isolate ct1083, partial genome | blastn | 230 | 287 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7806637 | 7806637 | PRJNA1008624_P_NODE_17907_length_201_cov_2.000000_g17719_i0 | PRJNA1008624 | 17907 | 201 | 2 | 4.02 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 1.2199999999999998e-73 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g17719 | i0 | 99.371 | 0.791044776119403 | 159 | 1 | 79 | 0 | 40 | 198 | 1513 | 1671 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 159 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7807151 | 7807151 | PRJNA1008624_P_NODE_447_length_1215_cov_5.668096_g375_i0 | PRJNA1008624 | 447 | 1215 | 5.668096 | 68.8673664 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 2228 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g375 | i0 | 99.835 | 0.997530864197531 | 1212 | 2 | 99 | 0 | 1 | 1212 | 5393 | 4182 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 1212 | 2228 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7807208 | 7807208 | PRJNA1008624_P_NODE_6087_length_341_cov_1.373288_g5899_i0 | PRJNA1008624 | 6087 | 341 | 1.373288 | 4.68291208 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 451 | 2.72e-122 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g5899 | i0 | 90.588 | 1.10557184750733 | 340 | 32 | 99 | 0 | 2 | 341 | 23863 | 23524 | Vibrio phage VP882, complete genome | blastn | 377 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 9081340 | 9081340 | PRJNA1008624_P_NODE_108_length_2273_cov_4.596673_g74_i0 | PRJNA1008624 | 108 | 2273 | 4.596673 | 104.48237729 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 4159 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g74 | i0 | 99.779 | 1.06687197536296 | 2267 | 5 | 99 | 0 | 4 | 2270 | 21869 | 19603 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 2425 | 4159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9081464 | 9081464 | PRJNA1008624_P_NODE_14568_length_221_cov_1.174419_g14380_i0 | PRJNA1008624 | 14568 | 221 | 1.174419 | 2.59546599 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 207 | 3.95e-49 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g14380 | i0 | 87.845 | 0.819004524886878 | 181 | 16 | 80 | 6 | 3 | 179 | 32801 | 32979 | Vibrio phage VP882, complete genome | blastn | 181 | 207 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 9081474 | 9081474 | PRJNA1008624_P_NODE_148_length_2035_cov_5.179255_g104_i0 | PRJNA1008624 | 148 | 2035 | 5.179255 | 105.39783925 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 2752 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g104 | i0 | 99.866 | 0.992137592137592 | 1496 | 2 | 99 | 0 | 4 | 1499 | 2000 | 3495 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 2019 | 2752 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9082229 | 9082229 | PRJNA1008624_P_NODE_8_length_6177_cov_8.374184_g5_i0 | PRJNA1008624 | 8 | 6177 | 8.374184 | 517.27334568 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 6403 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g5 | i0 | 99.714 | 0.969564513517889 | 3497 | 10 | 97 | 0 | 1 | 3497 | 27659 | 31155 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 5989 | 6403 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12908440 | 12908440 | PRJNA1008624_P_NODE_9311_length_274_cov_2.080000_g9123_i0 | PRJNA1008624 | 9311 | 274 | 2.08 | 5.6992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 501 | 2.08e-137 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g9123 | i0 | 99.635 | 1 | 274 | 1 | 100 | 0 | 1 | 274 | 21866 | 22139 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 274 | 501 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14183111 | 14183111 | PRJNA1008624_P_NODE_32_length_3793_cov_6.195246_g20_i0 | PRJNA1008624 | 32 | 3793 | 6.195246 | 234.98568078 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 6942 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g20 | i0 | 99.71 | 1.39546533087266 | 3792 | 11 | 99 | 0 | 1 | 3792 | 17992 | 14201 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 5293 | 6942 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15457207 | 15457207 | PRJNA1008624_P_NODE_4993_length_380_cov_0.942598_g4806_i0 | PRJNA1008624 | 4993 | 380 | 0.942598 | 3.5818724 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 135 | 3.5e-27 | NTclustered | gi|2054557975|tpg|BK048184.1| | 2832643 | g4806 | i0 | 100 | 0.192105263157895 | 73 | 0 | 19 | 0 | 306 | 378 | 14589 | 14517 | MAG TPA_asm: Caudoviricetes sp. isolate cthMZ1, partial genome | blastn | 73 | 135 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16730890 | 16730890 | PRJNA1008624_P_NODE_14_length_5310_cov_7.533929_g9_i0 | PRJNA1008624 | 14 | 5310 | 7.533929 | 400.0516299 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 9136 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g9 | i0 | 99.739 | 0.997551789077213 | 4986 | 13 | 99 | 0 | 4 | 4989 | 22123 | 27108 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 5297 | 9136 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19279878 | 19279878 | PRJNA1008624_P_NODE_2616_length_534_cov_2.179381_g2436_i0 | PRJNA1008624 | 2616 | 534 | 2.179381 | 11.63789454 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 693 | 0 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g2436 | i0 | 90.226 | 0.99625468164794 | 532 | 50 | 99 | 2 | 4 | 534 | 14933 | 15463 | Vibrio phage VP882, complete genome | blastn | 532 | 693 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 19279990 | 19279990 | PRJNA1008624_P_NODE_316_length_1446_cov_7.944882_g255_i0 | PRJNA1008624 | 316 | 1446 | 7.944882 | 114.88299372 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 2649 | 0 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g255 | i0 | 99.723 | 1.28769017980636 | 1446 | 4 | 100 | 0 | 1 | 1446 | 18088 | 19533 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 1862 | 2649 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20555213 | 20555213 | PRJNA1008624_P_NODE_16297_length_210_cov_1.472050_g16109_i0 | PRJNA1008624 | 16297 | 210 | 1.47205 | 3.091305 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.24e-103 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g16109 | i0 | 100 | 1 | 210 | 0 | 100 | 0 | 1 | 210 | 2018 | 1809 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 210 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20555737 | 20555737 | PRJNA1008624_P_NODE_3777_length_441_cov_2.079082_g3591_i0 | PRJNA1008624 | 3777 | 441 | 2.079082 | 9.16875162 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 357 | 8.069999999999997e-94 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g3591 | i0 | 82.995 | 0.893424036281179 | 394 | 67 | 89 | 0 | 1 | 394 | 12647 | 13040 | Vibrio phage VP882, complete genome | blastn | 394 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 21830715 | 21830715 | PRJNA1008624_P_NODE_13238_length_230_cov_4.513812_g13050_i0 | PRJNA1008624 | 13238 | 230 | 4.513812 | 10.3817676 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 422 | 1.36e-113 | NTclustered | gi|2057049861|tpg|BK049444.1| | 2832643 | g13050 | i0 | 100 | 0.991304347826087 | 228 | 0 | 99 | 0 | 1 | 228 | 14204 | 13977 | MAG TPA_asm: Caudoviricetes sp. isolate ctQlo1, partial genome | blastn | 228 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21830716 | 21830716 | PRJNA1008624_P_NODE_13298_length_230_cov_1.353591_g13110_i0 | PRJNA1008624 | 13298 | 230 | 1.353591 | 3.1132593 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 156 | 1.52e-33 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g13110 | i0 | 81.026 | 1.03913043478261 | 195 | 37 | 85 | 0 | 1 | 195 | 21573 | 21767 | Vibrio phage VP882, complete genome | blastn | 239 | 156 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 21831217 | 21831217 | PRJNA1008624_P_NODE_31338_length_166_cov_0.888889_g31150_i0 | PRJNA1008624 | 31338 | 166 | 0.888889 | 1.47555574 | Rhodoferax phage P26218 | 1636270 | Viruses | Viruses | 244 | 2.1399999999999998e-60 | NTclustered | gi|985757592|ref|NC_029061.1| | 1636270 | g31150 | i0 | 94.34 | 2.74096385542169 | 159 | 9 | 96 | 0 | 4 | 162 | 32377 | 32535 | Rhodoferax phage P26218, complete genome | blastn | 455 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhodoferax phage P26218 | |||||
| 21831285 | 21831285 | PRJNA1008624_P_NODE_35298_length_163_cov_0.912281_g35110_i0 | PRJNA1008624 | 35298 | 163 | 0.912281 | 1.48701803 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 95.3 | 2.23e-15 | NTclustered | gi|1839175886|emb|LR796718.1| | 2100421 | g35110 | i0 | 83.333 | 1.4601226993865 | 102 | 17 | 63 | 0 | 33 | 134 | 34388 | 34489 | uncultured Caudovirales phage genome assembly | blastn | 238 | 95.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 24380414 | 24380414 | PRJNA1008624_P_NODE_28980_length_168_cov_0.873950_g28792_i0 | PRJNA1008624 | 28980 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.73e-79 | NTclustered | gi|2906149211|gb|PQ646444.1| | 2832643 | g28792 | i0 | 100 | 1.1547619047619 | 166 | 0 | 99 | 0 | 1 | 166 | 5292 | 5127 | MAG: Caudoviricetes sp. isolate k127_3058080 genomic sequence | blastn | 194 | 307 | 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);;