contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_phylum = "Gastrotricha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 401096 | 401096 | PRJNA379145_P_NODE_57421_length_199_cov_1.536145_g55267_i0 | PRJNA379145 | 57421 | 199 | 1.536145 | 3.05692855 | Lepidodermella sp. DMW-2003 | 249249 | Gastrotricha | other_Eukaryota | 187 | 4.54e-43 | NTclustered | gi|37675450|gb|AY394702.1| | 249249 | g55267 | i0 | 89.262 | 89 | 149 | 16 | 99 | 0 | 51 | 199 | 295 | 147 | Lepidodermella sp. DMW-2003 82kD heat-shock protein, partial sequence | blastn | 17711 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella sp. DMW-2003 | ||
| 4228154 | 4228154 | PRJNA379145_P_NODE_49824_length_234_cov_2.407960_g47670_i0 | PRJNA379145 | 49824 | 234 | 2.40796 | 5.6346264 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 433 | 6.41e-117 | NTclustered | gi|389075661|gb|JN185539.1| | 1194616 | g47670 | i0 | 100 | 98.8247863247863 | 234 | 0 | 100 | 0 | 1 | 234 | 2110 | 1877 | Lepidodermella squamata voucher TK97 28S ribosomal RNA gene, partial sequence | blastn | 23125 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 5504817 | 5504817 | PRJNA379145_P_NODE_7525_length_1109_cov_6.328067_g6627_i0 | PRJNA379145 | 7525 | 1109 | 6.328067 | 70.17826303 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1123 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g6627 | i0 | 84.982 | 4.36699729486023 | 1112 | 161 | 100 | 6 | 1 | 1109 | 3010 | 1902 | Lepidodermella squamata mitochondrion, complete genome | blastn | 4843 | 1123 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 6778304 | 6778304 | PRJNA379145_P_NODE_15586_length_715_cov_14.214076_g13939_i0 | PRJNA379145 | 15586 | 715 | 14.214076 | 101.6306434 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 686 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g13939 | i0 | 84.1 | 1.0027972027972 | 717 | 106 | 100 | 5 | 1 | 715 | 6743 | 7453 | Lepidodermella squamata mitochondrion, complete genome | blastn | 717 | 686 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 7451959 | 7451959 | PRJNA379145_P_NODE_36746_length_333_cov_3.070000_g34598_i0 | PRJNA379145 | 36746 | 333 | 3.07 | 10.2231 | Chaetonotus | 68038 | Gastrotricha | other_Eukaryota | 516 | 9.26e-142 | NTclustered | gi|440197672|gb|JQ798548.1| | 1274944 | g34598 | i0 | 94.848 | 99.1171171171171 | 330 | 17 | 99 | 0 | 1 | 330 | 555 | 884 | Chaetonotus cf. similis TK106 18S ribosomal RNA gene, partial sequence | blastn | 33006 | 521 | 0.990403071017274 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Chaetonotus | Chaetonotus cf. similis TK106 | ||
| 8053856 | 8053856 | PRJNA379145_P_NODE_17787_length_650_cov_9.324149_g16017_i0 | PRJNA379145 | 17787 | 650 | 9.324149 | 60.6069685 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 595 | 2.379999999999999e-165 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g16017 | i0 | 86.447 | 0.884615384615385 | 546 | 71 | 84 | 3 | 105 | 650 | 10074 | 9532 | Lepidodermella squamata mitochondrion, complete genome | blastn | 575 | 595 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 8054276 | 8054276 | PRJNA379145_P_NODE_56307_length_203_cov_1.782353_g54153_i0 | PRJNA379145 | 56307 | 203 | 1.782353 | 3.61817659 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 364 | 2e-96 | NTclustered | gi|389075661|gb|JN185539.1| | 1194616 | g54153 | i0 | 99.015 | 100.738916256158 | 203 | 2 | 100 | 0 | 1 | 203 | 1026 | 824 | Lepidodermella squamata voucher TK97 28S ribosomal RNA gene, partial sequence | blastn | 20450 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 10604646 | 10604646 | PRJNA379145_P_NODE_38729_length_314_cov_2.412811_g36578_i0 | PRJNA379145 | 38729 | 314 | 2.412811 | 7.57622654 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 178 | 4.649999999999999e-40 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g36578 | i0 | 89.928 | 0.442675159235669 | 139 | 12 | 44 | 2 | 1 | 138 | 3166 | 3303 | Lepidodermella squamata mitochondrion, complete genome | blastn | 139 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 11879696 | 11879696 | PRJNA379145_P_NODE_48790_length_240_cov_2.251208_g46636_i0 | PRJNA379145 | 48790 | 240 | 2.251208 | 5.4028992 | Litigonotus ghinii | 3104745 | Gastrotricha | other_Eukaryota | 159 | 1.24e-34 | NTclustered | gi|2756221437|gb|PP105008.1| | 3104745 | g46636 | i0 | 79.412 | 0.991666666666667 | 238 | 40 | 96 | 4 | 1 | 230 | 4815 | 5051 | Litigonotus ghinii isolate HET1 mitochondrion, complete genome | blastn | 238 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Litigonotus | Litigonotus ghinii | ||
| 15703368 | 15703368 | PRJNA379145_P_NODE_20653_length_580_cov_2.714808_g18771_i0 | PRJNA379145 | 20653 | 580 | 2.714808 | 15.7458864 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 983 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g18771 | i0 | 97.251 | 2.00689655172414 | 582 | 13 | 100 | 3 | 1 | 580 | 8236 | 7656 | Lepidodermella squamata mitochondrion, complete genome | blastn | 1164 | 983 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 16978335 | 16978335 | PRJNA379145_P_NODE_48394_length_242_cov_3.421053_g46240_i0 | PRJNA379145 | 48394 | 242 | 3.421053 | 8.27894826 | Chaetonotus aff. maximus MK-2019 | 2614550 | Gastrotricha | other_Eukaryota | 302 | 1.96e-77 | NTclustered | gi|1748014055|gb|MN496273.1| | 2614550 | g46240 | i0 | 91.743 | 91.1776859504132 | 218 | 16 | 90 | 2 | 6 | 222 | 3385 | 3601 | Chaetonotus aff. maximus MK-2019 voucher HA_28.5 large subunit ribosomal RNA gene, partial sequence | blastn | 22065 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Chaetonotus | Chaetonotus aff. maximus MK-2019 | ||
| 18252727 | 18252727 | PRJNA379145_P_NODE_62695_length_179_cov_2.363014_g60541_i0 | PRJNA379145 | 62695 | 179 | 2.363014 | 4.22979506 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 196 | 6.62e-46 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g60541 | i0 | 90.667 | 2.3072625698324 | 150 | 10 | 83 | 4 | 1 | 148 | 1354 | 1501 | Lepidodermella squamata mitochondrion, complete genome | blastn | 413 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 18252751 | 18252751 | PRJNA379145_P_NODE_6515_length_1192_cov_9.119068_g5727_i0 | PRJNA379145 | 6515 | 1192 | 9.119068 | 108.69929056 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 800 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g5727 | i0 | 85.363 | 8.87751677852349 | 772 | 113 | 65 | 0 | 421 | 1192 | 10297 | 11068 | Lepidodermella squamata mitochondrion, complete genome | blastn | 10582 | 800 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 19526617 | 19526617 | PRJNA379145_P_NODE_30176_length_414_cov_1.669291_g28056_i0 | PRJNA379145 | 30176 | 414 | 1.669291 | 6.91086474 | Lepidodermella sp. DMW-2003 | 249249 | Gastrotricha | other_Eukaryota | 383 | 1.2399999999999996e-101 | NTclustered | gi|37675450|gb|AY394702.1| | 249249 | g28056 | i0 | 89.216 | 64.6545893719807 | 306 | 33 | 74 | 0 | 1 | 306 | 519 | 824 | Lepidodermella sp. DMW-2003 82kD heat-shock protein, partial sequence | blastn | 26767 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella sp. DMW-2003 | ||
| 20802277 | 20802277 | PRJNA379145_P_NODE_3557_length_1527_cov_9.825971_g3086_i0 | PRJNA379145 | 3557 | 1527 | 9.825971 | 150.04257717 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1592 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g3086 | i0 | 85.508 | 46.3339882121807 | 1525 | 221 | 99 | 0 | 3 | 1527 | 14365 | 12841 | Lepidodermella squamata mitochondrion, complete genome | blastn | 70752 | 1592 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 24627488 | 24627488 | PRJNA379145_P_NODE_8000_length_1074_cov_118.636888_g7044_i0 | PRJNA379145 | 8000 | 1074 | 118.636888 | 1274.16017712 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1773 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g7044 | i0 | 96.717 | 11.2830540037244 | 1066 | 34 | 99 | 1 | 10 | 1074 | 9460 | 8395 | Lepidodermella squamata mitochondrion, complete genome | blastn | 12118 | 1773 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata |
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);;