contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 377571 | 377571 | PRJNA312107_P_NODE_21421_length_166_cov_0.888889_g21255_i0 | PRJNA312107 | 21421 | 166 | 0.888889 | 1.47555574 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 279 | 5.86e-71 | NTclustered | gi|2914875765|gb|OR221646.1| | 2832643 | g21255 | i0 | 96.988 | 1 | 166 | 5 | 100 | 0 | 1 | 166 | 17318 | 17153 | MAG: Caudoviricetes sp. isolate MSP1406 genomic sequence | blastn | 166 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1063665 | 1063665 | PRJNA312107_P_NODE_26421_length_160_cov_2.351351_g26255_i0 | PRJNA312107 | 26421 | 160 | 2.351351 | 3.7621616 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 6.13e-6 | NTclustered | gi|2893578549|gb|OR703025.1| | 10334 | g26255 | i0 | 97.297 | 18.84375 | 37 | 1 | 23 | 0 | 8 | 44 | 28910 | 28946 | Mutant Felid alphaherpesvirus 1 isolate FHV-GZeGTmC, partial genome | blastn | 3015 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus felidalpha1 | ||
| 2338847 | 2338847 | PRJNA312107_P_NODE_20402_length_167_cov_1.466102_g20236_i0 | PRJNA312107 | 20402 | 167 | 1.466102 | 2.44839034 | Ceduovirus | 186532 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|1070102990|ref|NC_031075.1| | 1862960 | g20236 | i0 | 99.401 | 91.185628742515 | 167 | 1 | 100 | 0 | 1 | 167 | 7892 | 8058 | Lactococcus phage M5938, complete genome | blastn | 15228 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ceduovirus | Ceduovirus M5938 | ||||
| 2928207 | 2928207 | PRJNA312107_P_NODE_19903_length_168_cov_0.873950_g19737_i0 | PRJNA312107 | 19903 | 168 | 0.87395 | 1.468236 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 111 | 2.3e-20 | NTclustered | gi|1839144400|emb|LR796242.1| | 2100421 | g19737 | i0 | 80.69 | 1.64285714285714 | 145 | 26 | 86 | 2 | 16 | 159 | 16422 | 16279 | uncultured Caudovirales phage genome assembly | blastn | 276 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 4204825 | 4204825 | PRJNA312107_P_NODE_23564_length_164_cov_0.904348_g23398_i0 | PRJNA312107 | 23564 | 164 | 0.904348 | 1.48313072 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 259 | 7.52e-65 | NTclustered | gi|1839198779|emb|LR797243.1| | 2100421 | g23398 | i0 | 95.122 | 2 | 164 | 8 | 100 | 0 | 1 | 164 | 16399 | 16236 | uncultured Caudovirales phage genome assembly | blastn | 328 | 259 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 5481111 | 5481111 | PRJNA312107_P_NODE_24885_length_163_cov_0.912281_g24719_i0 | PRJNA312107 | 24885 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 141 | 2.82e-29 | NTclustered | gi|2906149782|gb|PQ646480.1| | 2832643 | g24719 | i0 | 82.738 | 1.03067484662577 | 168 | 19 | 100 | 7 | 1 | 163 | 4558 | 4396 | MAG: Caudoviricetes sp. isolate k127_2534360 genomic sequence | blastn | 168 | 141 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8030880 | 8030880 | PRJNA312107_P_NODE_25187_length_163_cov_0.912281_g25021_i0 | PRJNA312107 | 25187 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.25e-62 | NTclustered | gi|2053035115|tpg|BK024139.1| | 2832643 | g25021 | i0 | 94.479 | 5.77914110429448 | 163 | 9 | 100 | 0 | 1 | 163 | 32341 | 32503 | MAG TPA_asm: Caudoviricetes sp. isolate ctMhJ20, partial genome | blastn | 942 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9305605 | 9305605 | PRJNA312107_P_NODE_18648_length_169_cov_0.866667_g18482_i0 | PRJNA312107 | 18648 | 169 | 0.866667 | 1.46466723 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.73e-79 | NTclustered | gi|2054645468|tpg|BK051913.1| | 2832643 | g18482 | i0 | 99.408 | 1 | 169 | 1 | 100 | 0 | 1 | 169 | 22177 | 22009 | MAG TPA_asm: Caudoviricetes sp. isolate ctXoG1, partial genome | blastn | 169 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9991815 | 9991815 | PRJNA312107_P_NODE_9868_length_229_cov_1.733333_g9702_i0 | PRJNA312107 | 9868 | 229 | 1.733333 | 3.96933257 | Viruses | 10239 | Viruses | Viruses | 62.1 | 3.39e-5 | NTclustered | gi|2214379337|gb|OM735687.1| | 2924896 | g9702 | i0 | 89.583 | 0.615720524017467 | 48 | 5 | 21 | 0 | 182 | 229 | 29222 | 29175 | Stenotrophomonas phage vB_SmeS_BUCT702, complete genome | blastn | 141 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage vB_SmeS_BUCT702 | |||||
| 10581493 | 10581493 | PRJNA312107_P_NODE_17369_length_175_cov_1.571429_g17203_i0 | PRJNA312107 | 17369 | 175 | 1.571429 | 2.75000075 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 287 | 3.71e-73 | NTclustered | gi|2054593753|tpg|BK021589.1| | 2832643 | g17203 | i0 | 96.532 | 10.32 | 173 | 6 | 99 | 0 | 3 | 175 | 37014 | 37186 | MAG TPA_asm: Caudoviricetes sp. isolate ctuer2, partial genome | blastn | 1806 | 287 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11856215 | 11856215 | PRJNA312107_P_NODE_18990_length_169_cov_0.866667_g18824_i0 | PRJNA312107 | 18990 | 169 | 0.866667 | 1.46466723 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.73e-79 | NTclustered | gi|2058072589|tpg|BK042969.1| | 2832643 | g18824 | i0 | 99.408 | 2.97633136094675 | 169 | 1 | 100 | 0 | 1 | 169 | 4945 | 5113 | MAG TPA_asm: Caudoviricetes sp. isolate ctD8D13, partial genome | blastn | 503 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14406606 | 14406606 | PRJNA312107_P_NODE_792_length_784_cov_2.321088_g669_i0 | PRJNA312107 | 792 | 784 | 2.321088 | 18.19732992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 852 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g669 | i0 | 97.778 | 418.475765306122 | 495 | 10 | 63 | 1 | 291 | 784 | 18419 | 17925 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 328085 | 852 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17641274 | 17641274 | PRJNA312107_P_NODE_18974_length_169_cov_0.866667_g18808_i0 | PRJNA312107 | 18974 | 169 | 0.866667 | 1.46466723 | root | 1 | Root_unresolved | Root_unresolved | 296 | 5.9e-76 | NTclustered | gi|2915034053|gb|OR222678.1| | 2832643 | g18808 | i0 | 98.225 | 46.3727810650888 | 169 | 3 | 100 | 0 | 1 | 169 | 30366 | 30198 | MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence | blastn | 7837 | 296 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22054132 | 22054132 | PRJNA312107_P_NODE_20198_length_168_cov_0.873950_g20032_i0 | PRJNA312107 | 20198 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 4.56e-77 | NTclustered | gi|2914826342|gb|OR222300.1| | 2832643 | g20032 | i0 | 98.81 | 6.96428571428571 | 168 | 2 | 100 | 0 | 1 | 168 | 52216 | 52383 | MAG: Caudoviricetes sp. isolate MSP0667 genomic sequence | blastn | 1170 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22054169 | 22054169 | PRJNA312107_P_NODE_24518_length_163_cov_0.912281_g24352_i0 | PRJNA312107 | 24518 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 1.04e-8 | NTclustered | gi|2052195372|tpg|BK055993.1| | 2832643 | g24352 | i0 | 87.5 | 0.392638036809816 | 64 | 7 | 39 | 1 | 3 | 66 | 90807 | 90869 | MAG TPA_asm: Caudoviricetes sp. isolate ctL0v2, partial genome | blastn | 64 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24603589 | 24603589 | PRJNA312107_P_NODE_11800_length_211_cov_2.580247_g11634_i0 | PRJNA312107 | 11800 | 211 | 2.580247 | 5.44432117 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.4 | 1.84e-7 | NTclustered | gi|2914808834|gb|OR221690.1| | 2832643 | g11634 | i0 | 97.561 | 20.0047393364929 | 41 | 0 | 19 | 1 | 1 | 40 | 46365 | 46325 | MAG: Caudoviricetes sp. isolate MSP1351 genomic sequence | blastn | 4221 | 69.4 | 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);;