contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA594101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5670890 | 5670890 | PRJNA594101_S_NODE_41725_length_270_cov_0.832487_g41423_i0 | PRJNA594101 | 41725 | 270 | 0.832487 | 2.2477149 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 209 | 1.3900000000000001e-49 | NTclustered | gi|393794122|dbj|AK388719.1| | 6161 | g41423 | i0 | 80.882 | 15.9851851851852 | 272 | 46 | 99 | 5 | 1 | 269 | 667 | 399 | Dugesia japonica cDNA, clone: Dj_aH_000_01290HH.full, full-insert sequence, expressed in adult head | blastn | 4316 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 12046022 | 12046022 | PRJNA594101_S_NODE_12190_length_472_cov_67.646617_g11888_i0 | PRJNA594101 | 12190 | 472 | 67.646617 | 319.29203224 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 747 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g11888 | i0 | 96.667 | 0.953389830508475 | 450 | 13 | 95 | 2 | 11 | 459 | 460 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 450 | 747 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 13321069 | 13321069 | PRJNA594101_S_NODE_36771_length_286_cov_1.107981_g36469_i0 | PRJNA594101 | 36771 | 286 | 1.107981 | 3.16882566 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|687787484|emb|LK827537.1| | 57078 | g36469 | i0 | 96.97 | 0.409090909090909 | 33 | 0 | 11 | 1 | 1 | 32 | 528 | 560 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0061396 | blastn | 117 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 20969200 | 20969200 | PRJNA594101_S_NODE_21877_length_359_cov_2.877622_g21575_i0 | PRJNA594101 | 21877 | 359 | 2.877622 | 10.33066298 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 442 | 1.7299999999999993e-119 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g21575 | i0 | 88.889 | 1.00278551532033 | 360 | 38 | 100 | 2 | 1 | 359 | 40 | 398 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 360 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23519283 | 23519283 | PRJNA594101_S_NODE_11219_length_491_cov_2.267943_g10918_i0 | PRJNA594101 | 11219 | 491 | 2.267943 | 11.13560013 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 54.7 | 0.013 | NTclustered | gi|2318774105|ref|XM_051217904.1| | 6185 | g10918 | i0 | 96.97 | 0.134419551934827 | 33 | 0 | 7 | 1 | 316 | 347 | 1782 | 1814 | Schistosoma haematobium YTH domain (ECT11_1), mRNA | blastn | 66 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium |
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);;