contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3014749 | 3014749 | PRJNA493632_P_NODE_440003_length_264_cov_1.277487_g436564_i0 | PRJNA493632 | 440003 | 264 | 1.277487 | 3.37256568 | Andihavirus borborohabitans | 2843692 | Viruses | Viruses | 281 | 2.83e-71 | NTclustered | gi|2497515024|ref|NC_074146.1| | 2786658 | g436564 | i0 | 94.054 | 1.37878787878788 | 185 | 11 | 70 | 0 | 59 | 243 | 2 | 186 | SsRNA phage SRR7976300_9 genomic sequence | blastn | 364 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Andihavirus | Andihavirus borborohabitans | ||
| 11947410 | 11947410 | PRJNA493632_P_NODE_718810_length_211_cov_8.036232_g715368_i0 | PRJNA493632 | 718810 | 211 | 8.036232 | 16.95644952 | Chrocagost virus | 3129398 | Viruses | Viruses | 289 | 1.2999999999999999e-73 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g715368 | i0 | 91.469 | 856.161137440758 | 211 | 17 | 99 | 1 | 1 | 210 | 5828 | 5618 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 180650 | 289 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 17036593 | 17036593 | PRJNA493632_P_NODE_188114_length_353_cov_2.935714_g184683_i0 | PRJNA493632 | 188114 | 353 | 2.935714 | 10.36307042 | Sonamyl virus | 3131590 | Viruses | Viruses | 91.6 | 7.07e-14 | NTclustered | gi|2717322886|gb|PP173891.1| | 3131590 | g184683 | i0 | 91.176 | 0.192634560906516 | 68 | 4 | 19 | 2 | 40 | 106 | 2688 | 2622 | MAG: Sonamyl virus isolate SN2B_k141_68293 genomic sequence | blastn | 68 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sonamyl virus | |||||
| 22143032 | 22143032 | PRJNA493632_P_NODE_588598_length_245_cov_7.854651_g585157_i0 | PRJNA493632 | 588598 | 245 | 7.854651 | 19.24389495 | Chrocagosk virus | 3129397 | Viruses | Viruses | 191 | 4.49e-44 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g585157 | i0 | 87.879 | 0.673469387755102 | 165 | 16 | 67 | 4 | 1 | 164 | 518 | 679 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 165 | 191 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus |
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);;