contig_metadata
12 rows where bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370193 | 370193 | PRJNA270367_P_NODE_46301_length_162_cov_0.920354_g46096_i0 | PRJNA270367 | 46301 | 162 | 0.920354 | 1.49097348 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 182 | 1.6499999999999996e-41 | NTclustered | gi|2914993804|gb|OR222211.1| | 2832643 | g46096 | i0 | 86.957 | 0.993827160493827 | 161 | 21 | 99 | 0 | 2 | 162 | 53129 | 53289 | MAG: Caudoviricetes sp. isolate MSP0761 genomic sequence | blastn | 161 | 182 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4197013 | 4197013 | PRJNA270367_P_NODE_16224_length_312_cov_3.543726_g16019_i0 | PRJNA270367 | 16224 | 312 | 3.543726 | 11.05642512 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 67.6 | 1.04e-6 | NTclustered | gi|1971775256|gb|MW460245.1| | 2805747 | g16019 | i0 | 100 | 0.483974358974359 | 36 | 0 | 12 | 0 | 134 | 169 | 619 | 654 | Burkholderia phage BCSR5, complete genome | blastn | 151 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 10574186 | 10574186 | PRJNA270367_P_NODE_45269_length_163_cov_0.912281_g45064_i0 | PRJNA270367 | 45269 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g45064 | i0 | 100 | 1 | 163 | 0 | 100 | 0 | 1 | 163 | 25373 | 25535 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 163 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11848655 | 11848655 | PRJNA270367_P_NODE_27910_length_214_cov_0.945455_g27705_i0 | PRJNA270367 | 27910 | 214 | 0.945455 | 2.0232737 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 396 | 7.559999999999996e-106 | NTclustered | gi|2054436092|tpg|BK036040.1| | 2832643 | g27705 | i0 | 100 | 2.98598130841122 | 214 | 0 | 100 | 0 | 1 | 214 | 29891 | 29678 | MAG TPA_asm: Caudoviricetes sp. isolate ctZQF2, partial genome | blastn | 639 | 396 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11848656 | 11848656 | PRJNA270367_P_NODE_27930_length_214_cov_0.884848_g27725_i0 | PRJNA270367 | 27930 | 214 | 0.884848 | 1.89357472 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 357 | 3.5699999999999996e-94 | NTclustered | gi|2052187283|tpg|BK055844.1| | 2832643 | g27725 | i0 | 96.729 | 1.98130841121495 | 214 | 7 | 100 | 0 | 1 | 214 | 5009 | 5222 | MAG TPA_asm: Caudoviricetes sp. isolate cty0V13, partial genome | blastn | 424 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14399191 | 14399191 | PRJNA270367_P_NODE_45232_length_163_cov_0.929825_g45027_i0 | PRJNA270367 | 45232 | 163 | 0.929825 | 1.51561475 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2054436092|tpg|BK036040.1| | 2832643 | g45027 | i0 | 100 | 3 | 163 | 0 | 100 | 0 | 1 | 163 | 35597 | 35759 | MAG TPA_asm: Caudoviricetes sp. isolate ctZQF2, partial genome | blastn | 489 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18221794 | 18221794 | PRJNA270367_P_NODE_38155_length_173_cov_1.137097_g37950_i0 | PRJNA270367 | 38155 | 173 | 1.137097 | 1.96717781 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 315 | 1.68e-81 | NTclustered | gi|2058061264|tpg|BK042747.1| | 2832643 | g37950 | i0 | 99.422 | 2.99421965317919 | 173 | 1 | 100 | 0 | 1 | 173 | 3401 | 3229 | MAG TPA_asm: Caudoviricetes sp. isolate ctWpO1, partial genome | blastn | 518 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18221831 | 18221831 | PRJNA270367_P_NODE_41275_length_167_cov_1.322034_g41070_i0 | PRJNA270367 | 41275 | 167 | 1.322034 | 2.20779678 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|2059682310|tpg|BK029302.1| | 2832643 | g41070 | i0 | 99.401 | 5.72455089820359 | 167 | 1 | 100 | 0 | 1 | 167 | 41766 | 41600 | MAG TPA_asm: Caudoviricetes sp. isolate ctpyl1, partial genome | blastn | 956 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23322166 | 23322166 | PRJNA270367_P_NODE_40639_length_168_cov_0.873950_g40434_i0 | PRJNA270367 | 40639 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 4.56e-77 | NTclustered | gi|2059789084|tpg|BK039506.1| | 2832643 | g40434 | i0 | 98.81 | 1 | 168 | 2 | 100 | 0 | 1 | 168 | 27429 | 27262 | MAG TPA_asm: Caudoviricetes sp. isolate ctCfj1, partial genome | blastn | 168 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27074017 | 27074017 | PRJNA270367_P_NODE_32782_length_192_cov_1.104895_g32577_i0 | PRJNA270367 | 32782 | 192 | 1.104895 | 2.1213984 | phage Lak_Megaphage_RVC_AP1_GC26 | 3109224 | Viruses | Viruses | 44.3 | 0.00551 | NR | WQJ54389.1 | 3109224 | g32577 | i0 | 39.6 | 0.828125 | 53 | 30 | 79.7 | 1 | 168 | 16 | 142 | 194 | WQJ54389.1 MAG: nucleotidyltransferase [phage Lak_Megaphage_RVC_AP1_GC26] | diamond | 159 | 44.3 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP1_GC26 | ||||
| 30737427 | 30737427 | PRJNA270367_P_NODE_45574_length_163_cov_0.912281_g45369_i0 | PRJNA270367 | 45574 | 163 | 0.912281 | 1.48701803 | Pseudomonas phage PaBG | 1335230 | Viruses | Viruses | 58.2 | 6.96e-9 | NR | YP_008433468.1 | 1335230 | g45369 | i0 | 52.3 | 0.809815950920245 | 44 | 21 | 81 | 0 | 4 | 135 | 90 | 133 | YP_008433468.1 hypothetical protein O152_gp138 [Pseudomonas phage PaBG] | diamond | 132 | 58.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Baikalvirus | Baikalvirus PaBG | ||||
| 32160680 | 32160680 | PRJNA270367_P_NODE_46438_length_162_cov_0.920354_g46233_i0 | PRJNA270367 | 46438 | 162 | 0.920354 | 1.49097348 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 86.3 | 1.35e-19 | NR | XOR53229.1 | 2832643 | g46233 | i0 | 88.7 | 0.981481481481482 | 53 | 6 | 98.1 | 0 | 161 | 3 | 96 | 148 | XOR53229.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 159 | 86.3 | 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);;