contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1407091 | 1407091 | PRJEB66218_P_NODE_222162_length_206_cov_0.896552_g219732_i0 | PRJEB66218 | 222162 | 206 | 0.896552 | 1.84689712 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g219732 | i0 | 100 | 0.140776699029126 | 29 | 0 | 14 | 0 | 138 | 166 | 42613943 | 42613915 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3545775 | 3545775 | PRJEB66218_P_NODE_91383_length_324_cov_2.049430_g88956_i0 | PRJEB66218 | 91383 | 324 | 2.04943 | 6.6401532 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g88956 | i0 | 94.286 | 0.41358024691358 | 35 | 2 | 11 | 0 | 78 | 112 | 13274695 | 13274729 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 134 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3958190 | 3958190 | PRJEB66218_P_NODE_191584_length_214_cov_1.607843_g189154_i0 | PRJEB66218 | 191584 | 214 | 1.607843 | 3.44078402 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.019 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g189154 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 102 | 129 | 3119631 | 3119604 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3959955 | 3959955 | PRJEB66218_P_NODE_58104_length_434_cov_2.058981_g55684_i0 | PRJEB66218 | 58104 | 434 | 2.058981 | 8.93597754 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g55684 | i0 | 100 | 0.0714285714285714 | 31 | 0 | 7 | 0 | 269 | 299 | 3787713 | 3787683 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4822637 | 4822637 | PRJEB66218_P_NODE_207724_length_209_cov_0.878378_g205294_i0 | PRJEB66218 | 207724 | 209 | 0.878378 | 1.83581002 | Metazoa | 33208 | Annelida | Annelida | 58.4 | 3.94e-4 | NTclustered | gi|675868731|ref|XM_009021678.1| | 6412 | g205294 | i0 | 100 | 0.444976076555024 | 31 | 0 | 15 | 0 | 101 | 131 | 116 | 86 | Helobdella robusta hypothetical protein mRNA | blastn | 93 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 6508791 | 6508791 | PRJEB66218_P_NODE_111206_length_287_cov_2.747788_g108777_i0 | PRJEB66218 | 111206 | 287 | 2.747788 | 7.88615156 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.59e-4 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g108777 | i0 | 100 | 1.38675958188153 | 32 | 0 | 11 | 0 | 152 | 183 | 13476588 | 13476619 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 398 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9923194 | 9923194 | PRJEB66218_P_NODE_76168_length_364_cov_3.313531_g73742_i0 | PRJEB66218 | 76168 | 364 | 3.313531 | 12.06125284 | Metazoa | 33208 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g73742 | i0 | 100 | 0.164835164835165 | 30 | 0 | 8 | 0 | 173 | 202 | 6951749 | 6951720 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12884969 | 12884969 | PRJEB66218_P_NODE_148231_length_243_cov_1.291209_g145802_i0 | PRJEB66218 | 148231 | 243 | 1.291209 | 3.13763787 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g145802 | i0 | 100 | 0.230452674897119 | 28 | 0 | 12 | 0 | 101 | 128 | 1105981 | 1105954 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12885297 | 12885297 | PRJEB66218_P_NODE_165711_length_230_cov_1.538462_g163281_i0 | PRJEB66218 | 165711 | 230 | 1.538462 | 3.5384626 | Octolasion lacteum | 334871 | Annelida | Annelida | 425 | 1.05e-114 | NTclustered | gi|674656307|gb|KJ912228.1| | 334871 | g163281 | i0 | 100 | 100.008695652174 | 230 | 0 | 100 | 0 | 1 | 230 | 380 | 151 | Octolasion lacteum isolate MPL411 28S ribosomal RNA gene, partial sequence | blastn | 23002 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Octolasion | Octolasion lacteum | |
| 12886880 | 12886880 | PRJEB66218_P_NODE_35451_length_602_cov_1.175601_g33071_i0 | PRJEB66218 | 35451 | 602 | 1.175601 | 7.07711802 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.005 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g33071 | i0 | 100 | 0.0980066445182724 | 30 | 0 | 5 | 0 | 403 | 432 | 8168514 | 8168485 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12887950 | 12887950 | PRJEB66218_P_NODE_77871_length_359_cov_2.218121_g75445_i0 | PRJEB66218 | 77871 | 359 | 2.218121 | 7.96305439 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.034 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g75445 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 110 | 137 | 11253832 | 11253805 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15433305 | 15433305 | PRJEB66218_P_NODE_125633_length_267_cov_1.893204_g123204_i0 | PRJEB66218 | 125633 | 267 | 1.893204 | 5.05485468 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 5.25e-4 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g123204 | i0 | 100 | 11.3258426966292 | 31 | 0 | 15 | 0 | 176 | 206 | 12469252 | 12469282 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 3024 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15434219 | 15434219 | PRJEB66218_P_NODE_170053_length_227_cov_1.849398_g167623_i0 | PRJEB66218 | 170053 | 227 | 1.849398 | 4.19813346 | Hirudo verbana | 311461 | Annelida | Annelida | 84.2 | 7.17e-12 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g167623 | i0 | 79.675 | 0.541850220264317 | 123 | 19 | 52 | 4 | 13 | 130 | 11097534 | 11097413 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 123 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16296768 | 16296768 | PRJEB66218_P_NODE_122333_length_271_cov_6.509524_g119904_i0 | PRJEB66218 | 122333 | 271 | 6.509524 | 17.64081004 | Terebellida | 6373 | Annelida | Annelida | 97.1 | 1.13e-15 | NTclustered | gi|47717242|gb|AY611446.1| | 279652 | g119904 | i0 | 93.846 | 20.6678966789668 | 65 | 3 | 24 | 1 | 208 | 271 | 81 | 17 | Pista cristata 28S ribosomal RNA gene, partial sequence | blastn | 5601 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Terebellidae | Pista | Pista cristata | |
| 16297199 | 16297199 | PRJEB66218_P_NODE_208733_length_209_cov_0.878378_g206303_i0 | PRJEB66218 | 208733 | 209 | 0.878378 | 1.83581002 | Naididae | 2109251 | Annelida | Annelida | 339 | 1.26e-88 | NTclustered | gi|316990285|gb|GU902024.1| | 188231 | g206303 | i0 | 96.135 | 99.3875598086124 | 207 | 8 | 99 | 0 | 3 | 209 | 223 | 17 | Pristina longiseta isolate CE1588 28S ribosomal RNA gene, partial sequence | blastn | 20772 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 19257635 | 19257635 | PRJEB66218_P_NODE_187996_length_216_cov_1.677419_g185566_i0 | PRJEB66218 | 187996 | 216 | 1.677419 | 3.62322504 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.019 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g185566 | i0 | 100 | 0.12962962962963 | 28 | 0 | 13 | 0 | 29 | 56 | 10595390 | 10595363 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20531979 | 20531979 | PRJEB66218_P_NODE_132677_length_259_cov_1.156566_g130248_i0 | PRJEB66218 | 132677 | 259 | 1.156566 | 2.99550594 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5.07e-4 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g130248 | i0 | 100 | 0.474903474903475 | 31 | 0 | 12 | 0 | 133 | 163 | 24825685 | 24825715 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 123 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21809978 | 21809978 | PRJEB66218_P_NODE_34318_length_615_cov_1.270758_g31946_i0 | PRJEB66218 | 34318 | 615 | 1.270758 | 7.8151617 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.017 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g31946 | i0 | 100 | 0.0471544715447154 | 29 | 0 | 5 | 0 | 333 | 361 | 1744240 | 1744212 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23083142 | 23083142 | PRJEB66218_P_NODE_140279_length_251_cov_0.847368_g137850_i0 | PRJEB66218 | 140279 | 251 | 0.847368 | 2.12689368 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 130 | 1.02e-25 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g137850 | i0 | 88.073 | 4.04780876494024 | 109 | 13 | 43 | 0 | 49 | 157 | 6976877 | 6976769 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 1016 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23084250 | 23084250 | PRJEB66218_P_NODE_210559_length_208_cov_1.278912_g208129_i0 | PRJEB66218 | 210559 | 208 | 1.278912 | 2.66013696 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g208129 | i0 | 100 | 0.139423076923077 | 29 | 0 | 14 | 0 | 1 | 29 | 8582843 | 8582871 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24359744 | 24359744 | PRJEB66218_P_NODE_61340_length_419_cov_1.787709_g58919_i0 | PRJEB66218 | 61340 | 419 | 1.787709 | 7.49050071 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 8.67e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g58919 | i0 | 97.059 | 6.25059665871122 | 34 | 1 | 8 | 0 | 370 | 403 | 11723890 | 11723857 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 2619 | 58.4 | 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);;