contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB82358" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140814 | 140814 | PRJEB82358_P_NODE_18201_length_244_cov_0.900585_g18190_i0 | PRJEB82358 | 18201 | 244 | 0.900585 | 2.1974274 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|747017592|dbj|AB850660.1| | 10376 | g18190 | i0 | 100 | 105.446721311475 | 244 | 0 | 100 | 0 | 1 | 244 | 11179 | 10936 | Human herpesvirus 4 DNA, complete genome, strain: HN18 | blastn | 25729 | 451 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 2690858 | 2690858 | PRJEB82358_P_NODE_14523_length_266_cov_9.414508_g14512_i0 | PRJEB82358 | 14523 | 266 | 9.414508 | 25.04259128 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 215 | 2.93e-51 | NTclustered | gi|2914941188|gb|OR221748.1| | 2832643 | g14512 | i0 | 89.941 | 0.635338345864662 | 169 | 13 | 63 | 4 | 9 | 176 | 166 | 1 | MAG: Caudoviricetes sp. isolate MSP1278 genomic sequence | blastn | 169 | 215 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2690963 | 2690963 | PRJEB82358_P_NODE_4423_length_441_cov_3.809783_g4412_i0 | PRJEB82358 | 4423 | 441 | 3.809783 | 16.80114303 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 390 | 7.96e-104 | NTclustered | gi|2915035437|gb|OR222691.1| | 2832643 | g4412 | i0 | 86.857 | 72.1292517006803 | 350 | 44 | 79 | 2 | 90 | 438 | 18529 | 18181 | MAG: Caudoviricetes sp. isolate MSP0240 genomic sequence | blastn | 31809 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5243534 | 5243534 | PRJEB82358_S_NODE_5_length_242_cov_1.627219_g4_i0 | PRJEB82358 | 5 | 242 | 1.627219 | 3.93786998 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2059612120|tpg|BK037321.1| | 2832643 | g4 | i0 | 100 | 0.37603305785124 | 29 | 0 | 12 | 0 | 214 | 242 | 23579 | 23607 | MAG TPA_asm: Caudoviricetes sp. isolate ct2AU18, partial genome | blastn | 91 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9068100 | 9068100 | PRJEB82358_P_NODE_14348_length_268_cov_2.584615_g14337_i0 | PRJEB82358 | 14348 | 268 | 2.584615 | 6.9267682 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 355 | 1.67e-93 | NTclustered | gi|2053017625|tpg|BK023808.1| | 2832643 | g14337 | i0 | 91.473 | 0.962686567164179 | 258 | 22 | 96 | 0 | 11 | 268 | 23614 | 23871 | MAG TPA_asm: Caudoviricetes sp. isolate ctB811, partial genome | blastn | 258 | 355 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10343763 | 10343763 | PRJEB82358_P_NODE_14349_length_268_cov_2.548718_g14338_i0 | PRJEB82358 | 14349 | 268 | 2.548718 | 6.83056424 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 484 | 2.0399999999999996e-132 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g14338 | i0 | 99.254 | 3.90671641791045 | 268 | 2 | 100 | 0 | 1 | 268 | 7421 | 7688 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 1047 | 484 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15443285 | 15443285 | PRJEB82358_P_NODE_15373_length_260_cov_2.973262_g15362_i0 | PRJEB82358 | 15373 | 260 | 2.973262 | 7.7304812 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 2.55e-131 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g15362 | i0 | 100 | 1.87692307692308 | 260 | 0 | 100 | 0 | 1 | 260 | 6460 | 6201 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 488 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15443340 | 15443340 | PRJEB82358_P_NODE_22753_length_208_cov_4.792593_g22742_i0 | PRJEB82358 | 22753 | 208 | 4.792593 | 9.96859344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.58e-102 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g22742 | i0 | 100 | 3.01923076923077 | 208 | 0 | 100 | 0 | 1 | 208 | 7241 | 7034 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 628 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17992455 | 17992455 | PRJEB82358_P_NODE_695_length_786_cov_24.791024_g686_i0 | PRJEB82358 | 695 | 786 | 24.791024 | 194.85744864 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 257 | 1.5600000000000001e-63 | NTclustered | gi|2054596226|tpg|BK021635.1| | 2832643 | g686 | i0 | 78.412 | 2.63994910941476 | 403 | 81 | 99 | 3 | 6 | 408 | 13283 | 13679 | MAG TPA_asm: Caudoviricetes sp. isolate ctG972, partial genome | blastn | 2075 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20541757 | 20541757 | PRJEB82358_P_NODE_17097_length_249_cov_0.875000_g17086_i0 | PRJEB82358 | 17097 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 427 | 3.2e-115 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g17086 | i0 | 100 | 0.927710843373494 | 231 | 0 | 93 | 0 | 1 | 231 | 39674 | 39444 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 231 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20541792 | 20541792 | PRJEB82358_P_NODE_21957_length_216_cov_5.951049_g21946_i0 | PRJEB82358 | 21957 | 216 | 5.951049 | 12.85426584 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 344 | 2.81e-90 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g21946 | i0 | 100 | 0.861111111111111 | 186 | 0 | 86 | 0 | 31 | 216 | 3821 | 3636 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 186 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21817515 | 21817515 | PRJEB82358_P_NODE_11758_length_291_cov_3.761468_g11747_i0 | PRJEB82358 | 11758 | 291 | 3.761468 | 10.94587188 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 1.06e-120 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g11747 | i0 | 100 | 8.94845360824742 | 241 | 0 | 83 | 0 | 30 | 270 | 5727 | 5967 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 2604 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24366650 | 24366650 | PRJEB82358_P_NODE_23720_length_198_cov_8.576000_g23709_i0 | PRJEB82358 | 23720 | 198 | 8.576 | 16.98048 | Thermus phage YS40_Isch | 2494333 | Viruses | Viruses | 139 | 1.2799999999999999e-28 | NTclustered | gi|1549118528|gb|MK257744.1| | 2494333 | g23709 | i0 | 92 | 0.505050505050505 | 100 | 7 | 50 | 1 | 67 | 165 | 19473 | 19374 | Thermus phage YS40_Isch, complete genome | blastn | 100 | 139 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage YS40_Isch |
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);;