contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA407368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2965909 | 2965909 | PRJNA407368_S_NODE_7803_length_184_cov_3.477419_g7701_i0 | PRJNA407368 | 7803 | 184 | 3.477419 | 6.39845096 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 335 | 1.3899999999999996e-87 | NTclustered | gi|2906150747|gb|PQ646533.1| | 2832643 | g7701 | i0 | 99.457 | 1 | 184 | 1 | 100 | 0 | 1 | 184 | 7214 | 7397 | MAG: Caudoviricetes sp. isolate k127_4397921 genomic sequence | blastn | 184 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8068344 | 8068344 | PRJNA407368_S_NODE_2067_length_429_cov_24.220000_g1966_i0 | PRJNA407368 | 2067 | 429 | 24.22 | 103.9038 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 538 | 2.6099999999999992e-148 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g1966 | i0 | 89.327 | 435.50582750582703 | 431 | 42 | 100 | 4 | 1 | 429 | 18219 | 17791 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 186832 | 538 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8068446 | 8068446 | PRJNA407368_S_NODE_667_length_786_cov_16.817701_g608_i0 | PRJNA407368 | 667 | 786 | 16.817701 | 132.18712986 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 907 | 0 | NTclustered | gi|2058043668|tpg|BK042394.1| | 2832643 | g608 | i0 | 100 | 1.01017811704835 | 491 | 0 | 100 | 0 | 1 | 491 | 109474 | 109964 | MAG TPA_asm: Caudoviricetes sp. isolate ctStP2, partial genome | blastn | 794 | 907 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9343343 | 9343343 | PRJNA407368_S_NODE_868_length_697_cov_8.908683_g799_i0 | PRJNA407368 | 868 | 697 | 8.908683 | 62.09352051 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 6.209999999999998e-82 | NTclustered | gi|2906148703|gb|PQ646410.1| | 2832643 | g799 | i0 | 81.205 | 1.03730272596844 | 415 | 61 | 100 | 13 | 290 | 697 | 24223 | 23819 | MAG: Caudoviricetes sp. isolate k127_2521799 genomic sequence | blastn | 723 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10618952 | 10618952 | PRJNA407368_S_NODE_1569_length_502_cov_12.181818_g1475_i0 | PRJNA407368 | 1569 | 502 | 12.181818 | 61.15272636 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 375 | 2.5599999999999997e-99 | NTclustered | gi|2906145245|gb|PQ646172.1| | 2832643 | g1475 | i0 | 82.751 | 0.854581673306773 | 429 | 66 | 85 | 8 | 78 | 502 | 36573 | 36997 | MAG: Caudoviricetes sp. isolate k127_1850996 genomic sequence | blastn | 429 | 375 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11893908 | 11893908 | PRJNA407368_S_NODE_3550_length_311_cov_5.946809_g3448_i0 | PRJNA407368 | 3550 | 311 | 5.946809 | 18.49457599 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.5 | 1.71e-14 | NTclustered | gi|2053082307|tpg|BK020121.1| | 2832643 | g3448 | i0 | 94.915 | 0.189710610932476 | 59 | 3 | 19 | 0 | 186 | 244 | 16006 | 15948 | MAG TPA_asm: Caudoviricetes sp. isolate ct1j32, partial genome | blastn | 59 | 93.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11893989 | 11893989 | PRJNA407368_S_NODE_7570_length_188_cov_2.509434_g7468_i0 | PRJNA407368 | 7570 | 188 | 2.509434 | 4.71773592 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 198 | 1.9599999999999998e-46 | NTclustered | gi|2914826573|gb|OR222318.1| | 2832643 | g7468 | i0 | 86.339 | 1.95744680851064 | 183 | 23 | 97 | 2 | 6 | 187 | 8389 | 8208 | MAG: Caudoviricetes sp. isolate MSP1085 genomic sequence | blastn | 368 | 198 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16384126 | 16384126 | PRJNA407368_S_NODE_6973_length_199_cov_2.347059_g6871_i0 | PRJNA407368 | 6973 | 199 | 2.347059 | 4.67064741 | root | 1 | Root_unresolved | Root_unresolved | 252 | 1.59e-62 | NTclustered | gi|2914812517|gb|OR221846.1| | 2832643 | g6871 | i0 | 89.447 | 52.3668341708543 | 199 | 21 | 100 | 0 | 1 | 199 | 22414 | 22216 | MAG: Caudoviricetes sp. isolate MSP1164 genomic sequence | blastn | 10421 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19540924 | 19540924 | PRJNA407368_S_NODE_7436_length_190_cov_13.273292_g7334_i0 | PRJNA407368 | 7436 | 190 | 13.273292 | 25.2192548 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 158 | 3.36e-34 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g7334 | i0 | 81.675 | 495.268421052632 | 191 | 33 | 100 | 2 | 1 | 190 | 17968 | 18157 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 94101 | 158 | 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);;