contig_metadata
6 rows where bioproject = "PRJNA661142", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 628102 | 628102 | PRJNA661142_P_NODE_11161_length_175_cov_1.039683_g11096_i0 | PRJNA661142 | 11161 | 175 | 1.039683 | 1.81944525 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 281 | 1.73e-71 | NTclustered | gi|1972305279|ref|NM_001392751.1| | 6239 | g11096 | i0 | 100 | 2.91428571428571 | 152 | 0 | 87 | 0 | 2 | 153 | 152 | 1 | Caenorhabditis elegans UPF0057 membrane protein F47B7.1 (pmpl-1), mRNA | blastn | 510 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3178993 | 3178993 | PRJNA661142_P_NODE_12123_length_164_cov_0.886957_g12058_i0 | PRJNA661142 | 12123 | 164 | 0.886957 | 1.45460948 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 257 | 2.7e-64 | NTclustered | gi|1972311474|ref|NM_001029430.4| | 6239 | g12058 | i0 | 99.296 | 3.80487804878049 | 142 | 1 | 87 | 0 | 23 | 164 | 1 | 142 | Caenorhabditis elegans Neuropeptide-Like Protein (F23D12.7), mRNA | blastn | 624 | 257 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 5731553 | 5731553 | PRJNA661142_P_NODE_12785_length_161_cov_0.910714_g12720_i0 | PRJNA661142 | 12785 | 161 | 0.910714 | 1.46624954 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 250 | 4.42e-62 | NTclustered | gi|1972225930|ref|NM_058275.7| | 6239 | g12720 | i0 | 99.275 | 3.5776397515528 | 138 | 1 | 86 | 0 | 23 | 160 | 1 | 138 | Caenorhabditis elegans Large ribosomal subunit protein uL30 (rpl-7), mRNA | blastn | 576 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10832254 | 10832254 | PRJNA661142_P_NODE_12849_length_153_cov_2.336538_g12784_i0 | PRJNA661142 | 12849 | 153 | 2.336538 | 3.57490314 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 244 | 1.93e-60 | NTclustered | gi|687866020|emb|LK927829.1| | 6239 | g12784 | i0 | 100 | 45.7712418300654 | 132 | 0 | 86 | 0 | 2 | 133 | 60146 | 60015 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000261 | blastn | 7003 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 17206125 | 17206125 | PRJNA661142_P_NODE_11594_length_166_cov_0.871795_g11529_i0 | PRJNA661142 | 11594 | 166 | 0.871795 | 1.4471797 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 270 | 3.5299999999999998e-68 | NTclustered | gi|687865429|emb|LK927562.1| | 6239 | g11529 | i0 | 100 | 3.5 | 146 | 0 | 88 | 0 | 21 | 166 | 239952 | 239807 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000030 | blastn | 581 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 21030631 | 21030631 | PRJNA661142_P_NODE_11337_length_167_cov_0.864407_g11272_i0 | PRJNA661142 | 11337 | 167 | 0.864407 | 1.44355969 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 268 | 1.28e-67 | NTclustered | gi|1972254356|ref|NM_063878.6| | 6239 | g11272 | i0 | 100 | 2.91017964071856 | 145 | 0 | 87 | 0 | 23 | 167 | 1 | 145 | Caenorhabditis elegans Deoxyhypusine hydroxylase (dohh-1), mRNA | blastn | 486 | 268 | 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);;