contig_metadata
4 rows where bioproject = "PRJNA1218816", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4160213 | 4160213 | PRJNA1218816_P_NODE_16324_length_570_cov_1.442656_g15897_i0 | PRJNA1218816 | 16324 | 570 | 1.442656 | 8.2231392 | root | 1 | Root_unresolved | Root_unresolved | 307 | 4.05e-103 | NR | CAH1778036.1 | 6347 | g15897 | i0 | 81.9 | 94.9578947368421 | 188 | 34 | 98.9 | 0 | 564 | 1 | 9 | 196 | CAH1778036.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 54126 | 309 | 0.993527508090615 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 7986870 | 7986870 | PRJNA1218816_P_NODE_52107_length_256_cov_1.688525_g51674_i0 | PRJNA1218816 | 52107 | 256 | 1.688525 | 4.322624 | Pristina aequiseta | 212339 | Annelida | Annelida | 350 | 7.37e-92 | NTclustered | gi|285029437|gb|GQ355455.1| | 212339 | g51674 | i0 | 91.473 | 96.0234375 | 258 | 16 | 100 | 5 | 1 | 256 | 328 | 581 | Pristina aequiseta 28S ribosomal RNA gene, partial sequence | blastn | 24582 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina aequiseta | |
| 18184966 | 18184966 | PRJNA1218816_P_NODE_45615_length_281_cov_1.447115_g45182_i0 | PRJNA1218816 | 45615 | 281 | 1.447115 | 4.06639315 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 3.33e-6 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g45182 | i0 | 84.615 | 4.18861209964413 | 65 | 10 | 23 | 0 | 67 | 131 | 11991686 | 11991750 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 1177 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 32809537 | 32809537 | PRJNA1218816_P_NODE_62200_length_242_cov_0.911243_g61767_i0 | PRJNA1218816 | 62200 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Annelida | Annelida | 44.7 | 0.00773 | NR | KAK2173121.1 | 27915 | g61767 | i0 | 71.4 | 2.47933884297521 | 28 | 8 | 34.7 | 0 | 241 | 158 | 346 | 373 | KAK2173121.1 hypothetical protein NP493_901g00090 [Ridgeia piscesae] | diamond | 600 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;