contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA600413" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3123834 | 3123834 | PRJNA600413_P_NODE_10843_length_448_cov_51.774436_g10144_i0 | PRJNA600413 | 10843 | 448 | 51.774436 | 231.94947328 | Lumbricidae sp. Bozorgi-2018 | 2419836 | Annelida | Annelida | 699 | 0 | NTclustered | gi|1594445602|dbj|LC427092.1| | 2419836 | g10144 | i0 | 99.738 | 132.997767857143 | 382 | 0 | 85 | 1 | 1 | 382 | 381 | 1 | Lumbricidae sp. Bozorgi-2018 gene for 28S ribosomal RNA, partial sequence | blastn | 59583 | 699 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricidae sp. Bozorgi-2018 | ||
| 4402673 | 4402673 | PRJNA600413_P_NODE_76244_length_182_cov_1.533835_g75543_i0 | PRJNA600413 | 76244 | 182 | 1.533835 | 2.7915797 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 3.33e-4 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g75543 | i0 | 100 | 0.17032967032967 | 31 | 0 | 17 | 0 | 138 | 168 | 21159711 | 21159681 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6953611 | 6953611 | PRJNA600413_P_NODE_94246_length_171_cov_1.672131_g93545_i0 | PRJNA600413 | 94246 | 171 | 1.672131 | 2.85934401 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g93545 | i0 | 90.476 | 0.409356725146199 | 42 | 3 | 24 | 1 | 56 | 96 | 6334533 | 6334492 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 70 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9502280 | 9502280 | PRJNA600413_P_NODE_26228_length_277_cov_1.565789_g25527_i0 | PRJNA600413 | 26228 | 277 | 1.565789 | 4.33723553 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g25527 | i0 | 100 | 0.202166064981949 | 28 | 0 | 10 | 0 | 21 | 48 | 22770282 | 22770309 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13328287 | 13328287 | PRJNA600413_P_NODE_43451_length_220_cov_11.233918_g42750_i0 | PRJNA600413 | 43451 | 220 | 11.233918 | 24.7146196 | Lumbricidae sp. Bozorgi-2018 | 2419836 | Annelida | Annelida | 350 | 6.17e-92 | NTclustered | gi|1594445602|dbj|LC427092.1| | 2419836 | g42750 | i0 | 95.909 | 100 | 220 | 2 | 100 | 3 | 1 | 220 | 406 | 618 | Lumbricidae sp. Bozorgi-2018 gene for 28S ribosomal RNA, partial sequence | blastn | 22000 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricidae sp. Bozorgi-2018 | ||
| 15875768 | 15875768 | PRJNA600413_P_NODE_118773_length_165_cov_0.879310_g118072_i0 | PRJNA600413 | 118773 | 165 | 0.87931 | 1.4508615 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g118072 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 34 | 61 | 22187419 | 22187392 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15875867 | 15875867 | PRJNA600413_P_NODE_125573_length_164_cov_0.886957_g124872_i0 | PRJNA600413 | 125573 | 164 | 0.886957 | 1.45460948 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g124872 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 9 | 36 | 10631475 | 10631448 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15876149 | 15876149 | PRJNA600413_P_NODE_142673_length_162_cov_0.902655_g141972_i0 | PRJNA600413 | 142673 | 162 | 0.902655 | 1.4623011 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g141972 | i0 | 100 | 0.185185185185185 | 30 | 0 | 19 | 0 | 86 | 115 | 4703480 | 4703451 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15876264 | 15876264 | PRJNA600413_P_NODE_15033_length_374_cov_1.990769_g14333_i0 | PRJNA600413 | 15033 | 374 | 1.990769 | 7.44547606 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.036 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g14333 | i0 | 100 | 0.0748663101604278 | 28 | 0 | 7 | 0 | 166 | 193 | 6347586 | 6347613 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18425117 | 18425117 | PRJNA600413_P_NODE_131615_length_163_cov_0.894737_g130914_i0 | PRJNA600413 | 131615 | 163 | 0.894737 | 1.45842131 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 2.26e-5 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g130914 | i0 | 97.222 | 5.3680981595092 | 36 | 1 | 22 | 0 | 1 | 36 | 15247458 | 15247423 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 875 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20975972 | 20975972 | PRJNA600413_P_NODE_19177_length_326_cov_21.379061_g18476_i0 | PRJNA600413 | 19177 | 326 | 21.379061 | 69.69573886 | Eudrilus eugeniae | 169957 | Annelida | Annelida | 603 | 6.749999999999998e-168 | NTclustered | gi|2875316952|gb|PQ824456.1| | 169957 | g18476 | i0 | 100 | 100.527607361963 | 326 | 0 | 100 | 0 | 1 | 326 | 606 | 931 | Eudrilus eugeniae isolate AJP small subunit ribosomal RNA gene, partial sequence | blastn | 32772 | 603 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Eudrilidae | Eudrilus | Eudrilus eugeniae | |
| 24798921 | 24798921 | PRJNA600413_P_NODE_10040_length_467_cov_6.665072_g9343_i0 | PRJNA600413 | 10040 | 467 | 6.665072 | 31.12588624 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.045 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g9343 | i0 | 100 | 0.0599571734475375 | 28 | 0 | 6 | 0 | 312 | 339 | 33715827 | 33715800 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 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);;