contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1011844" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27793014 | 27793014 | PRJNA1011844_P_NODE_148344_length_249_cov_2.363636_g139765_i0 | PRJNA1011844 | 148344 | 249 | 2.363636 | 5.88545364 | Bradyrhizobium phage BDU-MI-1 | 1983459 | Viruses | Viruses | 55.8 | 9.17e-7 | NR | ARQ95354.1 | 1983459 | g139765 | i0 | 49.2 | 0.710843373493976 | 59 | 27 | 71.1 | 1 | 189 | 13 | 1 | 56 | ARQ95354.1 hypothetical protein [Bradyrhizobium phage BDU-MI-1] | diamond | 177 | 55.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bradyrhizobium phage BDU-MI-1 | |||||
| 28361101 | 28361101 | PRJNA1011844_P_NODE_136766_length_261_cov_1.984043_g128188_i0 | PRJNA1011844 | 136766 | 261 | 1.984043 | 5.17835223 | Clavibacter phage CMP1 | 686439 | Viruses | Viruses | 51.6 | 3.38e-5 | NR | YP_003359103.1 | 686439 | g128188 | i0 | 57.4 | 0.540229885057471 | 47 | 20 | 54 | 0 | 155 | 15 | 116 | 162 | YP_003359103.1 portal protein [Clavibacter phage CMP1] | diamond | 141 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cimpunavirus | Cimpunavirus CMP1 | ||||
| 28487609 | 28487609 | PRJNA1011844_P_NODE_106167_length_310_cov_4.337553_g97594_i0 | PRJNA1011844 | 106167 | 310 | 4.337553 | 13.4464143 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42.4 | 0.0109 | NR | XOR11060.1 | 2832643 | g97594 | i0 | 45.7 | 0.445161290322581 | 46 | 22 | 41.6 | 1 | 21 | 149 | 1 | 46 | XOR11060.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 138 | 42.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28550861 | 28550861 | PRJNA1011844_P_NODE_138427_length_259_cov_2.161290_g129849_i0 | PRJNA1011844 | 138427 | 259 | 2.16129 | 5.5977411 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 88.2 | 1.06e-18 | NR | XOR25180.1 | 2832643 | g129849 | i0 | 61.7 | 0.938223938223938 | 81 | 28 | 90.3 | 2 | 20 | 253 | 127 | 207 | XOR25180.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 243 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29497860 | 29497860 | PRJNA1011844_P_NODE_141950_length_255_cov_1.851648_g133372_i0 | PRJNA1011844 | 141950 | 255 | 1.851648 | 4.7217024 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 42.7 | 0.0343 | NR | CAB4146277.1 | 2100421 | g133372 | i0 | 39.3 | 0.717647058823529 | 61 | 31 | 64.7 | 1 | 40 | 204 | 53 | 113 | CAB4146277.1 hypothetical protein UFOVP478_23 [uncultured Caudovirales phage] | diamond | 183 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30824605 | 30824605 | PRJNA1011844_P_NODE_167594_length_232_cov_2.742138_g159013_i0 | PRJNA1011844 | 167594 | 232 | 2.742138 | 6.36176016 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 104 | 6.43e-25 | NR | CAB4147590.1 | 2100421 | g159013 | i0 | 71.2 | 0.943965517241379 | 73 | 21 | 94.4 | 0 | 11 | 229 | 42 | 114 | CAB4147590.1 hypothetical protein UFOVP507_36 [uncultured Caudovirales phage] | diamond | 219 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31077620 | 31077620 | PRJNA1011844_P_NODE_65755_length_482_cov_1.748166_g57329_i0 | PRJNA1011844 | 65755 | 482 | 1.748166 | 8.42616012 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 48.1 | 1.66e-4 | NR | XOS47303.1 | 2832643 | g57329 | i0 | 59.5 | 0.230290456431535 | 37 | 15 | 23 | 0 | 361 | 251 | 5 | 41 | XOS47303.1 MAG: hypothetical protein MSP0429_98 [Caudoviricetes sp.] | diamond | 111 | 48.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31488703 | 31488703 | PRJNA1011844_P_NODE_177656_length_206_cov_4.150376_g169074_i0 | PRJNA1011844 | 177656 | 206 | 4.150376 | 8.54977456 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 40.4 | 0.0473 | NR | DAV92362.1 | 2832643 | g169074 | i0 | 37.5 | 0.699029126213592 | 48 | 30 | 69.9 | 0 | 174 | 31 | 7 | 54 | DAV92362.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 144 | 40.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32815975 | 32815975 | PRJNA1011844_P_NODE_167540_length_232_cov_2.993711_g158959_i0 | PRJNA1011844 | 167540 | 232 | 2.993711 | 6.94540952 | Virus Rctr197k | 1924548 | Viruses | Viruses | 102 | 1.2199999999999999e-23 | NR | APU88843.1 | 1924548 | g158959 | i0 | 57.5 | 0.943965517241379 | 73 | 31 | 94.4 | 0 | 220 | 2 | 187 | 259 | APU88843.1 conserved hypothetical protein [Virus Rctr197k] | diamond | 219 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Virus Rctr197k |
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);;