contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA774958" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 752593 | 752593 | PRJNA774958_P_NODE_20181_length_355_cov_1.500000_g19934_i0 | PRJNA774958 | 20181 | 355 | 1.5 | 5.325 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 65.8 | 4.31e-6 | NTclustered | gi|209489254|gb|FJ362359.1| | 135651 | g19934 | i0 | 90 | 1.91549295774648 | 50 | 5 | 14 | 0 | 40 | 89 | 29820 | 29771 | Caenorhabditis brenneri contig JD07, partial sequence | blastn | 680 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 16055191 | 16055191 | PRJNA774958_P_NODE_26033_length_301_cov_51.820175_g25786_i0 | PRJNA774958 | 26033 | 301 | 51.820175 | 155.97872675 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 302 | 2.5200000000000006e-77 | NTclustered | gi|1376147859|ref|XM_024654603.1| | 34506 | g25786 | i0 | 84.718 | 181.614617940199 | 301 | 46 | 100 | 0 | 1 | 301 | 989 | 1289 | Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA | blastn | 54666 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22429769 | 22429769 | PRJNA774958_P_NODE_10878_length_494_cov_1.736342_g10632_i0 | PRJNA774958 | 10878 | 494 | 1.736342 | 8.57752948 | Brugia malayi | 6279 | Nematoda | Nematoda | 58.4 | 0.001 | NTclustered | gi|2082283750|ref|XM_001896543.2| | 6279 | g10632 | i0 | 100 | 0.062753036437247 | 31 | 0 | 6 | 0 | 336 | 366 | 193 | 163 | Brugia malayi Phosducin family protein (Bma-mau-8), partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 23705745 | 23705745 | PRJNA774958_P_NODE_5079_length_724_cov_5.261137_g4864_i0 | PRJNA774958 | 5079 | 724 | 5.261137 | 38.09063188 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 499 | 2.15e-136 | NTclustered | gi|1376146183|ref|XM_024653652.1| | 34506 | g4864 | i0 | 80.841 | 87.5593922651934 | 642 | 118 | 88 | 5 | 1 | 639 | 923 | 1562 | Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA | blastn | 63393 | 499 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 24979245 | 24979245 | PRJNA774958_P_NODE_2660_length_970_cov_3.633222_g2496_i0 | PRJNA774958 | 2660 | 970 | 3.633222 | 35.2422534 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 577 | 1.3099999999999995e-159 | NTclustered | gi|1376147403|ref|XM_024654346.1| | 34506 | g2496 | i0 | 77.998 | 50.3092783505155 | 959 | 184 | 97 | 22 | 27 | 970 | 235 | 1181 | Strongyloides ratti Proteasome (Prosome, macropain) 26S subunit, ATPase, 5 (SRAE_2000318400), partial mRNA | blastn | 48800 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti |
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);;