contig_metadata
13 rows where bioproject = "PRJNA849646", tax_phylum = "Nematoda" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2113691 | 2113691 | PRJNA849646_P_NODE_31862_length_248_cov_1.760000_g31744_i0 | PRJNA849646 | 31862 | 248 | 1.76 | 4.3648 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.13e-124 | NTclustered | gi|1845972078|ref|NM_001027037.4| | 6239 | g31744 | i0 | 100 | 9.01612903225806 | 248 | 0 | 100 | 0 | 1 | 248 | 3995 | 3748 | Caenorhabditis elegans Receptor-type tyrosine-protein phosphatase (clr-1), mRNA | blastn | 2236 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 2113808 | 2113808 | PRJNA849646_P_NODE_41582_length_228_cov_3.554839_g41464_i0 | PRJNA849646 | 41582 | 228 | 3.554839 | 8.10503292 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 422 | 1.34e-113 | NTclustered | gi|1015446|emb|Z54342.1| | 6239 | g41464 | i0 | 100 | 3 | 228 | 0 | 100 | 0 | 1 | 228 | 34890 | 34663 | Caenorhabditis elegans Cosmid C08H9, complete sequence | blastn | 684 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3388858 | 3388858 | PRJNA849646_P_NODE_20563_length_267_cov_2.226804_g20445_i0 | PRJNA849646 | 20563 | 267 | 2.226804 | 5.94556668 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 488 | 1.5699999999999998e-133 | NTclustered | gi|1972239523|ref|NM_061815.6| | 6239 | g20445 | i0 | 99.625 | 4.91760299625468 | 267 | 1 | 100 | 0 | 1 | 267 | 281 | 15 | Caenorhabditis elegans MICOS complex subunit Mic10 (F54A3.5), mRNA | blastn | 1313 | 488 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9766252 | 9766252 | PRJNA849646_P_NODE_26488_length_256_cov_1.683060_g26370_i0 | PRJNA849646 | 26488 | 256 | 1.68306 | 4.3086336 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 473 | 4.189999999999999e-129 | NTclustered | gi|1972256714|ref|NM_064506.8| | 6239 | g26370 | i0 | 100 | 4.01171875 | 256 | 0 | 100 | 0 | 1 | 256 | 364 | 619 | Caenorhabditis elegans NADH dehydrogenase [ubiquinone] 1 beta subcomplex subunit 8, mitochondrial (ndub-8), mRNA | blastn | 1027 | 473 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 12317327 | 12317327 | PRJNA849646_P_NODE_22850_length_263_cov_1.621053_g22732_i0 | PRJNA849646 | 22850 | 263 | 1.621053 | 4.26336939 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 486 | 5.5499999999999986e-133 | NTclustered | gi|1972288669|ref|NM_072288.7| | 6239 | g22732 | i0 | 100 | 5.44866920152091 | 263 | 0 | 100 | 0 | 1 | 263 | 1546 | 1808 | Caenorhabditis elegans ABC transporter domain-containing protein (pmp-5), mRNA | blastn | 1433 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13592127 | 13592127 | PRJNA849646_P_NODE_7631_length_295_cov_3.004505_g7513_i0 | PRJNA849646 | 7631 | 295 | 3.004505 | 8.86328975 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 278 | 4.15e-70 | NTclustered | gi|687867925|emb|LK929948.1| | 6239 | g7513 | i0 | 100 | 2.02033898305085 | 150 | 0 | 100 | 0 | 1 | 150 | 674 | 525 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0001447 | blastn | 596 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 14865994 | 14865994 | PRJNA849646_P_NODE_10992_length_286_cov_1.361502_g10874_i0 | PRJNA849646 | 10992 | 286 | 1.361502 | 3.89389572 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 529 | 1e-145 | NTclustered | gi|1972264791|ref|NM_066172.10| | 6239 | g10874 | i0 | 100 | 14.0244755244755 | 286 | 0 | 100 | 0 | 1 | 286 | 12 | 297 | Caenorhabditis elegans Large ribosomal subunit protein eL36 (rpl-36), mRNA | blastn | 4011 | 529 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19964691 | 19964691 | PRJNA849646_P_NODE_29856_length_250_cov_2.508475_g29738_i0 | PRJNA849646 | 29856 | 250 | 2.508475 | 6.2711875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 455 | 1.48e-123 | NTclustered | gi|1972230218|ref|NM_001263440.3| | 6239 | g29738 | i0 | 99.6 | 2.992 | 250 | 0 | 100 | 1 | 1 | 250 | 263 | 511 | Caenorhabditis elegans AbLIM_anchor domain-containing protein (C30F12.5), mRNA | blastn | 748 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22514980 | 22514980 | PRJNA849646_P_NODE_26238_length_256_cov_2.513661_g26120_i0 | PRJNA849646 | 26238 | 256 | 2.513661 | 6.43497216 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 473 | 4.189999999999999e-129 | NTclustered | gi|1972228951|ref|NM_170865.6| | 6239 | g26120 | i0 | 100 | 7 | 256 | 0 | 100 | 0 | 1 | 256 | 1884 | 1629 | Caenorhabditis elegans polynucleotide adenylyltransferase (tent-5), mRNA | blastn | 1792 | 473 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22515109 | 22515109 | PRJNA849646_P_NODE_38618_length_241_cov_0.916667_g38500_i0 | PRJNA849646 | 38618 | 241 | 0.916667 | 2.20916747 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 446 | 8.519999999999999e-121 | NTclustered | gi|687865712|emb|LK927652.1| | 6239 | g38500 | i0 | 100 | 3.99170124481328 | 241 | 0 | 100 | 0 | 1 | 241 | 95124 | 95364 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000108 | blastn | 962 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23790314 | 23790314 | PRJNA849646_P_NODE_12139_length_283_cov_3.033333_g12021_i0 | PRJNA849646 | 12139 | 283 | 3.033333 | 8.58433239 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 523 | 4.5999999999999983e-144 | NTclustered | gi|1972312769|ref|NM_078428.8| | 6239 | g12021 | i0 | 100 | 9.92932862190813 | 283 | 0 | 100 | 0 | 1 | 283 | 691 | 409 | Caenorhabditis elegans Myosin regulatory light chain 1 (mlc-1), mRNA | blastn | 2810 | 523 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23790698 | 23790698 | PRJNA849646_P_NODE_7519_length_295_cov_5.594595_g7401_i0 | PRJNA849646 | 7519 | 295 | 5.594595 | 16.50405525 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 545 | 1.03e-150 | NTclustered | gi|1972306251|ref|NM_001029747.7| | 6239 | g7401 | i0 | 100 | 10.8135593220339 | 295 | 0 | 100 | 0 | 1 | 295 | 320 | 614 | Caenorhabditis elegans Transcription factor egl-13 (egl-13), mRNA | blastn | 3190 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25064194 | 25064194 | PRJNA849646_P_NODE_12920_length_282_cov_1.473684_g12802_i0 | PRJNA849646 | 12920 | 282 | 1.473684 | 4.15578888 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 521 | 1.6499999999999996e-143 | NTclustered | gi|1734320731|ref|NM_062161.5| | 6239 | g12802 | i0 | 100 | 5.1205673758865196 | 282 | 0 | 100 | 0 | 1 | 282 | 448 | 729 | Caenorhabditis elegans Cuticle collagen 71 (col-71), mRNA | blastn | 1444 | 521 | 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);;