contig_metadata
9 rows where bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2995043 | 2995043 | PRJNA473201_P_NODE_70843_length_249_cov_0.875000_g70101_i0 | PRJNA473201 | 70843 | 249 | 0.875 | 2.17875 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|690601964|emb|LN155797.1| | 99802 | g70101 | i0 | 100 | 0.232931726907631 | 29 | 0 | 12 | 0 | 160 | 188 | 1039 | 1011 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0140542 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 17021057 | 17021057 | PRJNA473201_P_NODE_34274_length_339_cov_1.406015_g33532_i0 | PRJNA473201 | 34274 | 339 | 1.406015 | 4.76639085 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 154 | 8.53e-33 | NTclustered | gi|690929153|emb|LN438066.1| | 99802 | g33532 | i0 | 82.123 | 4.87905604719764 | 179 | 32 | 53 | 0 | 156 | 334 | 132 | 310 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0186957 | blastn | 1654 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 19570168 | 19570168 | PRJNA473201_P_NODE_73276_length_247_cov_0.885057_g72534_i0 | PRJNA473201 | 73276 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 2.71e-24 | NR | PAA47604.1 | 282301 | g72534 | i0 | 69.4 | 6.01214574898785 | 72 | 22 | 87.4 | 0 | 216 | 1 | 4 | 75 | PAA47604.1 hypothetical protein BOX15_Mlig032962g2 [Macrostomum lignano] | diamond | 1485 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 21497072 | 21497072 | PRJNA473201_P_NODE_70637_length_249_cov_0.875000_g69895_i0 | PRJNA473201 | 70637 | 249 | 0.875 | 2.17875 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 294 | 3.39e-75 | NTclustered | gi|10880358|emb|AJ405975.1| | 52061 | g69895 | i0 | 87.952 | 91.7710843373494 | 249 | 30 | 100 | 0 | 1 | 249 | 274 | 26 | Stenostomum leucops partial mitochondrial cytochrome oxidase c subunit I (cox1 gene), part 1 | blastn | 22851 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 23395632 | 23395632 | PRJNA473201_P_NODE_20939_length_431_cov_1.650838_g20197_i0 | PRJNA473201 | 20939 | 431 | 1.650838 | 7.11511178 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 752 | 0 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g20197 | i0 | 98.144 | 47.631090487239 | 431 | 8 | 100 | 0 | 1 | 431 | 8964 | 8534 | Stenostomum sthenum mitochondrion, complete genome | blastn | 20529 | 752 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 24670028 | 24670028 | PRJNA473201_P_NODE_44660_length_305_cov_1.327586_g43918_i0 | PRJNA473201 | 44660 | 305 | 1.327586 | 4.0491373 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 381 | 3.1899999999999997e-101 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g43918 | i0 | 89.18 | 1 | 305 | 33 | 100 | 0 | 1 | 305 | 13597 | 13901 | Stenostomum sthenum mitochondrion, complete genome | blastn | 305 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 26871229 | 26871229 | PRJNA473201_P_NODE_78821_length_244_cov_0.900585_g78079_i0 | PRJNA473201 | 78821 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 72.4 | 7.8e-14 | NR | VDM31564.1 | 6205 | g78079 | i0 | 45.5 | 12.1967213114754 | 77 | 42 | 94.7 | 0 | 233 | 3 | 9 | 85 | VDM31564.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 2976 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29776360 | 29776360 | PRJNA473201_P_NODE_24931_length_394_cov_2.613707_g24189_i0 | PRJNA473201 | 24931 | 394 | 2.613707 | 10.29800558 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 92.4 | 4.79e-20 | NR | VDN13523.1 | 60516 | g24189 | i0 | 63.2 | 2.09390862944162 | 68 | 23 | 51.8 | 1 | 8 | 211 | 168 | 233 | VDN13523.1 unnamed protein product [Dibothriocephalus latus] | diamond | 825 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 30913992 | 30913992 | PRJNA473201_P_NODE_72194_length_248_cov_0.880000_g71452_i0 | PRJNA473201 | 72194 | 248 | 0.88 | 2.1824 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 98.2 | 3.73e-23 | NR | CAH8485309.1 | 57078 | g71452 | i0 | 53.7 | 5.58870967741935 | 82 | 38 | 99.2 | 0 | 247 | 2 | 121 | 202 | CAH8485309.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 1386 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;