contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA695273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5781726 | 5781726 | PRJNA695273_P_NODE_47985_length_392_cov_0.965517_g47227_i0 | PRJNA695273 | 47985 | 392 | 0.965517 | 3.78482664 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 472 | 2.43e-128 | NTclustered | gi|474805|emb|Z32683.1| | 6239 | g47227 | i0 | 99.614 | 16.2040816326531 | 259 | 0 | 66 | 1 | 1 | 259 | 21034 | 20777 | Caenorhabditis elegans Cosmid R07E5, complete sequence | blastn | 6352 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 7056330 | 7056330 | PRJNA695273_P_NODE_21246_length_606_cov_3.245779_g20496_i0 | PRJNA695273 | 21246 | 606 | 3.245779 | 19.66942074 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 822 | 0 | NTclustered | gi|1429284|emb|Z75954.1| | 6239 | g20496 | i0 | 100 | 11.1848184818482 | 445 | 0 | 73 | 0 | 162 | 606 | 2230 | 1786 | Caenorhabditis elegans Cosmid F58H1, complete sequence | blastn | 6778 | 822 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13431779 | 13431779 | PRJNA695273_P_NODE_3511_length_1653_cov_3.814557_g2076_i1 | PRJNA695273 | 3511 | 1653 | 3.814557 | 63.05462721 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 1912 | 0 | NTclustered | gi|1429284|emb|Z75954.1| | 6239 | g2076 | i1 | 99.524 | 36.805202661827 | 1051 | 4 | 64 | 1 | 1 | 1050 | 1786 | 736 | Caenorhabditis elegans Cosmid F58H1, complete sequence | blastn | 60839 | 1912 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 14705164 | 14705164 | PRJNA695273_P_NODE_101192_length_278_cov_1.770732_g100434_i0 | PRJNA695273 | 101192 | 278 | 1.770732 | 4.92263496 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 468 | 2.14e-127 | NTclustered | gi|1429284|emb|Z75954.1| | 6239 | g100434 | i0 | 100 | 2.44604316546763 | 253 | 0 | 91 | 0 | 1 | 253 | 480 | 732 | Caenorhabditis elegans Cosmid F58H1, complete sequence | blastn | 680 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15979466 | 15979466 | PRJNA695273_P_NODE_127273_length_251_cov_0.865169_g126515_i0 | PRJNA695273 | 127273 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 464 | 2.47e-126 | NTclustered | gi|373219291|emb|FO080793.1| | 6239 | g126515 | i0 | 100 | 5 | 251 | 0 | 100 | 0 | 1 | 251 | 16869 | 16619 | Caenorhabditis elegans Cosmid F55A3, complete sequence | blastn | 1255 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16484667 | 16484667 | PRJNA695273_P_NODE_113293_length_264_cov_2.659686_g112535_i0 | PRJNA695273 | 113293 | 264 | 2.659686 | 7.02157104 | Metazoa | 33208 | Nematoda | Nematoda | 174 | 4.93e-39 | NTclustered | gi|76560692|gb|DQ145717.1| | 52064 | g112535 | i0 | 92 | 46.6439393939394 | 125 | 8 | 47 | 2 | 12 | 135 | 593 | 716 | Heterorhabditis marelatus 28S ribosomal RNA gene, partial sequence | blastn | 12314 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heterorhabditidae | Heterorhabditis | Heterorhabditis marelatus | |
| 19804626 | 19804626 | PRJNA695273_P_NODE_2436_length_2024_cov_3.201948_g2076_i0 | PRJNA695273 | 2436 | 2024 | 3.201948 | 64.80742752 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 1912 | 0 | NTclustered | gi|1429284|emb|Z75954.1| | 6239 | g2076 | i0 | 99.524 | 35.8917984189723 | 1051 | 4 | 52 | 1 | 975 | 2024 | 736 | 1786 | Caenorhabditis elegans Cosmid F58H1, complete sequence | blastn | 72645 | 1912 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22355109 | 22355109 | PRJNA695273_P_NODE_23018_length_580_cov_3.816568_g22266_i0 | PRJNA695273 | 23018 | 580 | 3.816568 | 22.1360944 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 959 | 0 | NTclustered | gi|2226399|emb|Z75956.1| | 6239 | g22266 | i0 | 100 | 4.55689655172414 | 519 | 0 | 89 | 0 | 1 | 519 | 19932 | 19414 | Caenorhabditis elegans Cosmid R31, complete sequence | blastn | 2643 | 959 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;