contig_metadata
8 rows where bioproject = "PRJNA596867", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3691872 | 3691872 | PRJNA596867_P_NODE_4743_length_356_cov_1.904594_g4668_i0 | PRJNA596867 | 4743 | 356 | 1.904594 | 6.78035464 | Hirudo | 6420 | Annelida | Annelida | 584 | 2.689999999999999e-162 | NTclustered | gi|38154529|gb|AY364866.1| | 6421 | g4668 | i0 | 96.359 | 79.314606741573 | 357 | 10 | 100 | 3 | 1 | 356 | 2166 | 1812 | Hirudo medicinalis 28S ribosomal RNA gene, partial sequence | blastn | 28236 | 584 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo medicinalis | |
| 5671792 | 5671792 | PRJNA596867_P_NODE_15465_length_230_cov_2.757962_g15390_i0 | PRJNA596867 | 15465 | 230 | 2.757962 | 6.3433126 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.41e-4 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g15390 | i0 | 94.737 | 1.1304347826087 | 38 | 1 | 17 | 1 | 174 | 211 | 6234727 | 6234763 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 260 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10772306 | 10772306 | PRJNA596867_P_NODE_13429_length_245_cov_1.808140_g13354_i0 | PRJNA596867 | 13429 | 245 | 1.80814 | 4.429943 | Macrobdella decora | 6405 | Annelida | Annelida | 142 | 2.21e-41 | NR | BAC82447.1 | 6405 | g13354 | i0 | 85.2 | 0.991836734693878 | 81 | 12 | 99.2 | 0 | 1 | 243 | 61 | 141 | BAC82447.1 hemoglobin, chain B [Macrobdella decora] | diamond | 243 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Macrobdella | Macrobdella decora | |
| 15870779 | 15870779 | PRJNA596867_P_NODE_8433_length_285_cov_1.830189_g8358_i0 | PRJNA596867 | 8433 | 285 | 1.830189 | 5.21603865 | Hirudo nipponia | 42736 | Annelida | Annelida | 521 | 1.6699999999999996e-143 | NTclustered | gi|594448608|ref|NC_023776.1| | 42736 | g8358 | i0 | 99.649 | 80.8385964912281 | 285 | 1 | 100 | 0 | 1 | 285 | 11413 | 11129 | Hirudo nipponia mitochondrion, complete genome | blastn | 23039 | 521 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo nipponia | |
| 17145727 | 17145727 | PRJNA596867_P_NODE_9634_length_271_cov_1.343434_g9559_i0 | PRJNA596867 | 9634 | 271 | 1.343434 | 3.64070614 | Hirudo verbana | 311461 | Annelida | Annelida | 119 | 2.42e-22 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g9559 | i0 | 84.127 | 0.464944649446494 | 126 | 16 | 46 | 2 | 143 | 268 | 7525215 | 7525336 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 126 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18991810 | 18991810 | PRJNA596867_P_NODE_3315_length_410_cov_6.448071_g3240_i0 | PRJNA596867 | 3315 | 410 | 6.448071 | 26.4370911 | Hirudo | 6420 | Annelida | Annelida | 691 | 0 | NTclustered | gi|160425550|gb|EU100079.1| | 6421 | g3240 | i0 | 97.073 | 69.2219512195122 | 410 | 12 | 100 | 0 | 1 | 410 | 320 | 729 | Hirudo medicinalis 28S ribosomal RNA gene, partial sequence | blastn | 28381 | 691 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo medicinalis | |
| 22245182 | 22245182 | PRJNA596867_P_NODE_5458_length_339_cov_1.150376_g5383_i0 | PRJNA596867 | 5458 | 339 | 1.150376 | 3.89977464 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.91e-4 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g5383 | i0 | 97.143 | 1.23008849557522 | 35 | 1 | 11 | 0 | 213 | 247 | 520370 | 520404 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 417 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24794113 | 24794113 | PRJNA596867_P_NODE_13280_length_246_cov_0.890173_g13205_i0 | PRJNA596867 | 13280 | 246 | 0.890173 | 2.18982558 | Hirudo verbana | 311461 | Annelida | Annelida | 335 | 1.9699999999999992e-87 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g13205 | i0 | 91.393 | 0.991869918699187 | 244 | 21 | 99 | 0 | 1 | 244 | 13966636 | 13966879 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 244 | 335 | 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);;