contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513053 | 6513053 | PRJEB673_P_NODE_7246_length_321_cov_1.318182_g6897_i0 | PRJEB673 | 7246 | 321 | 1.318182 | 4.23136422 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 196 | 1.31e-45 | NTclustered | gi|359318420|gb|JN968463.2| | 6161 | g6897 | i0 | 78.71 | 71.0218068535826 | 310 | 55 | 95 | 9 | 10 | 315 | 950 | 648 | Dugesia japonica glucose-regulated protein 78 (grp78) mRNA, complete cds | blastn | 22798 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 7372844 | 7372844 | PRJEB673_P_NODE_6906_length_330_cov_1.220339_g6557_i0 | PRJEB673 | 6906 | 330 | 1.220339 | 4.0271187 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 274 | 6.09e-69 | NTclustered | gi|209968707|gb|FJ384870.1| | 52061 | g6557 | i0 | 100 | 45.6575757575758 | 148 | 0 | 45 | 0 | 183 | 330 | 1373 | 1226 | Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence | blastn | 15067 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 10337901 | 10337901 | PRJEB673_P_NODE_10309_length_176_cov_2.780142_g9960_i0 | PRJEB673 | 10309 | 176 | 2.780142 | 4.89304992 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 326 | 7.92e-85 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g9960 | i0 | 100 | 81.0397727272727 | 176 | 0 | 100 | 0 | 1 | 176 | 2341 | 2516 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14263 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 14163262 | 14163262 | PRJEB673_P_NODE_11492_length_161_cov_0.952381_g11143_i0 | PRJEB673 | 11492 | 161 | 0.952381 | 1.53333341 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|687156761|emb|LN010431.1| | 99802 | g11143 | i0 | 100 | 0.180124223602484 | 29 | 0 | 18 | 0 | 77 | 105 | 11687 | 11715 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0010307 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 15023191 | 15023191 | PRJEB673_P_NODE_12412_length_154_cov_1.008403_g12063_i0 | PRJEB673 | 12412 | 154 | 1.008403 | 1.55294062 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 285 | 1.14e-72 | NTclustered | gi|2866376384|gb|PQ722296.1| | 39377 | g12063 | i0 | 100 | 99.7467532467532 | 154 | 0 | 100 | 0 | 1 | 154 | 1373 | 1526 | Stenostomum sp. (in: flatworms) isolate F8 small subunit ribosomal RNA gene, partial sequence | blastn | 15361 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. (in: flatworms) | |||
| 18846976 | 18846976 | PRJEB673_P_NODE_8295_length_288_cov_1.264822_g7946_i0 | PRJEB673 | 8295 | 288 | 1.264822 | 3.64268736 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 514 | 2.83e-141 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g7946 | i0 | 98.955 | 70.8784722222222 | 287 | 3 | 99 | 0 | 2 | 288 | 1017 | 731 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 20413 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 25221446 | 25221446 | PRJEB673_P_NODE_6580_length_339_cov_1.315789_g6231_i0 | PRJEB673 | 6580 | 339 | 1.315789 | 4.46052471 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.2 | 1.91e-4 | NTclustered | gi|2224869|gb|U53001.1|DLU53001 | 27895 | g6231 | i0 | 100 | 9.59882005899705 | 32 | 0 | 9 | 0 | 234 | 265 | 80 | 111 | Dendrocoelum lacteum ribosomal RNA large subunit gene, partial sequence | blastn | 3254 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dendrocoelidae | Dendrocoelum | Dendrocoelum lacteum |
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);;