contig_metadata
8 rows where bioproject = "PRJNA986547", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6077516 | 6077516 | PRJNA986547_P_NODE_9165_length_249_cov_1.312500_g9083_i0 | PRJNA986547 | 9165 | 249 | 1.3125 | 3.268125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 5.67e-27 | NR | CDW55610.1 | 36087 | g9083 | i0 | 81.4 | 18.7228915662651 | 59 | 11 | 71.1 | 0 | 213 | 37 | 1 | 59 | CDW55610.1 60S ribosomal protein L10 [Trichuris trichiura] | diamond | 4662 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 13727705 | 13727705 | PRJNA986547_P_NODE_13371_length_232_cov_6.805031_g13289_i0 | PRJNA986547 | 13371 | 232 | 6.805031 | 15.78767192 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|339262803|ref|XM_003367173.1| | 6334 | g13289 | i0 | 88 | 0.939655172413793 | 50 | 1 | 21 | 4 | 51 | 99 | 259 | 214 | Trichinella spiralis conserved hypothetical protein (Tsp_13564) mRNA, complete cds | blastn | 218 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 15002016 | 15002016 | PRJNA986547_P_NODE_1192_length_409_cov_3.547619_g1110_i0 | PRJNA986547 | 1192 | 409 | 3.547619 | 14.50976171 | Pristionchus sp. 11 RS5228 | 452806 | Nematoda | Nematoda | 344 | 5.79e-90 | NTclustered | gi|150984487|gb|EF634886.1| | 452806 | g1110 | i0 | 85.455 | 82.4254278728606 | 330 | 48 | 81 | 0 | 16 | 345 | 387 | 58 | Pristionchus sp. 11 RS5228 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 33712 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 11 RS5228 | |
| 22651163 | 22651163 | PRJNA986547_P_NODE_12318_length_240_cov_2.371257_g12236_i0 | PRJNA986547 | 12318 | 240 | 2.371257 | 5.6910168 | Metazoa | 33208 | Nematoda | Nematoda | 138 | 1.02e-35 | NR | KAE9413899.1 | 6313 | g12236 | i0 | 78.8 | 50 | 80 | 17 | 100 | 0 | 240 | 1 | 135 | 214 | KAE9413899.1 hypothetical protein Angca_008466, partial [Angiostrongylus cantonensis] | diamond | 12000 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 23926730 | 23926730 | PRJNA986547_P_NODE_2659_length_310_cov_5.527426_g2577_i0 | PRJNA986547 | 2659 | 310 | 5.527426 | 17.1350206 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 152 | 2.7799999999999996e-32 | NTclustered | gi|11094915|gb|AC084465.1|AC084465 | 6238 | g2577 | i0 | 77.5 | 20.8838709677419 | 280 | 46 | 89 | 7 | 34 | 310 | 37012 | 37277 | Caenorhabditis briggsae cosmid CB039B01, complete sequence | blastn | 6474 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 24223920 | 24223920 | PRJNA986547_P_NODE_17199_length_199_cov_4.277778_g17117_i0 | PRJNA986547 | 17199 | 199 | 4.277778 | 8.51277822 | Metazoa | 33208 | Nematoda | Nematoda | 222 | 1.24e-53 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g17117 | i0 | 87.179 | 92.3115577889447 | 195 | 25 | 98 | 0 | 2 | 196 | 299 | 105 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 18370 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 26868445 | 26868445 | PRJNA986547_P_NODE_7361_length_258_cov_8.767568_g7279_i0 | PRJNA986547 | 7361 | 258 | 8.767568 | 22.62032544 | Trichinella britovi | 45882 | Nematoda | Nematoda | 66.2 | 2.34e-10 | NR | KRY46612.1 | 45882 | g7279 | i0 | 48.6 | 2.58139534883721 | 72 | 37 | 83.7 | 0 | 257 | 42 | 619 | 690 | KRY46612.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Trichinella britovi] | diamond | 666 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella britovi | |
| 31986133 | 31986133 | PRJNA986547_P_NODE_9398_length_248_cov_3.857143_g9316_i0 | PRJNA986547 | 9398 | 248 | 3.857143 | 9.56571464 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 75.9 | 2.84e-15 | NR | CAD2162211.1 | 390850 | g9316 | i0 | 59.3 | 2.61290322580645 | 54 | 22 | 65.3 | 0 | 246 | 85 | 88 | 141 | CAD2162211.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 648 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii |
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);;