contig_metadata
8 rows where bioproject = "PRJEB50332", tax_kingdom = "Metazoa" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21393314 | 21393314 | PRJEB50332_P_NODE_1157_length_505_cov_2.252252_g1076_i0 | PRJEB50332 | 1157 | 505 | 2.252252 | 11.3738726 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 140 | 2.26e-36 | NR | CAF1656256.1 | 249248 | g1076 | i0 | 50 | 3.23168316831683 | 136 | 62 | 79.6 | 3 | 30 | 431 | 84 | 215 | CAF1656256.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1632 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27159676 | 27159676 | PRJEB50332_P_NODE_5382_length_265_cov_1.078431_g5300_i0 | PRJEB50332 | 5382 | 265 | 1.078431 | 2.85784215 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 73.9 | 2.6e-14 | NR | CAF0829117.1 | 249248 | g5300 | i0 | 40.4 | 1.00754716981132 | 89 | 49 | 99.6 | 2 | 2 | 265 | 31 | 116 | CAF0829117.1 unnamed protein product [Adineta ricciae] | diamond | 267 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27697346 | 27697346 | PRJEB50332_P_NODE_12184_length_212_cov_1.721854_g12102_i0 | PRJEB50332 | 12184 | 212 | 1.721854 | 3.65033048 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 119 | 5.1e-30 | NR | CAF0996228.1 | 392030 | g12102 | i0 | 75.4 | 3.90566037735849 | 69 | 17 | 97.6 | 0 | 5 | 211 | 322 | 390 | CAF0996228.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 828 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28454943 | 28454943 | PRJEB50332_P_NODE_6026_length_253_cov_1.692708_g5944_i0 | PRJEB50332 | 6026 | 253 | 1.692708 | 4.28255124 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 95.9 | 3.25e-23 | NR | CAF0909918.1 | 104777 | g5944 | i0 | 64.6 | 0.770750988142292 | 65 | 23 | 77.1 | 0 | 1 | 195 | 67 | 131 | CAF0909918.1 unnamed protein product [Brachionus calyciflorus] | diamond | 195 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28928334 | 28928334 | PRJEB50332_P_NODE_17468_length_202_cov_2.361702_g17386_i0 | PRJEB50332 | 17468 | 202 | 2.361702 | 4.77063804 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 63.5 | 1.03e-9 | NR | CAF0882972.1 | 1234261 | g17386 | i0 | 63.8 | 3.32673267326733 | 47 | 17 | 69.8 | 0 | 195 | 55 | 1937 | 1983 | CAF0882972.1 unnamed protein product [Didymodactylos carnosus] | diamond | 672 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29552871 | 29552871 | PRJEB50332_P_NODE_17850_length_202_cov_0.921986_g17768_i0 | PRJEB50332 | 17850 | 202 | 0.921986 | 1.86241172 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 48.9 | 1.41e-4 | NR | CAF0858903.1 | 392033 | g17768 | i0 | 48 | 3.05940594059406 | 50 | 24 | 74.3 | 1 | 29 | 178 | 10 | 57 | CAF0858903.1 unnamed protein product [Rotaria sordida] | diamond | 618 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32056604 | 32056604 | PRJEB50332_P_NODE_138_length_1279_cov_4.059113_g105_i0 | PRJEB50332 | 138 | 1279 | 4.059113 | 51.91605527 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 75.1 | 2.24e-10 | NR | CAF3732971.1 | 2762511 | g105 | i0 | 26.6 | 1.40031274433151 | 199 | 138 | 46.7 | 2 | 630 | 1226 | 468 | 658 | CAF3732971.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1791 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32619144 | 32619144 | PRJEB50332_P_NODE_17420_length_203_cov_0.915493_g17338_i0 | PRJEB50332 | 17420 | 203 | 0.915493 | 1.85845079 | Rotaria | 231623 | Rotifera | other_Eukaryota | 88.6 | 1.34e-20 | NR | CAF5168967.1 | 392030 | g17338 | i0 | 64.7 | 3.04433497536946 | 51 | 18 | 75.4 | 0 | 9 | 161 | 30 | 80 | CAF5168967.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 618 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata |
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);;