contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA547066" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6889279 | 6889279 | PRJNA547066_P_NODE_6166_length_150_cov_1.391304_g6072_i0 | PRJNA547066 | 6166 | 150 | 1.391304 | 2.086956 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 8.609999999999998e-69 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g6072 | i0 | 99.333 | 1 | 150 | 1 | 100 | 0 | 1 | 150 | 37688 | 37539 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 150 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8164408 | 8164408 | PRJNA547066_P_NODE_6127_length_151_cov_1.077586_g6033_i0 | PRJNA547066 | 6127 | 151 | 1.077586 | 1.62715486 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 274 | 2.42e-69 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g6033 | i0 | 99.338 | 1 | 151 | 1 | 100 | 0 | 1 | 151 | 3111 | 2961 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 151 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9439924 | 9439924 | PRJNA547066_P_NODE_3388_length_234_cov_2.095477_g3294_i0 | PRJNA547066 | 3388 | 234 | 2.095477 | 4.90341618 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 405 | 1.4e-108 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g3294 | i0 | 97.863 | 1.61965811965812 | 234 | 5 | 100 | 0 | 1 | 234 | 6690 | 6457 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 379 | 405 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10715699 | 10715699 | PRJNA547066_P_NODE_2949_length_261_cov_1.199115_g2855_i0 | PRJNA547066 | 2949 | 261 | 1.199115 | 3.12969015 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 466 | 7.17e-127 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g2855 | i0 | 98.851 | 5.39846743295019 | 261 | 3 | 100 | 0 | 1 | 261 | 6218 | 5958 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 1409 | 466 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11990390 | 11990390 | PRJNA547066_P_NODE_2350_length_314_cov_1.440860_g2256_i0 | PRJNA547066 | 2350 | 314 | 1.44086 | 4.5243004000000004 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 520 | 6.6999999999999985e-143 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g2256 | i0 | 96.497 | 2 | 314 | 11 | 100 | 0 | 1 | 314 | 25727 | 26040 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 628 | 520 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17089046 | 17089046 | PRJNA547066_P_NODE_2934_length_262_cov_1.801762_g2840_i0 | PRJNA547066 | 2934 | 262 | 1.801762 | 4.72061644 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.34e-124 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g2840 | i0 | 98.092 | 1 | 262 | 5 | 100 | 0 | 1 | 262 | 28918 | 28657 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 262 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17089059 | 17089059 | PRJNA547066_P_NODE_4554_length_184_cov_2.140940_g4460_i0 | PRJNA547066 | 4554 | 184 | 2.14094 | 3.9393296 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 322 | 1.08e-83 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g4460 | i0 | 98.889 | 0.978260869565217 | 180 | 2 | 98 | 0 | 5 | 184 | 5244 | 5065 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 180 | 322 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18363142 | 18363142 | PRJNA547066_P_NODE_4395_length_189_cov_1.298701_g4301_i0 | PRJNA547066 | 4395 | 189 | 1.298701 | 2.45454489 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 344 | 2.39e-90 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g4301 | i0 | 99.471 | 1 | 189 | 1 | 100 | 0 | 1 | 189 | 3651 | 3839 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 189 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18363148 | 18363148 | PRJNA547066_P_NODE_4935_length_174_cov_2.294964_g4841_i0 | PRJNA547066 | 4935 | 174 | 2.294964 | 3.99323736 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 4.769999999999999e-72 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g4841 | i0 | 95.977 | 2 | 174 | 7 | 100 | 0 | 1 | 174 | 13413 | 13586 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 348 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22188403 | 22188403 | PRJNA547066_P_NODE_4878_length_176_cov_1.113475_g4784_i0 | PRJNA547066 | 4878 | 176 | 1.113475 | 1.959716 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 315 | 1.7199999999999996e-81 | NTclustered | gi|2914789839|gb|OR222684.1| | 2832643 | g4784 | i0 | 98.864 | 1 | 176 | 2 | 100 | 0 | 1 | 176 | 79890 | 80065 | MAG: Caudoviricetes sp. isolate MSP0244 genomic sequence | blastn | 176 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23463839 | 23463839 | PRJNA547066_P_NODE_2639_length_286_cov_1.274900_g2545_i0 | PRJNA547066 | 2639 | 286 | 1.2749 | 3.646214 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 501 | 2.18e-137 | NTclustered | gi|2059699024|tpg|BK029571.1| | 2832643 | g2545 | i0 | 98.252 | 1 | 286 | 5 | 100 | 0 | 1 | 286 | 37381 | 37096 | MAG TPA_asm: Caudoviricetes sp. isolate ctTKM2, partial genome | blastn | 286 | 501 | 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);;