contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27105676 | 27105676 | PRJNA309466_P_NODE_16942_length_165_cov_0.896552_g16885_i0 | PRJNA309466 | 16942 | 165 | 0.896552 | 1.4793108 | Indivirus ILV1 | 1977633 | Viruses | Viruses | 89 | 2.66e-19 | NR | ARF10107.1 | 1977633 | g16885 | i0 | 79.2 | 0.963636363636364 | 53 | 11 | 96.4 | 0 | 160 | 2 | 261 | 313 | ARF10107.1 transposase [Indivirus ILV1] | diamond | 159 | 89 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Indivirus | Indivirus ILV1 | ||
| 27327183 | 27327183 | PRJNA309466_P_NODE_13883_length_176_cov_2.866142_g13826_i0 | PRJNA309466 | 13883 | 176 | 2.866142 | 5.04440992 | Pacmanvirus A23 | 1932881 | Viruses | Viruses | 79 | 2.59e-15 | NR | YP_009361566.1 | 1932881 | g13826 | i0 | 74.4 | 1.46590909090909 | 43 | 11 | 73.3 | 0 | 130 | 2 | 539 | 581 | YP_009361566.1 Major capsid protein [Pacmanvirus A23] | diamond | 258 | 79 | 1 | Viruses | Pacmanvirus A23 | ||||||||
| 28369039 | 28369039 | PRJNA309466_P_NODE_6686_length_229_cov_3.411111_g6629_i0 | PRJNA309466 | 6686 | 229 | 3.411111 | 7.81144419 | Bacteriophage sp. | 38018 | Viruses | Viruses | 50.4 | 4.26e-5 | NR | AXH75887.1 | 38018 | g6629 | i0 | 40.3 | 0.943231441048035 | 72 | 43 | 94.3 | 0 | 6 | 221 | 149 | 220 | AXH75887.1 MAG: hypothetical protein [Bacteriophage sp.] | diamond | 216 | 50.4 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 30769424 | 30769424 | PRJNA309466_P_NODE_14974_length_171_cov_1.704918_g14917_i0 | PRJNA309466 | 14974 | 171 | 1.704918 | 2.91540978 | Crogonang virus 159 | 3062886 | Viruses | Viruses | 90.9 | 1.52e-19 | NR | WPR17963.1 | 3062886 | g14917 | i0 | 87 | 0.807017543859649 | 46 | 6 | 80.7 | 0 | 140 | 3 | 1180 | 1225 | WPR17963.1 MAG: capsid protein [Crogonang virus 159] | diamond | 138 | 90.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 159 | ||||
| 31844156 | 31844156 | PRJNA309466_P_NODE_9637_length_202_cov_1.352941_g9580_i0 | PRJNA309466 | 9637 | 202 | 1.352941 | 2.73294082 | Crogonang virus 159 | 3062886 | Viruses | Viruses | 140 | 8.769999999999999e-37 | NR | WPR17963.1 | 3062886 | g9580 | i0 | 97 | 0.98019801980198 | 66 | 2 | 98 | 0 | 200 | 3 | 1240 | 1305 | WPR17963.1 MAG: capsid protein [Crogonang virus 159] | diamond | 198 | 140 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 159 | ||||
| 31970799 | 31970799 | PRJNA309466_P_NODE_11198_length_191_cov_2.401408_g11141_i0 | PRJNA309466 | 11198 | 191 | 2.401408 | 4.58668928 | Pseudomonas phage HU1 | 2056127 | Viruses | Viruses | 41.2 | 0.0421 | NR | BBI47399.1 | 2056127 | g11141 | i0 | 85 | 0.31413612565445 | 20 | 3 | 31.4 | 0 | 103 | 162 | 1 | 20 | BBI47399.1 putative endolysin [Pseudomonas phage HU1] | diamond | 60 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage HU1 | |||||
| 32287572 | 32287572 | PRJNA309466_P_NODE_6179_length_236_cov_1.941176_g6122_i0 | PRJNA309466 | 6179 | 236 | 1.941176 | 4.58117536 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 51.2 | 1.72e-5 | NR | CAB4142003.1 | 2100421 | g6122 | i0 | 38.7 | 0.788135593220339 | 62 | 38 | 78.8 | 0 | 8 | 193 | 109 | 170 | CAB4142003.1 hypothetical protein UFOVP427_5 [uncultured Caudovirales phage] | diamond | 186 | 51.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32382223 | 32382223 | PRJNA309466_P_NODE_15339_length_169_cov_8.075000_g15282_i0 | PRJNA309466 | 15339 | 169 | 8.075 | 13.64675 | Crogonang virus 159 | 3062886 | Viruses | Viruses | 48.1 | 1.74e-4 | NR | XII42848.1 | 3062886 | g15282 | i0 | 71.9 | 1.13609467455621 | 32 | 9 | 56.8 | 0 | 7 | 102 | 92 | 123 | XII42848.1 MAG: capsid protein, partial [Crogonang virus 159] | diamond | 192 | 48.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 159 | ||||
| 32509006 | 32509006 | PRJNA309466_P_NODE_11659_length_188_cov_2.741007_g11602_i0 | PRJNA309466 | 11659 | 188 | 2.741007 | 5.15309316 | Nucleocytoviricota sp. | 2809609 | Viruses | Viruses | 75.9 | 3.72e-14 | NR | UZT28811.1 | 2809609 | g11602 | i0 | 57.4 | 0.973404255319149 | 61 | 25 | 95.7 | 1 | 4 | 183 | 359 | 419 | UZT28811.1 phosphotransferase [Nucleocytoviricota sp.] | diamond | 183 | 75.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Nucleocytoviricota sp. | ||||||
| 32540614 | 32540614 | PRJNA309466_P_NODE_9719_length_201_cov_3.263158_g9662_i0 | PRJNA309466 | 9719 | 201 | 3.263158 | 6.55894758 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 58.2 | 7.96e-8 | NR | CAB4148597.1 | 2100421 | g9662 | i0 | 80.6 | 0.537313432835821 | 36 | 7 | 53.7 | 0 | 201 | 94 | 203 | 238 | CAB4148597.1 hypothetical protein UFOVP530_21 [uncultured Caudovirales phage] | diamond | 108 | 58.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;