contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13600117 | 13600117 | PRJNA861969_P_NODE_31131_length_251_cov_0.865169_g30900_i0 | PRJNA861969 | 31131 | 251 | 0.865169 | 2.17157419 | Xanthomonas phage XbC2 | 2978503 | Viruses | Viruses | 78.2 | 1.34e-14 | NR | UYE98870.1 | 2978503 | g30900 | i0 | 80.3 | 0.729083665338645 | 61 | 9 | 69.3 | 1 | 178 | 5 | 60 | 120 | UYE98870.1 adhesin [Xanthomonas phage XbC2] | diamond | 183 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Xanthomonas phage XbC2 | ||||
| 27718937 | 27718937 | PRJNA861969_P_NODE_35644_length_247_cov_0.885057_g35413_i0 | PRJNA861969 | 35644 | 247 | 0.885057 | 2.18609079 | Erythrobacter phage vB_EliS-L | 2909139 | Viruses | Viruses | 133 | 2.15e-34 | NR | UIS25203.1 | 2909139 | g35413 | i0 | 81.5 | 0.983805668016194 | 81 | 15 | 98.4 | 0 | 3 | 245 | 410 | 490 | UIS25203.1 portal protein [Erythrobacter phage vB_EliS-L02] | diamond | 243 | 133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Erythrobacter phage vB_EliS-L02 | |||||
| 27781774 | 27781774 | PRJNA861969_P_NODE_23384_length_283_cov_1.128571_g23153_i0 | PRJNA861969 | 23384 | 283 | 1.128571 | 3.19385593 | Stenotrophomonas phage BUCT6 | 3430623 | Viruses | Viruses | 74.7 | 1.92e-15 | NR | QVR48665.1 | 2834250 | g23153 | i0 | 54.8 | 0.657243816254417 | 62 | 25 | 65.7 | 1 | 283 | 98 | 5 | 63 | QVR48665.1 hypothetical protein [Stenotrophomonas phage BUCT609] | diamond | 186 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Maltophvirus | Maltophvirus BUCT609 | ||
| 28318377 | 28318377 | PRJNA861969_P_NODE_37306_length_245_cov_0.895349_g37075_i0 | PRJNA861969 | 37306 | 245 | 0.895349 | 2.19360505 | Yersinia phage JC221 | 2654973 | Viruses | Viruses | 116 | 9.31e-29 | NR | QFR55877.1 | 2654973 | g37075 | i0 | 69.1 | 0.991836734693878 | 81 | 25 | 99.2 | 0 | 3 | 245 | 262 | 342 | QFR55877.1 DNA topoisomerase subunit [Yersinia phage JC221] | diamond | 243 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Yersinia phage JC221 | |||
| 28476296 | 28476296 | PRJNA861969_P_NODE_23806_length_281_cov_1.149038_g23575_i0 | PRJNA861969 | 23806 | 281 | 1.149038 | 3.22879678 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 146 | 1.39e-39 | NR | XOR33963.1 | 2832643 | g23575 | i0 | 84.9 | 0.918149466192171 | 86 | 13 | 91.8 | 0 | 279 | 22 | 366 | 451 | XOR33963.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 258 | 146 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29802307 | 29802307 | PRJNA861969_P_NODE_25331_length_274_cov_1.278607_g25100_i0 | PRJNA861969 | 25331 | 274 | 1.278607 | 3.50338318 | Ralstonia phage RSK1 | 1417599 | Viruses | Viruses | 146 | 5.3799999999999996e-42 | NR | YP_008853793.1 | 1417599 | g25100 | i0 | 82.4 | 0.996350364963504 | 91 | 16 | 99.6 | 0 | 1 | 273 | 13 | 103 | YP_008853793.1 hypothetical protein X532_gp08 [Ralstonia phage RSK1] | diamond | 273 | 146 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Firingavirus | Firingavirus RSK1 | ||||
| 30118171 | 30118171 | PRJNA861969_P_NODE_33072_length_249_cov_0.875000_g32841_i0 | PRJNA861969 | 33072 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 114 | 2.01e-29 | NR | XOR18877.1 | 2832643 | g32841 | i0 | 63.3 | 0.951807228915663 | 79 | 29 | 95.2 | 0 | 13 | 249 | 2 | 80 | XOR18877.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 237 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32118151 | 32118151 | PRJNA861969_P_NODE_32418_length_250_cov_0.870056_g32187_i0 | PRJNA861969 | 32418 | 250 | 0.870056 | 2.17514 | Pavtokvirus | 3044786 | Viruses | Viruses | 116 | 5.729999999999999e-28 | NR | YP_005098423.1 | 1131315 | g32187 | i0 | 66.3 | 1.944 | 83 | 27 | 99.6 | 1 | 2 | 250 | 61 | 142 | YP_005098423.1 tail protein [Erwinia phage PEp14] | diamond | 486 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pavtokvirus | Pavtokvirus PEp14 | ||||
| 32300086 | 32300086 | PRJNA861969_P_NODE_32139_length_250_cov_0.870056_g31908_i0 | PRJNA861969 | 32139 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 65.1 | 1.61e-11 | NR | DAO01745.1 | 2832643 | g31908 | i0 | 45 | 1.884 | 80 | 42 | 96 | 2 | 248 | 9 | 11 | 88 | DAO01745.1 MAG TPA: type I neck protein [Caudoviricetes sp.] | diamond | 471 | 65.1 | 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);;