contig_metadata
7 rows where bioproject = "PRJEB58983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1399163 | 1399163 | PRJEB58983_P_NODE_16042_length_320_cov_1.186235_g15627_i0 | PRJEB58983 | 16042 | 320 | 1.186235 | 3.795952 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 183 | 1.02e-41 | NTclustered | gi|150982147|gb|EF634662.1| | 452809 | g15627 | i0 | 87.821 | 49.153125 | 156 | 19 | 49 | 0 | 151 | 306 | 165 | 10 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 15729 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 2675031 | 2675031 | PRJEB58983_P_NODE_27083_length_256_cov_1.519126_g26668_i0 | PRJEB58983 | 27083 | 256 | 1.519126 | 3.88896256 | Diplogastrellus gracilis | 669117 | Nematoda | Nematoda | 158 | 4.79e-34 | NTclustered | gi|256709130|gb|GQ422217.1| | 669117 | g26668 | i0 | 82.162 | 66.2109375 | 185 | 31 | 72 | 2 | 73 | 256 | 723 | 540 | Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 16950 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogastrellus | Diplogastrellus gracilis | |
| 14153018 | 14153018 | PRJEB58983_P_NODE_10272_length_390_cov_2.779180_g9857_i0 | PRJEB58983 | 10272 | 390 | 2.77918 | 10.838802 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 270 | 9.45e-68 | NTclustered | gi|1109667|gb|U31077.1|CEU31077 | 6239 | g9857 | i0 | 80.938 | 67.748717948718 | 341 | 65 | 87 | 0 | 45 | 385 | 490 | 150 | Caenorhabditis elegans cyclophilin isoform 3 (cyp-3) mRNA, complete cds | blastn | 26422 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27823512 | 27823512 | PRJEB58983_P_NODE_32064_length_243_cov_0.917647_g31649_i0 | PRJEB58983 | 32064 | 243 | 0.917647 | 2.22988221 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 116 | 8.22e-29 | NR | CAI4230971.1 | 2878363 | g31649 | i0 | 59.5 | 0.975308641975309 | 79 | 32 | 97.5 | 0 | 3 | 239 | 95 | 173 | CAI4230971.1 unnamed protein product [Auanema sp. JU1783] | diamond | 237 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 28770488 | 28770488 | PRJEB58983_P_NODE_27527_length_254_cov_1.718232_g27112_i0 | PRJEB58983 | 27527 | 254 | 1.718232 | 4.36430928 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 94.7 | 3.02e-21 | NR | KAH7710288.1 | 70226 | g27112 | i0 | 52.6 | 1.84251968503937 | 78 | 37 | 92.1 | 0 | 234 | 1 | 57 | 134 | KAH7710288.1 CPZ-1 protein [Aphelenchoides avenae] | diamond | 468 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 30002159 | 30002159 | PRJEB58983_P_NODE_32951_length_239_cov_2.096386_g32536_i0 | PRJEB58983 | 32951 | 239 | 2.096386 | 5.01036254 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 63.5 | 1.63e-9 | NR | VDN52653.1 | 318479 | g32536 | i0 | 41.9 | 2.66108786610879 | 74 | 42 | 92.9 | 1 | 5 | 226 | 46 | 118 | VDN52653.1 unnamed protein product, partial [Dracunculus medinensis] | diamond | 636 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 32056682 | 32056682 | PRJEB58983_P_NODE_6558_length_481_cov_5.595588_g6144_i0 | PRJEB58983 | 6558 | 481 | 5.595588 | 26.91477828 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 202 | 7.7e-64 | NR | CAD5208001.1 | 6326 | g6144 | i0 | 66.2 | 1.81496881496882 | 145 | 49 | 90.4 | 0 | 476 | 42 | 1 | 145 | CAD5208001.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 873 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus |
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);;