contig_metadata
18 rows where bioproject = "PRJNA675042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3198215 | 3198215 | PRJNA675042_P_NODE_65903_length_299_cov_1.106195_g65453_i0 | PRJNA675042 | 65903 | 299 | 1.106195 | 3.30752305 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|2057821658|tpg|BK055369.1| | 2832643 | g65453 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 0 | 60 | 87 | 12422 | 12449 | MAG TPA_asm: Caudoviricetes sp. isolate ctZ8x11, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4473816 | 4473816 | PRJNA675042_P_NODE_113484_length_250_cov_0.870056_g113034_i0 | PRJNA675042 | 113484 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|1436198482|gb|MH622943.1| | 2832643 | g113034 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 15 | 42 | 183784 | 183757 | MAG: Caudoviricetes sp. isolate ctbc_4, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5749294 | 5749294 | PRJNA675042_P_NODE_105345_length_251_cov_2.595506_g104895_i0 | PRJNA675042 | 105345 | 251 | 2.595506 | 6.51472006 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 322 | 1.57e-83 | NTclustered | gi|2915016823|gb|OR222530.1| | 2832643 | g104895 | i0 | 95.96 | 46.3306772908367 | 198 | 8 | 100 | 0 | 1 | 198 | 38741 | 38938 | MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence | blastn | 11629 | 322 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5750279 | 5750279 | PRJNA675042_P_NODE_25725_length_388_cov_0.869841_g25275_i0 | PRJNA675042 | 25725 | 388 | 0.869841 | 3.37498308 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|2056742671|tpg|BK045140.1| | 2832643 | g25275 | i0 | 100 | 0.0747422680412371 | 29 | 0 | 7 | 0 | 127 | 155 | 28359 | 28387 | MAG TPA_asm: Caudoviricetes sp. isolate ctjy25, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6272256 | 6272256 | PRJNA675042_P_NODE_5_length_52356_cov_22.278829_g1_i0 | PRJNA675042 | 5 | 52356 | 22.278829000000002 | 11664.30371124 | root | 1 | Root_unresolved | Root_unresolved | 16648 | 0 | NTclustered | gi|2308466659|dbj|LC730321.1| | 10710 | g1 | i0 | 78.157 | 96.3352815341126 | 26155 | 5712 | 99 | 1 | 26189 | 52342 | 22347 | 48501 | Lambdavirus lambda Lambda_AGU DNA, complete genome | blastn | 5043730 | 16704 | 0.996647509578544 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 8821433 | 8821433 | PRJNA675042_P_NODE_7_length_48512_cov_24.859576_g1_i1 | PRJNA675042 | 7 | 48512 | 24.859576 | 12059.87750912 | root | 1 | Root_unresolved | Root_unresolved | 26555 | 0 | NTclustered | gi|2308466659|dbj|LC730321.1| | 10710 | g1 | i1 | 76.554 | 92.1440056068602 | 48486 | 11365 | 99 | 3 | 16 | 48498 | 16 | 48501 | Lambdavirus lambda Lambda_AGU DNA, complete genome | blastn | 4470090 | 26639 | 0.996846728480799 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 9574489 | 9574489 | PRJNA675042_P_NODE_117128_length_250_cov_0.870056_g116678_i0 | PRJNA675042 | 117128 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|2057899591|tpg|BK051138.1| | 2832643 | g116678 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 192 | 219 | 49674 | 49701 | MAG TPA_asm: Caudoviricetes sp. isolate ctUPW16, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10097130 | 10097130 | PRJNA675042_P_NODE_8_length_48512_cov_19.897706_g1_i2 | PRJNA675042 | 8 | 48512 | 19.897706 | 9652.77513472 | root | 1 | Root_unresolved | Root_unresolved | 17091 | 0 | NTclustered | gi|2308466659|dbj|LC730321.1| | 10710 | g1 | i2 | 75.493 | 68.1668247031662 | 34957 | 8565 | 72 | 2 | 31 | 34985 | 48484 | 13528 | Lambdavirus lambda Lambda_AGU DNA, complete genome | blastn | 3306909 | 17162 | 0.995862953035777 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 10849969 | 10849969 | PRJNA675042_P_NODE_119889_length_249_cov_0.875000_g119439_i0 | PRJNA675042 | 119889 | 249 | 0.875 | 2.17875 | Proboscivirus elephantidbeta1 | 3050273 | Viruses | Viruses | 58.4 | 4.84e-4 | NTclustered | gi|1912085272|gb|MN366293.1| | 759753 | g119439 | i0 | 84.127 | 0.506024096385542 | 63 | 6 | 24 | 3 | 145 | 203 | 7275 | 7213 | Elephant endotheliotropic herpesvirus 1A isolate IP164 Muthanga2, partial genome | blastn | 126 | 58.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Proboscivirus | Proboscivirus elephantidbeta1 | ||
| 11371551 | 11371551 | PRJNA675042_P_NODE_17089_length_429_cov_1.494382_g16639_i0 | PRJNA675042 | 17089 | 429 | 1.494382 | 6.41089878 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.041 | NTclustered | gi|1070064791|ref|NC_031039.1| | 1815509 | g16639 | i0 | 100 | 0.326340326340326 | 28 | 0 | 7 | 0 | 121 | 148 | 120114 | 120141 | Bacillus phage AR9, complete genome | blastn | 140 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Takahashivirus | Takahashivirus PBS1 | ||||
| 11371894 | 11371894 | PRJNA675042_P_NODE_68849_length_295_cov_0.972973_g68399_i0 | PRJNA675042 | 68849 | 295 | 0.972973 | 2.87027035 | Kayvirus | 1857843 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2035160538|gb|MW546073.1| | 2813338 | g68399 | i0 | 100 | 1.32542372881356 | 28 | 0 | 9 | 0 | 62 | 89 | 85382 | 85355 | Staphylococcus phage BT3, complete genome | blastn | 391 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Kayvirus | Staphylococcus phage BT3 | |||
| 13400451 | 13400451 | PRJNA675042_P_NODE_159431_length_244_cov_0.900585_g158981_i0 | PRJNA675042 | 159431 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.4 | 4.73e-4 | NTclustered | gi|2057797820|tpg|BK054966.1| | 2832643 | g158981 | i0 | 100 | 2.61475409836066 | 31 | 0 | 13 | 0 | 23 | 53 | 22431 | 22461 | MAG TPA_asm: Caudoviricetes sp. isolate ctIj97, partial genome | blastn | 638 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14675348 | 14675348 | PRJNA675042_P_NODE_14912_length_445_cov_1.639785_g14462_i0 | PRJNA675042 | 14912 | 445 | 1.639785 | 7.29704325 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 732 | 0 | NTclustered | gi|2059898580|tpg|BK041281.1| | 2832643 | g14462 | i0 | 99.749 | 2.03595505617978 | 399 | 1 | 100 | 0 | 47 | 445 | 1784 | 2182 | MAG TPA_asm: Caudoviricetes sp. isolate ctgo940, partial genome | blastn | 906 | 732 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15949131 | 15949131 | PRJNA675042_P_NODE_161553_length_243_cov_0.905882_g161103_i0 | PRJNA675042 | 161553 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2058004547|tpg|BK047199.1| | 2832643 | g161103 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 42 | 69 | 84634 | 84661 | MAG TPA_asm: Caudoviricetes sp. isolate ct0Ru19, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17225558 | 17225558 | PRJNA675042_P_NODE_85014_length_275_cov_0.990099_g84564_i0 | PRJNA675042 | 85014 | 275 | 0.990099 | 2.72277225 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 392 | 1.3099999999999999e-104 | NTclustered | gi|2915053633|gb|OR222872.1| | 2832643 | g84564 | i0 | 92.364 | 2 | 275 | 21 | 100 | 0 | 1 | 275 | 4736 | 4462 | MAG: Caudoviricetes sp. isolate MSP0478 genomic sequence | blastn | 550 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18498403 | 18498403 | PRJNA675042_P_NODE_132855_length_247_cov_1.511494_g132405_i0 | PRJNA675042 | 132855 | 247 | 1.511494 | 3.73339018 | Bacillus phage vB_BpuM-BpSp | 1739968 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|952094897|gb|KT895374.1| | 1739968 | g132405 | i0 | 100 | 0.121457489878543 | 30 | 0 | 12 | 0 | 165 | 194 | 211173 | 211144 | Bacillus phage vB_BpuM-BpSp, complete genome | blastn | 30 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Takahashivirus | Bacillus phage vB_BpuM-BpSp | ||||
| 19020041 | 19020041 | PRJNA675042_P_NODE_63715_length_302_cov_1.323144_g63265_i0 | PRJNA675042 | 63715 | 302 | 1.323144 | 3.99589488 | Viruses | 10239 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|2051140172|tpg|BK015707.1| | 2826332 | g63265 | i0 | 100 | 0.185430463576159 | 28 | 0 | 9 | 0 | 175 | 202 | 18044 | 18071 | MAG TPA_asm: Siphoviridae sp. ctRCE13, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctRCE13 | |||||
| 21049971 | 21049971 | PRJNA675042_P_NODE_79697_length_281_cov_1.192308_g79247_i0 | PRJNA675042 | 79697 | 281 | 1.192308 | 3.35038548 | Varicellovirus canidalpha1 | 3050251 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|1953434698|gb|MW353127.1| | 170325 | g79247 | i0 | 96.774 | 3.19928825622776 | 31 | 1 | 11 | 0 | 47 | 77 | 112790 | 112820 | Canid alphaherpesvirus 1 strain ELAL-3, complete genome | blastn | 899 | 52.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus canidalpha1 |
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);;