contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA399133" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1688038 | 1688038 | PRJNA399133_P_NODE_142_length_1307_cov_3.996855_g112_i0 | PRJNA399133 | 142 | 1307 | 3.996855 | 52.23889485 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 58.4 | 0.003 | NTclustered | gi|1839187624|emb|LR796897.1| | 2100421 | g112 | i0 | 100 | 0.0749808722264728 | 31 | 0 | 2 | 0 | 1086 | 1116 | 6284 | 6314 | uncultured Caudovirales phage genome assembly | blastn | 98 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 10617244 | 10617244 | PRJNA399133_P_NODE_8289_length_182_cov_1.755102_g8201_i0 | PRJNA399133 | 8289 | 182 | 1.755102 | 3.19428564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 124 | 3.2299999999999997e-24 | NTclustered | gi|2054463720|tpg|BK031592.1| | 2832643 | g8201 | i0 | 83.088 | 0.747252747252747 | 136 | 23 | 75 | 0 | 5 | 140 | 8581 | 8446 | MAG TPA_asm: Caudoviricetes sp. isolate ctgih1, partial genome | blastn | 136 | 124 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13167143 | 13167143 | PRJNA399133_P_NODE_9791_length_168_cov_1.879699_g9703_i0 | PRJNA399133 | 9791 | 168 | 1.879699 | 3.15789432 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1839214128|emb|LR797474.1| | 2100421 | g9703 | i0 | 96.97 | 0.196428571428571 | 33 | 1 | 20 | 0 | 37 | 69 | 197505 | 197537 | uncultured Caudovirales phage genome assembly | blastn | 33 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 13834443 | 13834443 | PRJNA399133_P_NODE_9971_length_167_cov_0.909091_g9883_i0 | PRJNA399133 | 9971 | 167 | 0.909091 | 1.51818197 | Viruses | 10239 | Viruses | Viruses | 309 | 7.53e-80 | NTclustered | gi|2052870917|tpg|BK032626.1| | 2827768 | g9883 | i0 | 100 | 61.3053892215569 | 167 | 0 | 100 | 0 | 1 | 167 | 660 | 826 | MAG TPA_asm: Siphoviridae sp. ct2KB1, partial genome | blastn | 10238 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ct2KB1 | |||||
| 16990683 | 16990683 | PRJNA399133_P_NODE_10474_length_163_cov_1.414062_g10386_i0 | PRJNA399133 | 10474 | 163 | 1.414062 | 2.30492106 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 211 | 2.12e-50 | NTclustered | gi|2216802433|gb|MW202867.1| | 2832643 | g10386 | i0 | 93.617 | 0.865030674846626 | 141 | 9 | 87 | 0 | 1 | 141 | 3814 | 3954 | Myoviridae sp. isolate ct3Oc712, complete genome | blastn | 141 | 211 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20814792 | 20814792 | PRJNA399133_P_NODE_11477_length_156_cov_1.652893_g11389_i0 | PRJNA399133 | 11477 | 156 | 1.652893 | 2.57851308 | Crassvirales sp. | 2960088 | Viruses | Viruses | 185 | 1.2099999999999999e-42 | NTclustered | gi|2054561072|tpg|BK048250.1| | 2960088 | g11389 | i0 | 88.312 | 0.987179487179487 | 154 | 18 | 99 | 0 | 3 | 156 | 15051 | 15204 | MAG TPA_asm: Crassvirales sp. isolate ct4px4, partial genome | blastn | 154 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Crassvirales sp. | ||||
| 22089698 | 22089698 | PRJNA399133_P_NODE_2718_length_303_cov_1.723881_g2630_i0 | PRJNA399133 | 2718 | 303 | 1.723881 | 5.22335943 | Veracruzvirus phantastic | 2956639 | Viruses | Viruses | 62.1 | 4.69e-5 | NTclustered | gi|640885266|ref|NC_024148.1| | 1486426 | g2630 | i0 | 92.857 | 0.237623762376238 | 42 | 3 | 14 | 0 | 109 | 150 | 2117 | 2158 | Mycobacterium phage Phantastic, complete genome | blastn | 72 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Veracruzvirus | Veracruzvirus phantastic |
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);;