contig_metadata
8 rows where bioproject = "PRJNA446034", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1091905 | 1091905 | PRJNA446034_S_NODE_15201_length_239_cov_7.594059_g15164_i0 | PRJNA446034 | 15201 | 239 | 7.594059 | 18.14980101 | Lumbricus | 6397 | Annelida | Annelida | 298 | 2.5e-76 | NTclustered | gi|1785188346|gb|MN102127.1| | 35632 | g15164 | i0 | 93.596 | 84.5146443514644 | 203 | 7 | 84 | 5 | 1 | 201 | 12467 | 12665 | Lumbricus rubellus mitochondrion, complete genome | blastn | 20199 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus rubellus | |
| 6194947 | 6194947 | PRJNA446034_S_NODE_21785_length_221_cov_5.478261_g21748_i0 | PRJNA446034 | 21785 | 221 | 5.478261 | 12.10695681 | Perinereis | 6354 | Annelida | Annelida | 73.1 | 1.5e-8 | NTclustered | gi|2666679620|ref|NC_085286.1| | 1348146 | g21748 | i0 | 82.022 | 1.20814479638009 | 89 | 13 | 40 | 3 | 13 | 100 | 12978 | 12892 | Perinereis wilsoni mitochondrion, complete genome | blastn | 267 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Perinereis | Perinereis wilsoni | |
| 6816184 | 6816184 | PRJNA446034_S_NODE_93646_length_158_cov_1.495868_g93609_i0 | PRJNA446034 | 93646 | 158 | 1.495868 | 2.36347144 | Lumbricus rubellus | 35632 | Annelida | Annelida | 281 | 1.53e-71 | NTclustered | gi|1785188346|gb|MN102127.1| | 35632 | g93609 | i0 | 98.734 | 2 | 158 | 2 | 100 | 0 | 1 | 158 | 15460 | 15303 | Lumbricus rubellus mitochondrion, complete genome | blastn | 316 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus rubellus | |
| 8091444 | 8091444 | PRJNA446034_S_NODE_57467_length_177_cov_10.378571_g57430_i0 | PRJNA446034 | 57467 | 177 | 10.378571 | 18.37007067 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.015 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g57430 | i0 | 100 | 0.15819209039548 | 28 | 0 | 16 | 0 | 3 | 30 | 4907020 | 4906993 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13191626 | 13191626 | PRJNA446034_S_NODE_107371_length_152_cov_13.365217_g107334_i0 | PRJNA446034 | 107371 | 152 | 13.365217 | 20.31512984 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.003 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g107334 | i0 | 100 | 0.190789473684211 | 29 | 0 | 19 | 0 | 2 | 30 | 20169993 | 20170021 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22114549 | 22114549 | PRJNA446034_S_NODE_104698_length_153_cov_9.250000_g104661_i0 | PRJNA446034 | 104698 | 153 | 9.25 | 14.1525 | Amynthas gracilis | 301145 | Annelida | Annelida | 167 | 4.2899999999999995e-37 | NTclustered | gi|836614202|ref|NC_027258.1| | 301145 | g104661 | i0 | 86.275 | 68.3529411764706 | 153 | 21 | 100 | 0 | 1 | 153 | 1344 | 1192 | Amynthas gracilis mitochondrion, complete genome | blastn | 10458 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Megascolecidae | Amynthas | Amynthas gracilis | |
| 28892157 | 28892157 | PRJNA446034_S_NODE_53648_length_180_cov_7.055944_g53611_i0 | PRJNA446034 | 53648 | 180 | 7.055944 | 12.7006992 | root | 1 | Root_unresolved | Root_unresolved | 117 | 2.2599999999999996e-31 | NR | XP_009012174.1 | 6412 | g53611 | i0 | 100 | 3.86666666666667 | 58 | 0 | 96.7 | 0 | 178 | 5 | 136 | 193 | XP_009012174.1 hypothetical protein HELRODRAFT_92894, partial [Helobdella robusta] | diamond | 696 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29065645 | 29065645 | PRJNA446034_S_NODE_64588_length_173_cov_1.117647_g64551_i0 | PRJNA446034 | 64588 | 173 | 1.117647 | 1.93352931 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 65.5 | 1.39e-10 | NR | KAI0208158.1 | 104711 | g64551 | i0 | 62.7 | 6.13872832369942 | 59 | 20 | 98.8 | 1 | 3 | 173 | 857 | 915 | KAI0208158.1 hypothetical protein LSAT2_007158 [Lamellibrachia satsuma] | diamond | 1062 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma |
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);;