contig_metadata
4 rows where bioproject = "PRJNA758087", tax_clade = "Opisthokonta" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4562020 | 4562020 | PRJNA758087_P_NODE_33924_length_351_cov_2.133094_g32604_i0 | PRJNA758087 | 33924 | 351 | 2.133094 | 7.48715994 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 4.26e-6 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g32604 | i0 | 95.122 | 3.06837606837607 | 41 | 2 | 12 | 0 | 5 | 45 | 4433649 | 4433689 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 1077 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 7112221 | 7112221 | PRJNA758087_P_NODE_29806_length_414_cov_4.516129_g28486_i0 | PRJNA758087 | 29806 | 414 | 4.516129 | 18.69677406 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 8.55e-4 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g28486 | i0 | 100 | 1.21256038647343 | 31 | 0 | 7 | 0 | 304 | 334 | 24032540 | 24032570 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 502 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10937211 | 10937211 | PRJNA758087_P_NODE_17789_length_675_cov_11.330565_g16508_i0 | PRJNA758087 | 17789 | 675 | 11.330565 | 76.48131375 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.019 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g16508 | i0 | 96.875 | 0.0474074074074074 | 32 | 1 | 5 | 0 | 563 | 594 | 966998 | 967029 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24960020 | 24960020 | PRJNA758087_P_NODE_29100_length_426_cov_11.637394_g27780_i0 | PRJNA758087 | 29100 | 426 | 11.637394 | 49.57529844 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.041 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g27780 | i0 | 96.774 | 0.0727699530516432 | 31 | 1 | 7 | 0 | 351 | 381 | 7863981 | 7863951 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
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);;