contig_metadata
12 rows where bioproject = "PRJNA1004255", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1428031 | 1428031 | PRJNA1004255_S_NODE_7062_length_231_cov_7.127660_g6854_i0 | PRJNA1004255 | 7062 | 231 | 7.12766 | 16.4648946 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 427 | 2.9399999999999998e-115 | NTclustered | gi|1879207294|gb|MT797802.1| | 6239 | g6854 | i0 | 100 | 91.4978354978355 | 231 | 0 | 100 | 0 | 1 | 231 | 233 | 3 | Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence | blastn | 21136 | 427 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 2703455 | 2703455 | PRJNA1004255_S_NODE_13343_length_177_cov_1.753731_g13135_i0 | PRJNA1004255 | 13343 | 177 | 1.753731 | 3.10410387 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 281 | 1.75e-71 | NTclustered | gi|2056519505|gb|MZ435570.1| | 6239 | g13135 | i0 | 100 | 14.5819209039548 | 152 | 0 | 86 | 0 | 26 | 177 | 77 | 228 | Caenorhabditis elegans voucher KTnemPosCtrl internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 2581 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 5256155 | 5256155 | PRJNA1004255_S_NODE_2065_length_352_cov_15.268608_g1857_i0 | PRJNA1004255 | 2065 | 352 | 15.268608 | 53.74550016 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 645 | 1.2e-180 | NTclustered | gi|25167357|ref|NR_000053.1| | 6239 | g1857 | i0 | 99.716 | 96.9403409090909 | 352 | 1 | 100 | 0 | 1 | 352 | 943 | 592 | Caenorhabditis elegans 18S ribosomal RNA (rrn-1.1), rRNA | blastn | 34123 | 645 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9080710 | 9080710 | PRJNA1004255_S_NODE_17048_length_157_cov_9.192982_g16840_i0 | PRJNA1004255 | 17048 | 157 | 9.192982 | 14.43298174 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 291 | 2.52e-74 | NTclustered | gi|2056519505|gb|MZ435570.1| | 6239 | g16840 | i0 | 100 | 14.8917197452229 | 157 | 0 | 100 | 0 | 1 | 157 | 201 | 357 | Caenorhabditis elegans voucher KTnemPosCtrl internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 2338 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9080760 | 9080760 | PRJNA1004255_S_NODE_9088_length_209_cov_5.102410_g8880_i0 | PRJNA1004255 | 9088 | 209 | 5.10241 | 10.6640369 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 387 | 4.42e-103 | NTclustered | gi|1972264646|ref|NM_066119.9| | 6239 | g8880 | i0 | 100 | 35.6124401913876 | 209 | 0 | 100 | 0 | 1 | 209 | 1257 | 1465 | Caenorhabditis elegans Elongation factor 1-alpha (eef-1A.1), mRNA | blastn | 7443 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 12479829 | 12479829 | PRJNA1004255_S_NODE_7850_length_222_cov_9.335196_g7642_i0 | PRJNA1004255 | 7850 | 222 | 9.335196 | 20.72413512 | Caenorhabditis | 6237 | Nematoda | Nematoda | 283 | 6.409999999999999e-72 | NTclustered | gi|356605872|gb|JN636061.1| | 6238 | g7642 | i0 | 100 | 70.054054054054 | 153 | 0 | 69 | 0 | 45 | 197 | 1300 | 1148 | Caenorhabditis briggsae 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 15552 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 14181894 | 14181894 | PRJNA1004255_S_NODE_10032_length_201_cov_1.784810_g9824_i0 | PRJNA1004255 | 10032 | 201 | 1.78481 | 3.5874681 | Rubzovinema sp. EIK-2013 | 1400286 | Nematoda | Nematoda | 248 | 2.08e-61 | NTclustered | gi|543891909|gb|KF155282.1| | 1400286 | g9824 | i0 | 90.052 | 66.6318407960199 | 191 | 19 | 95 | 0 | 10 | 200 | 4363 | 4553 | Rubzovinema sp. EIK-2013 isolate A.r. 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 13393 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neotylenchidae | Rubzovinema | Rubzovinema sp. EIK-2013 | |
| 15455918 | 15455918 | PRJNA1004255_S_NODE_5093_length_261_cov_5.981651_g4885_i0 | PRJNA1004255 | 5093 | 261 | 5.981651 | 15.61210911 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 483 | 7.12e-132 | NTclustered | gi|1972267336|ref|NM_069785.8| | 6239 | g4885 | i0 | 100 | 5.38314176245211 | 261 | 0 | 100 | 0 | 1 | 261 | 257 | 517 | Caenorhabditis elegans Small ribosomal subunit protein uS17 (rps-11), mRNA | blastn | 1405 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19278855 | 19278855 | PRJNA1004255_S_NODE_7856_length_222_cov_6.793296_g7648_i0 | PRJNA1004255 | 7856 | 222 | 6.793296 | 15.08111712 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 411 | 2.8199999999999996e-110 | NTclustered | gi|1831506465|ref|NM_001380979.1| | 6239 | g7648 | i0 | 100 | 28.8333333333333 | 222 | 0 | 100 | 0 | 1 | 222 | 2514 | 2293 | Caenorhabditis elegans Elongation factor 2 (eef-2), partial mRNA | blastn | 6401 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 20554398 | 20554398 | PRJNA1004255_S_NODE_12817_length_180_cov_2.744526_g12609_i0 | PRJNA1004255 | 12817 | 180 | 2.744526 | 4.9401468 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 333 | 4.87e-87 | NTclustered | gi|1734332489|ref|NM_070479.2| | 6239 | g12609 | i0 | 100 | 11.3555555555556 | 180 | 0 | 100 | 0 | 1 | 180 | 213 | 34 | Caenorhabditis elegans SMP domain-containing protein (Y105C5A.12), mRNA | blastn | 2044 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 24379243 | 24379243 | PRJNA1004255_S_NODE_13620_length_175_cov_4.272727_g13412_i0 | PRJNA1004255 | 13620 | 175 | 4.272727 | 7.47727225 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 324 | 2.83e-84 | NTclustered | gi|2814962|emb|Z82285.1| | 6239 | g13412 | i0 | 100 | 6.65142857142857 | 175 | 0 | 100 | 0 | 1 | 175 | 739 | 913 | Caenorhabditis elegans Cosmid T28F3, complete sequence | blastn | 1164 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 24379313 | 24379313 | PRJNA1004255_S_NODE_8400_length_216_cov_5.832370_g8192_i0 | PRJNA1004255 | 8400 | 216 | 5.83237 | 12.5979192 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 394 | 2.75e-105 | NTclustered | gi|413006566|emb|Z92784.2| | 6239 | g8192 | i0 | 99.537 | 91.3935185185185 | 216 | 1 | 100 | 0 | 1 | 216 | 28681 | 28896 | Caenorhabditis elegans Cosmid F31C3, complete sequence | blastn | 19741 | 394 | 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);;