contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295867 | 1295867 | PRJEB17675_P_NODE_24362_length_154_cov_1.193277_g24058_i0 | PRJEB17675 | 24362 | 154 | 1.193277 | 1.83764658 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 113 | 5.72e-21 | NTclustered | gi|687022647|emb|LM525561.1| | 174720 | g24058 | i0 | 83.333 | 11.487012987013 | 126 | 17 | 81 | 4 | 1 | 124 | 124926 | 124803 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000006 | blastn | 1769 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 2571541 | 2571541 | PRJEB17675_P_NODE_24163_length_155_cov_1.000000_g23859_i0 | PRJEB17675 | 24163 | 155 | 1 | 1.55 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 178 | 2.02e-40 | NTclustered | gi|1376157149|ref|XM_024646005.1| | 34506 | g23859 | i0 | 87.582 | 51.0709677419355 | 153 | 19 | 99 | 0 | 1 | 153 | 1065 | 913 | Strongyloides ratti 26S protease regulatory subunit 4 (SRAE_0000015400), partial mRNA | blastn | 7916 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 8948685 | 8948685 | PRJEB17675_P_NODE_24988_length_152_cov_1.017094_g24684_i0 | PRJEB17675 | 24988 | 152 | 1.017094 | 1.54598288 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 124 | 2.5999999999999996e-24 | NTclustered | gi|399163138|gb|JQ235181.1| | 6239 | g24684 | i0 | 81.757 | 13.5789473684211 | 148 | 27 | 97 | 0 | 5 | 152 | 227 | 80 | Caenorhabditis elegans isolate GC5-1 rab-2 (unc-108) mRNA, partial cds | blastn | 2064 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11499735 | 11499735 | PRJEB17675_P_NODE_9750_length_281_cov_1.463415_g9446_i0 | PRJEB17675 | 9750 | 281 | 1.463415 | 4.11219615 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|1376142617|ref|XM_024651632.1| | 34506 | g9446 | i0 | 100 | 0.270462633451957 | 30 | 0 | 11 | 0 | 125 | 154 | 1462 | 1491 | Strongyloides ratti MIP20649p (SRAE_2000076000), partial mRNA | blastn | 76 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 16598535 | 16598535 | PRJEB17675_P_NODE_9054_length_295_cov_3.680769_g8750_i0 | PRJEB17675 | 9054 | 295 | 3.680769 | 10.85826855 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 58.4 | 5.88e-4 | NTclustered | gi|2445351206|ref|XM_003111984.2| | 31234 | g8750 | i0 | 85 | 0.203389830508475 | 60 | 6 | 20 | 2 | 118 | 177 | 830 | 886 | Caenorhabditis remanei uncharacterized protein (GCK72_002409), partial mRNA | blastn | 60 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 17873278 | 17873278 | PRJEB17675_P_NODE_22795_length_160_cov_1.280000_g22491_i0 | PRJEB17675 | 22795 | 160 | 1.28 | 2.048 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 154 | 3.54e-33 | NTclustered | gi|268568589|ref|XM_002640248.1| | 6238 | g22491 | i0 | 84.516 | 28.35625 | 155 | 24 | 97 | 0 | 6 | 160 | 707 | 553 | Caenorhabditis briggsae Protein CBR-KIN-3 (Cbr-kin-3), partial mRNA | blastn | 4537 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 20422436 | 20422436 | PRJEB17675_P_NODE_9877_length_278_cov_2.259259_g9573_i0 | PRJEB17675 | 9877 | 278 | 2.259259 | 6.28074002 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.007 | NTclustered | gi|351058242|emb|FO080670.1| | 6239 | g9573 | i0 | 100 | 0.413669064748201 | 29 | 0 | 10 | 0 | 85 | 113 | 5134 | 5162 | Caenorhabditis elegans Cosmid T27E4, complete sequence | blastn | 115 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22973643 | 22973643 | PRJEB17675_P_NODE_22399_length_162_cov_1.149606_g22095_i0 | PRJEB17675 | 22399 | 162 | 1.149606 | 1.86236172 | Brugia malayi | 6279 | Nematoda | Nematoda | 111 | 2.19e-20 | NTclustered | gi|2082284419|ref|XM_001901045.2| | 6279 | g22095 | i0 | 79.141 | 17.3765432098765 | 163 | 32 | 100 | 2 | 1 | 162 | 277 | 438 | Brugia malayi Uncharacterized protein (Bma-unc-108), partial mRNA | blastn | 2815 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi |
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);;