contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 833029 | 833029 | PRJNA846110_P_NODE_17901_length_273_cov_2.280000_g17656_i0 | PRJNA846110 | 17901 | 273 | 2.28 | 6.2244 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.77e-68 | NTclustered | gi|2914988762|gb|OR222153.1| | 2832643 | g17656 | i0 | 84.615 | 3.01098901098901 | 273 | 42 | 100 | 0 | 1 | 273 | 37741 | 38013 | MAG: Caudoviricetes sp. isolate MSP0823 genomic sequence | blastn | 822 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1231290 | 1231290 | PRJNA846110_P_NODE_18561_length_270_cov_1.563452_g18316_i0 | PRJNA846110 | 18561 | 270 | 1.563452 | 4.2213204 | Hennigervirus | 3424959 | Viruses | Viruses | 494 | 3.4199999999999996e-135 | NTclustered | gi|1842037666|ref|NC_048200.1| | 1729933 | g18316 | i0 | 99.63 | 35.2481481481481 | 270 | 1 | 100 | 0 | 1 | 270 | 11231 | 11500 | Pseudomonas phage shl2 genome assembly, chromosome: 1 | blastn | 9517 | 494 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Hennigervirus | Hennigervirus shl2 | ||
| 3783194 | 3783194 | PRJNA846110_P_NODE_23783_length_249_cov_2.232955_g23538_i0 | PRJNA846110 | 23783 | 249 | 2.232955 | 5.56005795 | Marchewkavirus | 3425052 | Viruses | Viruses | 357 | 4.2599999999999997e-94 | NTclustered | gi|2264473600|gb|ON529851.1| | 2948604 | g23538 | i0 | 93.361 | 7.93172690763052 | 241 | 16 | 97 | 0 | 9 | 249 | 47300 | 47060 | Brevundimonas phage vB_BpoS-Marchewka, complete genome | blastn | 1975 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jeanschmidtviridae | Marchewkavirus | Marchewkavirus marchewka | |||
| 5936185 | 5936185 | PRJNA846110_P_NODE_19105_length_267_cov_2.577320_g18860_i0 | PRJNA846110 | 19105 | 267 | 2.57732 | 6.8814444 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 416 | 7.519999999999998e-112 | NTclustered | gi|2053083540|tpg|BK020145.1| | 2832643 | g18860 | i0 | 94.757 | 3.00374531835206 | 267 | 14 | 100 | 0 | 1 | 267 | 4164 | 3898 | MAG TPA_asm: Caudoviricetes sp. isolate ctnvU3, partial genome | blastn | 802 | 416 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8485978 | 8485978 | PRJNA846110_P_NODE_30347_length_241_cov_0.916667_g30102_i0 | PRJNA846110 | 30347 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 412 | 8.64e-111 | NTclustered | gi|2914947028|gb|OR221843.1| | 2832643 | g30102 | i0 | 97.51 | 1 | 241 | 6 | 100 | 0 | 1 | 241 | 10780 | 11020 | MAG: Caudoviricetes sp. isolate MSP1171 genomic sequence | blastn | 241 | 412 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12312215 | 12312215 | PRJNA846110_P_NODE_24650_length_248_cov_1.308571_g24405_i0 | PRJNA846110 | 24650 | 248 | 1.308571 | 3.24525608 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 394 | 3.24e-105 | NTclustered | gi|2914938176|gb|OR221695.1| | 2832643 | g24405 | i0 | 95.528 | 1.98387096774194 | 246 | 11 | 99 | 0 | 1 | 246 | 17036 | 17281 | MAG: Caudoviricetes sp. isolate MSP1344 genomic sequence | blastn | 492 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14861047 | 14861047 | PRJNA846110_P_NODE_29192_length_242_cov_0.911243_g28947_i0 | PRJNA846110 | 29192 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1099999999999995e-119 | NTclustered | gi|2914751570|gb|OR221330.1| | 2832643 | g28947 | i0 | 99.587 | 1 | 242 | 1 | 100 | 0 | 1 | 242 | 22311 | 22070 | MAG: Caudoviricetes sp. isolate MSP1779 genomic sequence | blastn | 242 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15259282 | 15259282 | PRJNA846110_P_NODE_16432_length_280_cov_2.608696_g16187_i0 | PRJNA846110 | 16432 | 280 | 2.608696 | 7.3043488 | Pahexavirus | 1982251 | Viruses | Viruses | 409 | 1.33e-109 | NTclustered | gi|849122467|ref|NC_027401.1| | 1500814 | g16187 | i0 | 93.165 | 99.7178571428571 | 278 | 19 | 99 | 0 | 2 | 279 | 2805 | 2528 | Propionibacterium phage PHL095N00, complete genome | blastn | 27921 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL095N00 | ||||
| 16135844 | 16135844 | PRJNA846110_P_NODE_30373_length_241_cov_0.886905_g30128_i0 | PRJNA846110 | 30373 | 241 | 0.886905 | 2.13744105 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 285 | 1.96e-72 | NTclustered | gi|2058038123|tpg|BK042290.1| | 2832643 | g30128 | i0 | 87.967 | 1 | 241 | 29 | 100 | 0 | 1 | 241 | 155482 | 155242 | MAG TPA_asm: Caudoviricetes sp. isolate ctZEn3, partial genome | blastn | 241 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18684425 | 18684425 | PRJNA846110_P_NODE_30135_length_241_cov_0.916667_g29890_i0 | PRJNA846110 | 30135 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2053025026|tpg|BK023955.1| | 2832643 | g29890 | i0 | 99.585 | 19.0414937759336 | 241 | 1 | 100 | 0 | 1 | 241 | 15824 | 16064 | MAG TPA_asm: Caudoviricetes sp. isolate ctWEw2, partial genome | blastn | 4589 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19959456 | 19959456 | PRJNA846110_P_NODE_21716_length_254_cov_2.276243_g21471_i0 | PRJNA846110 | 21716 | 254 | 2.276243 | 5.78165722 | Serratia phage WSPA | 3384840 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2905000930|gb|PQ600363.1| | 3384840 | g21471 | i0 | 100 | 2.47637795275591 | 254 | 0 | 100 | 0 | 1 | 254 | 65451 | 65198 | Serratia phage WSPA, partial genome | blastn | 629 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Muldoonvirus | Serratia phage WSPA | ||||
| 21235080 | 21235080 | PRJNA846110_P_NODE_18617_length_270_cov_1.294416_g18372_i0 | PRJNA846110 | 18617 | 270 | 1.294416 | 3.4949232 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 7.349999999999998e-137 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g18372 | i0 | 100 | 1 | 270 | 0 | 100 | 0 | 1 | 270 | 38956 | 38687 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 270 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25059168 | 25059168 | PRJNA846110_P_NODE_15540_length_285_cov_1.155660_g15295_i0 | PRJNA846110 | 15540 | 285 | 1.15566 | 3.293631 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 185 | 2.4899999999999998e-42 | NTclustered | gi|2054478271|tpg|BK031892.1| | 2832643 | g15295 | i0 | 82.096 | 0.929824561403509 | 229 | 29 | 77 | 6 | 1 | 220 | 9057 | 8832 | MAG TPA_asm: Caudoviricetes sp. isolate ctCd92, partial genome | blastn | 265 | 185 | 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);;