contig_metadata
12 rows where bioproject = "PRJEB2925", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26044 | 26044 | PRJEB2925_P_NODE_13661_length_280_cov_7.204082_g12383_i0 | PRJEB2925 | 13661 | 280 | 7.204082 | 20.1714296 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 101 | 4.82e-26 | NR | CAD2132787.1 | 390850 | g12383 | i0 | 82.1 | 1.22142857142857 | 56 | 10 | 60 | 0 | 234 | 67 | 1 | 56 | CAD2132787.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 342 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 3852335 | 3852335 | PRJEB2925_P_NODE_9524_length_382_cov_2.775216_g8254_i0 | PRJEB2925 | 9524 | 382 | 2.775216 | 10.60132512 | Rhabditoides inermis | 96661 | Nematoda | Nematoda | 172 | 2.68e-38 | NTclustered | gi|256709257|gb|GQ422281.1| | 96661 | g8254 | i0 | 80.519 | 5.30628272251309 | 231 | 39 | 60 | 6 | 138 | 365 | 57 | 284 | Rhabditoides inermis small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 2027 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditoides | Rhabditoides inermis | |
| 6404362 | 6404362 | PRJEB2925_P_NODE_6646_length_502_cov_2.734475_g5501_i0 | PRJEB2925 | 6646 | 502 | 2.734475 | 13.7270645 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 182 | 6e-41 | NTclustered | gi|1972261274|ref|NM_001384026.2| | 6239 | g5501 | i0 | 80.591 | 17.0099601593625 | 237 | 44 | 47 | 2 | 212 | 447 | 138 | 373 | Caenorhabditis elegans ATP synthase c subunit (Y82E9BR.3), mRNA | blastn | 8539 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10228856 | 10228856 | PRJEB2925_P_NODE_14009_length_275_cov_1.562500_g12731_i0 | PRJEB2925 | 14009 | 275 | 1.5625 | 4.296875 | Metazoa | 33208 | Nematoda | Nematoda | 163 | 6.28e-49 | NR | NP_496384.1 | 6239 | g12731 | i0 | 86.8 | 70.4509090909091 | 91 | 12 | 99.3 | 0 | 273 | 1 | 40 | 130 | NP_496384.1 Small ribosomal subunit protein uS4 [Caenorhabditis elegans] | diamond | 19374 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10228877 | 10228877 | PRJEB2925_P_NODE_15909_length_249_cov_1.953271_g14631_i0 | PRJEB2925 | 15909 | 249 | 1.953271 | 4.86364479 | Opisthokonta | 33154 | Nematoda | Nematoda | 89 | 4.82e-20 | NR | ULU06033.1 | 6238 | g14631 | i0 | 89.6 | 21.9759036144578 | 48 | 5 | 57.8 | 0 | 144 | 1 | 61 | 108 | ULU06033.1 hypothetical protein L3Y34_018141 [Caenorhabditis briggsae] | diamond | 5472 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 20426757 | 20426757 | PRJEB2925_P_NODE_11777_length_318_cov_2.844523_g10502_i0 | PRJEB2925 | 11777 | 318 | 2.844523 | 9.04558314 | root | 1 | Root_unresolved | Root_unresolved | 176 | 6.539999999999999e-54 | NR | KAF8364219.1 | 54126 | g10502 | i0 | 80 | 37.6415094339623 | 105 | 21 | 99.1 | 0 | 317 | 3 | 9 | 113 | KAF8364219.1 cyn-7, partial [Pristionchus pacificus] | diamond | 11970 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 20426833 | 20426833 | PRJEB2925_P_NODE_4017_length_700_cov_2.978947_g3124_i0 | PRJEB2925 | 4017 | 700 | 2.978947 | 20.852629 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 310 | 2.2399999999999994e-104 | NR | XP_003139952.1 | 7209 | g3124 | i0 | 70.5 | 34.6585714285714 | 207 | 61 | 88.7 | 0 | 19 | 639 | 1 | 207 | XP_003139952.1 50S ribosomal protein L16 [Loa loa] | diamond | 24261 | 312 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 26900271 | 26900271 | PRJEB2925_P_NODE_5761_length_553_cov_1.955598_g4693_i0 | PRJEB2925 | 5761 | 553 | 1.955598 | 10.81445694 | Metazoa | 33208 | Nematoda | Nematoda | 100 | 1.43e-21 | NR | KAH7717885.1 | 70226 | g4693 | i0 | 41.4 | 2.3869801084991 | 133 | 72 | 68.9 | 1 | 107 | 487 | 128 | 260 | KAH7717885.1 cathepsin L-like protein [Aphelenchoides avenae] | diamond | 1320 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 30918098 | 30918098 | PRJEB2925_P_NODE_9234_length_392_cov_2.218487_g7966_i0 | PRJEB2925 | 9234 | 392 | 2.218487 | 8.69646904 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 162 | 5.96e-45 | NR | CAJ0582755.1 | 96644 | g7966 | i0 | 56.7 | 2.91581632653061 | 127 | 54 | 97.2 | 1 | 2 | 382 | 327 | 452 | CAJ0582755.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 1143 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 31448896 | 31448896 | PRJEB2925_P_NODE_11036_length_336_cov_3.584718_g9762_i0 | PRJEB2925 | 11036 | 336 | 3.584718 | 12.04465248 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.6 | 2.56e-15 | NR | KAL1246409.1 | 6334 | g9762 | i0 | 51.3 | 7.26785714285714 | 80 | 39 | 71.4 | 0 | 85 | 324 | 30 | 109 | KAL1246409.1 E3 UFM1-protein ligase [Trichinella spiralis] | diamond | 2442 | 82 | 0.995121951219512 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 31866353 | 31866353 | PRJEB2925_P_NODE_7897_length_444_cov_3.520782_g6685_i0 | PRJEB2925 | 7897 | 444 | 3.520782 | 15.63227208 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 88.6 | 2.12e-19 | NR | GMT18625.1 | 1538716 | g6685 | i0 | 40.5 | 1.75675675675676 | 131 | 71 | 87.8 | 3 | 444 | 55 | 2 | 126 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 780 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 32656743 | 32656743 | PRJEB2925_P_NODE_10500_length_351_cov_6.879747_g9228_i0 | PRJEB2925 | 10500 | 351 | 6.879747 | 24.14791197 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 128 | 7.67e-36 | NR | GMT14341.1 | 1538716 | g9228 | i0 | 65.6 | 1.58119658119658 | 93 | 31 | 79.5 | 1 | 325 | 47 | 7 | 98 | GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus] | diamond | 555 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus |
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);;