contig_metadata
8 rows where bioproject = "PRJNA532380", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 504273 | 504273 | PRJNA532380_P_NODE_6001_length_399_cov_3.477143_g5676_i0 | PRJNA532380 | 6001 | 399 | 3.477143 | 13.87380057 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 3.59e-47 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g5676 | i0 | 79.649 | 6.67669172932331 | 285 | 54 | 71 | 4 | 65 | 347 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 2664 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 28625223 | 28625223 | PRJNA532380_P_NODE_17207_length_217_cov_1.238095_g16882_i0 | PRJNA532380 | 17207 | 217 | 1.238095 | 2.68666615 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 52 | 1.1e-5 | NR | CAD5220209.1 | 6326 | g16882 | i0 | 38.3 | 0.829493087557604 | 60 | 37 | 82.9 | 0 | 6 | 185 | 179 | 238 | CAD5220209.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 180 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 28656753 | 28656753 | PRJNA532380_P_NODE_32487_length_163_cov_0.912281_g32162_i0 | PRJNA532380 | 32487 | 163 | 0.912281 | 1.48701803 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 55.8 | 2.86e-7 | NR | CAD5234675.1 | 6326 | g32162 | i0 | 50 | 2.57668711656442 | 54 | 26 | 99.4 | 1 | 1 | 162 | 238 | 290 | CAD5234675.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 420 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 28877556 | 28877556 | PRJNA532380_P_NODE_19268_length_205_cov_1.333333_g18943_i0 | PRJNA532380 | 19268 | 205 | 1.333333 | 2.73333265 | Pristionchus mayeri | 1317129 | Nematoda | Nematoda | 51.2 | 1.31e-5 | NR | GMR47851.1 | 1317129 | g18943 | i0 | 45.9 | 0.892682926829268 | 61 | 31 | 86.3 | 1 | 204 | 28 | 22 | 82 | GMR47851.1 hypothetical protein PMAYCL1PPCAC_18046, partial [Pristionchus mayeri] | diamond | 183 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 30345969 | 30345969 | PRJNA532380_P_NODE_20932_length_196_cov_1.639456_g20607_i0 | PRJNA532380 | 20932 | 196 | 1.639456 | 3.21333376 | Trichinella | 6333 | Nematoda | Nematoda | 102 | 5.0799999999999996e-24 | NR | KAL1242640.1 | 6334 | g20607 | i0 | 64.6 | 3.91836734693878 | 65 | 23 | 99.5 | 0 | 195 | 1 | 70 | 134 | KAL1242640.1 Aspartic protease [Trichinella spiralis] | diamond | 768 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 30471953 | 30471953 | PRJNA532380_P_NODE_31453_length_164_cov_0.904348_g31128_i0 | PRJNA532380 | 31453 | 164 | 0.904348 | 1.48313072 | Metazoa | 33208 | Nematoda | Nematoda | 89.7 | 2.54e-19 | NR | VBB30036.1 | 6277 | g31128 | i0 | 83 | 287.963414634146 | 53 | 9 | 97 | 0 | 2 | 160 | 21 | 73 | VBB30036.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 47226 | 90.5 | 0.991160220994475 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 30661392 | 30661392 | PRJNA532380_P_NODE_17133_length_217_cov_1.857143_g16808_i0 | PRJNA532380 | 17133 | 217 | 1.857143 | 4.03000031 | Metazoa | 33208 | Nematoda | Nematoda | 56.6 | 2.94e-7 | NR | XP_024504851.1 | 34506 | g16808 | i0 | 50 | 1.36866359447005 | 50 | 25 | 69.1 | 0 | 3 | 152 | 15 | 64 | XP_024504851.1 GDP-L-fucose synthase [Strongyloides ratti] | diamond | 297 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 30661397 | 30661397 | PRJNA532380_P_NODE_9433_length_305_cov_1.218750_g9108_i0 | PRJNA532380 | 9433 | 305 | 1.21875 | 3.7171875 | Metazoa | 33208 | Nematoda | Nematoda | 100 | 3.96e-22 | NR | KHN78058.1 | 6265 | g9108 | i0 | 52.6 | 2.85245901639344 | 97 | 45 | 94.4 | 1 | 5 | 292 | 197 | 293 | KHN78058.1 Polyadenylate-binding protein 1 [Toxocara canis] | diamond | 870 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis |
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);;