contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJEB56699" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2674664 | 2674664 | PRJEB56699_P_NODE_2863_length_321_cov_3.061644_g2633_i0 | PRJEB56699 | 2863 | 321 | 3.061644 | 9.82787724 | Tolivirales sp. | 2809914 | Viruses | Viruses | 117 | 5.75e-28 | NR | WRQ65272.1 | 2809914 | g2633 | i0 | 54.4 | 1.77570093457944 | 103 | 47 | 96.3 | 0 | 9 | 317 | 70 | 172 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 570 | 117 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 27286423 | 27286423 | PRJEB56699_P_NODE_463_length_854_cov_3.506667_g355_i0 | PRJEB56699 | 463 | 854 | 3.506667 | 29.94693618 | Tolivirales sp. | 2809914 | Viruses | Viruses | 387 | 1.85e-123 | NR | WRQ65272.1 | 2809914 | g355 | i0 | 65.8 | 0.997658079625293 | 284 | 97 | 99.8 | 0 | 2 | 853 | 515 | 798 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 852 | 387 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 30381546 | 30381546 | PRJEB56699_P_NODE_6553_length_156_cov_1.039370_g6323_i0 | PRJEB56699 | 6553 | 156 | 1.03937 | 1.6214172 | Tolivirales sp. | 2809914 | Viruses | Viruses | 89 | 5.78e-19 | NR | WRQ65630.1 | 2809914 | g6323 | i0 | 76.5 | 0.980769230769231 | 51 | 12 | 98.1 | 0 | 155 | 3 | 451 | 501 | WRQ65630.1 polyprotein, partial [Tolivirales sp.] | diamond | 153 | 89 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 30602160 | 30602160 | PRJEB56699_P_NODE_413_length_895_cov_3.581986_g311_i0 | PRJEB56699 | 413 | 895 | 3.581986 | 32.0587747 | Tolivirales sp. | 2809914 | Viruses | Viruses | 198 | 2.71e-53 | NR | WRQ65272.1 | 2809914 | g311 | i0 | 59.4 | 0.569832402234637 | 170 | 61 | 54.3 | 1 | 16 | 501 | 861 | 1030 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 510 | 198 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 31582308 | 31582308 | PRJEB56699_P_NODE_796_length_660_cov_2.717908_g641_i0 | PRJEB56699 | 796 | 660 | 2.717908 | 17.9381928 | Tolivirales sp. | 2809914 | Viruses | Viruses | 264 | 2.88e-78 | NR | WRQ65272.1 | 2809914 | g641 | i0 | 73.3 | 0.8 | 176 | 43 | 80 | 1 | 132 | 659 | 284 | 455 | WRQ65272.1 polyprotein [Tolivirales sp.] | diamond | 528 | 264 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. |
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);;