contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 795733 | 795733 | PRJNA799842_P_NODE_83021_length_317_cov_0.946721_g81448_i0 | PRJNA799842 | 83021 | 317 | 0.946721 | 3.00110557 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g81448 | i0 | 100 | 0.0914826498422713 | 29 | 0 | 9 | 0 | 255 | 283 | 3653033 | 3653005 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4622009 | 4622009 | PRJNA799842_P_NODE_150624_length_248_cov_0.880000_g149051_i0 | PRJNA799842 | 150624 | 248 | 0.88 | 2.1824 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g149051 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 167 | 194 | 40712108 | 40712135 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4622385 | 4622385 | PRJNA799842_P_NODE_170924_length_244_cov_0.900585_g169351_i0 | PRJNA799842 | 170924 | 244 | 0.900585 | 2.1974274 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 2.83e-6 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g169351 | i0 | 93.182 | 5.3155737704918 | 44 | 3 | 18 | 0 | 26 | 69 | 13068667 | 13068710 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 1297 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5896641 | 5896641 | PRJNA799842_P_NODE_119925_length_267_cov_1.623711_g118352_i0 | PRJNA799842 | 119925 | 267 | 1.623711 | 4.33530837 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g118352 | i0 | 100 | 0.337078651685393 | 30 | 0 | 11 | 0 | 180 | 209 | 3108358 | 3108387 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 90 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9723856 | 9723856 | PRJNA799842_P_NODE_83528_length_316_cov_1.016461_g81955_i0 | PRJNA799842 | 83528 | 316 | 1.016461 | 3.21201676 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g81955 | i0 | 100 | 0.645569620253165 | 30 | 0 | 9 | 0 | 247 | 276 | 30510502 | 30510473 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 204 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10998212 | 10998212 | PRJNA799842_P_NODE_18689_length_702_cov_8.680445_g17206_i0 | PRJNA799842 | 18689 | 702 | 8.680445 | 60.9367239 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 9.01e-6 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g17206 | i0 | 83.333 | 0.603988603988604 | 72 | 10 | 10 | 2 | 619 | 689 | 19159118 | 19159048 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 424 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17374495 | 17374495 | PRJNA799842_P_NODE_9794_length_1002_cov_10.956943_g8693_i0 | PRJNA799842 | 9794 | 1002 | 10.956943 | 109.78856886 | Dinophilus gyrociliatus | 120995 | Annelida | Annelida | 1533 | 0 | NTclustered | gi|1337016615|gb|MG428625.1| | 120995 | g8693 | i0 | 94.323 | 27.7155688622755 | 1004 | 52 | 100 | 5 | 1 | 1002 | 5382 | 4382 | Dinophilus gyrociliatus mitochondrion | blastn | 27771 | 1533 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dinophilus | Dinophilus gyrociliatus | ||
| 18646435 | 18646435 | PRJNA799842_P_NODE_46195_length_418_cov_2.008696_g44622_i0 | PRJNA799842 | 46195 | 418 | 2.008696 | 8.39634928 | Dinophilus gyrociliatus | 120995 | Annelida | Annelida | 442 | 2.0399999999999988e-119 | NTclustered | gi|1337016615|gb|MG428625.1| | 120995 | g44622 | i0 | 85.851 | 64.9688995215311 | 417 | 57 | 99 | 2 | 1 | 416 | 14610 | 14195 | Dinophilus gyrociliatus mitochondrion | blastn | 27157 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dinophilus | Dinophilus gyrociliatus | ||
| 23746793 | 23746793 | PRJNA799842_P_NODE_174299_length_244_cov_0.900585_g172726_i0 | PRJNA799842 | 174299 | 244 | 0.900585 | 2.1974274 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g172726 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 45 | 72 | 15958752 | 15958725 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 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);;