contig_metadata
6 rows where bioproject = "PRJNA380660", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7452200 | 7452200 | PRJNA380660_P_NODE_4886_length_359_cov_12.557576_g4488_i0 | PRJNA380660 | 4886 | 359 | 12.557576 | 45.08169784 | Naididae | 2109251 | Annelida | Annelida | 520 | 7.759999999999998e-143 | NTclustered | gi|94467817|gb|DQ459965.1| | 74735 | g4488 | i0 | 92.758 | 99.9470752089136 | 359 | 26 | 100 | 0 | 1 | 359 | 382 | 24 | Rhyacodrilus falciformis 18S ribosomal RNA gene, partial sequence | blastn | 35881 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Rhyacodrilus | Rhyacodrilus falciformis | |
| 8055516 | 8055516 | PRJNA380660_P_NODE_5667_length_325_cov_3.719595_g5268_i0 | PRJNA380660 | 5667 | 325 | 3.719595 | 12.08868375 | Claudrilus corderoi | 3262671 | Annelida | Annelida | 91.6 | 6.47e-14 | NTclustered | gi|923872644|gb|KJ451231.1| | 3262671 | g5268 | i0 | 91.045 | 15.8953846153846 | 67 | 6 | 21 | 0 | 243 | 309 | 195 | 261 | Claudrilus corderoi 28S ribosomal RNA gene, partial sequence | blastn | 5166 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Protodrilidae | Claudrilus | Claudrilus corderoi | ||
| 19528088 | 19528088 | PRJNA380660_P_NODE_4256_length_393_cov_3.250000_g3861_i0 | PRJNA380660 | 4256 | 393 | 3.25 | 12.7725 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 2.25e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g3861 | i0 | 100 | 2 | 32 | 0 | 9 | 0 | 305 | 336 | 1760047 | 1760016 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 786 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22078735 | 22078735 | PRJNA380660_P_NODE_11238_length_184_cov_5.122581_g10838_i0 | PRJNA380660 | 11238 | 184 | 5.122581 | 9.42554904 | Paranais litoralis | 74742 | Annelida | Annelida | 274 | 3.0799999999999997e-69 | NTclustered | gi|1494622622|gb|MK076421.1| | 74742 | g10838 | i0 | 94.022 | 100.527173913043 | 184 | 6 | 100 | 1 | 1 | 184 | 1658 | 1480 | Paranais litoralis isolate PARliHBMD large subunit ribosomal RNA gene, partial sequence | blastn | 18497 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Paranais | Paranais litoralis | |
| 25300445 | 25300445 | PRJNA380660_P_NODE_3760_length_422_cov_3.114504_g3371_i0 | PRJNA380660 | 3760 | 422 | 3.114504 | 13.14320688 | Pristina | 150439 | Annelida | Annelida | 778 | 0 | NTclustered | gi|285029397|gb|GQ355415.1| | 212339 | g3371 | i0 | 100 | 98.1184834123223 | 421 | 0 | 99 | 0 | 2 | 422 | 428 | 8 | Pristina aequiseta 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 41406 | 778 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina aequiseta | |
| 30074867 | 30074867 | PRJNA380660_P_NODE_792_length_982_cov_2.668416_g587_i0 | PRJNA380660 | 792 | 982 | 2.668416 | 26.20384512 | Owenia fusiformis | 6347 | Annelida | Annelida | 166 | 4.609999999999999e-43 | NR | CAH1794753.1 | 6347 | g587 | i0 | 40.3 | 4.11812627291242 | 226 | 110 | 67.2 | 8 | 5 | 664 | 265 | 471 | CAH1794753.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 4044 | 166 | 1 | 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);;