contig_metadata
6 rows where bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5060953 | 5060953 | PRJNA849172_P_NODE_74764_length_264_cov_16.450262_g74404_i0 | PRJNA849172 | 74764 | 264 | 16.450262 | 43.42869168 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 77.4 | 1.41e-16 | NR | CAF1326126.1 | 1234261 | g74404 | i0 | 56.3 | 3.23863636363636 | 71 | 31 | 80.7 | 0 | 24 | 236 | 1 | 71 | CAF1326126.1 unnamed protein product [Didymodactylos carnosus] | diamond | 855 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 8489575 | 8489575 | PRJNA849172_P_NODE_5707_length_921_cov_38.991745_g5415_i0 | PRJNA849172 | 5707 | 921 | 38.991745 | 359.11397145 | Metazoa | 33208 | Rotifera | other_Eukaryota | 170 | 2.25e-47 | NR | RNA11554.1 | 10195 | g5415 | i0 | 39.4 | 4.29315960912052 | 274 | 141 | 86.6 | 10 | 905 | 108 | 4 | 260 | RNA11554.1 serine protease 27-like [Brachionus plicatilis] | diamond | 3954 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 12316558 | 12316558 | PRJNA849172_P_NODE_7870_length_777_cov_33.872159_g7534_i0 | PRJNA849172 | 7870 | 777 | 33.872159 | 263.18667543 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 402 | 5.21e-140 | NR | CAF1220590.1 | 249248 | g7534 | i0 | 95.1 | 0.795366795366795 | 206 | 10 | 79.5 | 0 | 4 | 621 | 4 | 209 | CAF1220590.1 unnamed protein product [Adineta ricciae] | diamond | 618 | 402 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27623704 | 27623704 | PRJNA849172_P_NODE_23344_length_425_cov_23.997159_g22985_i0 | PRJNA849172 | 23344 | 425 | 23.997159 | 101.98792575 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 53.5 | 4.07e-5 | NR | CAF4584132.1 | 392030 | g22985 | i0 | 45.9 | 1.29176470588235 | 61 | 32 | 42.4 | 1 | 1 | 180 | 295 | 355 | CAF4584132.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 549 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28318151 | 28318151 | PRJNA849172_P_NODE_66146_length_274_cov_1.358209_g65786_i0 | PRJNA849172 | 66146 | 274 | 1.358209 | 3.72149266 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 90.1 | 1.22e-18 | NR | CAF2510592.1 | 2762512 | g65786 | i0 | 50 | 1.97080291970803 | 90 | 45 | 98.5 | 0 | 270 | 1 | 390 | 479 | CAF2510592.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 540 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28507642 | 28507642 | PRJNA849172_P_NODE_145347_length_201_cov_13.312500_g144987_i0 | PRJNA849172 | 145347 | 201 | 13.3125 | 26.758125 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 50.1 | 4.32e-6 | NR | CAF1358887.1 | 1234261 | g144987 | i0 | 61.3 | 0.462686567164179 | 31 | 12 | 46.3 | 0 | 3 | 95 | 42 | 72 | CAF1358887.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 93 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;