contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7379371 | 7379371 | PRJNA1011844_P_NODE_125166_length_276_cov_1.886700_g116589_i0 | PRJNA1011844 | 125166 | 276 | 1.8867 | 5.207292 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|48374999|gb|AY551107.1| | 100414 | g116589 | i0 | 96.97 | 0.902173913043478 | 33 | 0 | 12 | 1 | 245 | 276 | 23 | 55 | Endorchis piraeeba 18S ribosomal RNA gene, partial sequence | blastn | 249 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Proteocephalidea | Monticelliidae | Endorchis | Endorchis piraeeba | |
| 7809016 | 7809016 | PRJNA1011844_P_NODE_168427_length_231_cov_2.177215_g159846_i0 | PRJNA1011844 | 168427 | 231 | 2.177215 | 5.02936665 | Neppia sp. MR-2006 | 391277 | Platyhelminthes | Platyhelminthes | 148 | 2.5599999999999997e-31 | NTclustered | gi|109631062|gb|DQ665982.1| | 391277 | g159846 | i0 | 83.974 | 33.4199134199134 | 156 | 23 | 67 | 2 | 67 | 221 | 1195 | 1041 | Neppia sp. MR-2006 28S ribosomal RNA gene, partial sequence | blastn | 7720 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Neppia | Neppia sp. MR-2006 | |
| 7809116 | 7809116 | PRJNA1011844_P_NODE_177607_length_206_cov_4.812030_g169025_i0 | PRJNA1011844 | 177607 | 206 | 4.81203 | 9.9127818 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 326 | 9.61e-85 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g169025 | i0 | 96.923 | 45.6990291262136 | 195 | 4 | 94 | 2 | 2 | 194 | 2935 | 2741 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 9414 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 12909706 | 12909706 | PRJNA1011844_P_NODE_137071_length_261_cov_1.250000_g128493_i0 | PRJNA1011844 | 137071 | 261 | 1.25 | 3.2625 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 60.2 | 1.42e-4 | NTclustered | gi|690488189|emb|LN032496.1| | 99802 | g128493 | i0 | 100 | 0.122605363984674 | 32 | 0 | 12 | 0 | 132 | 163 | 3505 | 3474 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0031832 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 12911183 | 12911183 | PRJNA1011844_P_NODE_69571_length_456_cov_6.798956_g61102_i0 | PRJNA1011844 | 69571 | 456 | 6.7989560000000004 | 31.00323936 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.003 | NTclustered | gi|690460069|emb|LN002230.1| | 99802 | g61102 | i0 | 100 | 0.881578947368421 | 30 | 0 | 7 | 0 | 49 | 78 | 6570 | 6541 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0002212 | blastn | 402 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 12911410 | 12911410 | PRJNA1011844_P_NODE_85351_length_376_cov_10.792079_g76805_i0 | PRJNA1011844 | 85351 | 376 | 10.792079 | 40.57821704 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.01 | NTclustered | gi|690466776|emb|LN005000.1| | 99802 | g76805 | i0 | 100 | 0.0771276595744681 | 29 | 0 | 8 | 0 | 238 | 266 | 5050 | 5078 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0004953 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 16304661 | 16304661 | PRJNA1011844_P_NODE_46133_length_673_cov_2.851667_g38010_i0 | PRJNA1011844 | 46133 | 673 | 2.851667 | 19.19171891 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 54.7 | 0.019 | NTclustered | gi|1373851260|ref|XM_024492007.1| | 6210 | g38010 | i0 | 100 | 0.233283803863299 | 29 | 0 | 4 | 0 | 299 | 327 | 7070 | 7042 | Echinococcus granulosus Afadin (EGR_02758), partial mRNA | blastn | 157 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 17579649 | 17579649 | PRJNA1011844_P_NODE_124854_length_276_cov_4.822660_g116277_i0 | PRJNA1011844 | 124854 | 276 | 4.82266 | 13.3105416 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 383 | 7.92e-102 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g116277 | i0 | 92.884 | 8.80797101449275 | 267 | 13 | 95 | 3 | 2 | 262 | 8964 | 8698 | Stenostomum sthenum mitochondrion, complete genome | blastn | 2431 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 18009220 | 18009220 | PRJNA1011844_P_NODE_57035_length_553_cov_5.797917_g48673_i0 | PRJNA1011844 | 57035 | 553 | 5.797917 | 32.06248101 | Duplominona sp. n. 2 FS-2014 | 1578780 | Platyhelminthes | Platyhelminthes | 265 | 6.42e-66 | NTclustered | gi|728882876|gb|KJ682435.1| | 1578780 | g48673 | i0 | 81.073 | 50.2441229656419 | 354 | 48 | 63 | 17 | 17 | 362 | 1271 | 929 | Duplominona sp. n. 2 FS-2014 isolate DNSPNA3 28S large subunit ribosomal RNA gene, partial sequence | blastn | 27785 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Monocelididae | Duplominona | Duplominona sp. n. 2 FS-2014 | |
| 19282465 | 19282465 | PRJNA1011844_P_NODE_28916_length_984_cov_11.714599_g22381_i0 | PRJNA1011844 | 28916 | 984 | 11.714599 | 115.27165416 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.028 | NTclustered | gi|690484865|emb|LN028320.1| | 99802 | g22381 | i0 | 100 | 0.0294715447154472 | 29 | 0 | 3 | 0 | 941 | 969 | 1330 | 1302 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0000540 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 21833744 | 21833744 | PRJNA1011844_P_NODE_29918_length_960_cov_10.184893_g23249_i0 | PRJNA1011844 | 29918 | 960 | 10.184893 | 97.7749728 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.008 | NTclustered | gi|687170330|emb|LN074246.1| | 99802 | g23249 | i0 | 97.059 | 0.0958333333333333 | 34 | 0 | 4 | 1 | 361 | 394 | 1808 | 1776 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0002767 | blastn | 92 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;