contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3006103 | 3006103 | PRJNA493244_P_NODE_1298683_length_297_cov_2.139831_g1275559_i0 | PRJNA493244 | 1298683 | 297 | 2.139831 | 6.35529807 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 69.4 | 2.74e-7 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g1275559 | i0 | 97.5 | 1.63973063973064 | 40 | 1 | 13 | 0 | 119 | 158 | 2364719 | 2364758 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 487 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3651118 | 3651118 | PRJNA493244_P_NODE_1726883_length_200_cov_7.035971_g1703758_i0 | PRJNA493244 | 1726883 | 200 | 7.035971 | 14.071942 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 2.1800000000000003e-21 | NTclustered | gi|2440748728|gb|OQ389666.1| | 104685 | g1703758 | i0 | 85.586 | 46.025 | 111 | 15 | 56 | 1 | 90 | 200 | 194 | 303 | Galeolaria caespitosa voucher SAM:E3529 large subunit ribosomal RNA gene, partial sequence | blastn | 9205 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Galeolaria | Galeolaria caespitosa | |
| 4282548 | 4282548 | PRJNA493244_P_NODE_1386684_length_272_cov_1.483412_g1363559_i0 | PRJNA493244 | 1386684 | 272 | 1.483412 | 4.03488064 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g1363559 | i0 | 100 | 0.106617647058824 | 29 | 0 | 11 | 0 | 4 | 32 | 14337646 | 14337618 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5560122 | 5560122 | PRJNA493244_P_NODE_1753825_length_168_cov_4.186916_g1730700_i0 | PRJNA493244 | 1753825 | 168 | 4.186916 | 7.03401888 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 122 | 1.06e-23 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g1730700 | i0 | 84.8 | 0.744047619047619 | 125 | 15 | 73 | 4 | 1 | 123 | 5635585 | 5635707 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 125 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5561340 | 5561340 | PRJNA493244_P_NODE_920545_length_443_cov_6.798429_g897561_i0 | PRJNA493244 | 920545 | 443 | 6.798429 | 30.11704047 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.043 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g897561 | i0 | 100 | 0.0632054176072235 | 28 | 0 | 6 | 0 | 48 | 75 | 4853679 | 4853706 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6833964 | 6833964 | PRJNA493244_P_NODE_1689866_length_205_cov_0.888889_g1666741_i0 | PRJNA493244 | 1689866 | 205 | 0.888889 | 1.82222245 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 3.85e-4 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g1666741 | i0 | 92.683 | 10.7170731707317 | 41 | 1 | 20 | 2 | 81 | 121 | 15387145 | 15387183 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 2197 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8108576 | 8108576 | PRJNA493244_P_NODE_1345247_length_283_cov_6.234234_g1322123_i0 | PRJNA493244 | 1345247 | 283 | 6.234234 | 17.64288222 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g1322123 | i0 | 92.105 | 0.134275618374558 | 38 | 3 | 13 | 0 | 1 | 38 | 33665958 | 33665921 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 38 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10658474 | 10658474 | PRJNA493244_P_NODE_1008169_length_403_cov_2.967836_g985074_i0 | PRJNA493244 | 1008169 | 403 | 2.967836 | 11.96037908 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 215 | 4.66e-51 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g985074 | i0 | 81.679 | 6.68238213399504 | 262 | 44 | 67 | 2 | 98 | 356 | 8931956 | 8932216 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 2693 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19583795 | 19583795 | PRJNA493244_P_NODE_982636_length_414_cov_7.688385_g959562_i0 | PRJNA493244 | 982636 | 414 | 7.688385 | 31.8299139 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.04 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g959562 | i0 | 100 | 0.0676328502415459 | 28 | 0 | 7 | 0 | 1 | 28 | 45211418 | 45211445 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20857736 | 20857736 | PRJNA493244_P_NODE_1603137_length_220_cov_1.207547_g1580012_i0 | PRJNA493244 | 1603137 | 220 | 1.207547 | 2.6566034 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.019 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g1580012 | i0 | 100 | 0.127272727272727 | 28 | 0 | 13 | 0 | 141 | 168 | 4512231 | 4512258 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24681237 | 24681237 | PRJNA493244_P_NODE_1281060_length_302_cov_7.398340_g1257936_i0 | PRJNA493244 | 1281060 | 302 | 7.39834 | 22.3429868 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.68e-4 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g1257936 | i0 | 97.143 | 0.735099337748344 | 35 | 1 | 12 | 0 | 89 | 123 | 27786011 | 27785977 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 222 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
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);;