contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4114194 | 4114194 | PRJNA1144090_P_NODE_29744_length_483_cov_2.234146_g29210_i0 | PRJNA1144090 | 29744 | 483 | 2.234146 | 10.79092518 | Oigolaimella sp. VS-2014 | 1538701 | Nematoda | Nematoda | 344 | 6.9299999999999984e-90 | NTclustered | gi|675118939|gb|KJ877349.1| | 1538701 | g29210 | i0 | 80 | 47.527950310559 | 485 | 81 | 99 | 15 | 6 | 482 | 483 | 7 | Oigolaimella sp. VS-2014 strain RS9010 large subunit ribosomal protein 10 (rpl-10) mRNA, partial cds | blastn | 22956 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella sp. VS-2014 | |
| 4114196 | 4114196 | PRJNA1144090_P_NODE_30004_length_480_cov_607.186732_g29470_i0 | PRJNA1144090 | 30004 | 480 | 607.186732 | 2914.4963136 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 52.8 | 0.047 | NTclustered | gi|2445383759|ref|XM_053732915.1| | 31234 | g29470 | i0 | 100 | 0.116666666666667 | 28 | 0 | 6 | 0 | 123 | 150 | 657 | 630 | Caenorhabditis remanei uncharacterized protein (GCK72_019189), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 9215017 | 9215017 | PRJNA1144090_P_NODE_121588_length_202_cov_5.131783_g121053_i0 | PRJNA1144090 | 121588 | 202 | 5.131783 | 10.36620166 | Cooperia oncophora | 27828 | Nematoda | Nematoda | 180 | 7.73e-41 | NTclustered | gi|38491404|gb|AY372758.1| | 27828 | g121053 | i0 | 83.957 | 42.0940594059406 | 187 | 30 | 93 | 0 | 15 | 201 | 31 | 217 | Cooperia oncophora actin mRNA, complete cds | blastn | 8503 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 9215905 | 9215905 | PRJNA1144090_P_NODE_93128_length_260_cov_1.229947_g92593_i0 | PRJNA1144090 | 93128 | 260 | 1.229947 | 3.1978622 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|687022652|emb|LM525566.1| | 174720 | g92593 | i0 | 96.875 | 0.123076923076923 | 32 | 0 | 12 | 1 | 170 | 201 | 440798 | 440768 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000003 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 13786318 | 13786318 | PRJNA1144090_P_NODE_12651_length_788_cov_6.048951_g12193_i0 | PRJNA1144090 | 12651 | 788 | 6.048951 | 47.66573388 | Metazoa | 33208 | Nematoda | Nematoda | 91.6 | 1.68e-13 | NTclustered | gi|2707548438|ref|XM_013445985.2| | 51031 | g12193 | i0 | 77.16 | 8.90355329949239 | 162 | 33 | 20 | 4 | 164 | 323 | 293 | 134 | Necator americanus uncharacterized protein (RB195_007272), partial mRNA | blastn | 7016 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 15590270 | 15590270 | PRJNA1144090_P_NODE_49553_length_362_cov_1519.349481_g49018_i0 | PRJNA1144090 | 49553 | 362 | 1519.349481 | 5500.04512122 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 52.8 | 0.034 | NTclustered | gi|2445383759|ref|XM_053732915.1| | 31234 | g49018 | i0 | 100 | 0.154696132596685 | 28 | 0 | 8 | 0 | 213 | 240 | 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 | |
| 16865030 | 16865030 | PRJNA1144090_P_NODE_97054_length_254_cov_1.469613_g96519_i0 | PRJNA1144090 | 97054 | 254 | 1.469613 | 3.73281702 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 248 | 2.74e-61 | NTclustered | gi|1376149319|ref|XM_024642975.1| | 34506 | g96519 | i0 | 84.585 | 96.9330708661417 | 253 | 35 | 99 | 4 | 3 | 253 | 94 | 344 | Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000414100), partial mRNA | blastn | 24621 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 18138610 | 18138610 | PRJNA1144090_P_NODE_103075_length_249_cov_0.875000_g102540_i0 | PRJNA1144090 | 103075 | 249 | 0.875 | 2.17875 | Brugia malayi | 6279 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|2082287633|ref|XM_043081495.1| | 6279 | g102540 | i0 | 96.875 | 0.1285140562249 | 32 | 0 | 13 | 1 | 142 | 173 | 605 | 575 | Brugia malayi Josephin family protein (Bma-atx-3), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 19413018 | 19413018 | PRJNA1144090_P_NODE_14176_length_741_cov_4.809880_g13701_i0 | PRJNA1144090 | 14176 | 741 | 4.80988 | 35.6412108 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 239 | 5.31e-58 | NTclustered | gi|1376146059|ref|XM_024653581.1| | 34506 | g13701 | i0 | 79.109 | 8.90013495276653 | 359 | 65 | 48 | 9 | 343 | 696 | 220 | 573 | Strongyloides ratti NADH dehydrogenase [ubiquinone] iron-sulfur protein 8, mitochondrial (SRAE_2000250600), partial mRNA | blastn | 6595 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 19413940 | 19413940 | PRJNA1144090_P_NODE_98756_length_251_cov_2.112360_g98221_i0 | PRJNA1144090 | 98756 | 251 | 2.11236 | 5.3020236 | Rhabditidoides sp. VS-2014 | 1538705 | Nematoda | Nematoda | 87.9 | 6.24e-13 | NTclustered | gi|675118780|gb|KJ877251.1| | 1538705 | g98221 | i0 | 83.696 | 23.3466135458167 | 92 | 15 | 37 | 0 | 160 | 251 | 3228 | 3137 | Rhabditidoides sp. VS-2014 strain RS5443 28S ribosomal RNA gene, partial sequence | blastn | 5860 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Rhabditidoides | Rhabditidoides sp. VS-2014 | |
| 24513605 | 24513605 | PRJNA1144090_P_NODE_79780_length_282_cov_1.842105_g79245_i0 | PRJNA1144090 | 79780 | 282 | 1.842105 | 5.1947361 | Necator americanus | 51031 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|2707542806|ref|XM_013436861.2| | 51031 | g79245 | i0 | 100 | 0.099290780141844 | 28 | 0 | 10 | 0 | 121 | 148 | 1620 | 1593 | Necator americanus uncharacterized protein (RB195_005476), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 24513734 | 24513734 | PRJNA1144090_P_NODE_91500_length_262_cov_1.830688_g90965_i0 | PRJNA1144090 | 91500 | 262 | 1.830688 | 4.79640256 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|1376153731|ref|XM_024649585.1| | 34506 | g90965 | i0 | 100 | 0.106870229007634 | 28 | 0 | 11 | 0 | 123 | 150 | 3385 | 3358 | Strongyloides ratti SAP domain-containing protein (SRAE_X000105100), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti |
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);;