contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA781427" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2036534 | 2036534 | PRJNA781427_P_NODE_36722_length_379_cov_0.941176_g35840_i0 | PRJNA781427 | 36722 | 379 | 0.941176 | 3.56705704 | Hirudo verbana | 311461 | Annelida | Annelida | 525 | 1.7699999999999995e-144 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g35840 | i0 | 91.821 | 11.8944591029024 | 379 | 28 | 99 | 1 | 1 | 376 | 6574967 | 6575345 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 4508 | 525 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7139554 | 7139554 | PRJNA781427_P_NODE_54906_length_302_cov_1.344978_g54023_i0 | PRJNA781427 | 54906 | 302 | 1.344978 | 4.06183356 | Sipunculus nudus | 6446 | Annelida | Annelida | 176 | 1.6e-39 | NTclustered | gi|159145649|gb|EU116867.1| | 6446 | g54023 | i0 | 82.266 | 35.6523178807947 | 203 | 36 | 67 | 0 | 16 | 218 | 245 | 43 | Sipunculus nudus putative ribosomal protein L30 mRNA, complete cds | blastn | 10767 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 7590008 | 7590008 | PRJNA781427_P_NODE_66126_length_271_cov_1.474747_g65242_i0 | PRJNA781427 | 66126 | 271 | 1.474747 | 3.99656437 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g65242 | i0 | 100 | 1.09225092250923 | 29 | 0 | 11 | 0 | 41 | 69 | 20161121 | 20161093 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 296 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12240538 | 12240538 | PRJNA781427_P_NODE_52410_length_310_cov_2.371308_g51527_i0 | PRJNA781427 | 52410 | 310 | 2.371308 | 7.3510548 | Enchytraeus albidus | 6390 | Annelida | Annelida | 171 | 7.66e-38 | NTclustered | gi|1068288887|gb|KU728864.1| | 6390 | g51527 | i0 | 77.143 | 71.741935483871 | 315 | 58 | 99 | 10 | 2 | 309 | 731 | 424 | Enchytraeus albidus cytochrome c oxidase subunit 3 (Cox3) gene, partial cds; mitochondrial | blastn | 22240 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus albidus | |
| 13515303 | 13515303 | PRJNA781427_P_NODE_73691_length_251_cov_3.022472_g72807_i0 | PRJNA781427 | 73691 | 251 | 3.022472 | 7.58640472 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 161 | 3.62e-35 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g72807 | i0 | 79.476 | 1.8406374501992 | 229 | 45 | 91 | 2 | 4 | 231 | 7306218 | 7305991 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 462 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19888508 | 19888508 | PRJNA781427_P_NODE_80896_length_248_cov_0.880000_g80012_i0 | PRJNA781427 | 80896 | 248 | 0.88 | 2.1824 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g80012 | i0 | 100 | 1.13709677419355 | 30 | 0 | 12 | 0 | 46 | 75 | 11849279 | 11849308 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 282 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22437367 | 22437367 | PRJNA781427_P_NODE_18_length_7656_cov_7.207965_g14_i0 | PRJNA781427 | 18 | 7656 | 7.207965 | 551.8418004 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 71.3 | 2.21e-6 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g14 | i0 | 81.818 | 0.0331765935214211 | 99 | 5 | 1 | 5 | 7255 | 7352 | 31308429 | 31308515 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 254 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22438862 | 22438862 | PRJNA781427_P_NODE_75618_length_251_cov_0.865169_g74734_i0 | PRJNA781427 | 75618 | 251 | 0.865169 | 2.17157419 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g74734 | i0 | 96.97 | 2.86852589641434 | 33 | 1 | 13 | 0 | 102 | 134 | 11739963 | 11739995 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 720 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23713233 | 23713233 | PRJNA781427_P_NODE_32659_length_404_cov_1.761329_g31778_i0 | PRJNA781427 | 32659 | 404 | 1.761329 | 7.11576916 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 736 | 0 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g31778 | i0 | 99.505 | 24.2153465346535 | 404 | 2 | 100 | 0 | 1 | 404 | 446 | 43 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 9783 | 736 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 24987860 | 24987860 | PRJNA781427_P_NODE_69140_length_263_cov_1.621053_g68256_i0 | PRJNA781427 | 69140 | 263 | 1.621053 | 4.26336939 | Lepidonotopodium plicata | 2879644 | Annelida | Annelida | 187 | 6.309999999999998e-43 | NTclustered | gi|2738922719|gb|OP648302.1| | 2879644 | g68256 | i0 | 79.623 | 98.93536121673 | 265 | 50 | 100 | 4 | 1 | 263 | 3991 | 4253 | Lepidonotopodium plicata voucher SIO:BIC:A14234 mitochondrion, complete genome | blastn | 26020 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Polynoidae | Lepidonotopodium | Lepidonotopodium plicata |
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);;