contig_metadata
13 rows where bioproject = "PRJNA763243", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12223019 | 12223019 | PRJNA763243_P_NODE_43170_length_269_cov_2.193878_g42824_i0 | PRJNA763243 | 43170 | 269 | 2.193878 | 5.90153182 | Plectus minimus | 446301 | Nematoda | Nematoda | 457 | 4.4699999999999985e-124 | NTclustered | gi|148614851|gb|EF417148.1| | 446301 | g42824 | i0 | 97.736 | 97.8252788104089 | 265 | 6 | 99 | 0 | 3 | 267 | 280 | 16 | Plectus minimus large subunit ribosomal RNA gene, partial sequence | blastn | 26315 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Plectida | Plectidae | Plectus | Plectus minimus | |
| 13497653 | 13497653 | PRJNA763243_P_NODE_66431_length_233_cov_5.900000_g66085_i0 | PRJNA763243 | 66431 | 233 | 5.9 | 13.747 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 101 | 2.44e-25 | NR | KAE9553166.1 | 2598192 | g66085 | i0 | 63.2 | 0.978540772532189 | 76 | 28 | 97.9 | 0 | 228 | 1 | 40 | 115 | KAE9553166.1 hypothetical protein FO519_003605 [Halicephalobus sp. NKZ332] | diamond | 228 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 23697020 | 23697020 | PRJNA763243_P_NODE_7379_length_536_cov_2.531317_g7039_i0 | PRJNA763243 | 7379 | 536 | 2.531317 | 13.56785912 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 197 | 2.36e-60 | NR | XP_064070308.1 | 51031 | g7039 | i0 | 60.5 | 21.3470149253731 | 172 | 68 | 96.3 | 0 | 531 | 16 | 35 | 206 | XP_064070308.1 hypothetical protein RB195_026050 [Necator americanus] | diamond | 11442 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 24970759 | 24970759 | PRJNA763243_P_NODE_9060_length_493_cov_8.440476_g8718_i0 | PRJNA763243 | 9060 | 493 | 8.440476 | 41.61154668 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 385 | 4.18e-102 | NTclustered | gi|2445353178|ref|XM_003097296.2| | 31234 | g8718 | i0 | 85.912 | 75.6754563894523 | 362 | 49 | 73 | 2 | 121 | 481 | 1307 | 947 | Caenorhabditis remanei uncharacterized protein (GCK72_003433), partial mRNA | blastn | 37308 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 27410734 | 27410734 | PRJNA763243_P_NODE_60563_length_243_cov_2.552941_g60217_i0 | PRJNA763243 | 60563 | 243 | 2.552941 | 6.20364663 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 5.7899999999999995e-30 | NR | KAL1245660.1 | 6334 | g60217 | i0 | 61.5 | 9.62962962962963 | 78 | 30 | 96.3 | 0 | 239 | 6 | 7 | 84 | KAL1245660.1 U6 snRNA-associated Sm-like protein [Trichinella spiralis] | diamond | 2340 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 28316526 | 28316526 | PRJNA763243_P_NODE_43346_length_269_cov_1.168367_g43000_i0 | PRJNA763243 | 43346 | 269 | 1.168367 | 3.14290723 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 57.4 | 3.1e-7 | NR | KAL3073343.1 | 157864 | g43000 | i0 | 51.7 | 0.646840148698885 | 58 | 28 | 64.7 | 0 | 268 | 95 | 209 | 266 | KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii] | diamond | 174 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 28515641 | 28515641 | PRJNA763243_P_NODE_33267_length_296_cov_1.739910_g32921_i0 | PRJNA763243 | 33267 | 296 | 1.73991 | 5.1501336 | Rhabditida | 6236 | Nematoda | Nematoda | 43.9 | 0.0205 | NR | TKR81205.1 | 34508 | g32921 | i0 | 56.8 | 1.85472972972973 | 37 | 15 | 36.5 | 1 | 293 | 186 | 172 | 208 | TKR81205.1 hypothetical protein L596_015117 [Steinernema carpocapsae] | diamond | 549 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 28663877 | 28663877 | PRJNA763243_P_NODE_59567_length_244_cov_1.368421_g59221_i0 | PRJNA763243 | 59567 | 244 | 1.368421 | 3.33894724 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 48.9 | 1.83e-4 | NR | KAI1722980.1 | 166010 | g59221 | i0 | 47.2 | 2.55737704918033 | 53 | 23 | 61.5 | 2 | 88 | 237 | 163 | 213 | KAI1722980.1 lectin c-type domain-containing protein [Ditylenchus destructor] | diamond | 624 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 29800355 | 29800355 | PRJNA763243_P_NODE_37331_length_284_cov_1.180095_g36985_i0 | PRJNA763243 | 37331 | 284 | 1.180095 | 3.3514698 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 52.4 | 2.47e-5 | NR | CAD5210860.1 | 465554 | g36985 | i0 | 35.6 | 3.47535211267606 | 59 | 32 | 56 | 2 | 112 | 270 | 124 | 182 | CAD5210860.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 987 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 30147711 | 30147711 | PRJNA763243_P_NODE_56692_length_247_cov_0.879310_g56346_i0 | PRJNA763243 | 56692 | 247 | 0.87931 | 2.1718957 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 46.2 | 6.87e-4 | NR | GMT18625.1 | 1538716 | g56346 | i0 | 34.9 | 1.0080971659919 | 83 | 48 | 99.6 | 2 | 2 | 247 | 9 | 86 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 249 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30874637 | 30874637 | PRJNA763243_P_NODE_59274_length_244_cov_3.064327_g58928_i0 | PRJNA763243 | 59274 | 244 | 3.064327 | 7.47695788 | Trichostrongylus colubriformis | 6319 | Nematoda | Nematoda | 55.1 | 3.66e-7 | NR | KAK5965779.1 | 6319 | g58928 | i0 | 54.8 | 5.63114754098361 | 42 | 19 | 51.6 | 0 | 242 | 117 | 87 | 128 | KAK5965779.1 Anticodon binding domain protein [Trichostrongylus colubriformis] | diamond | 1374 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus colubriformis | |
| 31507088 | 31507088 | PRJNA763243_P_NODE_24436_length_326_cov_4.521739_g24090_i0 | PRJNA763243 | 24436 | 326 | 4.521739 | 14.74086914 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 47.8 | 0.00148 | NR | CAD5226631.1 | 6326 | g24090 | i0 | 50.9 | 2.43865030674847 | 53 | 23 | 48.8 | 2 | 128 | 286 | 18 | 67 | CAD5226631.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 795 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 32244487 | 32244487 | PRJNA763243_P_NODE_61658_length_242_cov_5.568047_g61312_i0 | PRJNA763243 | 61658 | 242 | 5.568047 | 13.47467374 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 0.00208 | NR | KAK0427080.1 | 289476 | g61312 | i0 | 40 | 2.20661157024793 | 65 | 38 | 79.3 | 1 | 200 | 9 | 1 | 65 | KAK0427080.1 hypothetical protein QR680_010051 [Steinernema hermaphroditum] | diamond | 534 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum |
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);;