contig_metadata
11 rows where bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1271595 | 1271595 | PRJNA983848_P_NODE_150081_length_247_cov_0.896552_g144198_i0 | PRJNA983848 | 150081 | 247 | 0.896552 | 2.21448344 | Viruses | 10239 | Viruses | Viruses | 248 | 2.65e-61 | NTclustered | gi|1817928471|gb|MN988496.1| | 2509575 | g144198 | i0 | 87.736 | 2.78542510121457 | 212 | 26 | 86 | 0 | 36 | 247 | 45134 | 44923 | Rhizobium phage RHph_TM3_3_14B, complete genome | blastn | 688 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage RHph_TM3_3_14B | |||||
| 2245710 | 2245710 | PRJNA983848_P_NODE_72862_length_368_cov_1.515254_g66979_i0 | PRJNA983848 | 72862 | 368 | 1.515254 | 5.57613472 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.035 | NTclustered | gi|2057905075|tpg|BK051223.1| | 2832643 | g66979 | i0 | 100 | 0.152173913043478 | 28 | 0 | 8 | 0 | 23 | 50 | 18602 | 18575 | MAG TPA_asm: Caudoviricetes sp. isolate ctHTF4, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11171078 | 11171078 | PRJNA983848_P_NODE_143989_length_250_cov_0.881356_g138106_i0 | PRJNA983848 | 143989 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.91e-122 | NTclustered | gi|2915024281|gb|OR222600.1| | 2832643 | g138106 | i0 | 99.595 | 99.14 | 247 | 1 | 99 | 0 | 1 | 247 | 27305 | 27551 | MAG: Caudoviricetes sp. isolate MSP0334 genomic sequence | blastn | 24785 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13722936 | 13722936 | PRJNA983848_P_NODE_42031_length_574_cov_2.808383_g36182_i0 | PRJNA983848 | 42031 | 574 | 2.808383 | 16.12011842 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.016 | NTclustered | gi|2057056863|tpg|BK037435.1| | 2832643 | g36182 | i0 | 100 | 0.0505226480836237 | 29 | 0 | 5 | 0 | 180 | 208 | 13449 | 13421 | MAG TPA_asm: Caudoviricetes sp. isolate ctKbT3, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14994470 | 14994470 | PRJNA983848_P_NODE_110832_length_286_cov_0.741784_g104949_i0 | PRJNA983848 | 110832 | 286 | 0.741784 | 2.12150224 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 126 | 1.5399999999999999e-24 | NTclustered | gi|2059608416|tpg|BK037250.1| | 2832643 | g104949 | i0 | 82.313 | 0.513986013986014 | 147 | 24 | 51 | 2 | 16 | 161 | 17633 | 17778 | MAG TPA_asm: Caudoviricetes sp. isolate ctmNp13, partial genome | blastn | 147 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16270946 | 16270946 | PRJNA983848_P_NODE_155933_length_244_cov_0.912281_g150050_i0 | PRJNA983848 | 155933 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.48e-103 | NTclustered | gi|2914754492|gb|OR221467.1| | 2832643 | g150050 | i0 | 96.97 | 1.90983606557377 | 231 | 7 | 95 | 0 | 1 | 231 | 31141 | 30911 | MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence | blastn | 466 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17545754 | 17545754 | PRJNA983848_P_NODE_150134_length_247_cov_0.896552_g144251_i0 | PRJNA983848 | 150134 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2915019340|gb|OR222551.1| | 2832643 | g144251 | i0 | 100 | 9.93117408906883 | 247 | 0 | 100 | 0 | 1 | 247 | 39676 | 39430 | MAG: Caudoviricetes sp. isolate MSP0382 genomic sequence | blastn | 2453 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27721816 | 27721816 | PRJNA983848_P_NODE_149844_length_247_cov_0.896552_g143961_i0 | PRJNA983848 | 149844 | 247 | 0.896552 | 2.21448344 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 75.9 | 4.98e-16 | NR | CAB4148105.1 | 2100421 | g143961 | i0 | 63.5 | 0.631578947368421 | 52 | 16 | 63.2 | 1 | 247 | 92 | 9 | 57 | CAB4148105.1 hypothetical protein UFOVP431_110 [uncultured Caudovirales phage] | diamond | 156 | 75.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28921007 | 28921007 | PRJNA983848_P_NODE_150228_length_247_cov_0.896552_g144345_i0 | PRJNA983848 | 150228 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 68.6 | 3.23e-11 | NR | XOR78579.1 | 2832643 | g144345 | i0 | 72.7 | 0.534412955465587 | 44 | 12 | 53.4 | 0 | 247 | 116 | 887 | 930 | XOR78579.1 MAG: p036 protein [Caudoviricetes sp.] | diamond | 132 | 68.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29589864 | 29589864 | PRJNA983848_P_NODE_142070_length_251_cov_0.876404_g136187_i0 | PRJNA983848 | 142070 | 251 | 0.876404 | 2.19977404 | root | 1 | Root_unresolved | Root_unresolved | 108 | 2.04e-25 | NR | YP_009005974.1 | 1458697 | g136187 | i0 | 63.4 | 8.85657370517928 | 82 | 30 | 98 | 0 | 247 | 2 | 396 | 477 | YP_009005974.1 DNA polymerase [Rhizobium phage vB_RglS_P106B] | diamond | 2223 | 109 | 0.990825688073395 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rigallicvirus | Rigallicvirus P106B | ||||
| 32366044 | 32366044 | PRJNA983848_P_NODE_143659_length_250_cov_0.881356_g137776_i0 | PRJNA983848 | 143659 | 250 | 0.881356 | 2.20339 | Haloarcula hispanica tailed virus 2 | 1273751 | Viruses | Viruses | 115 | 7.83e-29 | NR | YP_008060355.1 | 1273751 | g137776 | i0 | 64.2 | 0.972 | 81 | 29 | 97.2 | 0 | 3 | 245 | 202 | 282 | YP_008060355.1 minor tail protein [Haloarcula hispanica tailed virus 2] | diamond | 243 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Saparoviridae | Halohivirus | Halohivirus suolae |
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);;