contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA1136505" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1559092 | 1559092 | PRJNA1136505_P_NODE_28462_length_745_cov_4.065476_g21793_i0 | PRJNA1136505 | 28462 | 745 | 4.065476 | 30.2877962 | Pristionchus microcercus | 3308705 | Nematoda | Nematoda | 442 | 3.789999999999999e-119 | NTclustered | gi|675118833|gb|KJ877296.1| | 3308705 | g21793 | i0 | 78.016 | 97.4093959731544 | 746 | 134 | 98 | 27 | 10 | 740 | 731 | 1 | Paroigolaimella micrura large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 72570 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus microcercus | |
| 18136180 | 18136180 | PRJNA1136505_P_NODE_123335_length_259_cov_1.188172_g116475_i0 | PRJNA1136505 | 123335 | 259 | 1.188172 | 3.07736548 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 174 | 4.83e-39 | NTclustered | gi|1376148385|ref|XM_024654896.1| | 34506 | g116475 | i0 | 79.167 | 66.4633204633205 | 264 | 45 | 100 | 8 | 1 | 259 | 742 | 1000 | Strongyloides ratti Phosphate carrier protein, mitochondrial (SRAE_2000367400), partial mRNA | blastn | 17214 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 24510453 | 24510453 | PRJNA1136505_P_NODE_153820_length_241_cov_1.833333_g146960_i0 | PRJNA1136505 | 153820 | 241 | 1.833333 | 4.41833253 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 255 | 1.54e-63 | NTclustered | gi|687022646|emb|LM525560.1| | 174720 | g146960 | i0 | 86.638 | 91.6265560165975 | 232 | 30 | 96 | 1 | 1 | 232 | 864975 | 865205 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000001 | blastn | 22082 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;