contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1016321" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2710090 | 2710090 | PRJNA1016321_P_NODE_42103_length_271_cov_2.141414_g41872_i0 | PRJNA1016321 | 42103 | 271 | 2.141414 | 5.80323194 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 9.83e-116 | NTclustered | gi|2053209494|tpg|BK017127.1| | 2832643 | g41872 | i0 | 97.984 | 4.12177121771218 | 248 | 4 | 92 | 1 | 24 | 271 | 11611 | 11857 | MAG TPA_asm: Caudoviricetes sp. isolate ctfoB3, partial genome | blastn | 1117 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5262371 | 5262371 | PRJNA1016321_P_NODE_30165_length_331_cov_1.689922_g29934_i0 | PRJNA1016321 | 30165 | 331 | 1.689922 | 5.59364182 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1.68e-79 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g29934 | i0 | 91.228 | 0.688821752265861 | 228 | 18 | 69 | 2 | 89 | 315 | 50991 | 51217 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 228 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5262402 | 5262402 | PRJNA1016321_P_NODE_32245_length_318_cov_1.551020_g32014_i0 | PRJNA1016321 | 32245 | 318 | 1.55102 | 4.9322436 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 1.24e-80 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g32014 | i0 | 84.591 | 1 | 318 | 46 | 100 | 1 | 1 | 318 | 36409 | 36095 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 318 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7812307 | 7812307 | PRJNA1016321_P_NODE_42287_length_271_cov_1.131313_g42056_i0 | PRJNA1016321 | 42287 | 271 | 1.131313 | 3.06585823 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 207 | 5.01e-49 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g42056 | i0 | 80.755 | 2.4169741697417 | 265 | 51 | 98 | 0 | 7 | 271 | 38464 | 38200 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 655 | 207 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10362364 | 10362364 | PRJNA1016321_P_NODE_12889_length_552_cov_2.319415_g12666_i0 | PRJNA1016321 | 12889 | 552 | 2.319415 | 12.8031708 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 346 | 2.23e-90 | NTclustered | gi|1436214368|gb|MH617486.1| | 2832643 | g12666 | i0 | 78.707 | 1.90036231884058 | 526 | 106 | 95 | 5 | 28 | 551 | 31551 | 31030 | MAG: Caudoviricetes sp. isolate ctce_1, complete genome | blastn | 1049 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10362509 | 10362509 | PRJNA1016321_P_NODE_20809_length_416_cov_3.069971_g20578_i0 | PRJNA1016321 | 20809 | 416 | 3.069971 | 12.77107936 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 438 | 2.629999999999999e-118 | NTclustered | gi|1990397921|gb|MW347459.1| | 2832643 | g20578 | i0 | 86.098 | 0.985576923076923 | 410 | 53 | 98 | 4 | 9 | 416 | 237 | 644 | MAG: Caudoviricetes sp. isolate 3nj-TERL-60 terminase large subunit gene, partial cds | blastn | 410 | 438 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11638597 | 11638597 | PRJNA1016321_P_NODE_56130_length_241_cov_0.916667_g55899_i0 | PRJNA1016321 | 56130 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8599999999999995e-112 | NTclustered | gi|2914760312|gb|OR221747.1| | 2832643 | g55899 | i0 | 97.925 | 4.78423236514523 | 241 | 5 | 100 | 0 | 1 | 241 | 7332 | 7572 | MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence | blastn | 1153 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12912878 | 12912878 | PRJNA1016321_P_NODE_17051_length_470_cov_2.801008_g16821_i0 | PRJNA1016321 | 17051 | 470 | 2.801008 | 13.1647376 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 830 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g16821 | i0 | 98.511 | 412.234042553192 | 470 | 7 | 100 | 0 | 1 | 470 | 17951 | 18420 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 193750 | 830 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16736147 | 16736147 | PRJNA1016321_P_NODE_14494_length_517_cov_1.029279_g14266_i0 | PRJNA1016321 | 14494 | 517 | 1.029279 | 5.32137243 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 399 | 1.5699999999999997e-106 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g14266 | i0 | 82.378 | 0.911025145067698 | 471 | 71 | 90 | 10 | 45 | 509 | 42907 | 43371 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 471 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18011800 | 18011800 | PRJNA1016321_P_NODE_55935_length_241_cov_1.339286_g55704_i0 | PRJNA1016321 | 55935 | 241 | 1.339286 | 3.22767926 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 169 | 2.0599999999999997e-37 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g55704 | i0 | 82.653 | 0.813278008298755 | 196 | 28 | 80 | 5 | 1 | 193 | 40881 | 40689 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 196 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20561179 | 20561179 | PRJNA1016321_P_NODE_56717_length_238_cov_2.490909_g56486_i0 | PRJNA1016321 | 56717 | 238 | 2.490909 | 5.92836342 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.86e-102 | NTclustered | gi|2057899373|tpg|BK051134.1| | 2832643 | g56486 | i0 | 95.798 | 36.3445378151261 | 238 | 10 | 100 | 0 | 1 | 238 | 7552 | 7789 | MAG TPA_asm: Caudoviricetes sp. isolate ctS2e9, partial genome | blastn | 8650 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24385771 | 24385771 | PRJNA1016321_P_NODE_4000_length_1014_cov_3.747078_g3840_i0 | PRJNA1016321 | 4000 | 1014 | 3.747078 | 37.99537092 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1821 | 0 | NTclustered | gi|2915047850|gb|OR222814.1| | 2832643 | g3840 | i0 | 99.698 | 1.73175542406312 | 995 | 3 | 98 | 0 | 20 | 1014 | 57973 | 56979 | MAG: Caudoviricetes sp. isolate MSP0542 genomic sequence | blastn | 1756 | 1821 | 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);;