contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA540466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508229 | 508229 | PRJNA540466_S_NODE_52921_length_258_cov_1.983784_g52372_i0 | PRJNA540466 | 52921 | 258 | 1.983784 | 5.11816272 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 436 | 5.549999999999999e-118 | NTclustered | gi|1972252859|ref|NM_001267265.5| | 6239 | g52372 | i0 | 100 | 4.55038759689922 | 236 | 0 | 91 | 0 | 1 | 236 | 424 | 189 | Caenorhabditis elegans Large ribosomal subunit protein eL32 (rpl-32), mRNA | blastn | 1174 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 1783508 | 1783508 | PRJNA540466_S_NODE_45442_length_275_cov_1.158416_g44893_i0 | PRJNA540466 | 45442 | 275 | 1.158416 | 3.185644 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 508 | 1.2499999999999999e-139 | NTclustered | gi|1495011|emb|Z78413.1| | 6239 | g44893 | i0 | 100 | 5.05818181818182 | 275 | 0 | 100 | 0 | 1 | 275 | 14342 | 14068 | Caenorhabditis elegans Cosmid T01C3, complete sequence | blastn | 1391 | 508 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3058826 | 3058826 | PRJNA540466_S_NODE_23743_length_365_cov_32.958904_g23194_i0 | PRJNA540466 | 23743 | 365 | 32.958904 | 120.2999996 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 176 | 1.97e-39 | NTclustered | gi|351047525|emb|FO080366.1| | 6239 | g23194 | i0 | 87.097 | 39.1479452054795 | 155 | 20 | 42 | 0 | 1 | 155 | 15524 | 15370 | Caenorhabditis elegans Cosmid T26A5, complete sequence | blastn | 14289 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3058986 | 3058986 | PRJNA540466_S_NODE_4103_length_713_cov_20120.471875_g3733_i0 | PRJNA540466 | 4103 | 713 | 20120.471875 | 143458.96446875 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 6.689999999999998e-47 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g3733 | i0 | 79.649 | 12.9873772791024 | 285 | 54 | 40 | 4 | 146 | 428 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 9260 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 3059108 | 3059108 | PRJNA540466_S_NODE_57443_length_250_cov_1.322034_g56894_i0 | PRJNA540466 | 57443 | 250 | 1.322034 | 3.305085 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 396 | 9.079999999999996e-106 | NTclustered | gi|1734330880|ref|NM_069429.5| | 6239 | g56894 | i0 | 99.539 | 2.628 | 217 | 1 | 87 | 0 | 18 | 234 | 1908 | 1692 | Caenorhabditis elegans Kinetochore protein ndc-80 (ndc-80), mRNA | blastn | 657 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6885511 | 6885511 | PRJNA540466_S_NODE_17026_length_426_cov_1.747875_g16478_i0 | PRJNA540466 | 17026 | 426 | 1.747875 | 7.4459475 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 778 | 0 | NTclustered | gi|416296|gb|U00240.1|U00240 | 6239 | g16478 | i0 | 100 | 4.19953051643192 | 421 | 0 | 99 | 0 | 3 | 423 | 2182 | 2602 | Caenorhabditis elegans beta-amyloid protein precursor (APL-1) mRNA complete cds | blastn | 1789 | 778 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8160773 | 8160773 | PRJNA540466_S_NODE_28347_length_337_cov_1.166667_g27798_i0 | PRJNA540466 | 28347 | 337 | 1.166667 | 3.93166779 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 185 | 3.01e-42 | NTclustered | gi|1376134653|ref|XM_024647302.1| | 34506 | g27798 | i0 | 79.537 | 45.1691394658754 | 259 | 53 | 77 | 0 | 77 | 335 | 748 | 490 | Strongyloides ratti 60S ribosomal protein L8 (SRAE_1000046600), partial mRNA | blastn | 15222 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 9436177 | 9436177 | PRJNA540466_S_NODE_19548_length_400_cov_1.256881_g18999_i0 | PRJNA540466 | 19548 | 400 | 1.256881 | 5.027524 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.038 | NTclustered | gi|690019075|emb|LM526367.1| | 174720 | g18999 | i0 | 100 | 0.07 | 28 | 0 | 7 | 0 | 117 | 144 | 408 | 435 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000712 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 10046897 | 10046897 | PRJNA540466_S_NODE_37428_length_298_cov_3.302222_g36879_i0 | PRJNA540466 | 37428 | 298 | 3.302222 | 9.84062156 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.5 | 1.27e-10 | NTclustered | gi|380447938|gb|JQ074059.1| | 34510 | g36879 | i0 | 97.826 | 0.61744966442953 | 46 | 1 | 15 | 0 | 1 | 46 | 1108 | 1153 | Heterodera avenae actin 2 mRNA, complete cds | blastn | 184 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera avenae | |
| 10712106 | 10712106 | PRJNA540466_S_NODE_36129_length_303_cov_1.673913_g35580_i0 | PRJNA540466 | 36129 | 303 | 1.673913 | 5.07195639 | Pristionchus uniformis | 358041 | Nematoda | Nematoda | 159 | 1.6199999999999996e-34 | NTclustered | gi|150984659|gb|EF634991.1| | 358041 | g35580 | i0 | 82.292 | 31.8316831683168 | 192 | 26 | 61 | 6 | 96 | 280 | 4 | 194 | Pristionchus uniformis small subunit ribosomal protein 28 (rps-28) mRNA, complete cds | blastn | 9645 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus uniformis | |
| 10712124 | 10712124 | PRJNA540466_S_NODE_38809_length_294_cov_1.393665_g38260_i0 | PRJNA540466 | 38809 | 294 | 1.393665 | 4.0973751 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 538 | 1.7199999999999995e-148 | NTclustered | gi|1831511366|ref|NM_066884.7| | 6239 | g38260 | i0 | 99.66 | 4.98299319727891 | 294 | 1 | 100 | 0 | 1 | 294 | 310 | 17 | Caenorhabditis elegans Transthyretin-like protein 15 (ttr-15), mRNA | blastn | 1465 | 538 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10712247 | 10712247 | PRJNA540466_S_NODE_50809_length_262_cov_3.179894_g50260_i0 | PRJNA540466 | 50809 | 262 | 3.179894 | 8.33132228 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|1376150295|ref|XM_024643536.1| | 34506 | g50260 | i0 | 96.774 | 0.118320610687023 | 31 | 1 | 12 | 0 | 214 | 244 | 455 | 485 | Strongyloides ratti Nrf2-associated protein keap1b (SRAE_2000464100), partial mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 13261930 | 13261930 | PRJNA540466_S_NODE_47891_length_269_cov_1.341837_g47342_i0 | PRJNA540466 | 47891 | 269 | 1.341837 | 3.60954153 | Diplogasteroides magnus | 560213 | Nematoda | Nematoda | 165 | 3.03e-36 | NTclustered | gi|256709124|gb|GQ422214.1| | 560213 | g47342 | i0 | 80.263 | 74.2899628252788 | 228 | 37 | 83 | 8 | 1 | 224 | 504 | 727 | Diplogasteroides magnus large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 19984 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteroididae | Diplogasteroides | Diplogasteroides magnus | |
| 15810798 | 15810798 | PRJNA540466_S_NODE_35053_length_307_cov_1.645299_g34504_i0 | PRJNA540466 | 35053 | 307 | 1.645299 | 5.05106793 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 564 | 2.98e-156 | NTclustered | gi|1972266114|ref|NM_001027628.8| | 6239 | g34504 | i0 | 100 | 5.68403908794788 | 305 | 0 | 99 | 0 | 3 | 307 | 1101 | 797 | Caenorhabditis elegans ADP/ATP translocase (ant-1.1), mRNA | blastn | 1745 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 17085621 | 17085621 | PRJNA540466_S_NODE_49054_length_266_cov_2.284974_g48505_i0 | PRJNA540466 | 49054 | 266 | 2.284974 | 6.07803084 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 453 | 5.71e-123 | NTclustered | gi|1972264789|ref|NM_066171.10| | 6239 | g48505 | i0 | 100 | 51.3947368421053 | 245 | 0 | 92 | 0 | 22 | 266 | 136 | 380 | Caenorhabditis elegans Small ribosomal subunit protein uS11 (rps-14), mRNA | blastn | 13671 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 17696431 | 17696431 | PRJNA540466_S_NODE_62094_length_244_cov_0.900585_g61545_i0 | PRJNA540466 | 62094 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Nematoda | Nematoda | 159 | 1.2599999999999999e-34 | NTclustered | gi|2445348377|ref|XM_003109331.2| | 31234 | g61545 | i0 | 83.333 | 3.01639344262295 | 174 | 27 | 71 | 2 | 38 | 210 | 562 | 734 | Caenorhabditis remanei uncharacterized protein (GCK72_000822), partial mRNA | blastn | 736 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 20910029 | 20910029 | PRJNA540466_S_NODE_31017_length_324_cov_1.067729_g30468_i0 | PRJNA540466 | 31017 | 324 | 1.067729 | 3.45944196 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 575 | 1.4599999999999995e-159 | NTclustered | gi|687865451|emb|LK927650.1| | 6239 | g30468 | i0 | 100 | 2.79012345679012 | 311 | 0 | 96 | 0 | 1 | 311 | 74894 | 74584 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000107 | blastn | 904 | 575 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 20910181 | 20910181 | PRJNA540466_S_NODE_50437_length_263_cov_2.184211_g49888_i0 | PRJNA540466 | 50437 | 263 | 2.184211 | 5.74447493 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 150 | 8.279999999999998e-32 | NTclustered | gi|1376143403|ref|XM_024652078.1| | 34506 | g49888 | i0 | 86.331 | 16.7186311787072 | 139 | 17 | 52 | 2 | 34 | 171 | 1181 | 1318 | Strongyloides ratti Elongation factor 1-alpha (SRAE_2000115900), partial mRNA | blastn | 4397 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22184874 | 22184874 | PRJNA540466_S_NODE_45558_length_274_cov_3.895522_g45009_i0 | PRJNA540466 | 45558 | 274 | 3.895522 | 10.67373028 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 490 | 4.499999999999999e-134 | NTclustered | gi|1972297290|ref|NM_074459.8| | 6239 | g45009 | i0 | 100 | 4.43430656934307 | 265 | 0 | 97 | 0 | 4 | 268 | 21 | 285 | Caenorhabditis elegans Large ribosomal subunit protein eL38 (rpl-38), mRNA | blastn | 1215 | 490 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23460151 | 23460151 | PRJNA540466_S_NODE_27879_length_339_cov_2.560150_g27330_i0 | PRJNA540466 | 27879 | 339 | 2.56015 | 8.6789085 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 52.8 | 0.032 | NTclustered | gi|2445383759|ref|XM_053732915.1| | 31234 | g27330 | i0 | 100 | 0.165191740412979 | 28 | 0 | 8 | 0 | 187 | 214 | 630 | 657 | Caenorhabditis remanei uncharacterized protein (GCK72_019189), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 23460261 | 23460261 | PRJNA540466_S_NODE_38979_length_293_cov_2.881818_g38430_i0 | PRJNA540466 | 38979 | 293 | 2.881818 | 8.44372674 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 401 | 2.3399999999999992e-107 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g38430 | i0 | 98.678 | 78.2354948805461 | 227 | 1 | 77 | 2 | 69 | 293 | 247 | 21 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 22923 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 24734198 | 24734198 | PRJNA540466_S_NODE_61100_length_245_cov_1.354651_g60551_i0 | PRJNA540466 | 61100 | 245 | 1.354651 | 3.31889495 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 431 | 2.4299999999999996e-116 | NTclustered | gi|1972298706|ref|NM_075232.9| | 6239 | g60551 | i0 | 99.576 | 3.58367346938775 | 236 | 1 | 96 | 0 | 10 | 245 | 5 | 240 | Caenorhabditis elegans transcellular chaperone signaling (x)cross tissue (txt-14), mRNA | blastn | 878 | 431 | 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);;