contig_metadata
21 rows where bioproject = "PRJNA950981", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2209177 | 2209177 | PRJNA950981_P_NODE_4242_length_468_cov_1.501266_g4067_i0 | PRJNA950981 | 4242 | 468 | 1.501266 | 7.02592488 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 254 | 1.16e-62 | NTclustered | gi|268580870|ref|XM_002645372.1| | 6238 | g4067 | i0 | 82.807 | 15.7029914529915 | 285 | 48 | 61 | 1 | 56 | 339 | 938 | 654 | Caenorhabditis briggsae Protein CBR-SAMS-1 (Cbr-sams-1), partial mRNA | blastn | 7349 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 11137476 | 11137476 | PRJNA950981_P_NODE_16589_length_253_cov_0.866667_g16413_i0 | PRJNA950981 | 16589 | 253 | 0.866667 | 2.19266751 | Onchocercidae | 6296 | Nematoda | Nematoda | 63.2 | 2.67e-9 | NR | XP_042933799.1 | 6279 | g16413 | i0 | 57.7 | 2.46640316205534 | 52 | 22 | 61.7 | 0 | 252 | 97 | 311 | 362 | XP_042933799.1 Calreticulin family protein [Brugia malayi] | diamond | 624 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 15290415 | 15290415 | PRJNA950981_P_NODE_6532_length_384_cov_1.694534_g6356_i0 | PRJNA950981 | 6532 | 384 | 1.694534 | 6.50701056 | Metazoa | 33208 | Nematoda | Nematoda | 158 | 2.93e-46 | NR | KAH7731741.1 | 70226 | g6356 | i0 | 59.2 | 9.0546875 | 130 | 50 | 99.2 | 2 | 383 | 3 | 16 | 145 | KAH7731741.1 Protein RAL-1 a [Aphelenchoides avenae] | diamond | 3477 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 16236710 | 16236710 | PRJNA950981_P_NODE_7813_length_356_cov_1.840989_g7637_i0 | PRJNA950981 | 7813 | 356 | 1.840989 | 6.55392084 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 183 | 1.15e-41 | NTclustered | gi|150984457|gb|EF634871.1| | 452809 | g7637 | i0 | 77.492 | 26.0056179775281 | 311 | 66 | 87 | 3 | 48 | 356 | 329 | 21 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 9258 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 17512037 | 17512037 | PRJNA950981_P_NODE_21174_length_243_cov_0.917647_g20998_i0 | PRJNA950981 | 21174 | 243 | 0.917647 | 2.22988221 | root | 1 | Root_unresolved | Root_unresolved | 130 | 6.98e-33 | NR | KAI6214930.1 | 269767 | g20998 | i0 | 81.2 | 5.55555555555556 | 69 | 13 | 85.2 | 0 | 241 | 35 | 928 | 996 | KAI6214930.1 Dihydropyrimidine dehydrogenase [NADP(+)] [Aphelenchoides besseyi] | diamond | 1350 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 17512050 | 17512050 | PRJNA950981_P_NODE_5634_length_411_cov_1.884615_g5458_i0 | PRJNA950981 | 5634 | 411 | 1.884615 | 7.74576765 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 195 | 1.47e-58 | NR | KRY41729.1 | 6334 | g5458 | i0 | 72.2 | 3.64233576642336 | 126 | 35 | 92 | 0 | 380 | 3 | 226 | 351 | KRY41729.1 60S ribosomal protein L27a [Trichinella spiralis] | diamond | 1497 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 21335941 | 21335941 | PRJNA950981_P_NODE_16337_length_254_cov_1.270718_g16161_i0 | PRJNA950981 | 16337 | 254 | 1.270718 | 3.22762372 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 166 | 1.93e-48 | NR | MCP9256899.1 | 6287 | g16161 | i0 | 88.1 | 173.610236220472 | 84 | 10 | 99.2 | 0 | 2 | 253 | 153 | 236 | MCP9256899.1 Serine/threonine-protein phosphatase [Dirofilaria immitis] | diamond | 44097 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 21335970 | 21335970 | PRJNA950981_P_NODE_6677_length_380_cov_1.599349_g6501_i0 | PRJNA950981 | 6677 | 380 | 1.599349 | 6.0775262 | Diplogastrellus gracilis | 669117 | Nematoda | Nematoda | 206 | 2.63e-48 | NTclustered | gi|256709130|gb|GQ422217.1| | 669117 | g6501 | i0 | 79.47 | 66.2263157894737 | 302 | 52 | 78 | 8 | 36 | 332 | 427 | 723 | Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 25166 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogastrellus | Diplogastrellus gracilis | |
| 21335972 | 21335972 | PRJNA950981_P_NODE_7217_length_368_cov_1.586441_g7041_i0 | PRJNA950981 | 7217 | 368 | 1.586441 | 5.83810288 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 230 | 1.4999999999999999e-55 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g7041 | i0 | 80.323 | 5.33423913043478 | 310 | 55 | 83 | 6 | 62 | 368 | 37 | 343 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 1963 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 26683814 | 26683814 | PRJNA950981_P_NODE_12741_length_288_cov_1.451163_g12565_i0 | PRJNA950981 | 12741 | 288 | 1.451163 | 4.17934944 | Rhabditida | 6236 | Nematoda | Nematoda | 127 | 2.13e-34 | NR | KAE9420971.1 | 6313 | g12565 | i0 | 67 | 11.4270833333333 | 91 | 30 | 94.8 | 0 | 287 | 15 | 93 | 183 | KAE9420971.1 hypothetical protein Angca_002129 [Angiostrongylus cantonensis] | diamond | 3291 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 26962115 | 26962115 | PRJNA950981_P_NODE_22102_length_228_cov_2.012903_g21926_i0 | PRJNA950981 | 22102 | 228 | 2.012903 | 4.5894188400000004 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 58.5 | 3.32e-8 | NR | CAI4222289.1 | 2878363 | g21926 | i0 | 51.7 | 0.763157894736842 | 58 | 25 | 75 | 2 | 210 | 40 | 1 | 56 | CAI4222289.1 unnamed protein product [Auanema sp. JU1783] | diamond | 174 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 27373526 | 27373526 | PRJNA950981_P_NODE_15543_length_261_cov_1.404255_g15367_i0 | PRJNA950981 | 15543 | 261 | 1.404255 | 3.66510555 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 61.2 | 1.4e-8 | NR | KAE9547480.1 | 2598192 | g15367 | i0 | 40.3 | 0.827586206896552 | 72 | 42 | 82.8 | 1 | 251 | 36 | 555 | 625 | KAE9547480.1 hypothetical protein FO519_009307, partial [Halicephalobus sp. NKZ332] | diamond | 216 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 27594396 | 27594396 | PRJNA950981_P_NODE_5444_length_417_cov_3.098837_g5268_i0 | PRJNA950981 | 5444 | 417 | 3.098837 | 12.92215029 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 92.8 | 3.36e-21 | NR | GMT18625.1 | 1538716 | g5268 | i0 | 42 | 0.942446043165468 | 131 | 70 | 93.5 | 3 | 416 | 27 | 1 | 126 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 393 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 27664183 | 27664183 | PRJNA950981_P_NODE_20124_length_245_cov_0.906977_g19948_i0 | PRJNA950981 | 20124 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92 | 6.95e-20 | NR | OUC46811.1 | 6335 | g19948 | i0 | 56.4 | 14.265306122449 | 78 | 32 | 93.1 | 1 | 12 | 239 | 200 | 277 | OUC46811.1 kinase domain protein, partial [Trichinella nativa] | diamond | 3495 | 92.8 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa | |
| 27822064 | 27822064 | PRJNA950981_P_NODE_16624_length_253_cov_0.866667_g16448_i0 | PRJNA950981 | 16624 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 109 | 1.32e-26 | NR | XP_045091399.1 | 6238 | g16448 | i0 | 57.8 | 43.3280632411067 | 83 | 35 | 98.4 | 0 | 251 | 3 | 216 | 298 | XP_045091399.1 Protein CBR-GOA-1 [Caenorhabditis briggsae] | diamond | 10962 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 28351990 | 28351990 | PRJNA950981_P_NODE_10026_length_321_cov_1.258065_g9850_i0 | PRJNA950981 | 10026 | 321 | 1.258065 | 4.03838865 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 59.7 | 1.07e-7 | NR | KAI1705971.1 | 166010 | g9850 | i0 | 35.3 | 3.90654205607477 | 85 | 50 | 79.4 | 1 | 297 | 43 | 377 | 456 | KAI1705971.1 enoyl-(Acyl carrier protein) reductase domain-containing protein [Ditylenchus destructor] | diamond | 1254 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 29267476 | 29267476 | PRJNA950981_P_NODE_21189_length_243_cov_0.917647_g21013_i0 | PRJNA950981 | 21189 | 243 | 0.917647 | 2.22988221 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 43.5 | 0.0171 | NR | KAI6196838.1 | 269767 | g21013 | i0 | 32.4 | 2.80246913580247 | 71 | 46 | 87.7 | 1 | 16 | 228 | 66 | 134 | KAI6196838.1 hypothetical protein M3Y94_01155900 [Aphelenchoides besseyi] | diamond | 681 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 30657429 | 30657429 | PRJNA950981_P_NODE_12393_length_292_cov_1.242009_g12217_i0 | PRJNA950981 | 12393 | 292 | 1.242009 | 3.62666628 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 118 | 2.1e-28 | NR | EFP01601.1 | 31234 | g12217 | i0 | 79.1 | 8.26027397260274 | 67 | 14 | 68.8 | 0 | 291 | 91 | 694 | 760 | EFP01601.1 hypothetical protein CRE_03500 [Caenorhabditis remanei] | diamond | 2412 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 31131143 | 31131143 | PRJNA950981_P_NODE_20735_length_244_cov_0.912281_g20559_i0 | PRJNA950981 | 20735 | 244 | 0.912281 | 2.22596564 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 83.6 | 1.62e-16 | NR | KAI6215006.1 | 269767 | g20559 | i0 | 48.7 | 4.77049180327869 | 76 | 36 | 93.4 | 1 | 237 | 10 | 71 | 143 | KAI6215006.1 Phospholipid-transporting ATPase [Aphelenchoides besseyi] | diamond | 1164 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 31200744 | 31200744 | PRJNA950981_P_NODE_16475_length_253_cov_0.866667_g16299_i0 | PRJNA950981 | 16475 | 253 | 0.866667 | 2.19266751 | Rhabditida | 6236 | Nematoda | Nematoda | 68.6 | 3.5e-11 | NR | KAE9421197.1 | 6313 | g16299 | i0 | 49.2 | 1.49407114624506 | 63 | 30 | 74.7 | 1 | 189 | 1 | 871 | 931 | KAE9421197.1 hypothetical protein Angca_004087, partial [Angiostrongylus cantonensis] | diamond | 378 | 68.9 | 0.995645863570392 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 31447638 | 31447638 | PRJNA950981_P_NODE_17176_length_252_cov_0.871508_g17000_i0 | PRJNA950981 | 17176 | 252 | 0.871508 | 2.19620016 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 57.8 | 2.01e-7 | NR | KAH7712903.1 | 70226 | g17000 | i0 | 42.3 | 0.845238095238095 | 71 | 39 | 82.1 | 1 | 211 | 5 | 161 | 231 | KAH7712903.1 Protein F09A5.2 [Aphelenchoides avenae] | diamond | 213 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae |
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);;