contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27605338 | 27605338 | PRJNA1118794_P_NODE_54004_length_249_cov_0.875000_g53254_i0 | PRJNA1118794 | 54004 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 89.4 | 1.57e-18 | NR | QHJ77332.1 | 2832643 | g53254 | i0 | 52.5 | 0.963855421686747 | 80 | 38 | 96.4 | 0 | 247 | 8 | 531 | 610 | QHJ77332.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 240 | 89.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28110216 | 28110216 | PRJNA1118794_P_NODE_67025_length_243_cov_1.811765_g66275_i0 | PRJNA1118794 | 67025 | 243 | 1.811765 | 4.40258895 | Agrobacterium phage Atu_ph | 3435407 | Viruses | Viruses | 45.8 | 0.00298 | NR | YP_009611863.1 | 2024264 | g66275 | i0 | 44.4 | 0.666666666666667 | 54 | 28 | 65.4 | 2 | 160 | 2 | 1 | 53 | YP_009611863.1 portal protein [Agrobacterium phage Atu_ph07] | diamond | 162 | 45.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Polybotosvirus | Polybotosvirus Atuph07 | ||||
| 29184076 | 29184076 | PRJNA1118794_P_NODE_70809_length_242_cov_0.911243_g70059_i0 | PRJNA1118794 | 70809 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 105 | 1.12e-27 | NR | XOS54950.1 | 2832643 | g70059 | i0 | 71 | 0.768595041322314 | 62 | 18 | 76.9 | 0 | 186 | 1 | 20 | 81 | XOS54950.1 MAG: hypothetical protein MSP0307_62 [Caudoviricetes sp.] | diamond | 186 | 105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29499526 | 29499526 | PRJNA1118794_P_NODE_52950_length_249_cov_1.437500_g52200_i0 | PRJNA1118794 | 52950 | 249 | 1.4375 | 3.579375 | Eurybiavirus sp. | 2821410 | Viruses | Viruses | 53.1 | 8.12e-6 | NR | BCU98624.1 | 2821410 | g52200 | i0 | 32.5 | 2.67469879518072 | 80 | 52 | 94 | 1 | 243 | 10 | 100 | 179 | BCU98624.1 MAG: hypothetical protein CM15mV23_0050 [Eurybiavirus sp.] | diamond | 666 | 53.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Eurybiavirus | Eurybiavirus sp. | ||||
| 30541983 | 30541983 | PRJNA1118794_P_NODE_74373_length_241_cov_0.916667_g73623_i0 | PRJNA1118794 | 74373 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 103 | 3.85e-24 | NR | DAV36682.1 | 2832643 | g73623 | i0 | 56.3 | 0.995850622406639 | 80 | 35 | 99.6 | 0 | 1 | 240 | 158 | 237 | DAV36682.1 MAG TPA: endonuclease [Caudoviricetes sp.] | diamond | 240 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30826315 | 30826315 | PRJNA1118794_P_NODE_58994_length_247_cov_0.885057_g58244_i0 | PRJNA1118794 | 58994 | 247 | 0.885057 | 2.18609079 | Bordetella phage vB_BbrP_BB8 | 2587820 | Viruses | Viruses | 73.6 | 2.86e-14 | NR | QDB71031.1 | 2587820 | g58244 | i0 | 47.5 | 2.00404858299595 | 80 | 41 | 96 | 1 | 11 | 247 | 44 | 123 | QDB71031.1 hypothetical protein bb8_p56 [Bordetella phage vB_BbrP_BB8] | diamond | 495 | 73.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Vistulavirus | Vistulavirus BB8 | |||
| 32091234 | 32091234 | PRJNA1118794_P_NODE_54138_length_249_cov_0.875000_g53388_i0 | PRJNA1118794 | 54138 | 249 | 0.875 | 2.17875 | Ralstonia phage RsoM2USA | 2070027 | Viruses | Viruses | 86.3 | 1.92e-17 | NR | AVH85290.1 | 2070027 | g53388 | i0 | 51.9 | 2.95180722891566 | 81 | 39 | 97.6 | 0 | 6 | 248 | 165 | 245 | AVH85290.1 hypothetical protein RsoM2USA_362 [Ralstonia phage RsoM2USA] | diamond | 735 | 86.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage RsoM2USA | |||||
| 32344603 | 32344603 | PRJNA1118794_P_NODE_33199_length_284_cov_1.393365_g32449_i0 | PRJNA1118794 | 33199 | 284 | 1.393365 | 3.9571566 | Gordonia Phage Zitch | 2743909 | Viruses | Viruses | 62.8 | 5.47e-9 | NR | YP_010002699.1 | 2743909 | g32449 | i0 | 52.1 | 1.7112676056338 | 73 | 33 | 77.1 | 1 | 64 | 282 | 617 | 687 | YP_010002699.1 minor tail protein [Gordonia Phage Zitch] | diamond | 486 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stackebrandtviridae | Zitchvirus | Zitchvirus zitch | |||
| 32660022 | 32660022 | PRJNA1118794_P_NODE_38260_length_272_cov_2.226131_g37510_i0 | PRJNA1118794 | 38260 | 272 | 2.226131 | 6.05507632 | Maribacter phage Panino | 3135610 | Viruses | Viruses | 43.1 | 0.0357 | NR | WZE63580.1 | 3135610 | g37510 | i0 | 29.7 | 0.816176470588235 | 74 | 50 | 81.6 | 2 | 46 | 267 | 61 | 132 | WZE63580.1 DNA transfer protein [Maribacter phage Panino] | diamond | 222 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Maribacter phage Panino |
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);;