contig_metadata
5 rows where bioproject = "PRJNA446034", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26871189 | 26871189 | PRJNA446034_S_NODE_48261_length_185_cov_2.797297_g48224_i0 | PRJNA446034 | 48261 | 185 | 2.797297 | 5.17499945 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 68.9 | 9.89e-13 | NR | CAF0934208.1 | 249248 | g48224 | i0 | 100 | 1.60540540540541 | 33 | 0 | 53.5 | 0 | 2 | 100 | 130 | 162 | CAF0934208.1 unnamed protein product [Adineta ricciae] | diamond | 297 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27518419 | 27518419 | PRJNA446034_S_NODE_14963_length_240_cov_4.571429_g14926_i0 | PRJNA446034 | 14963 | 240 | 4.571429 | 10.9714296 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 45.4 | 0.00414 | NR | CAF1545313.1 | 249248 | g14926 | i0 | 33.3 | 2.725 | 72 | 48 | 90 | 0 | 231 | 16 | 508 | 579 | CAF1545313.1 unnamed protein product [Adineta ricciae] | diamond | 654 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27613274 | 27613274 | PRJNA446034_S_NODE_113624_length_150_cov_8.902655_g113587_i0 | PRJNA446034 | 113624 | 150 | 8.902655 | 13.3539825 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 68.6 | 8e-12 | NR | CAF1313708.1 | 392033 | g113587 | i0 | 68.1 | 1.9 | 47 | 15 | 94 | 0 | 6 | 146 | 85 | 131 | CAF1313708.1 unnamed protein product [Rotaria sordida] | diamond | 285 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29570601 | 29570601 | PRJNA446034_S_NODE_80330_length_164_cov_1.488189_g80293_i0 | PRJNA446034 | 80330 | 164 | 1.488189 | 2.44062996 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 41.2 | 0.0426 | NR | CAF1109261.1 | 1234261 | g80293 | i0 | 57.1 | 0.98780487804878 | 28 | 12 | 51.2 | 0 | 69 | 152 | 146 | 173 | CAF1109261.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 162 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30265911 | 30265911 | PRJNA446034_S_NODE_75172_length_166_cov_5.868217_g75135_i0 | PRJNA446034 | 75172 | 166 | 5.868217 | 9.74124022 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 90.1 | 7.75e-20 | NR | UJR24876.1 | 104782 | g75135 | i0 | 77.8 | 3.9578313253012 | 54 | 12 | 97.6 | 0 | 166 | 5 | 209 | 262 | UJR24876.1 hypothetical protein I4U23_006245 [Adineta vaga] | diamond | 657 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;