contig_metadata
14 rows where bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12378450 | 12378450 | PRJNA924320_S_NODE_50510_length_165_cov_0.879310_g50368_i0 | PRJNA924320 | 50510 | 165 | 0.87931 | 1.4508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|2060053595|tpg|BK028058.1| | 2832643 | g50368 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 128 | 155 | 49390 | 49363 | MAG TPA_asm: Caudoviricetes sp. isolate ctNaS19, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17477606 | 17477606 | PRJNA924320_S_NODE_7334_length_355_cov_3.660131_g7192_i0 | PRJNA924320 | 7334 | 355 | 3.660131 | 12.99346505 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1862933311|emb|LR798231.1| | 2100421 | g7192 | i0 | 100 | 0.157746478873239 | 28 | 0 | 8 | 0 | 68 | 95 | 322907 | 322880 | uncultured Caudovirales phage genome assembly | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 17829743 | 17829743 | PRJNA924320_S_NODE_53494_length_163_cov_0.894737_g53352_i0 | PRJNA924320 | 53494 | 163 | 0.894737 | 1.45842131 | Viruses | 10239 | Viruses | Viruses | 279 | 5.73e-71 | NTclustered | gi|2314129646|tpd|BR001712.1| | 2774419 | g53352 | i0 | 97.546 | 95.1963190184049 | 163 | 4 | 100 | 0 | 1 | 163 | 25545 | 25383 | MAG TPA_asm: Siphovirus LN-2020-2 Modern44_CT89 DNA, nearly complete genome | blastn | 15517 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphovirus LN-2020-2 | |||||
| 22929978 | 22929978 | PRJNA924320_S_NODE_45678_length_167_cov_1.686441_g45536_i0 | PRJNA924320 | 45678 | 167 | 1.686441 | 2.81635647 | Lymphocryptovirus | 10375 | Viruses | Viruses | 309 | 7.53e-80 | NTclustered | gi|764011926|emb|LN827583.1| | 10376 | g45536 | i0 | 100 | 101 | 167 | 0 | 100 | 0 | 1 | 167 | 159180 | 159346 | Human herpesvirus 4 genome assembly sLCL-IM1.17, segment : I | blastn | 16867 | 309 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26676208 | 26676208 | PRJNA924320_S_NODE_52741_length_163_cov_1.789474_g52599_i0 | PRJNA924320 | 52741 | 163 | 1.789474 | 2.91684262 | Vibrio virus VPMCC5 | 2900301 | Viruses | Viruses | 75.5 | 1.2e-14 | NR | UIW11075.1 | 2900301 | g52599 | i0 | 68.5 | 2.98159509202454 | 54 | 17 | 99.4 | 0 | 2 | 163 | 162 | 215 | UIW11075.1 putative head completion adaptor [Vibrio virus VPMCC5] | diamond | 486 | 75.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio virus VPMCC5 | ||||
| 28856211 | 28856211 | PRJNA924320_S_NODE_48408_length_166_cov_0.871795_g48266_i0 | PRJNA924320 | 48408 | 166 | 0.871795 | 1.4471797 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 3.56e-22 | NR | XOS48669.1 | 2832643 | g48266 | i0 | 80 | 0.993975903614458 | 55 | 11 | 99.4 | 0 | 166 | 2 | 52 | 106 | XOS48669.1 MAG: hypothetical protein MSP0393_28 [Caudoviricetes sp.] | diamond | 165 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29740194 | 29740194 | PRJNA924320_S_NODE_56370_length_161_cov_1.821429_g56228_i0 | PRJNA924320 | 56370 | 161 | 1.821429 | 2.93250069 | Acinetobacter phage APK2 | 2865959 | Viruses | Viruses | 45.4 | 0.00137 | NR | UAW10085.1 | 2873375 | g56228 | i0 | 45 | 0.745341614906832 | 40 | 22 | 74.5 | 0 | 34 | 153 | 184 | 223 | UAW10085.1 tailspike protein [Acinetobacter phage APK20] | diamond | 120 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autoscriptoviridae | Friunavirus | Friunavirus APK20 | ||
| 30593341 | 30593341 | PRJNA924320_S_NODE_55213_length_162_cov_0.902655_g55071_i0 | PRJNA924320 | 55213 | 162 | 0.902655 | 1.4623011 | Pseudoalteromonas phage vB_PtuP_Slicky | 3038240 | Viruses | Viruses | 81.6 | 5.98e-17 | NR | WGH49963.1 | 3038240 | g55071 | i0 | 71.4 | 0.907407407407407 | 49 | 14 | 90.7 | 0 | 3 | 149 | 16 | 64 | WGH49963.1 hypothetical protein [Pseudoalteromonas phage vB_PtuP_Slicky01] | diamond | 147 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudoalteromonas phage vB_PtuP_Slicky01 | |||||
| 31067561 | 31067561 | PRJNA924320_S_NODE_7095_length_360_cov_3.418006_g6953_i0 | PRJNA924320 | 7095 | 360 | 3.418006 | 12.3048216 | Pseudomonas phage GP1 | 2055238 | Viruses | Viruses | 49.3 | 7.01e-4 | NR | SPF82137.1 | 2055238 | g6953 | i0 | 56.8 | 0.308333333333333 | 37 | 16 | 30.8 | 0 | 4 | 114 | 557 | 593 | SPF82137.1 The actual alignment was detected with superfamily member TIGR01709: [Pseudomonas phage GP100] | diamond | 111 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 31668076 | 31668076 | PRJNA924320_S_NODE_13377_length_273_cov_1.138393_g13235_i0 | PRJNA924320 | 13377 | 273 | 1.138393 | 3.10781289 | Vibrio phage 1.235.O._1 | 1881352 | Viruses | Viruses | 117 | 3.05e-28 | NR | AUR96941.1 | 1881352 | g13235 | i0 | 71.2 | 2.37362637362637 | 73 | 21 | 80.2 | 0 | 53 | 271 | 1 | 73 | AUR96941.1 head-to-tail joining protein [Vibrio phage 1.235.O._10N.261.52.B2] | diamond | 648 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio phage 1.235.O._10N.261.52.B2 | ||||
| 31738502 | 31738502 | PRJNA924320_S_NODE_48177_length_166_cov_0.871795_g48035_i0 | PRJNA924320 | 48177 | 166 | 0.871795 | 1.4471797 | Viruses | 10239 | Viruses | Viruses | 73.2 | 9.8e-14 | NR | SPF82143.1 | 2055238 | g48035 | i0 | 72.9 | 2.63855421686747 | 48 | 13 | 86.7 | 0 | 148 | 5 | 5 | 52 | SPF82143.1 Phage protein [Pseudomonas phage GP100] | diamond | 438 | 73.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 31928440 | 31928440 | PRJNA924320_S_NODE_817_length_960_cov_2.003293_g744_i0 | PRJNA924320 | 817 | 960 | 2.003293 | 19.2316128 | Viruses | 10239 | Viruses | Viruses | 248 | 6.79e-77 | NR | AUR96944.1 | 1881352 | g744 | i0 | 75 | 1.00625 | 160 | 40 | 50 | 0 | 474 | 953 | 1 | 160 | AUR96944.1 major capsid protein [Vibrio phage 1.235.O._10N.261.52.B2] | diamond | 966 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio phage 1.235.O._10N.261.52.B2 | ||||
| 32111129 | 32111129 | PRJNA924320_S_NODE_28818_length_202_cov_1.215686_g28676_i0 | PRJNA924320 | 28818 | 202 | 1.215686 | 2.45568572 | Rheinheimera phage vB_RspM_Barba18A | 2565657 | Viruses | Viruses | 70.9 | 8.35e-14 | NR | YP_009823000.1 | 2565657 | g28676 | i0 | 53.1 | 1.9009900990099 | 64 | 30 | 95 | 0 | 197 | 6 | 47 | 110 | YP_009823000.1 endolysin [Rheinheimera phage vB_RspM_Barba18A] | diamond | 384 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Barbavirus | Barbavirus barba18A | ||||
| 32743166 | 32743166 | PRJNA924320_S_NODE_26860_length_207_cov_1.936709_g26718_i0 | PRJNA924320 | 26860 | 207 | 1.936709 | 4.00898763 | Citrobacter phage CVT22 | 1622234 | Viruses | Viruses | 83.6 | 9.33e-17 | NR | YP_009168387.1 | 1622234 | g26718 | i0 | 63.6 | 1.91304347826087 | 66 | 24 | 95.7 | 0 | 6 | 203 | 515 | 580 | YP_009168387.1 head-tail adaptor [Citrobacter phage CVT22] | diamond | 396 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Citrovirus | Citrovirus coptotermitis |
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);;