contig_metadata
8 rows where bioproject = "PRJNA356682" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8050650 | 8050650 | PRJNA356682_P_NODE_20907_length_316_cov_4.349794_g20216_i0 | PRJNA356682 | 20907 | 316 | 4.349794 | 13.74534904 | Enchytraeus cf. crypticus SL-2017 | 2052677 | Annelida | Annelida | 324 | 5.68e-84 | NTclustered | gi|1294255821|gb|MG642143.1| | 2052677 | g20216 | i0 | 85.266 | 96.6329113924051 | 319 | 42 | 100 | 5 | 1 | 316 | 102 | 418 | Enchytraeus cf. crypticus SL-2017 isolate DHS large subunit ribosomal RNA gene, partial sequence | blastn | 30536 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus cf. crypticus SL-2017 | |
| 13151056 | 13151056 | PRJNA356682_P_NODE_19991_length_322_cov_7.373494_g19300_i0 | PRJNA356682 | 19991 | 322 | 7.373494 | 23.74265068 | Enchytraeus cf. crypticus SL-2017 | 2052677 | Annelida | Annelida | 346 | 1.24e-90 | NTclustered | gi|1294255821|gb|MG642143.1| | 2052677 | g19300 | i0 | 86.42 | 97.4285714285714 | 324 | 35 | 99 | 8 | 4 | 322 | 422 | 103 | Enchytraeus cf. crypticus SL-2017 isolate DHS large subunit ribosomal RNA gene, partial sequence | blastn | 31372 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus cf. crypticus SL-2017 | |
| 13151459 | 13151459 | PRJNA356682_P_NODE_3751_length_738_cov_9.315789_g3105_i0 | PRJNA356682 | 3751 | 738 | 9.315789 | 68.75052282 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 4.42e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g3105 | i0 | 100 | 0.90514905149051506 | 32 | 0 | 5 | 0 | 465 | 496 | 1760047 | 1760016 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 668 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13151550 | 13151550 | PRJNA356682_P_NODE_41131_length_245_cov_0.895349_g40440_i0 | PRJNA356682 | 41131 | 245 | 0.895349 | 2.19360505 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 67.6 | 7.9e-7 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g40440 | i0 | 79.817 | 3.44081632653061 | 109 | 8 | 55 | 10 | 77 | 175 | 17596531 | 17596427 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 843 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20198396 | 20198396 | PRJNA356682_P_NODE_31376_length_266_cov_1.362694_g30685_i0 | PRJNA356682 | 31376 | 266 | 1.362694 | 3.62476604 | Megascolecidae | 6400 | Annelida | Annelida | 479 | 9.42e-131 | NTclustered | gi|341833297|gb|HQ728988.1| | 169954 | g30685 | i0 | 99.248 | 132.642857142857 | 266 | 0 | 100 | 2 | 1 | 266 | 2109 | 2372 | Dichogaster saliens 28S large subunit ribosomal RNA gene, partial sequence | blastn | 35283 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Megascolecidae | Dichogaster | Dichogaster saliens | |
| 22073926 | 22073926 | PRJNA356682_P_NODE_20298_length_320_cov_3.060729_g19607_i0 | PRJNA356682 | 20298 | 320 | 3.060729 | 9.7943328 | Dichogaster sp. 1059 | 925648 | Annelida | Annelida | 592 | 1.4299999999999996e-164 | NTclustered | gi|312284436|gb|HQ232751.1| | 925648 | g19607 | i0 | 100 | 100.090625 | 320 | 0 | 100 | 0 | 1 | 320 | 329 | 648 | Dichogaster sp. 1059 28S ribosomal RNA gene, partial sequence | blastn | 32029 | 592 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Megascolecidae | Dichogaster | Dichogaster sp. 1059 | |
| 23349790 | 23349790 | PRJNA356682_P_NODE_41319_length_245_cov_0.895349_g40628_i0 | PRJNA356682 | 41319 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Annelida | Annelida | 147 | 1.98e-39 | NR | XP_009029587.1 | 6412 | g40628 | i0 | 85.2 | 10.8489795918367 | 81 | 12 | 99.2 | 0 | 3 | 245 | 79 | 159 | XP_009029587.1 hypothetical protein HELRODRAFT_103835 [Helobdella robusta] | diamond | 2658 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27944865 | 27944865 | PRJNA356682_P_NODE_38805_length_248_cov_0.880000_g38114_i0 | PRJNA356682 | 38805 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Annelida | Annelida | 137 | 1.36e-37 | NR | XP_009029644.1 | 6412 | g38114 | i0 | 77.8 | 4.8991935483871 | 81 | 18 | 98 | 0 | 247 | 5 | 144 | 224 | XP_009029644.1 hypothetical protein HELRODRAFT_186151 [Helobdella robusta] | diamond | 1215 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;