contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26665194 | 26665194 | PRJNA494251_P_NODE_5181_length_560_cov_1.215606_g4887_i0 | PRJNA494251 | 5181 | 560 | 1.215606 | 6.8073936 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.8 | 3.47e-7 | NR | XOR05084.1 | 2832643 | g4887 | i0 | 47.5 | 0.739285714285714 | 61 | 30 | 31.6 | 1 | 1 | 177 | 312 | 372 | XOR05084.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 414 | 60.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27740627 | 27740627 | PRJNA494251_P_NODE_24944_length_291_cov_1.412844_g24630_i0 | PRJNA494251 | 24944 | 291 | 1.412844 | 4.11137604 | Rhizobium phage RHph_TM39 | 2509768 | Viruses | Viruses | 55.5 | 2.22e-6 | NR | QIG77325.1 | 2509768 | g24630 | i0 | 34.1 | 0.938144329896907 | 91 | 58 | 93.8 | 1 | 279 | 7 | 239 | 327 | QIG77325.1 portal vertex protein of head [Rhizobium phage RHph_TM39] | diamond | 273 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kleczkowskaviridae | Cuauhnahuacvirus | Rhizobium phage RHph_TM39 | |||
| 29287316 | 29287316 | PRJNA494251_P_NODE_21469_length_309_cov_0.915254_g21155_i0 | PRJNA494251 | 21469 | 309 | 0.915254 | 2.82813486 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 62.8 | 7.02e-9 | NR | CAB4180527.1 | 2100421 | g21155 | i0 | 60.9 | 0.446601941747573 | 46 | 18 | 44.7 | 0 | 307 | 170 | 256 | 301 | CAB4180527.1 hypothetical protein UFOVP1040_70 [uncultured Caudovirales phage] | diamond | 138 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29350647 | 29350647 | PRJNA494251_P_NODE_15169_length_356_cov_1.402827_g14856_i0 | PRJNA494251 | 15169 | 356 | 1.402827 | 4.99406412 | Escherichia phage vB_EcoM_IME392 | 2301649 | Viruses | Viruses | 93.6 | 1.61e-19 | NR | AXY86103.1 | 2301649 | g14856 | i0 | 42.1 | 0.960674157303371 | 114 | 66 | 96.1 | 0 | 353 | 12 | 204 | 317 | AXY86103.1 putative major capsid protein [Escherichia phage vB_EcoM_IME392] | diamond | 342 | 93.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Escherichia phage vB_EcoM_IME392 | |||||
| 29571516 | 29571516 | PRJNA494251_P_NODE_590_length_1389_cov_11.214286_g473_i0 | PRJNA494251 | 590 | 1389 | 11.214286 | 155.76643254 | Ralstonia phage RP13 | 2743402 | Viruses | Viruses | 162 | 8.71e-41 | NR | BCG50090.1 | 2743402 | g473 | i0 | 48.7 | 0.341252699784017 | 158 | 81 | 34.1 | 0 | 14 | 487 | 316 | 473 | BCG50090.1 hypothetical protein [Ralstonia phage RP13] | diamond | 474 | 162 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage RP13 | |||||
| 30139725 | 30139725 | PRJNA494251_P_NODE_23352_length_299_cov_1.230088_g23038_i0 | PRJNA494251 | 23352 | 299 | 1.230088 | 3.67796312 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0218 | NR | DAU75828.1 | 2832643 | g23038 | i0 | 58.6 | 0.290969899665552 | 29 | 12 | 29.1 | 0 | 127 | 213 | 1 | 29 | DAU75828.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 87 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30519293 | 30519293 | PRJNA494251_P_NODE_43493_length_246_cov_0.890173_g43179_i0 | PRJNA494251 | 43493 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0254 | NR | XOR29627.1 | 2832643 | g43179 | i0 | 54.1 | 0.451219512195122 | 37 | 16 | 45.1 | 1 | 5 | 115 | 15 | 50 | XOR29627.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 111 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31056696 | 31056696 | PRJNA494251_P_NODE_23015_length_300_cov_2.035242_g22701_i0 | PRJNA494251 | 23015 | 300 | 2.035242 | 6.105726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.7 | 2.12e-11 | NR | XOR60344.1 | 2832643 | g22701 | i0 | 39.1 | 1.55 | 87 | 52 | 86 | 1 | 280 | 23 | 140 | 226 | XOR60344.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 465 | 69.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32700438 | 32700438 | PRJNA494251_P_NODE_20860_length_312_cov_1.861925_g20546_i0 | PRJNA494251 | 20860 | 312 | 1.861925 | 5.809206 | Vibrio phage 15 | 2963171 | Viruses | Viruses | 110 | 6.73e-26 | NR | CAH9015086.1 | 2963171 | g20546 | i0 | 50.5 | 0.971153846153846 | 101 | 50 | 97.1 | 0 | 8 | 310 | 364 | 464 | CAH9015086.1 conserved hypothetical protein [Vibrio phage 150E35-1] | diamond | 303 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage 150E35-1 |
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);;