contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA438572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18286560 | 18286560 | PRJNA438572_P_NODE_14035_length_278_cov_1.136585_g13916_i0 | PRJNA438572 | 14035 | 278 | 1.136585 | 3.1597063 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 231 | 3.06e-56 | NTclustered | gi|1376147935|ref|XM_024654645.1| | 34506 | g13916 | i0 | 81.72 | 18.2805755395683 | 279 | 49 | 100 | 2 | 1 | 278 | 505 | 782 | Strongyloides ratti GMP reductase (SRAE_2000345100), partial mRNA | blastn | 5082 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 23387075 | 23387075 | PRJNA438572_P_NODE_11179_length_307_cov_2.333333_g11060_i0 | PRJNA438572 | 11179 | 307 | 2.333333 | 7.16333231 | Pristionchus exspectatus | 1195656 | Nematoda | Nematoda | 159 | 1.6399999999999999e-34 | NTclustered | gi|390135444|gb|JQ399919.1| | 1195656 | g11060 | i0 | 78.077 | 8.04885993485342 | 260 | 51 | 84 | 6 | 50 | 306 | 13 | 269 | Pristionchus exspectatus large subunit ribosomal protein 30 (rpl-30) gene, partial cds | blastn | 2471 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus exspectatus | |
| 23387119 | 23387119 | PRJNA438572_P_NODE_14019_length_278_cov_1.141463_g13900_i0 | PRJNA438572 | 14019 | 278 | 1.141463 | 3.17326714 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 182 | 3.13e-41 | NTclustered | gi|1376135993|ref|XM_024648054.1| | 34506 | g13900 | i0 | 84.127 | 8.03597122302158 | 189 | 28 | 68 | 2 | 21 | 208 | 1235 | 1048 | Strongyloides ratti Carboxyl transferase domain and Acetyl-coenzyme A carboxyltransferase, N-terminal domain and Acetyl-coenzyme A carboxyltransferase, C-terminal domain-containing protein (SRAE_1000113500), partial mRNA | blastn | 2234 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 24661101 | 24661101 | PRJNA438572_P_NODE_10380_length_318_cov_1.273469_g10261_i0 | PRJNA438572 | 10380 | 318 | 1.273469 | 4.04963142 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 75 | 6.36e-9 | NTclustered | gi|339241348|ref|XM_003376552.1| | 6334 | g10261 | i0 | 82.022 | 0.279874213836478 | 89 | 14 | 28 | 2 | 15 | 102 | 237 | 324 | Trichinella spiralis T-complex protein 1 subunit beta (Tsp_00786) mRNA, complete cds | blastn | 89 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis |
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);;