contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1919177 | 1919177 | PRJNA674048_P_NODE_10562_length_288_cov_2.343096_g10359_i0 | PRJNA674048 | 10562 | 288 | 2.343096 | 6.74811648 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 532 | 7.8e-147 | NTclustered | gi|1972267169|ref|NM_069484.3| | 6239 | g10359 | i0 | 100 | 3 | 288 | 0 | 100 | 0 | 1 | 288 | 482 | 195 | Caenorhabditis elegans Uncharacterized protein (Y43C5A.4), mRNA | blastn | 864 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3193942 | 3193942 | PRJNA674048_P_NODE_17163_length_214_cov_3.018182_g16960_i0 | PRJNA674048 | 17163 | 214 | 3.018182 | 6.45890948 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 390 | 3.519999999999999e-104 | NTclustered | gi|687865476|emb|LK927750.1| | 6239 | g16960 | i0 | 99.533 | 2 | 214 | 1 | 100 | 0 | 1 | 214 | 64875 | 64662 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000194 | blastn | 428 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 4471108 | 4471108 | PRJNA674048_P_NODE_29744_length_165_cov_2.637931_g29541_i0 | PRJNA674048 | 29744 | 165 | 2.637931 | 4.35258615 | Micoletzkya japonica | 1250332 | Nematoda | Nematoda | 147 | 6.149999999999999e-31 | NTclustered | gi|410992323|gb|JX163990.1| | 1250332 | g29541 | i0 | 83.439 | 18.2545454545455 | 157 | 26 | 95 | 0 | 7 | 163 | 190 | 34 | Micoletzkya japonica large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 3012 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Micoletzkya | Micoletzkya japonica | |
| 7021762 | 7021762 | PRJNA674048_P_NODE_28846_length_167_cov_0.881356_g28643_i0 | PRJNA674048 | 28846 | 167 | 0.881356 | 1.47186452 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 309 | 7.53e-80 | NTclustered | gi|687865476|emb|LK927750.1| | 6239 | g28643 | i0 | 100 | 2 | 167 | 0 | 100 | 0 | 1 | 167 | 60812 | 60646 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000194 | blastn | 334 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 17221252 | 17221252 | PRJNA674048_P_NODE_6774_length_384_cov_2.695522_g6571_i0 | PRJNA674048 | 6774 | 384 | 2.695522 | 10.35080448 | Sachsia zurstrasseni | 1538730 | Nematoda | Nematoda | 106 | 2.77e-18 | NTclustered | gi|675118987|gb|KJ877373.1| | 1538730 | g6571 | i0 | 95.455 | 1.59114583333333 | 66 | 3 | 17 | 0 | 319 | 384 | 410 | 345 | Sachsia zurstrasseni large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 611 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Sachsia | Sachsia zurstrasseni | |
| 18495523 | 18495523 | PRJNA674048_P_NODE_30595_length_164_cov_1.808696_g30392_i0 | PRJNA674048 | 30595 | 164 | 1.808696 | 2.96626144 | Loa loa | 7209 | Nematoda | Nematoda | 110 | 8.01e-20 | NTclustered | gi|1158592910|ref|XM_003138156.2| | 7209 | g30392 | i0 | 84.211 | 61.5243902439024 | 114 | 17 | 69 | 1 | 45 | 157 | 1499 | 1386 | Loa loa pre-mRNA-splicing factor ATP-dependent RNA helicase mRNA | blastn | 10090 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 19770036 | 19770036 | PRJNA674048_P_NODE_31816_length_163_cov_0.912281_g31613_i0 | PRJNA674048 | 31816 | 163 | 0.912281 | 1.48701803 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 158 | 2.8e-34 | NTclustered | gi|1376143403|ref|XM_024652078.1| | 34506 | g31613 | i0 | 84.146 | 84.361963190184 | 164 | 24 | 100 | 2 | 1 | 163 | 842 | 680 | Strongyloides ratti Elongation factor 1-alpha (SRAE_2000115900), partial mRNA | blastn | 13751 | 158 | 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);;