contig_metadata
15 rows where bioproject = "PRJNA384462", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2956016 | 2956016 | PRJNA384462_S_NODE_363_length_771_cov_8.019391_g290_i0 | PRJNA384462 | 363 | 771 | 8.019391 | 61.82950461 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 305 | 3.34e-93 | NR | MCP9264969.1 | 6287 | g290 | i0 | 69.9 | 10.4902723735409 | 206 | 62 | 80.2 | 0 | 13 | 630 | 801 | 1006 | MCP9264969.1 60S ribosomal protein L10 [Dirofilaria immitis] | diamond | 8088 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 5509043 | 5509043 | PRJNA384462_S_NODE_6185_length_220_cov_1.479532_g6069_i0 | PRJNA384462 | 6185 | 220 | 1.479532 | 3.2549704 | Pristionchus microcercus | 3308705 | Nematoda | Nematoda | 137 | 5.23e-28 | NTclustered | gi|675118993|gb|KJ877376.1| | 3308705 | g6069 | i0 | 80.328 | 19.0590909090909 | 183 | 34 | 83 | 2 | 38 | 219 | 416 | 235 | Paroigolaimella micrura large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 4193 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus microcercus | |
| 8058632 | 8058632 | PRJNA384462_S_NODE_5407_length_232_cov_2.491803_g5291_i0 | PRJNA384462 | 5407 | 232 | 2.491803 | 5.78098296 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 243 | 1.1500000000000001e-59 | NTclustered | gi|687022644|emb|LM525558.1| | 174720 | g5291 | i0 | 86.818 | 64.6336206896552 | 220 | 25 | 94 | 4 | 15 | 232 | 232637 | 232420 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004 | blastn | 14995 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 10609129 | 10609129 | PRJNA384462_S_NODE_3929_length_266_cov_2.714286_g3813_i0 | PRJNA384462 | 3929 | 266 | 2.714286 | 7.22000076 | Auanema freiburgensis | 1963013 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|1527173533|gb|MH124555.1| | 1963013 | g3813 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 28 | 55 | 12755 | 12728 | Auanema freiburgensis strain APS7 UNC-22 (unc-22) mRNA, partial cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema freiburgensis | |
| 11884003 | 11884003 | PRJNA384462_S_NODE_2690_length_316_cov_7.063670_g2574_i0 | PRJNA384462 | 2690 | 316 | 7.06367 | 22.3211972 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 62.8 | 7.85e-9 | NR | CAD2164178.1 | 390850 | g2574 | i0 | 40.4 | 3.66455696202532 | 94 | 52 | 85.4 | 2 | 292 | 23 | 4 | 97 | CAD2164178.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 1158 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 20806914 | 20806914 | PRJNA384462_S_NODE_15257_length_161_cov_1.357143_g15141_i0 | PRJNA384462 | 15257 | 161 | 1.357143 | 2.18500023 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|690018538|emb|LM525776.1| | 174720 | g15141 | i0 | 82.54 | 0.565217391304348 | 63 | 11 | 39 | 0 | 99 | 161 | 56383 | 56445 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000163 | blastn | 91 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22081762 | 22081762 | PRJNA384462_S_NODE_1438_length_435_cov_2.090674_g1322_i0 | PRJNA384462 | 1438 | 435 | 2.090674 | 9.0944319 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 164 | 8.969999999999999e-47 | NR | KRY31199.1 | 6334 | g1322 | i0 | 73.1 | 201.731034482759 | 119 | 31 | 82.1 | 1 | 3 | 359 | 196 | 313 | KRY31199.1 histone H3 [Trichinella spiralis] | diamond | 87753 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 22081800 | 22081800 | PRJNA384462_S_NODE_978_length_521_cov_2.368644_g864_i0 | PRJNA384462 | 978 | 521 | 2.368644 | 12.34063524 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 54.7 | 0.014 | NTclustered | gi|339237868|ref|XM_003380441.1| | 6334 | g864 | i0 | 94.444 | 0.0690978886756238 | 36 | 0 | 7 | 2 | 175 | 209 | 1195 | 1161 | Trichinella spiralis conserved hypothetical protein (Tsp_06171) mRNA, complete cds | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 23357408 | 23357408 | PRJNA384462_S_NODE_7279_length_207_cov_1.455696_g7163_i0 | PRJNA384462 | 7279 | 207 | 1.455696 | 3.01329072 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 104 | 4.93e-18 | NTclustered | gi|2445365113|ref|XM_003113331.2| | 31234 | g7163 | i0 | 79.221 | 27.8164251207729 | 154 | 29 | 73 | 3 | 45 | 196 | 597 | 445 | Caenorhabditis remanei uncharacterized protein (GCK72_009749), partial mRNA | blastn | 5758 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 26870916 | 26870916 | PRJNA384462_S_NODE_3901_length_267_cov_1.844037_g3785_i0 | PRJNA384462 | 3901 | 267 | 1.844037 | 4.92357879 | Rhabditida | 6236 | Nematoda | Nematoda | 71.6 | 1.59e-12 | NR | KAK6060278.1 | 27828 | g3785 | i0 | 67.9 | 2.51685393258427 | 53 | 16 | 59.6 | 1 | 39 | 197 | 1 | 52 | KAK6060278.1 ribosomal L29e protein [Cooperia oncophora] | diamond | 672 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 26933861 | 26933861 | PRJNA384462_S_NODE_1502_length_425_cov_3.034574_g1386_i0 | PRJNA384462 | 1502 | 425 | 3.034574 | 12.8969395 | Trichostrongylidae | 6315 | Nematoda | Nematoda | 64.3 | 3.76e-9 | NR | KAK6022555.1 | 6317 | g1386 | i0 | 69.6 | 1.29176470588235 | 46 | 13 | 32.5 | 1 | 425 | 288 | 179 | 223 | KAK6022555.1 V-type ATPase, D subunit [Ostertagia ostertagi] | diamond | 549 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 27359823 | 27359823 | PRJNA384462_S_NODE_2303_length_343_cov_3.629252_g2187_i0 | PRJNA384462 | 2303 | 343 | 3.629252 | 12.44833436 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 86.3 | 5.84e-17 | NR | CAJ0584621.1 | 96644 | g2187 | i0 | 67.9 | 1.4868804664723 | 53 | 17 | 46.4 | 0 | 7 | 165 | 414 | 466 | CAJ0584621.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 510 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 28923547 | 28923547 | PRJNA384462_S_NODE_9928_length_184_cov_1.133333_g9812_i0 | PRJNA384462 | 9928 | 184 | 1.133333 | 2.08533272 | Heterodera | 34509 | Nematoda | Nematoda | 53.9 | 1.86e-6 | NR | KAL3068977.1 | 97005 | g9812 | i0 | 46.7 | 5.65760869565217 | 60 | 30 | 94.6 | 1 | 176 | 3 | 466 | 525 | KAL3068977.1 hypothetical protein niasHS_015692 [Heterodera schachtii] | diamond | 1041 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera schachtii | |
| 32383070 | 32383070 | PRJNA384462_S_NODE_15699_length_159_cov_2.290909_g15583_i0 | PRJNA384462 | 15699 | 159 | 2.290909 | 3.64254531 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 67.8 | 1.42e-11 | NR | KAI6215557.1 | 269767 | g15583 | i0 | 56.3 | 1.81132075471698 | 48 | 21 | 90.6 | 0 | 2 | 145 | 291 | 338 | KAI6215557.1 Fructose-bisphosphatase [Aphelenchoides besseyi] | diamond | 288 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 32730411 | 32730411 | PRJNA384462_S_NODE_10860_length_178_cov_1.550388_g10744_i0 | PRJNA384462 | 10860 | 178 | 1.550388 | 2.75969064 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 45.1 | 0.00162 | NR | GMT09317.1 | 1538716 | g10744 | i0 | 53.1 | 0.539325842696629 | 32 | 15 | 53.9 | 0 | 26 | 121 | 117 | 148 | GMT09317.1 hypothetical protein PFISCL1PPCAC_614, partial [Pristionchus fissidentatus] | diamond | 96 | 45.1 | 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);;