contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA474426" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 447523 | 447523 | PRJNA474426_P_NODE_2241_length_660_cov_7.111293_g2090_i0 | PRJNA474426 | 2241 | 660 | 7.111293 | 46.9345338 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 5.54e-122 | NTclustered | gi|2906143737|gb|PQ646059.1| | 2832643 | g2090 | i0 | 95.122 | 0.434848484848485 | 287 | 13 | 43 | 1 | 13 | 298 | 2181 | 1895 | MAG: Caudoviricetes sp. isolate k127_1709622 genomic sequence | blastn | 287 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 447610 | 447610 | PRJNA474426_P_NODE_5281_length_468_cov_2.642005_g5086_i0 | PRJNA474426 | 5281 | 468 | 2.642005 | 12.3645834 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 1.15e-67 | NTclustered | gi|2906143291|gb|PQ646020.1| | 2832643 | g5086 | i0 | 86.831 | 0.519230769230769 | 243 | 31 | 52 | 1 | 184 | 426 | 32519 | 32278 | MAG: Caudoviricetes sp. isolate k127_2695563 genomic sequence | blastn | 243 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2998256 | 2998256 | PRJNA474426_P_NODE_33243_length_166_cov_1.547009_g33038_i0 | PRJNA474426 | 33243 | 166 | 1.547009 | 2.56803494 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.69e-79 | NTclustered | gi|2054685503|tpg|BK052689.1| | 2832643 | g33038 | i0 | 100 | 8.99397590361446 | 166 | 0 | 100 | 0 | 1 | 166 | 20356 | 20521 | MAG TPA_asm: Caudoviricetes sp. isolate ctjee9, partial genome | blastn | 1493 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4274405 | 4274405 | PRJNA474426_P_NODE_14084_length_278_cov_1.589520_g13879_i0 | PRJNA474426 | 14084 | 278 | 1.58952 | 4.4188656 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 2.2099999999999994e-107 | NTclustered | gi|2915004039|gb|OR222348.1| | 2832643 | g13879 | i0 | 93.657 | 1.35971223021583 | 268 | 17 | 96 | 0 | 11 | 278 | 11500 | 11233 | MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence | blastn | 378 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4274488 | 4274488 | PRJNA474426_P_NODE_31884_length_169_cov_0.866667_g31679_i0 | PRJNA474426 | 31884 | 169 | 0.866667 | 1.46466723 | Pseudomonas phage ZRG1 | 3032262 | Viruses | Viruses | 86.1 | 1.39e-12 | NTclustered | gi|2512630189|gb|OQ504961.1| | 3032262 | g31679 | i0 | 85.366 | 0.733727810650888 | 82 | 12 | 49 | 0 | 6 | 87 | 10893 | 10974 | Pseudomonas phage ZRG1, complete genome | blastn | 124 | 86.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage ZRG1 | |||||
| 5551182 | 5551182 | PRJNA474426_P_NODE_34005_length_165_cov_1.344828_g33800_i0 | PRJNA474426 | 34005 | 165 | 1.344828 | 2.2189662 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 265 | 1.6299999999999998e-66 | NTclustered | gi|2915004039|gb|OR222348.1| | 2832643 | g33800 | i0 | 95.732 | 2.94545454545455 | 164 | 7 | 99 | 0 | 1 | 164 | 21277 | 21440 | MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence | blastn | 486 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6825101 | 6825101 | PRJNA474426_P_NODE_32426_length_168_cov_0.865546_g32221_i0 | PRJNA474426 | 32426 | 168 | 0.865546 | 1.45411728 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 145 | 2.26e-30 | NTclustered | gi|1839181791|emb|LR796810.1| | 2100421 | g32221 | i0 | 93.75 | 0.571428571428571 | 96 | 6 | 57 | 0 | 73 | 168 | 16445 | 16540 | uncultured Caudovirales phage genome assembly | blastn | 96 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 6825163 | 6825163 | PRJNA474426_P_NODE_9006_length_360_cov_1.700965_g8801_i0 | PRJNA474426 | 9006 | 360 | 1.700965 | 6.123474 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 1.39e-95 | NTclustered | gi|2054707515|tpg|BK053147.1| | 2832643 | g8801 | i0 | 89.109 | 1.83611111111111 | 303 | 18 | 98 | 6 | 7 | 309 | 5440 | 5153 | MAG TPA_asm: Caudoviricetes sp. isolate ctp6L2, partial genome | blastn | 661 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9375246 | 9375246 | PRJNA474426_P_NODE_14268_length_276_cov_1.431718_g14063_i0 | PRJNA474426 | 14268 | 276 | 1.431718 | 3.95154168 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 110 | 1.48e-19 | NTclustered | gi|2488203215|emb|OX383243.1| | 2100421 | g14063 | i0 | 91.358 | 0.58695652173913 | 81 | 5 | 29 | 2 | 59 | 138 | 49474 | 49553 | MAG: uncultured Caudovirales phage genome assembly, chromosome: HRSG-E3-C25 | blastn | 162 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 9375256 | 9375256 | PRJNA474426_P_NODE_15868_length_258_cov_2.354067_g15663_i0 | PRJNA474426 | 15868 | 258 | 2.354067 | 6.07349286 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 220 | 6.08e-53 | NTclustered | gi|2906143663|gb|PQ646058.1| | 2832643 | g15663 | i0 | 86.341 | 14.5387596899225 | 205 | 25 | 78 | 3 | 57 | 258 | 32515 | 32311 | MAG: Caudoviricetes sp. isolate k127_1052599 genomic sequence | blastn | 3751 | 220 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11926062 | 11926062 | PRJNA474426_P_NODE_14590_length_272_cov_1.560538_g14385_i0 | PRJNA474426 | 14590 | 272 | 1.560538 | 4.24466336 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 80.5 | 1.14e-10 | NTclustered | gi|1839179596|emb|LR796775.1| | 2100421 | g14385 | i0 | 90.164 | 0.224264705882353 | 61 | 6 | 22 | 0 | 90 | 150 | 29713 | 29773 | uncultured Caudovirales phage genome assembly | blastn | 61 | 80.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 11926176 | 11926176 | PRJNA474426_P_NODE_34230_length_165_cov_0.896552_g34025_i0 | PRJNA474426 | 34230 | 165 | 0.896552 | 1.4793108 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 230 | 5.939999999999998e-56 | NTclustered | gi|2057054943|tpg|BK049556.1| | 2832643 | g34025 | i0 | 94.595 | 7.07878787878788 | 148 | 8 | 90 | 0 | 5 | 152 | 34564 | 34417 | MAG TPA_asm: Caudoviricetes sp. isolate ctZhZ5, partial genome | blastn | 1168 | 230 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11926230 | 11926230 | PRJNA474426_P_NODE_830_length_930_cov_4.670829_g737_i0 | PRJNA474426 | 830 | 930 | 4.670829 | 43.4387097 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 737 | 0 | NTclustered | gi|2057054943|tpg|BK049556.1| | 2832643 | g737 | i0 | 95.455 | 18.0806451612903 | 462 | 21 | 98 | 0 | 466 | 927 | 33410 | 33871 | MAG TPA_asm: Caudoviricetes sp. isolate ctZhZ5, partial genome | blastn | 16815 | 737 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13201088 | 13201088 | PRJNA474426_P_NODE_19371_length_228_cov_1.106145_g19166_i0 | PRJNA474426 | 19371 | 228 | 1.106145 | 2.5220106 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 263 | 8.629999999999999e-66 | NTclustered | gi|2906154269|gb|PQ646784.1| | 2832643 | g19166 | i0 | 89.423 | 0.912280701754386 | 208 | 22 | 91 | 0 | 21 | 228 | 32316 | 32523 | MAG: Caudoviricetes sp. isolate k127_343611 genomic sequence | blastn | 208 | 263 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14475987 | 14475987 | PRJNA474426_P_NODE_1712_length_728_cov_1.907216_g1571_i0 | PRJNA474426 | 1712 | 728 | 1.907216 | 13.88453248 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1096 | 0 | NTclustered | gi|2058002439|tpg|BK047154.1| | 2832643 | g1571 | i0 | 93.819 | 18.9368131868132 | 728 | 45 | 100 | 0 | 1 | 728 | 39806 | 39079 | MAG TPA_asm: Caudoviricetes sp. isolate cti0R4, partial genome | blastn | 13786 | 1096 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15750109 | 15750109 | PRJNA474426_P_NODE_20253_length_222_cov_1.450867_g20048_i0 | PRJNA474426 | 20253 | 222 | 1.450867 | 3.22092474 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 399 | 6.099999999999999e-107 | NTclustered | gi|2053226101|tpg|BK035372.1| | 2831613 | g20048 | i0 | 99.099 | 1 | 222 | 2 | 100 | 0 | 1 | 222 | 2203 | 2424 | MAG TPA_asm: Herelleviridae sp. isolate ctcri4, partial genome | blastn | 222 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae 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);;