contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4701489 | 4701489 | PRJNA896758_P_NODE_8424_length_391_cov_1.261006_g8034_i0 | PRJNA896758 | 8424 | 391 | 1.261006 | 4.93053346 | Necator americanus | 51031 | Nematoda | Nematoda | 56.5 | 0.003 | NTclustered | gi|2707568959|ref|XM_064195980.1| | 51031 | g8034 | i0 | 100 | 0.434782608695652 | 30 | 0 | 8 | 0 | 168 | 197 | 872 | 901 | Necator americanus uncharacterized protein (RB195_009134), partial mRNA | blastn | 170 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 5976216 | 5976216 | PRJNA896758_P_NODE_6865_length_432_cov_3.891365_g6475_i0 | PRJNA896758 | 6865 | 432 | 3.891365 | 16.8106968 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 176 | 2.37e-39 | NTclustered | gi|2445378119|ref|XM_003100380.2| | 31234 | g6475 | i0 | 86.709 | 25.3935185185185 | 158 | 21 | 37 | 0 | 207 | 364 | 194 | 37 | Caenorhabditis remanei uncharacterized protein (GCK72_016568), partial mRNA | blastn | 10970 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 13626697 | 13626697 | PRJNA896758_P_NODE_8031_length_400_cov_11.070336_g7641_i0 | PRJNA896758 | 8031 | 400 | 11.070336 | 44.281344 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 56.5 | 0.003 | NTclustered | gi|1376142617|ref|XM_024651632.1| | 34506 | g7641 | i0 | 100 | 0.26 | 30 | 0 | 8 | 0 | 254 | 283 | 1491 | 1462 | Strongyloides ratti MIP20649p (SRAE_2000076000), partial mRNA | blastn | 104 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 17450997 | 17450997 | PRJNA896758_P_NODE_14634_length_299_cov_2.561947_g14244_i0 | PRJNA896758 | 14634 | 299 | 2.561947 | 7.66022153 | Necator americanus | 51031 | Nematoda | Nematoda | 148 | 3.4499999999999998e-31 | NTclustered | gi|2707568045|ref|XM_064195547.1| | 51031 | g14244 | i0 | 82.738 | 5.49498327759197 | 168 | 27 | 56 | 2 | 131 | 297 | 407 | 241 | Necator americanus uncharacterized protein (RB195_008849), partial mRNA | blastn | 1643 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 17451028 | 17451028 | PRJNA896758_P_NODE_18394_length_271_cov_1.494949_g18004_i0 | PRJNA896758 | 18394 | 271 | 1.494949 | 4.05131179 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 235 | 2.2999999999999997e-57 | NTclustered | gi|1376134169|ref|XM_024647031.1| | 34506 | g18004 | i0 | 82.836 | 88.7047970479705 | 268 | 41 | 99 | 4 | 3 | 269 | 1075 | 1338 | Strongyloides ratti Heat shock cognate 71 kDa protein (SRAE_1000022300), partial mRNA | blastn | 24039 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 17451096 | 17451096 | PRJNA896758_P_NODE_26734_length_239_cov_2.512048_g26344_i0 | PRJNA896758 | 26734 | 239 | 2.512048 | 6.00379472 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.021 | NTclustered | gi|2653171|emb|Z82256.1| | 6239 | g26344 | i0 | 96.774 | 0.259414225941423 | 31 | 1 | 13 | 0 | 190 | 220 | 28228 | 28198 | Caenorhabditis elegans Cosmid B0513, complete sequence | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23825053 | 23825053 | PRJNA896758_P_NODE_3779_length_592_cov_1.903661_g3397_i0 | PRJNA896758 | 3779 | 592 | 1.903661 | 11.26967312 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 259 | 3.21e-64 | NTclustered | gi|1734332162|ref|NM_070257.4| | 6239 | g3397 | i0 | 80.403 | 33.5472972972973 | 347 | 62 | 58 | 5 | 136 | 479 | 435 | 92 | Caenorhabditis elegans NIF system FeS cluster assembly NifU N-terminal domain-containing protein (iscu-1), mRNA | blastn | 19860 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25470653 | 25470653 | PRJNA896758_P_NODE_18980_length_267_cov_1.304124_g18590_i0 | PRJNA896758 | 18980 | 267 | 1.304124 | 3.48201108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|339248614|ref|XM_003373247.1| | 6334 | g18590 | i0 | 100 | 0.224719101123595 | 30 | 0 | 11 | 0 | 205 | 234 | 1031 | 1060 | Trichinella spiralis hypothetical protein (Tsp_10135) mRNA, complete cds | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis |
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);;