contig_metadata
4 rows where bioproject = "PRJNA1196438", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10526847 | 10526847 | PRJNA1196438_P_NODE_4049_length_487_cov_2.391304_g3635_i0 | PRJNA1196438 | 4049 | 487 | 2.391304 | 11.64565048 | root | 1 | Root_unresolved | Root_unresolved | 116 | 5.300000000000001e-28 | NR | CAH1798522.1 | 6347 | g3635 | i0 | 45.7 | 11.1067761806982 | 140 | 68 | 81.3 | 4 | 90 | 485 | 51 | 190 | CAH1798522.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 5409 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 20724652 | 20724652 | PRJNA1196438_P_NODE_56517_length_263_cov_2.405263_g56090_i0 | PRJNA1196438 | 56517 | 263 | 2.405263 | 6.32584169 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.43e-4 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g56090 | i0 | 92.857 | 0.927756653992395 | 42 | 2 | 16 | 1 | 205 | 246 | 5905111 | 5905071 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 244 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26692618 | 26692618 | PRJNA1196438_P_NODE_861_length_1093_cov_5.441176_g610_i0 | PRJNA1196438 | 861 | 1093 | 5.441176 | 59.47205368 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 82.4 | 7.14e-13 | NR | CAD5121248.1 | 2664684 | g610 | i0 | 56.9 | 2.62122598353156 | 58 | 25 | 15.9 | 0 | 1040 | 867 | 1044 | 1101 | CAD5121248.1 DgyrCDS9780 [Dimorphilus gyrociliatus] | diamond | 2865 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27502417 | 27502417 | PRJNA1196438_P_NODE_3403_length_527_cov_7.011013_g2993_i0 | PRJNA1196438 | 3403 | 527 | 7.011013 | 36.94803851 | Metazoa | 33208 | Annelida | Annelida | 135 | 1.31e-36 | NR | CAH1798937.1 | 6347 | g2993 | i0 | 49.7 | 21.7798861480076 | 147 | 68 | 83.7 | 1 | 25 | 465 | 38 | 178 | CAH1798937.1 unnamed protein product [Owenia fusiformis] | diamond | 11478 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;