contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671204 | 671204 | PRJNA690592_S_NODE_174141_length_259_cov_1.220430_g173127_i0 | PRJNA690592 | 174141 | 259 | 1.22043 | 3.1609137 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2054779292|tpg|BK049701.1| | 2832643 | g173127 | i0 | 100 | 0.111969111969112 | 29 | 0 | 11 | 0 | 143 | 171 | 2196 | 2168 | MAG TPA_asm: Caudoviricetes sp. isolate cthCc3, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5774422 | 5774422 | PRJNA690592_S_NODE_123725_length_300_cov_2.365639_g122711_i0 | PRJNA690592 | 123725 | 300 | 2.365639 | 7.096917 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2058048439|tpg|BK042485.1| | 2832643 | g122711 | i0 | 100 | 0.39 | 30 | 0 | 10 | 0 | 25 | 54 | 31161 | 31190 | MAG TPA_asm: Caudoviricetes sp. isolate ctCEr7, partial genome | blastn | 117 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9599619 | 9599619 | PRJNA690592_S_NODE_16068_length_737_cov_21.843373_g15162_i0 | PRJNA690592 | 16068 | 737 | 21.843373 | 160.98565901 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.006 | NTclustered | gi|2059595612|tpg|BK036979.1| | 2832643 | g15162 | i0 | 96.97 | 0.0447761194029851 | 33 | 1 | 4 | 0 | 244 | 276 | 18043 | 18075 | MAG TPA_asm: Caudoviricetes sp. isolate ctoq918, partial genome | blastn | 33 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9600399 | 9600399 | PRJNA690592_S_NODE_71488_length_377_cov_1.144737_g70474_i0 | PRJNA690592 | 71488 | 377 | 1.144737 | 4.31565849 | Microbacterium phage YuuY | 2652417 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1764710673|gb|MN284901.1| | 2652417 | g70474 | i0 | 88 | 0.440318302387268 | 50 | 3 | 12 | 2 | 11 | 57 | 24523 | 24474 | Microbacterium phage YuuY, complete genome | blastn | 166 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Elerivirus | Microbacterium phage YuuY | ||||
| 12151152 | 12151152 | PRJNA690592_S_NODE_67010_length_387_cov_1.716561_g65996_i0 | PRJNA690592 | 67010 | 387 | 1.716561 | 6.64309107 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.4 | 7.94e-4 | NTclustered | gi|2059611993|tpg|BK037319.1| | 2832643 | g65996 | i0 | 97.059 | 0.816537467700258 | 34 | 1 | 10 | 0 | 184 | 217 | 46782 | 46815 | MAG TPA_asm: Caudoviricetes sp. isolate ctt3g2, partial genome | blastn | 316 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13424930 | 13424930 | PRJNA690592_S_NODE_16231_length_734_cov_18.065053_g15322_i0 | PRJNA690592 | 16231 | 734 | 18.065053 | 132.59748902 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.006 | NTclustered | gi|2059595612|tpg|BK036979.1| | 2832643 | g15322 | i0 | 96.97 | 0.0449591280653951 | 33 | 1 | 4 | 0 | 244 | 276 | 18043 | 18075 | MAG TPA_asm: Caudoviricetes sp. isolate ctoq918, partial genome | blastn | 33 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15973728 | 15973728 | PRJNA690592_S_NODE_143673_length_282_cov_1.473684_g142659_i0 | PRJNA690592 | 143673 | 282 | 1.473684 | 4.15578888 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2054629845|tpg|BK022290.1| | 2832643 | g142659 | i0 | 100 | 0.102836879432624 | 29 | 0 | 10 | 0 | 99 | 127 | 5132 | 5104 | MAG TPA_asm: Caudoviricetes sp. isolate ct1P710, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18523071 | 18523071 | PRJNA690592_S_NODE_153875_length_274_cov_1.149254_g152861_i0 | PRJNA690592 | 153875 | 274 | 1.149254 | 3.14895596 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 507 | 4.47e-139 | NTclustered | gi|2915016823|gb|OR222530.1| | 2832643 | g152861 | i0 | 100 | 52.6021897810219 | 274 | 0 | 100 | 0 | 1 | 274 | 21774 | 22047 | MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence | blastn | 14413 | 507 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24898022 | 24898022 | PRJNA690592_S_NODE_43660_length_466_cov_1.936387_g42646_i0 | PRJNA690592 | 43660 | 466 | 1.936387 | 9.02356342 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.045 | NTclustered | gi|2059778054|tpg|BK039281.1| | 2832643 | g42646 | i0 | 100 | 0.133047210300429 | 28 | 0 | 6 | 0 | 238 | 265 | 27942 | 27969 | MAG TPA_asm: Caudoviricetes sp. isolate ctwJd6, partial genome | blastn | 62 | 52.8 | 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);;