contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA741997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1997416 | 1997416 | PRJNA741997_P_NODE_30722_length_394_cov_5.003115_g29602_i0 | PRJNA741997 | 30722 | 394 | 5.003115 | 19.7122731 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 254 | 9.63e-63 | NTclustered | gi|687022713|emb|LM525627.1| | 174720 | g29602 | i0 | 78.811 | 89.2335025380711 | 387 | 74 | 97 | 5 | 7 | 389 | 62408 | 62790 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000036 | blastn | 35158 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 1997635 | 1997635 | PRJNA741997_P_NODE_67582_length_260_cov_1.647059_g66462_i0 | PRJNA741997 | 67582 | 260 | 1.647059 | 4.2823534 | Trichostrongylus vitrinus | 40352 | Nematoda | Nematoda | 193 | 1.34e-44 | NTclustered | gi|71057506|emb|AM050349.1| | 40352 | g66462 | i0 | 84.817 | 3.50384615384615 | 191 | 29 | 73 | 0 | 1 | 191 | 55 | 245 | Trichostrongylus vitrinus partial ORF for putative ATP synthase | blastn | 911 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus vitrinus | |
| 4549910 | 4549910 | PRJNA741997_P_NODE_30564_length_396_cov_0.953560_g29444_i0 | PRJNA741997 | 30564 | 396 | 0.95356 | 3.7760976 | Necator americanus | 51031 | Nematoda | Nematoda | 58.4 | 8.15e-4 | NTclustered | gi|2707617768|ref|XM_064212650.1| | 51031 | g29444 | i0 | 100 | 0.234848484848485 | 31 | 0 | 8 | 0 | 162 | 192 | 2940 | 2970 | Necator americanus uncharacterized protein (RB195_024762), partial mRNA | blastn | 93 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 5824969 | 5824969 | PRJNA741997_P_NODE_25905_length_436_cov_15.911846_g24785_i0 | PRJNA741997 | 25905 | 436 | 15.911846 | 69.37564856 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 298 | 4.9e-76 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g24785 | i0 | 81.768 | 5.1743119266055 | 362 | 60 | 82 | 6 | 70 | 428 | 37 | 395 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2256 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 7099990 | 7099990 | PRJNA741997_P_NODE_14506_length_633_cov_1.848214_g13414_i0 | PRJNA741997 | 14506 | 633 | 1.848214 | 11.69919462 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 377 | 9.13e-100 | NTclustered | gi|1376147859|ref|XM_024654603.1| | 34506 | g13414 | i0 | 86.765 | 162.668246445498 | 340 | 43 | 54 | 2 | 293 | 631 | 675 | 337 | Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA | blastn | 102969 | 377 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 7100335 | 7100335 | PRJNA741997_P_NODE_72666_length_251_cov_0.865169_g71546_i0 | PRJNA741997 | 72666 | 251 | 0.865169 | 2.17157419 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 169 | 2.1599999999999996e-37 | NTclustered | gi|308452822|ref|XM_003089146.1| | 31234 | g71546 | i0 | 85.714 | 17.0239043824701 | 161 | 21 | 64 | 2 | 91 | 250 | 95 | 254 | Caenorhabditis remanei uncharacterized protein (GCK72_014297), partial mRNA | blastn | 4273 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 8375047 | 8375047 | PRJNA741997_P_NODE_86047_length_243_cov_0.905882_g84927_i0 | PRJNA741997 | 86047 | 243 | 0.905882 | 2.20129326 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 161 | 3.4899999999999997e-35 | NTclustered | gi|687022666|emb|LM525580.1| | 174720 | g84927 | i0 | 78.862 | 32.238683127572 | 246 | 46 | 100 | 6 | 1 | 243 | 237400 | 237158 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000007 | blastn | 7834 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 9649927 | 9649927 | PRJNA741997_P_NODE_42168_length_334_cov_2.655172_g41048_i0 | PRJNA741997 | 42168 | 334 | 2.655172 | 8.86827448 | Pristionchus maupasi | 335527 | Nematoda | Nematoda | 174 | 6.44e-39 | NTclustered | gi|150981849|gb|EF634494.1| | 335527 | g41048 | i0 | 78.082 | 35.7125748502994 | 292 | 52 | 86 | 12 | 46 | 331 | 41 | 326 | Pristionchus maupasi large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds | blastn | 11928 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus maupasi | |
| 14750540 | 14750540 | PRJNA741997_P_NODE_67012_length_261_cov_3.792553_g65892_i0 | PRJNA741997 | 67012 | 261 | 3.792553 | 9.89856333 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 97.1 | 1.08e-15 | NTclustered | gi|268531145|ref|XM_002630653.1| | 6238 | g65892 | i0 | 87.805 | 2.33716475095785 | 82 | 10 | 31 | 0 | 172 | 253 | 86 | 167 | Caenorhabditis briggsae Protein CBR-PRDX-2 (Cbr-prdx-2), partial mRNA | blastn | 610 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 16023942 | 16023942 | PRJNA741997_P_NODE_26653_length_428_cov_9.371831_g25533_i0 | PRJNA741997 | 26653 | 428 | 9.371831 | 40.11143668 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 167 | 1.4100000000000001e-36 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g25533 | i0 | 81.166 | 31.1635514018692 | 223 | 28 | 50 | 11 | 76 | 291 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 13338 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 16024024 | 16024024 | PRJNA741997_P_NODE_39453_length_345_cov_2.386029_g38333_i0 | PRJNA741997 | 39453 | 345 | 2.386029 | 8.23180005 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 206 | 2.3699999999999998e-48 | NTclustered | gi|1376144539|ref|XM_024652732.1| | 34506 | g38333 | i0 | 80.364 | 20.1014492753623 | 275 | 50 | 79 | 4 | 73 | 345 | 81 | 353 | Strongyloides ratti 40S ribosomal protein S14 (SRAE_2000174400), partial mRNA | blastn | 6935 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 17775929 | 17775929 | PRJNA741997_P_NODE_80634_length_246_cov_0.890173_g79514_i0 | PRJNA741997 | 80634 | 246 | 0.890173 | 2.18982558 | Rhabditida | 6236 | Nematoda | Nematoda | 250 | 7.34e-62 | NTclustered | gi|38491404|gb|AY372758.1| | 27828 | g79514 | i0 | 84.959 | 96.4390243902439 | 246 | 37 | 100 | 0 | 1 | 246 | 41 | 286 | Cooperia oncophora actin mRNA, complete cds | blastn | 23724 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 21124176 | 21124176 | PRJNA741997_P_NODE_68737_length_258_cov_0.989189_g67617_i0 | PRJNA741997 | 68737 | 258 | 0.989189 | 2.55210762 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 93.5 | 1.38e-14 | NTclustered | gi|2445365113|ref|XM_003113331.2| | 31234 | g67617 | i0 | 78.986 | 22.0542635658915 | 138 | 27 | 53 | 2 | 4 | 140 | 581 | 445 | Caenorhabditis remanei uncharacterized protein (GCK72_009749), partial mRNA | blastn | 5690 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 23674397 | 23674397 | PRJNA741997_P_NODE_26419_length_431_cov_1.357542_g25299_i0 | PRJNA741997 | 26419 | 431 | 1.357542 | 5.85100602 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 372 | 2.8099999999999995e-98 | NTclustered | gi|687022644|emb|LM525558.1| | 174720 | g25299 | i0 | 82.857 | 55.8607888631091 | 420 | 66 | 97 | 6 | 7 | 423 | 232302 | 232718 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004 | blastn | 24076 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 23674464 | 23674464 | PRJNA741997_P_NODE_35039_length_367_cov_1.323129_g33919_i0 | PRJNA741997 | 35039 | 367 | 1.323129 | 4.8558834299999996 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 254 | 8.9e-63 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g33919 | i0 | 82.414 | 59.4359673024523 | 290 | 51 | 79 | 0 | 78 | 367 | 58 | 347 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 21813 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 23674586 | 23674586 | PRJNA741997_P_NODE_61019_length_275_cov_2.569307_g59899_i0 | PRJNA741997 | 61019 | 275 | 2.569307 | 7.06559425 | Tylopharynx sp. WEM-2009 | 669147 | Nematoda | Nematoda | 278 | 3.83e-70 | NTclustered | gi|256709136|gb|GQ422220.1| | 669147 | g59899 | i0 | 86.853 | 10.2 | 251 | 29 | 91 | 4 | 3 | 251 | 499 | 747 | Tylopharynx sp. WEM-2009 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 2805 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Tylopharyngidae | Tylopharynx | Tylopharynx sp. WEM-2009 | |
| 24149756 | 24149756 | PRJNA741997_P_NODE_41159_length_338_cov_2.784906_g40039_i0 | PRJNA741997 | 41159 | 338 | 2.784906 | 9.41298228 | Opisthokonta | 33154 | Nematoda | Nematoda | 217 | 1.07e-51 | NTclustered | gi|687022644|emb|LM525558.1| | 174720 | g40039 | i0 | 86.979 | 100.041420118343 | 192 | 25 | 57 | 0 | 147 | 338 | 390720 | 390529 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000004 | blastn | 33814 | 219 | 0.990867579908676 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;