contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA339266" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1069863 | 1069863 | PRJNA339266_S_NODE_6221_length_202_cov_867.387879_g6210_i0 | PRJNA339266 | 6221 | 202 | 867.387879 | 1752.12351558 | root | 1 | Root_unresolved | Root_unresolved | 178 | 2.7799999999999993e-40 | NTclustered | gi|671698184|gb|KM192300.1| | 10359 | g6210 | i0 | 96.296 | 73.9405940594059 | 108 | 4 | 70 | 0 | 1 | 108 | 39177 | 39070 | Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome | blastn | 14936 | 178 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 5494918 | 5494918 | PRJNA339266_P_NODE_5405_length_184_cov_2.333333_g5375_i0 | PRJNA339266 | 5405 | 184 | 2.333333 | 4.29333272 | Siphoviridae sp. ct3z32 | 2825327 | Viruses | Viruses | 135 | 1.51e-27 | NTclustered | gi|2053181631|tpg|BK016267.1| | 2825327 | g5375 | i0 | 98.684 | 1.23913043478261 | 76 | 1 | 83 | 0 | 1 | 76 | 27015 | 27090 | MAG TPA_asm: Siphoviridae sp. ct3z32, partial genome | blastn | 228 | 135 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ct3z32 | |||||
| 5495145 | 5495145 | PRJNA339266_S_NODE_19845_length_150_cov_2.681416_g19834_i0 | PRJNA339266 | 19845 | 150 | 2.681416 | 4.022124 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 8.609999999999998e-69 | NTclustered | gi|2057093414|tpg|BK038165.1| | 2832643 | g19834 | i0 | 99.333 | 4.99333333333333 | 150 | 1 | 100 | 0 | 1 | 150 | 6584 | 6733 | MAG TPA_asm: Caudoviricetes sp. isolate ctIkb7, partial genome | blastn | 749 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5495313 | 5495313 | PRJNA339266_S_NODE_8385_length_187_cov_8.013333_g8374_i0 | PRJNA339266 | 8385 | 187 | 8.013333 | 14.98493271 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 200 | 5.4e-47 | NTclustered | gi|2058005679|tpg|BK041634.1| | 2832643 | g8374 | i0 | 91.156 | 0.978609625668449 | 147 | 13 | 79 | 0 | 41 | 187 | 21842 | 21696 | MAG TPA_asm: Caudoviricetes sp. isolate ctuTV6, partial genome | blastn | 183 | 200 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11273070 | 11273070 | PRJNA339266_S_NODE_6749_length_198_cov_102.366460_g6738_i0 | PRJNA339266 | 6749 | 198 | 102.36646 | 202.6855908 | root | 1 | Root_unresolved | Root_unresolved | 287 | 4.32e-73 | NTclustered | gi|671698184|gb|KM192300.1| | 10359 | g6738 | i0 | 93.75 | 112.767676767677 | 192 | 11 | 97 | 1 | 1 | 191 | 39267 | 39076 | Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome | blastn | 22328 | 287 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 14420101 | 14420101 | PRJNA339266_P_NODE_1832_length_234_cov_1.979695_g1802_i0 | PRJNA339266 | 1832 | 234 | 1.979695 | 4.6324863 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.021 | NTclustered | gi|2053141422|tpg|BK018790.1| | 2832643 | g1802 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 88 | 115 | 3685 | 3712 | MAG TPA_asm: Caudoviricetes sp. isolate ctWJ240, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16968746 | 16968746 | PRJNA339266_S_NODE_10794_length_176_cov_2.014388_g10783_i0 | PRJNA339266 | 10794 | 176 | 2.014388 | 3.54532288 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 250 | 4.91e-62 | NTclustered | gi|2054414991|tpg|BK035615.1| | 2832643 | g10783 | i0 | 96.078 | 0.869318181818182 | 153 | 6 | 87 | 0 | 24 | 176 | 34636 | 34788 | MAG TPA_asm: Caudoviricetes sp. isolate ctfki10, partial genome | blastn | 153 | 250 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17647455 | 17647455 | PRJNA339266_P_NODE_2554_length_214_cov_83.954802_g2524_i0 | PRJNA339266 | 2554 | 214 | 83.954802 | 179.66327628 | root | 1 | Root_unresolved | Root_unresolved | 99 | 2.39e-16 | NTclustered | gi|671698184|gb|KM192300.1| | 10359 | g2524 | i0 | 95.161 | 87.0373831775701 | 62 | 3 | 87 | 0 | 143 | 204 | 39250 | 39311 | Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome | blastn | 18626 | 99 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 20792676 | 20792676 | PRJNA339266_P_NODE_1517_length_245_cov_75.701923_g1487_i0 | PRJNA339266 | 1517 | 245 | 75.701923 | 185.46971135 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2058161542|tpg|BK034705.1| | 2832643 | g1487 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 214 | 241 | 7618 | 7645 | MAG TPA_asm: Caudoviricetes sp. isolate ct4d17, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24617592 | 24617592 | PRJNA339266_S_NODE_16000_length_159_cov_1.680328_g15989_i0 | PRJNA339266 | 16000 | 159 | 1.680328 | 2.67172152 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 254 | 3.36e-63 | NTclustered | gi|2054414991|tpg|BK035615.1| | 2832643 | g15989 | i0 | 95.57 | 0.993710691823899 | 158 | 7 | 99 | 0 | 1 | 158 | 3329 | 3172 | MAG TPA_asm: Caudoviricetes sp. isolate ctfki10, partial genome | blastn | 158 | 254 | 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);;