contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1269306 | 1269306 | PRJNA980585_P_NODE_21301_length_316_cov_1.189300_g21047_i0 | PRJNA980585 | 21301 | 316 | 1.1893 | 3.758188 | Rhabditidae | 6243 | Nematoda | Nematoda | 128 | 4.78e-25 | NTclustered | gi|157431636|gb|AY602177.2| | 35559 | g21047 | i0 | 96.203 | 24.8544303797468 | 79 | 2 | 25 | 1 | 1 | 79 | 1901 | 1824 | Rhabditella axei strain DF5006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7854 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditella | Rhabditella axei | |
| 3821326 | 3821326 | PRJNA980585_P_NODE_38743_length_255_cov_1.692308_g38489_i0 | PRJNA980585 | 38743 | 255 | 1.692308 | 4.3153854 | Aphelenchoides | 90723 | Nematoda | Nematoda | 383 | 7.23e-102 | NTclustered | gi|975149648|gb|KT692695.1| | 1052528 | g38489 | i0 | 94.048 | 63.1490196078431 | 252 | 15 | 99 | 0 | 4 | 255 | 269 | 18 | Aphelenchoides fujianensis isolate DJ12F clone 1 28S ribosomal RNA gene, partial sequence | blastn | 16103 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 4783207 | 4783207 | PRJNA980585_P_NODE_49484_length_247_cov_0.885057_g49230_i0 | PRJNA980585 | 49484 | 247 | 0.885057 | 2.18609079 | Tylopharynx sp. WEM-2009 | 669147 | Nematoda | Nematoda | 206 | 1.6199999999999998e-48 | NTclustered | gi|256709136|gb|GQ422220.1| | 669147 | g49230 | i0 | 82.759 | 71.6072874493927 | 232 | 38 | 94 | 2 | 2 | 232 | 645 | 415 | Tylopharynx sp. WEM-2009 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 17687 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Tylopharyngidae | Tylopharynx | Tylopharynx sp. WEM-2009 | |
| 5097621 | 5097621 | PRJNA980585_P_NODE_11544_length_398_cov_7.873846_g11290_i0 | PRJNA980585 | 11544 | 398 | 7.873846 | 31.33790708 | Metazoa | 33208 | Nematoda | Nematoda | 320 | 9.46e-83 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g11290 | i0 | 84.688 | 79.1507537688442 | 320 | 49 | 80 | 0 | 12 | 331 | 374 | 55 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 31502 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 6058389 | 6058389 | PRJNA980585_P_NODE_52725_length_245_cov_0.895349_g52471_i0 | PRJNA980585 | 52725 | 245 | 0.895349 | 2.19360505 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 448 | 2.41e-121 | NTclustered | gi|156399|gb|J01050.1|CELMYUNC | 6239 | g52471 | i0 | 99.592 | 5.98367346938775 | 245 | 1 | 100 | 0 | 1 | 245 | 5916 | 5672 | Caenorhabditis elegans myosin heavy chain (unc54) gene, complete cds | blastn | 1466 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8607343 | 8607343 | PRJNA980585_P_NODE_14907_length_360_cov_4.418118_g14653_i0 | PRJNA980585 | 14907 | 360 | 4.418118 | 15.9052248 | Necator americanus | 51031 | Nematoda | Nematoda | 296 | 1.43e-75 | NTclustered | gi|2707603671|ref|XM_064207038.1| | 51031 | g14653 | i0 | 82.216 | 93.1555555555556 | 343 | 61 | 95 | 0 | 13 | 355 | 11 | 353 | Necator americanus uncharacterized protein (RB195_016055), partial mRNA | blastn | 33536 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 8922277 | 8922277 | PRJNA980585_P_NODE_38227_length_257_cov_1.255435_g37973_i0 | PRJNA980585 | 38227 | 257 | 1.255435 | 3.22646795 | Nematoda | 6231 | Nematoda | Nematoda | 163 | 1.04e-35 | NTclustered | gi|687022666|emb|LM525580.1| | 174720 | g37973 | i0 | 84.337 | 14.3424124513619 | 166 | 26 | 65 | 0 | 3 | 168 | 236998 | 237163 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000007 | blastn | 3686 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 10198061 | 10198061 | PRJNA980585_P_NODE_49928_length_246_cov_3.520231_g49674_i0 | PRJNA980585 | 49928 | 246 | 3.520231 | 8.65976826 | Metazoa | 33208 | Nematoda | Nematoda | 99 | 2.81e-16 | NTclustered | gi|150982145|gb|EF634661.1| | 452808 | g49674 | i0 | 86.022 | 20.1382113821138 | 93 | 11 | 37 | 2 | 72 | 163 | 391 | 300 | Pristionchus sp. 14 RS5230 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 4954 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 14 RS5230 | |
| 12433731 | 12433731 | PRJNA980585_P_NODE_20650_length_320_cov_1.056680_g20396_i0 | PRJNA980585 | 20650 | 320 | 1.05668 | 3.381376 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|334262922|gb|JF826240.1| | 29170 | g20396 | i0 | 100 | 0.090625 | 29 | 0 | 9 | 0 | 46 | 74 | 579 | 551 | Ancylostoma caninum small GTPase cdc-42 mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 16571769 | 16571769 | PRJNA980585_P_NODE_11613_length_397_cov_2.614198_g11359_i0 | PRJNA980585 | 11613 | 397 | 2.614198 | 10.37836606 | Opisthokonta | 33154 | Nematoda | Nematoda | 54.7 | 0.011 | NTclustered | gi|2158413889|ref|XM_045235375.1| | 6238 | g11359 | i0 | 100 | 0.153652392947103 | 29 | 0 | 7 | 0 | 120 | 148 | 474 | 446 | Caenorhabditis briggsae Protein CBG05506 (CBG05506), partial mRNA | blastn | 61 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 17532858 | 17532858 | PRJNA980585_P_NODE_41034_length_251_cov_0.865169_g40780_i0 | PRJNA980585 | 41034 | 251 | 0.865169 | 2.17157419 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 158 | 4.69e-34 | NTclustered | gi|308452822|ref|XM_003089146.1| | 31234 | g40780 | i0 | 85.161 | 17.5258964143426 | 155 | 21 | 61 | 2 | 1 | 154 | 248 | 95 | Caenorhabditis remanei uncharacterized protein (GCK72_014297), partial mRNA | blastn | 4399 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 17847004 | 17847004 | PRJNA980585_P_NODE_50574_length_246_cov_0.890173_g50320_i0 | PRJNA980585 | 50574 | 246 | 0.890173 | 2.18982558 | Caenorhabditis | 6237 | Nematoda | Nematoda | 121 | 6.01e-23 | NTclustered | gi|268558427|ref|XM_002637158.1| | 6238 | g50320 | i0 | 82.27 | 2.45121951219512 | 141 | 23 | 57 | 2 | 3 | 142 | 61 | 200 | Caenorhabditis briggsae Protein CBR-EMO-1 (Cbr-emo-1), partial mRNA | blastn | 603 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 20395711 | 20395711 | PRJNA980585_P_NODE_25036_length_296_cov_0.919283_g24782_i0 | PRJNA980585 | 25036 | 296 | 0.919283 | 2.72107768 | Metazoa | 33208 | Nematoda | Nematoda | 176 | 1.56e-39 | NTclustered | gi|2707544751|ref|XM_064178973.1| | 51031 | g24782 | i0 | 85.976 | 51.4189189189189 | 164 | 23 | 55 | 0 | 133 | 296 | 519 | 356 | Necator americanus uncharacterized protein (RB195_006096), partial mRNA | blastn | 15220 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 21356619 | 21356619 | PRJNA980585_P_NODE_24117_length_300_cov_1.859031_g23863_i0 | PRJNA980585 | 24117 | 300 | 1.859031 | 5.577093 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 237 | 7.18e-58 | NTclustered | gi|268559799|ref|XM_002646027.1| | 6238 | g23863 | i0 | 88.718 | 64.24 | 195 | 20 | 65 | 2 | 1 | 194 | 1114 | 1307 | Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA | blastn | 19272 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 23907472 | 23907472 | PRJNA980585_P_NODE_45139_length_249_cov_0.875000_g44885_i0 | PRJNA980585 | 45139 | 249 | 0.875 | 2.17875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 158 | 4.639999999999999e-34 | NTclustered | gi|687865590|emb|LK927653.1| | 6239 | g44885 | i0 | 87.97 | 10.7670682730924 | 133 | 16 | 53 | 0 | 23 | 155 | 95477 | 95345 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000016 | blastn | 2681 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25180615 | 25180615 | PRJNA980585_P_NODE_18960_length_330_cov_1.198444_g18706_i0 | PRJNA980585 | 18960 | 330 | 1.198444 | 3.9548652 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 206 | 2.25e-48 | NTclustered | gi|268559571|ref|XM_002637731.1| | 6238 | g18706 | i0 | 81.855 | 32.4393939393939 | 248 | 41 | 75 | 4 | 9 | 254 | 1081 | 1326 | Caenorhabditis briggsae Protein CBR-DAF-21 (Cbr-daf-21), partial mRNA | blastn | 10705 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae |
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);;