contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9923807 | 9923807 | PRJEB75230_P_NODE_12028_length_443_cov_1.378378_g11846_i0 | PRJEB75230 | 12028 | 443 | 1.378378 | 6.10621454 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 177 | 1.49e-51 | NR | XOS40287.1 | 2832643 | g11846 | i0 | 79.8 | 0.738148984198646 | 109 | 22 | 73.8 | 0 | 116 | 442 | 57 | 165 | XOS40287.1 MAG: phage P4 alpha zn-binding domain-containing protein [Caudoviricetes sp.] | diamond | 327 | 177 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27381989 | 27381989 | PRJEB75230_P_NODE_130403_length_249_cov_0.875000_g130221_i0 | PRJEB75230 | 130403 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 130 | 1.13e-33 | NR | WOE43378.1 | 2832643 | g130221 | i0 | 79.3 | 0.987951807228916 | 82 | 17 | 98.8 | 0 | 248 | 3 | 411 | 492 | WOE43378.1 MAG: terminase large subunit [Caudoviricetes sp.] | diamond | 246 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27918557 | 27918557 | PRJEB75230_P_NODE_149345_length_246_cov_0.890173_g149163_i0 | PRJEB75230 | 149345 | 246 | 0.890173 | 2.18982558 | Xanthomonas phage Xoo-sp13 | 2591401 | Viruses | Viruses | 121 | 3.1000000000000003e-30 | NR | QDJ96422.1 | 2591401 | g149163 | i0 | 79.5 | 0.890243902439024 | 73 | 15 | 89 | 0 | 28 | 246 | 1 | 73 | QDJ96422.1 helicase [Xanthomonas phage Xoo-sp13] | diamond | 219 | 121 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage Xoo-sp13 | |||||
| 28487056 | 28487056 | PRJEB75230_P_NODE_149847_length_246_cov_0.890173_g149665_i0 | PRJEB75230 | 149847 | 246 | 0.890173 | 2.18982558 | Stenotrophomonas phage RAS14 | 2996120 | Viruses | Viruses | 44.3 | 0.011 | NR | WAX21861.1 | 2996120 | g149665 | i0 | 62.5 | 0.390243902439024 | 32 | 12 | 39 | 0 | 98 | 3 | 1 | 32 | WAX21861.1 hypothetical protein [Stenotrophomonas phage RAS14] | diamond | 96 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage RAS14 | |||||
| 28550329 | 28550329 | PRJEB75230_P_NODE_184947_length_237_cov_2.817073_g184765_i0 | PRJEB75230 | 184947 | 237 | 2.817073 | 6.67646301 | Salmonella virus STSR3 | 2743845 | Viruses | Viruses | 40.8 | 0.0201 | NR | QLF85294.1 | 2743845 | g184765 | i0 | 53.1 | 0.40506329113924 | 32 | 14 | 39.2 | 1 | 152 | 60 | 19 | 50 | QLF85294.1 hypothetical protein STSR3_10 [Salmonella virus STSR3] | diamond | 96 | 40.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Salmonella virus STSR3 | ||||
| 28865815 | 28865815 | PRJEB75230_P_NODE_14428_length_419_cov_2.341040_g14246_i0 | PRJEB75230 | 14428 | 419 | 2.34104 | 9.8089576 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 57.8 | 1.28e-6 | NR | CAB4162630.1 | 2100421 | g14246 | i0 | 31.5 | 0.887828162291169 | 124 | 78 | 86.6 | 3 | 34 | 396 | 30 | 149 | CAB4162630.1 hypothetical protein UFOVP783_80 [uncultured Caudovirales phage] | diamond | 372 | 57.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29237642 | 29237642 | PRJEB75230_P_NODE_8949_length_489_cov_1.406250_g8767_i0 | PRJEB75230 | 8949 | 489 | 1.40625 | 6.8765625 | Viruses | 10239 | Viruses | Viruses | 89.4 | 1.35e-18 | NR | YP_009003183.1 | 1414737 | g8767 | i0 | 51.9 | 1.67484662576687 | 79 | 37 | 48.5 | 1 | 447 | 211 | 110 | 187 | YP_009003183.1 hypothetical protein CC53_gp026 [Rhizobium phage vB_RleS_L338C] | diamond | 819 | 89.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage vB_RleS_L338C | |||||
| 29433895 | 29433895 | PRJEB75230_P_NODE_161870_length_244_cov_0.900585_g161688_i0 | PRJEB75230 | 161870 | 244 | 0.900585 | 2.1974274 | Ralstonia phage RP31 | 1923890 | Viruses | Viruses | 57 | 3.68e-7 | NR | BAW19301.1 | 1923890 | g161688 | i0 | 42.4 | 0.811475409836066 | 66 | 38 | 81.1 | 0 | 2 | 199 | 669 | 734 | BAW19301.1 putative RNA polymerase beta subunit [Ralstonia phage RP31] | diamond | 198 | 57 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 29869027 | 29869027 | PRJEB75230_P_NODE_116451_length_251_cov_2.196629_g116269_i0 | PRJEB75230 | 116451 | 251 | 2.196629 | 5.51353879 | root | 1 | Root_unresolved | Root_unresolved | 153 | 2.47e-41 | NR | XOS04978.1 | 2832643 | g116269 | i0 | 88 | 1.9840637450199201 | 83 | 10 | 99.2 | 0 | 250 | 2 | 181 | 263 | XOS04978.1 MAG: putative primase [Caudoviricetes sp.] | diamond | 498 | 153 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31266559 | 31266559 | PRJEB75230_P_NODE_41375_length_325_cov_1.785714_g41193_i0 | PRJEB75230 | 41375 | 325 | 1.785714 | 5.8035705 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 156 | 4.32e-43 | NR | XOR10445.1 | 2832643 | g41193 | i0 | 85.9 | 2.35384615384615 | 85 | 12 | 78.5 | 0 | 256 | 2 | 2 | 86 | XOR10445.1 MAG: p097 protein [Caudoviricetes sp.] | diamond | 765 | 156 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31551444 | 31551444 | PRJEB75230_P_NODE_70556_length_288_cov_1.418605_g70374_i0 | PRJEB75230 | 70556 | 288 | 1.418605 | 4.0855824 | Ralstonia phage RP12 | 1923889 | Viruses | Viruses | 61.2 | 1.58e-8 | NR | YP_009598905.1 | 1923889 | g70374 | i0 | 40.5 | 0.822916666666667 | 79 | 47 | 82.3 | 0 | 237 | 1 | 17 | 95 | YP_009598905.1 ribose-phosphate pyrophosphokinase [Ralstonia phage RP12] | diamond | 237 | 61.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 31899131 | 31899131 | PRJEB75230_P_NODE_142857_length_247_cov_0.885057_g142675_i0 | PRJEB75230 | 142857 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 1.01e-27 | NR | XOR09692.1 | 2832643 | g142675 | i0 | 57.3 | 0.995951417004049 | 82 | 35 | 99.6 | 0 | 1 | 246 | 74 | 155 | XOR09692.1 MAG: putative HNH endonuclease [Caudoviricetes sp.] | diamond | 246 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32437280 | 32437280 | PRJEB75230_P_NODE_167879_length_243_cov_0.905882_g167697_i0 | PRJEB75230 | 167879 | 243 | 0.905882 | 2.20129326 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 114 | 2.02e-27 | NR | DAM72800.1 | 2831613 | g167697 | i0 | 62.5 | 4.88888888888889 | 80 | 30 | 98.8 | 0 | 241 | 2 | 424 | 503 | DAM72800.1 MAG TPA: Chromatin remodeling complex ATPase [Herelleviridae sp.] | diamond | 1188 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 32689394 | 32689394 | PRJEB75230_P_NODE_181580_length_241_cov_0.916667_g181398_i0 | PRJEB75230 | 181580 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 113 | 2.47e-27 | NR | DAU56310.1 | 2832643 | g181398 | i0 | 70.5 | 1.96680497925311 | 78 | 23 | 97.1 | 0 | 8 | 241 | 83 | 160 | DAU56310.1 MAG TPA: DNA helicase [Caudoviricetes sp.] | diamond | 474 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;