contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3505532 | 3505532 | PRJNA980585_P_NODE_45463_length_249_cov_0.875000_g45209_i0 | PRJNA980585 | 45463 | 249 | 0.875 | 2.17875 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|675888269|ref|XM_009031389.1| | 6412 | g45209 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 26 | 53 | 1533 | 1506 | Helobdella robusta hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 4782959 | 4782959 | PRJNA980585_P_NODE_32784_length_272_cov_1.276382_g32530_i0 | PRJNA980585 | 32784 | 272 | 1.276382 | 3.47175904 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g32530 | i0 | 100 | 0.102941176470588 | 28 | 0 | 10 | 0 | 158 | 185 | 25545718 | 25545691 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12433797 | 12433797 | PRJNA980585_P_NODE_24110_length_300_cov_2.013216_g23856_i0 | PRJNA980585 | 24110 | 300 | 2.013216 | 6.039648 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.29e-5 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g23856 | i0 | 97.297 | 0.68 | 37 | 1 | 12 | 0 | 20 | 56 | 4851973 | 4851937 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 204 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12434097 | 12434097 | PRJNA980585_P_NODE_39850_length_252_cov_1.703911_g39596_i0 | PRJNA980585 | 39850 | 252 | 1.703911 | 4.29385572 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|675886967|ref|XM_009030738.1| | 6412 | g39596 | i0 | 86.275 | 0.611111111111111 | 51 | 5 | 20 | 2 | 203 | 252 | 84 | 133 | Helobdella robusta hypothetical protein partial mRNA | blastn | 154 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 13708455 | 13708455 | PRJNA980585_P_NODE_36931_length_260_cov_1.647059_g36677_i0 | PRJNA980585 | 36931 | 260 | 1.647059 | 4.2823534 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g36677 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 7 | 34 | 264403 | 264430 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14982460 | 14982460 | PRJNA980585_P_NODE_22152_length_311_cov_1.289916_g21898_i0 | PRJNA980585 | 22152 | 311 | 1.289916 | 4.01163876 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 215 | 3.5e-51 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g21898 | i0 | 80.769 | 8.57556270096463 | 286 | 46 | 90 | 7 | 6 | 286 | 191 | 472 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2667 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 14982993 | 14982993 | PRJNA980585_P_NODE_55332_length_244_cov_0.900585_g55078_i0 | PRJNA980585 | 55332 | 244 | 0.900585 | 2.1974274 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g55078 | i0 | 100 | 0.118852459016393 | 29 | 0 | 12 | 0 | 210 | 238 | 17897855 | 17897883 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16257806 | 16257806 | PRJNA980585_P_NODE_43333_length_250_cov_0.870056_g43079_i0 | PRJNA980585 | 43333 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g43079 | i0 | 96.875 | 0.128 | 32 | 1 | 13 | 0 | 130 | 161 | 1519981 | 1519950 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17532450 | 17532450 | PRJNA980585_P_NODE_17134_length_342_cov_1.717472_g16880_i0 | PRJNA980585 | 17134 | 342 | 1.717472 | 5.87375424 | Helobdella robusta | 6412 | Annelida | Annelida | 65.8 | 4.15e-6 | NTclustered | gi|675890727|ref|XM_009032618.1| | 6412 | g16880 | i0 | 95.122 | 3.7953216374269 | 41 | 2 | 12 | 0 | 287 | 327 | 4168 | 4128 | Helobdella robusta hypothetical protein partial mRNA | blastn | 1298 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 17532530 | 17532530 | PRJNA980585_P_NODE_2114_length_818_cov_2.183893_g1886_i0 | PRJNA980585 | 2114 | 818 | 2.183893 | 17.86424474 | Helobdella robusta | 6412 | Annelida | Annelida | 228 | 1.2699999999999999e-54 | NTclustered | gi|675860785|ref|XM_009017705.1| | 6412 | g1886 | i0 | 73.977 | 17.3777506112469 | 611 | 138 | 74 | 17 | 1 | 602 | 995 | 397 | Helobdella robusta hypothetical protein mRNA | blastn | 14215 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 20081453 | 20081453 | PRJNA980585_P_NODE_42536_length_250_cov_0.870056_g42282_i0 | PRJNA980585 | 42536 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.76e-5 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g42282 | i0 | 97.222 | 7.48 | 36 | 1 | 14 | 0 | 187 | 222 | 15149045 | 15149080 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 1870 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24221108 | 24221108 | PRJNA980585_P_NODE_61859_length_231_cov_2.158228_g61605_i0 | PRJNA980585 | 61859 | 231 | 2.158228 | 4.98550668 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.021 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g61605 | i0 | 94.286 | 1.16017316017316 | 35 | 1 | 15 | 1 | 103 | 137 | 8763436 | 8763403 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 268 | 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);;