contig_metadata
4 rows where bioproject = "PRJNA825466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28633728 | 28633728 | PRJNA825466_P_NODE_23267_length_245_cov_1.767442_g23166_i0 | PRJNA825466 | 23267 | 245 | 1.767442 | 4.3302329 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 54.7 | 2.36e-6 | NR | CAF4650720.1 | 2762511 | g23166 | i0 | 35.5 | 1.86122448979592 | 76 | 46 | 93.1 | 1 | 5 | 232 | 95 | 167 | CAF4650720.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 456 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28759750 | 28759750 | PRJNA825466_P_NODE_29627_length_231_cov_3.113924_g29526_i0 | PRJNA825466 | 29627 | 231 | 3.113924 | 7.19316444 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 56.6 | 4.94e-8 | NR | CAF0998078.1 | 392030 | g29526 | i0 | 50 | 1.94805194805195 | 50 | 20 | 62.3 | 2 | 16 | 159 | 23 | 69 | CAF0998078.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 450 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30284680 | 30284680 | PRJNA825466_P_NODE_22492_length_246_cov_0.890173_g22391_i0 | PRJNA825466 | 22492 | 246 | 0.890173 | 2.18982558 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 70.9 | 4.88e-12 | NR | CAF3890895.1 | 392030 | g22391 | i0 | 40.3 | 6.18292682926829 | 72 | 43 | 87.8 | 0 | 216 | 1 | 345 | 416 | CAF3890895.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1521 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31729511 | 31729511 | PRJNA825466_P_NODE_18817_length_249_cov_0.875000_g18716_i0 | PRJNA825466 | 18817 | 249 | 0.875 | 2.17875 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 75.1 | 1.65e-13 | NR | CAF1340047.1 | 433720 | g18716 | i0 | 42.5 | 2.8433734939759 | 80 | 41 | 96.4 | 1 | 2 | 241 | 1314 | 1388 | CAF1340047.1 unnamed protein product [Adineta steineri] | diamond | 708 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri |
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);;