contig_metadata
14 rows where analysis = "diamond" and bioproject = "PRJEB56699"
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. | ||||
| 26931915 | 26931915 | PRJEB56699_P_NODE_2902_length_318_cov_13.660900_g2672_i0 | PRJEB56699 | 2902 | 318 | 13.6609 | 43.441662 | Saccharomycetaceae | 4893 | Fungi | Fungi | 63.2 | 7.63e-10 | NR | KAF4001137.1 | 4932 | g2672 | i0 | 54.5 | 3.09433962264151 | 66 | 20 | 62.3 | 1 | 4 | 201 | 51 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 984 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 27001715 | 27001715 | PRJEB56699_P_NODE_5622_length_193_cov_2.189024_g5392_i0 | PRJEB56699 | 5622 | 193 | 2.189024 | 4.22481632 | Bufotes viridis | 30338 | Chordata | Chordata | 49.3 | 9.26e-5 | NR | CAK8629749.1 | 30338 | g5392 | i0 | 71.4 | 0.435233160621762 | 28 | 8 | 43.5 | 0 | 138 | 55 | 337 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 84 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27001716 | 27001716 | PRJEB56699_P_NODE_6662_length_151_cov_2.163934_g6432_i0 | PRJEB56699 | 6662 | 151 | 2.163934 | 3.26754034 | Rheinheimera sp. D18 | 2545632 | Bacteria | Bacteria | 53.9 | 1.21e-6 | NR | WP_132584183.1 | 2545632 | g6432 | i0 | 55.6 | 0.894039735099338 | 45 | 20 | 89.4 | 0 | 138 | 4 | 438 | 482 | WP_132584183.1 hypothetical protein [Rheinheimera sp. D18] | diamond | 135 | 53.9 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Chromatiales | Chromatiaceae | Rheinheimera | Rheinheimera sp. D18 | ||
| 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. | ||||
| 27374833 | 27374833 | PRJEB56699_P_NODE_2663_length_337_cov_2.568182_g2433_i0 | PRJEB56699 | 2663 | 337 | 2.568182 | 8.65477334 | Luteovirus | 12036 | Viruses | Viruses | 63.9 | 4.03e-9 | NR | WKV33301.1 | 2585031 | g2433 | i0 | 43 | 2.65281899109792 | 79 | 42 | 68.5 | 2 | 327 | 97 | 156 | 233 | WKV33301.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] | diamond | 894 | 63.9 | 1 | Viruses | Riboviria sp. | ||||||||
| 28423386 | 28423386 | PRJEB56699_P_NODE_4866_length_214_cov_1.540541_g4636_i0 | PRJEB56699 | 4866 | 214 | 1.540541 | 3.29675774 | Niabella hibiscisoli | 1825928 | Bacteria | Bacteria | 42.4 | 0.0268 | NR | WP_240847907.1 | 1825928 | g4636 | i0 | 48.6 | 0.490654205607477 | 35 | 18 | 49.1 | 0 | 78 | 182 | 36 | 70 | WP_240847907.1 J domain-containing protein [Niabella hibiscisoli] | diamond | 105 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Niabella | Niabella hibiscisoli | |
| 28612684 | 28612684 | PRJEB56699_P_NODE_287_length_1083_cov_4.704934_g177_i1 | PRJEB56699 | 287 | 1083 | 4.704934 | 50.95443522 | Shorea laevis | 152420 | Plants | Plants | 52.4 | 0.0016 | NR | GLT66639.1 | 152420 | g177 | i1 | 58.5 | 1 | 41 | 17 | 11.4 | 0 | 554 | 676 | 210 | 250 | GLT66639.1 hypothetical protein SLA2020_389940 [Shorea laevis] | diamond | 1083 | 52.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Dipterocarpaceae | Shorea | Shorea laevis | |
| 28675932 | 28675932 | PRJEB56699_P_NODE_1187_length_540_cov_3.070450_g1001_i0 | PRJEB56699 | 1187 | 540 | 3.07045 | 16.58043 | Changjiang tombus-like virus 8 | 1922822 | Viruses | Viruses | 173 | 1.85e-49 | NR | YP_009337199.1 | 1922822 | g1001 | i0 | 55.7 | 0.877777777777778 | 158 | 70 | 87.8 | 0 | 6 | 479 | 187 | 344 | YP_009337199.1 hypothetical protein 3 [Changjiang tombus-like virus 8] | diamond | 474 | 173 | 1 | Viruses | Changjiang tombus-like virus 8 | ||||||||
| 29086412 | 29086412 | PRJEB56699_P_NODE_248_length_1159_cov_4.507080_g177_i0 | PRJEB56699 | 248 | 1159 | 4.50708 | 52.2370572 | Shorea laevis | 152420 | Plants | Plants | 52.4 | 0.00181 | NR | GLT66639.1 | 152420 | g177 | i0 | 58.5 | 0.934426229508197 | 41 | 17 | 10.6 | 0 | 614 | 492 | 210 | 250 | GLT66639.1 hypothetical protein SLA2020_389940 [Shorea laevis] | diamond | 1083 | 52.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Dipterocarpaceae | Shorea | Shorea laevis | |
| 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. | ||||
| 30823479 | 30823479 | PRJEB56699_P_NODE_4994_length_210_cov_2.138122_g4764_i0 | PRJEB56699 | 4994 | 210 | 2.138122 | 4.4900562 | Changjiang tombus-like virus 8 | 1922822 | Viruses | Viruses | 79 | 2.54e-15 | NR | YP_009337199.1 | 1922822 | g4764 | i0 | 60.9 | 0.985714285714286 | 69 | 16 | 98.6 | 1 | 208 | 2 | 95 | 152 | YP_009337199.1 hypothetical protein 3 [Changjiang tombus-like virus 8] | diamond | 207 | 79 | 1 | Viruses | Changjiang tombus-like virus 8 | ||||||||
| 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);;