contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA807347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 806297 | 806297 | PRJNA807347_P_NODE_15261_length_245_cov_0.906977_g15158_i0 | PRJNA807347 | 15261 | 245 | 0.906977 | 2.22209365 | Syrbvirus R1 | 3060725 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|2438003991|ref|NC_070775.1| | 2848881 | g15158 | i0 | 99.184 | 1 | 245 | 2 | 100 | 0 | 1 | 245 | 34559 | 34315 | Microbacterium phage vB_MoxS-R1, complete genome | blastn | 245 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Syrbvirus | Syrbvirus R1 | ||||
| 2082028 | 2082028 | PRJNA807347_P_NODE_14382_length_247_cov_0.896552_g14279_i0 | PRJNA807347 | 14382 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g14279 | i0 | 100 | 1 | 247 | 0 | 100 | 0 | 1 | 247 | 38959 | 38713 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 247 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2498174 | 2498174 | PRJNA807347_P_NODE_6182_length_330_cov_1.132296_g6079_i0 | PRJNA807347 | 6182 | 330 | 1.132296 | 3.7365768 | Tequatrovirus | 10663 | Viruses | Viruses | 599 | 8.849999999999995e-167 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g6079 | i0 | 99.394 | 99.9939393939394 | 330 | 2 | 100 | 0 | 1 | 330 | 12757 | 13086 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 32998 | 599 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 3357241 | 3357241 | PRJNA807347_P_NODE_3843_length_424_cov_1.943020_g3740_i0 | PRJNA807347 | 3843 | 424 | 1.94302 | 8.2384048 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 486 | 9.449999999999999e-133 | NTclustered | gi|2059798693|tpg|BK039666.1| | 2832643 | g3740 | i0 | 95.41 | 1.70990566037736 | 305 | 14 | 72 | 0 | 120 | 424 | 2266 | 2570 | MAG TPA_asm: Caudoviricetes sp. isolate ctWdx1, partial genome | blastn | 725 | 486 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4634754 | 4634754 | PRJNA807347_P_NODE_4864_length_374_cov_1.498339_g4761_i0 | PRJNA807347 | 4864 | 374 | 1.498339 | 5.60378786 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 691 | 0 | NTclustered | gi|2059607056|tpg|BK037221.1| | 2832643 | g4761 | i0 | 100 | 5.62299465240642 | 374 | 0 | 100 | 0 | 1 | 374 | 15613 | 15240 | MAG TPA_asm: Caudoviricetes sp. isolate ctHhr1, partial genome | blastn | 2103 | 691 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8459247 | 8459247 | PRJNA807347_P_NODE_11587_length_253_cov_1.722222_g11484_i0 | PRJNA807347 | 11587 | 253 | 1.722222 | 4.35722166 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 368 | 2.01e-97 | NTclustered | gi|2052231209|tpg|BK056717.1| | 2832643 | g11484 | i0 | 92.885 | 1 | 253 | 18 | 100 | 0 | 1 | 253 | 15235 | 14983 | MAG TPA_asm: Caudoviricetes sp. isolate ctN2L1, partial genome | blastn | 253 | 368 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8459308 | 8459308 | PRJNA807347_P_NODE_1947_length_599_cov_2.334601_g1846_i0 | PRJNA807347 | 1947 | 599 | 2.334601 | 13.98425999 | Phabquatrovirus PHB04 | 2734129 | Viruses | Viruses | 283 | 1.93e-71 | NTclustered | gi|1842005449|ref|NC_047861.1| | 2029657 | g1846 | i0 | 79.469 | 0.691151919866444 | 414 | 73 | 68 | 9 | 191 | 598 | 23611 | 23204 | Bordetella phage vB_BbrM_PHB04, complete genome | blastn | 414 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 9734365 | 9734365 | PRJNA807347_P_NODE_7528_length_298_cov_1.026667_g7425_i0 | PRJNA807347 | 7528 | 298 | 1.026667 | 3.05946766 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 100 | 9.75e-17 | NTclustered | gi|1839175104|emb|LR796706.1| | 2100421 | g7425 | i0 | 80.741 | 0.939597315436242 | 135 | 20 | 44 | 3 | 165 | 296 | 21429 | 21560 | uncultured Caudovirales phage genome assembly | blastn | 280 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 11010114 | 11010114 | PRJNA807347_P_NODE_12269_length_251_cov_1.640449_g12166_i0 | PRJNA807347 | 12269 | 251 | 1.640449 | 4.11752699 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g12166 | i0 | 99.602 | 1 | 251 | 1 | 100 | 0 | 1 | 251 | 25091 | 25341 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 251 | 459 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 13559926 | 13559926 | PRJNA807347_P_NODE_3651_length_436_cov_2.220386_g3548_i0 | PRJNA807347 | 3651 | 436 | 2.220386 | 9.68088296 | Siphoviridae sp. cttFh17 | 2826491 | Viruses | Viruses | 52.8 | 0.042 | NTclustered | gi|2051107155|tpg|BK015176.1| | 2826491 | g3548 | i0 | 100 | 0.0642201834862385 | 28 | 0 | 6 | 0 | 189 | 216 | 20797 | 20770 | MAG TPA_asm: Siphoviridae sp. cttFh17, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. cttFh17 | |||||
| 14834518 | 14834518 | PRJNA807347_P_NODE_14212_length_247_cov_1.298851_g14109_i0 | PRJNA807347 | 14212 | 247 | 1.298851 | 3.20816197 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2059607056|tpg|BK037221.1| | 2832643 | g14109 | i0 | 100 | 3.09716599190283 | 247 | 0 | 100 | 0 | 1 | 247 | 3552 | 3306 | MAG TPA_asm: Caudoviricetes sp. isolate ctHhr1, partial genome | blastn | 765 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15250571 | 15250571 | PRJNA807347_P_NODE_11672_length_253_cov_0.866667_g11569_i0 | PRJNA807347 | 11672 | 253 | 0.866667 | 2.19266751 | Haloferacalesvirus | 2843389 | Viruses | Viruses | 457 | 4.16e-124 | NTclustered | gi|509139559|ref|NC_021320.1| | 2847107 | g11569 | i0 | 99.209 | 22.7588932806324 | 253 | 2 | 100 | 0 | 1 | 253 | 70658 | 70910 | Halorubrum tailed phage 5, complete genome | blastn | 5758 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thumleimavirales | Hafunaviridae | Haloferacalesvirus | Haloferacalesvirus pyrstotum | ||
| 16108693 | 16108693 | PRJNA807347_P_NODE_11633_length_253_cov_1.255556_g11530_i0 | PRJNA807347 | 11633 | 253 | 1.255556 | 3.17655668 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 462 | 8.95e-126 | NTclustered | gi|2059607056|tpg|BK037221.1| | 2832643 | g11530 | i0 | 99.605 | 5.88932806324111 | 253 | 1 | 100 | 0 | 1 | 253 | 18110 | 17858 | MAG TPA_asm: Caudoviricetes sp. isolate ctHhr1, partial genome | blastn | 1490 | 462 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17384607 | 17384607 | PRJNA807347_P_NODE_2154_length_572_cov_1.492986_g2051_i0 | PRJNA807347 | 2154 | 572 | 1.492986 | 8.53987992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 195 | 8.86e-45 | NTclustered | gi|2914866336|gb|OR222585.1| | 2832643 | g2051 | i0 | 76.88 | 5.05594405594406 | 359 | 73 | 62 | 10 | 2 | 355 | 20697 | 20344 | MAG: Caudoviricetes sp. isolate MSP0348 genomic sequence | blastn | 2892 | 195 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18657640 | 18657640 | PRJNA807347_P_NODE_11115_length_257_cov_1.695652_g11012_i0 | PRJNA807347 | 11115 | 257 | 1.695652 | 4.35782564 | Phabquatrovirus PHB04 | 2734129 | Viruses | Viruses | 239 | 1.67e-58 | NTclustered | gi|1842005449|ref|NC_047861.1| | 2029657 | g11012 | i0 | 83.794 | 0.98443579766537 | 253 | 39 | 98 | 2 | 6 | 257 | 24124 | 23873 | Bordetella phage vB_BbrM_PHB04, complete genome | blastn | 253 | 239 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 18657683 | 18657683 | PRJNA807347_P_NODE_15255_length_245_cov_0.906977_g15152_i0 | PRJNA807347 | 15255 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 409 | 1.1399999999999998e-109 | NTclustered | gi|2057108184|tpg|BK038467.1| | 2832643 | g15152 | i0 | 96.735 | 3 | 245 | 8 | 100 | 0 | 1 | 245 | 38485 | 38241 | MAG TPA_asm: Caudoviricetes sp. isolate ctC7m8, partial genome | blastn | 735 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18657701 | 18657701 | PRJNA807347_P_NODE_17175_length_242_cov_0.911243_g17072_i0 | PRJNA807347 | 17175 | 242 | 0.911243 | 2.20520806 | Xanthomonas phage AhaSv | 3110507 | Viruses | Viruses | 364 | 2.4699999999999992e-96 | NTclustered | gi|2647401157|gb|OR820514.1| | 3110507 | g17072 | i0 | 94.85 | 6.94628099173554 | 233 | 12 | 96 | 0 | 10 | 242 | 24144 | 23912 | Xanthomonas phage AhaSv, complete genome | blastn | 1681 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Casjensviridae | Salvovirus | Xanthomonas phage AhaSv | |||
| 19933021 | 19933021 | PRJNA807347_P_NODE_8996_length_278_cov_1.648780_g8893_i0 | PRJNA807347 | 8996 | 278 | 1.64878 | 4.5836084 | Phabquatrovirus PHB04 | 2734129 | Viruses | Viruses | 143 | 1.48e-29 | NTclustered | gi|1842005449|ref|NC_047861.1| | 2029657 | g8893 | i0 | 77.481 | 0.942446043165468 | 262 | 44 | 91 | 13 | 22 | 275 | 29196 | 28942 | Bordetella phage vB_BbrM_PHB04, complete genome | blastn | 262 | 143 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 21208557 | 21208557 | PRJNA807347_P_NODE_12637_length_251_cov_0.865169_g12534_i0 | PRJNA807347 | 12637 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 211 | 3.55e-50 | NTclustered | gi|2915003778|gb|OR222346.1| | 2832643 | g12534 | i0 | 85.294 | 2.39840637450199 | 204 | 30 | 81 | 0 | 1 | 204 | 39319 | 39116 | MAG: Caudoviricetes sp. isolate MSP1057 genomic sequence | blastn | 602 | 211 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25032735 | 25032735 | PRJNA807347_P_NODE_14960_length_246_cov_0.895954_g14857_i0 | PRJNA807347 | 14960 | 246 | 0.895954 | 2.20404684 | Caulimovirus sp. | 2692413 | Viruses | Viruses | 340 | 4.2299999999999996e-89 | NTclustered | gi|2744499381|gb|PP874931.1| | 2692413 | g14857 | i0 | 92.766 | 0.955284552845528 | 235 | 17 | 96 | 0 | 12 | 246 | 5053 | 4819 | Caulimovirus sp. isolate MSa2 zinc finger protein, polyprotein, viroplasmin, movement protein, and NADH-dehyrogenase subunit F genes, complete cds | blastn | 235 | 340 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Caulimovirus | Caulimovirus 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);;