contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB48218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990347 | 990347 | PRJEB48218_S_NODE_21301_length_199_cov_2.394118_g20339_i0 | PRJEB48218 | 21301 | 199 | 2.394118 | 4.76429482 | Pahexavirus | 1982251 | Viruses | Viruses | 346 | 7.070000000000001e-91 | NTclustered | gi|849255742|ref|NC_027391.1| | 1500801 | g20339 | i0 | 97.99 | 99.6884422110553 | 199 | 4 | 100 | 0 | 1 | 199 | 18303 | 18105 | Propionibacterium phage PHL041M10, complete genome | blastn | 19838 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL041M10 | ||||
| 990439 | 990439 | PRJEB48218_S_NODE_27561_length_162_cov_1.849624_g26599_i0 | PRJEB48218 | 27561 | 162 | 1.849624 | 2.99639088 | Teetrevirus | 2732693 | Viruses | Viruses | 300 | 4.36e-77 | NTclustered | gi|15561|emb|X02981.1| | 10759 | g26599 | i0 | 100 | 99.6481481481482 | 162 | 0 | 100 | 0 | 1 | 162 | 1823 | 1662 | Bacteriophage T3 gene 1 for RNA polymerase | blastn | 16143 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Teetrevirus | Teetrevirus T3Luria | ||
| 3888576 | 3888576 | PRJEB48218_S_NODE_21864_length_195_cov_2.590361_g20902_i0 | PRJEB48218 | 21864 | 195 | 2.590361 | 5.05120395 | Pahexavirus PA6 | 1982269 | Viruses | Viruses | 327 | 2.5e-85 | NTclustered | gi|148727082|ref|NC_009541.1| | 376758 | g20902 | i0 | 96.923 | 96.2410256410256 | 195 | 6 | 100 | 0 | 1 | 195 | 10608 | 10414 | Propionibacterium phage PA6, complete genome | blastn | 18767 | 327 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PA6 | ||||
| 6440929 | 6440929 | PRJEB48218_S_NODE_7406_length_354_cov_11241.273846_g6444_i0 | PRJEB48218 | 7406 | 354 | 11241.273846 | 39794.10941484 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 171 | 8.859999999999999e-38 | NTclustered | gi|2906145245|gb|PQ646172.1| | 2832643 | g6444 | i0 | 87.261 | 224.937853107345 | 157 | 11 | 44 | 7 | 113 | 267 | 26202 | 26053 | MAG: Caudoviricetes sp. isolate k127_1850996 genomic sequence | blastn | 79628 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8989746 | 8989746 | PRJEB48218_S_NODE_27728_length_161_cov_2.598485_g26766_i0 | PRJEB48218 | 27728 | 161 | 2.598485 | 4.18356085 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 3.389999999999999e-68 | NTclustered | gi|2056870103|tpg|BK044667.1| | 2832643 | g26766 | i0 | 96.894 | 1.98136645962733 | 161 | 5 | 100 | 0 | 1 | 161 | 19563 | 19403 | MAG TPA_asm: Caudoviricetes sp. isolate ctQL51, partial genome | blastn | 319 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11540889 | 11540889 | PRJEB48218_S_NODE_30610_length_150_cov_3.165289_g29648_i0 | PRJEB48218 | 30610 | 150 | 3.165289 | 4.7479335 | Pahexavirus P144 | 1982262 | Viruses | Viruses | 250 | 4.04e-62 | NTclustered | gi|408905834|ref|NC_018839.1| | 1229784 | g29648 | i0 | 96.667 | 98.6533333333333 | 150 | 5 | 100 | 0 | 1 | 150 | 15531 | 15680 | Propionibacterium phage P14.4, complete genome | blastn | 14798 | 250 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P144 | ||||
| 14091009 | 14091009 | PRJEB48218_S_NODE_28452_length_158_cov_2.457364_g27490_i0 | PRJEB48218 | 28452 | 158 | 2.457364 | 3.88263512 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 265 | 1.5399999999999998e-66 | NTclustered | gi|2056922923|tpg|BK054346.1| | 2832643 | g27490 | i0 | 96.835 | 96.7784810126582 | 158 | 5 | 100 | 0 | 1 | 158 | 26558 | 26715 | MAG TPA_asm: Caudoviricetes sp. isolate ct0fI1, partial genome | blastn | 15291 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19188032 | 19188032 | PRJEB48218_S_NODE_22856_length_187_cov_6.936709_g21894_i0 | PRJEB48218 | 22856 | 187 | 6.936709 | 12.97164583 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|2054769213|tpg|BK043786.1| | 2832643 | g21894 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 157 | 184 | 14411 | 14438 | MAG TPA_asm: Caudoviricetes sp. isolate ct0jD4, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20463367 | 20463367 | PRJEB48218_S_NODE_22517_length_190_cov_3.149068_g21555_i0 | PRJEB48218 | 22517 | 190 | 3.149068 | 5.9832292 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 254 | 4.17e-63 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g21555 | i0 | 90.957 | 2 | 188 | 17 | 99 | 0 | 3 | 190 | 33119 | 32932 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 380 | 254 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20463431 | 20463431 | PRJEB48218_S_NODE_25157_length_173_cov_1.993056_g24195_i0 | PRJEB48218 | 25157 | 173 | 1.993056 | 3.44798688 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.31e-77 | NTclustered | gi|2057839312|tpg|BK055685.1| | 2832643 | g24195 | i0 | 98.256 | 3.49132947976879 | 172 | 3 | 99 | 0 | 1 | 172 | 6308 | 6479 | MAG TPA_asm: Caudoviricetes sp. isolate ctYzv17, partial genome | blastn | 604 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20463770 | 20463770 | PRJEB48218_S_NODE_9877_length_289_cov_14598.507692_g8915_i0 | PRJEB48218 | 9877 | 289 | 14598.507692 | 42189.68722988 | Pahexavirus PHL041M10 | 1982276 | Viruses | Viruses | 291 | 5.21e-74 | NTclustered | gi|849255742|ref|NC_027391.1| | 1500801 | g8915 | i0 | 97.633 | 58.1833910034602 | 169 | 4 | 58 | 0 | 4 | 172 | 21779 | 21611 | Propionibacterium phage PHL041M10, complete genome | blastn | 16815 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL041M10 | ||||
| 23942731 | 23942731 | PRJEB48218_S_NODE_28939_length_156_cov_3.102362_g27977_i0 | PRJEB48218 | 28939 | 156 | 3.102362 | 4.83968472 | Pahexavirus | 1982251 | Viruses | Viruses | 276 | 7e-70 | NTclustered | gi|408905837|ref|NC_018842.1| | 1229792 | g27977 | i0 | 99.342 | 97.6923076923077 | 152 | 1 | 97 | 0 | 5 | 156 | 151 | 302 | Propionibacterium phage P1.1, complete genome | blastn | 15240 | 278 | 0.992805755395683 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P11 | ||||
| 24288429 | 24288429 | PRJEB48218_S_NODE_28460_length_158_cov_2.403101_g27498_i0 | PRJEB48218 | 28460 | 158 | 2.403101 | 3.79689958 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 3.3099999999999996e-68 | NTclustered | gi|2056789935|tpg|BK057093.1| | 2832643 | g27498 | i0 | 97.468 | 100.208860759494 | 158 | 4 | 100 | 0 | 1 | 158 | 6146 | 5989 | MAG TPA_asm: Caudoviricetes sp. isolate ctkUK2, partial genome | blastn | 15833 | 270 | 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);;