contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA640350" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 610463 | 610463 | PRJNA640350_P_NODE_31521_length_168_cov_3.755396_g31360_i0 | PRJNA640350 | 31521 | 168 | 3.755396 | 6.30906528 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 311 | 2.11e-80 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g31360 | i0 | 100 | 1 | 168 | 0 | 100 | 0 | 1 | 168 | 32163 | 32330 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 168 | 311 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1886631 | 1886631 | PRJNA640350_P_NODE_28522_length_177_cov_1.439189_g28361_i0 | PRJNA640350 | 28522 | 177 | 1.439189 | 2.54736453 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 296 | 6.26e-76 | NTclustered | gi|2059836918|tpg|BK040265.1| | 2832643 | g28361 | i0 | 98.225 | 24.4180790960452 | 169 | 3 | 95 | 0 | 9 | 177 | 6620 | 6788 | MAG TPA_asm: Caudoviricetes sp. isolate ctKIJ8, partial genome | blastn | 4322 | 296 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3707240 | 3707240 | PRJNA640350_P_NODE_17463_length_258_cov_1.633188_g17302_i0 | PRJNA640350 | 17463 | 258 | 1.633188 | 4.21362504 | root | 1 | Root_unresolved | Root_unresolved | 422 | 1.55e-113 | NTclustered | gi|2059575236|tpg|BK036590.1| | 2832643 | g17302 | i0 | 96.124 | 7.04651162790698 | 258 | 10 | 100 | 0 | 1 | 258 | 13376 | 13633 | MAG TPA_asm: Caudoviricetes sp. isolate ctCL81, partial genome | blastn | 1818 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4438080 | 4438080 | PRJNA640350_P_NODE_21624_length_210_cov_1.497238_g21463_i0 | PRJNA640350 | 21624 | 210 | 1.497238 | 3.1441998 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 335 | 1.6299999999999994e-87 | NTclustered | gi|2914951766|gb|OR221911.1| | 2832643 | g21463 | i0 | 96.098 | 98.4333333333333 | 205 | 8 | 98 | 0 | 1 | 205 | 11644 | 11848 | MAG: Caudoviricetes sp. isolate MSP0215 genomic sequence | blastn | 20671 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4438263 | 4438263 | PRJNA640350_P_NODE_39804_length_152_cov_2.081301_g39643_i0 | PRJNA640350 | 39804 | 152 | 2.081301 | 3.16357752 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 1.46e-71 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g39643 | i0 | 100 | 1 | 152 | 0 | 100 | 0 | 1 | 152 | 63142 | 63293 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 152 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5714078 | 5714078 | PRJNA640350_P_NODE_32605_length_166_cov_1.343066_g32444_i0 | PRJNA640350 | 32605 | 166 | 1.343066 | 2.22948956 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.69e-79 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g32444 | i0 | 100 | 1 | 166 | 0 | 100 | 0 | 1 | 166 | 43721 | 43556 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 166 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8263747 | 8263747 | PRJNA640350_P_NODE_33127_length_164_cov_3.651852_g32966_i0 | PRJNA640350 | 33127 | 164 | 3.651852 | 5.98903728 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 65.8 | 1.76e-6 | NTclustered | gi|2915004668|gb|OR222365.1| | 2832643 | g32966 | i0 | 97.436 | 0.439024390243902 | 39 | 0 | 24 | 1 | 119 | 157 | 2291 | 2254 | MAG: Caudoviricetes sp. isolate MSP1038 genomic sequence | blastn | 72 | 65.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8263786 | 8263786 | PRJNA640350_P_NODE_38247_length_155_cov_1.404762_g38086_i0 | PRJNA640350 | 38247 | 155 | 1.404762 | 2.1773811 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.17e-62 | NTclustered | gi|2915004530|gb|OR222364.1| | 2832643 | g38086 | i0 | 96.689 | 10.5612903225806 | 151 | 5 | 97 | 0 | 1 | 151 | 13794 | 13644 | MAG: Caudoviricetes sp. isolate MSP1037 genomic sequence | blastn | 1637 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10814552 | 10814552 | PRJNA640350_P_NODE_15029_length_326_cov_1.538721_g14868_i0 | PRJNA640350 | 15029 | 326 | 1.538721 | 5.01623046 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 134 | 1.06e-26 | NTclustered | gi|2056754726|tpg|BK045397.1| | 2832643 | g14868 | i0 | 95.238 | 1.84049079754601 | 84 | 4 | 49 | 0 | 243 | 326 | 29871 | 29954 | MAG TPA_asm: Caudoviricetes sp. isolate ctz3n5, partial genome | blastn | 600 | 134 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14639431 | 14639431 | PRJNA640350_P_NODE_39652_length_152_cov_2.674797_g39491_i0 | PRJNA640350 | 39652 | 152 | 2.674797 | 4.06569144 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 204 | 3.2399999999999996e-48 | NTclustered | gi|2914781736|gb|OR222343.1| | 2832643 | g39491 | i0 | 90.789 | 1.40789473684211 | 152 | 14 | 100 | 0 | 1 | 152 | 45160 | 45009 | MAG: Caudoviricetes sp. isolate MSP1055 genomic sequence | blastn | 214 | 204 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17188305 | 17188305 | PRJNA640350_P_NODE_19754_length_226_cov_1.131980_g19593_i0 | PRJNA640350 | 19754 | 226 | 1.13198 | 2.5582748 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 405 | 1.34e-108 | NTclustered | gi|2915030668|gb|OR222658.1| | 2832643 | g19593 | i0 | 99.115 | 28.7699115044248 | 226 | 1 | 100 | 1 | 1 | 226 | 13356 | 13580 | MAG: Caudoviricetes sp. isolate MSP0273 genomic sequence | blastn | 6502 | 405 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17188422 | 17188422 | PRJNA640350_P_NODE_32014_length_167_cov_2.514493_g31853_i0 | PRJNA640350 | 32014 | 167 | 2.514493 | 4.19920331 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 246 | 5.99e-61 | NTclustered | gi|2915012310|gb|OR222474.1| | 2832643 | g31853 | i0 | 94.375 | 3.92215568862275 | 160 | 9 | 96 | 0 | 6 | 165 | 4392 | 4551 | MAG: Caudoviricetes sp. isolate MSP0914 genomic sequence | blastn | 655 | 246 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17188483 | 17188483 | PRJNA640350_P_NODE_39694_length_152_cov_2.455285_g39533_i0 | PRJNA640350 | 39694 | 152 | 2.455285 | 3.7320332 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 243 | 6.87e-60 | NTclustered | gi|2914927861|gb|OR221512.1| | 2832643 | g39533 | i0 | 95.395 | 2.99342105263158 | 152 | 7 | 100 | 0 | 1 | 152 | 31934 | 31783 | MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence | blastn | 455 | 243 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19737275 | 19737275 | PRJNA640350_P_NODE_34936_length_161_cov_1.356061_g34775_i0 | PRJNA640350 | 34936 | 161 | 1.356061 | 2.18325821 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 298 | 1.56e-76 | NTclustered | gi|2054437256|tpg|BK036062.1| | 2832643 | g34775 | i0 | 100 | 59.9751552795031 | 161 | 0 | 100 | 0 | 1 | 161 | 14003 | 14163 | MAG TPA_asm: Caudoviricetes sp. isolate ctnEG23, partial genome | blastn | 9656 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21012898 | 21012898 | PRJNA640350_P_NODE_33437_length_164_cov_1.362963_g33276_i0 | PRJNA640350 | 33437 | 164 | 1.362963 | 2.23525932 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 276 | 7.46e-70 | NTclustered | gi|2053193164|tpg|BK016525.1| | 2832643 | g33276 | i0 | 97.516 | 3.98170731707317 | 161 | 4 | 98 | 0 | 4 | 164 | 4904 | 4744 | MAG TPA_asm: Caudoviricetes sp. isolate ctnY75, partial genome | blastn | 653 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21012918 | 21012918 | PRJNA640350_P_NODE_36037_length_159_cov_1.053846_g35876_i0 | PRJNA640350 | 36037 | 159 | 1.053846 | 1.67561514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 220 | 3.4099999999999998e-53 | NTclustered | gi|2915004668|gb|OR222365.1| | 2832643 | g35876 | i0 | 92.763 | 0.955974842767296 | 152 | 11 | 96 | 0 | 2 | 153 | 3189 | 3340 | MAG: Caudoviricetes sp. isolate MSP1038 genomic sequence | blastn | 152 | 220 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22287532 | 22287532 | PRJNA640350_P_NODE_29898_length_173_cov_1.236111_g29737_i0 | PRJNA640350 | 29898 | 173 | 1.236111 | 2.13847203 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 320 | 3.61e-83 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g29737 | i0 | 100 | 1 | 173 | 0 | 100 | 0 | 1 | 173 | 38140 | 38312 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 173 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24836734 | 24836734 | PRJNA640350_P_NODE_27100_length_182_cov_1.130719_g26939_i0 | PRJNA640350 | 27100 | 182 | 1.130719 | 2.05790858 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 315 | 1.79e-81 | NTclustered | gi|2057066203|tpg|BK037613.1| | 2832643 | g26939 | i0 | 97.802 | 17.9505494505494 | 182 | 4 | 100 | 0 | 1 | 182 | 43287 | 43106 | MAG TPA_asm: Caudoviricetes sp. isolate ctK7V4, partial genome | blastn | 3267 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24836746 | 24836746 | PRJNA640350_P_NODE_28460_length_177_cov_1.844595_g28299_i0 | PRJNA640350 | 28460 | 177 | 1.844595 | 3.26493315 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 235 | 1.3799999999999998e-57 | NTclustered | gi|2914891224|gb|OR222812.1| | 2832643 | g28299 | i0 | 90.857 | 0.988700564971751 | 175 | 16 | 99 | 0 | 3 | 177 | 48223 | 48049 | MAG: Caudoviricetes sp. isolate MSP0544 genomic sequence | blastn | 175 | 235 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24836769 | 24836769 | PRJNA640350_P_NODE_30360_length_171_cov_2.739437_g30199_i0 | PRJNA640350 | 30360 | 171 | 2.739437 | 4.68443727 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g30199 | i0 | 100 | 1 | 171 | 0 | 100 | 0 | 1 | 171 | 22103 | 22273 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 171 | 316 | 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);;