contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA812715" and tax_phylum = "Hofneiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27117334 | 27117334 | PRJNA812715_P_NODE_75062_length_293_cov_1.127273_g73262_i0 | PRJNA812715 | 75062 | 293 | 1.127273 | 3.30290989 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 59.3 | 1.93e-9 | NR | WPH57058.1 | 3096133 | g73262 | i0 | 66 | 0.511945392491468 | 50 | 17 | 51.2 | 0 | 224 | 75 | 1 | 50 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 150 | 59.3 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 27465269 | 27465269 | PRJNA812715_P_NODE_120083_length_241_cov_2.827381_g118282_i0 | PRJNA812715 | 120083 | 241 | 2.827381 | 6.81398821 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 42.7 | 0.00353 | NR | WPH57058.1 | 3096133 | g118282 | i0 | 48.2 | 0.697095435684647 | 56 | 29 | 69.7 | 0 | 5 | 172 | 1 | 56 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 168 | 42.7 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 28475517 | 28475517 | PRJNA812715_P_NODE_120106_length_241_cov_2.666667_g118305_i0 | PRJNA812715 | 120106 | 241 | 2.666667 | 6.42666747 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 58.2 | 3.02e-9 | NR | WPH57058.1 | 3096133 | g118305 | i0 | 62 | 0.622406639004149 | 50 | 19 | 62.2 | 0 | 219 | 70 | 1 | 50 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 150 | 58.2 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 29107058 | 29107058 | PRJNA812715_P_NODE_46548_length_401_cov_2.170732_g44751_i0 | PRJNA812715 | 46548 | 401 | 2.170732 | 8.70463532 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 44.7 | 0.00272 | NR | WPH57058.1 | 3096133 | g44751 | i0 | 61.5 | 1.0997506234414 | 39 | 15 | 29.2 | 0 | 120 | 236 | 18 | 56 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 441 | 44.7 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 30244044 | 30244044 | PRJNA812715_P_NODE_71392_length_302_cov_11.580786_g69592_i0 | PRJNA812715 | 71392 | 302 | 11.580786 | 34.97397372 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 77.8 | 1.1e-16 | NR | WPH57058.1 | 3096133 | g69592 | i0 | 65.5 | 0.54635761589404 | 55 | 19 | 54.6 | 0 | 3 | 167 | 2 | 56 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 165 | 77.8 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 30622877 | 30622877 | PRJNA812715_P_NODE_47593_length_395_cov_4.981366_g45796_i0 | PRJNA812715 | 47593 | 395 | 4.981366 | 19.6763957 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 53.1 | 1.39e-6 | NR | WPH57058.1 | 3096133 | g45796 | i0 | 53.6 | 0.736708860759494 | 56 | 26 | 42.5 | 0 | 101 | 268 | 1 | 56 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 291 | 53.1 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 31286492 | 31286492 | PRJNA812715_P_NODE_60595_length_336_cov_3.558935_g58796_i0 | PRJNA812715 | 60595 | 336 | 3.558935 | 11.9580216 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 48.1 | 7.11e-5 | NR | WPH57058.1 | 3096133 | g58796 | i0 | 71.4 | 0.3125 | 35 | 10 | 31.3 | 0 | 227 | 123 | 1 | 35 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 105 | 48.1 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 32045887 | 32045887 | PRJNA812715_P_NODE_110618_length_246_cov_2.508671_g108817_i0 | PRJNA812715 | 110618 | 246 | 2.508671 | 6.17133066 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 47.8 | 3.93e-5 | NR | WPH57058.1 | 3096133 | g108817 | i0 | 61.7 | 0.573170731707317 | 47 | 18 | 57.3 | 0 | 227 | 87 | 1 | 47 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 141 | 47.8 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 32077458 | 32077458 | PRJNA812715_P_NODE_86118_length_274_cov_9.746269_g84317_i0 | PRJNA812715 | 86118 | 274 | 9.746269 | 26.70477706 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 43.5 | 0.00243 | NR | WPH57058.1 | 3096133 | g84317 | i0 | 68.6 | 0.383211678832117 | 35 | 11 | 38.3 | 0 | 69 | 173 | 1 | 35 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 105 | 43.5 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta |
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);;