contig_metadata
10 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;