contig_metadata
16 rows where bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671578 | 671578 | PRJNA690592_S_NODE_21921_length_639_cov_4.625442_g20944_i0 | PRJNA690592 | 21921 | 639 | 4.625442 | 29.55657438 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 760 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g20944 | i0 | 88.106 | 3.92175273865415 | 639 | 76 | 100 | 0 | 1 | 639 | 10940 | 10302 | Lepidodermella squamata mitochondrion, complete genome | blastn | 2506 | 760 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 1946730 | 1946730 | PRJNA690592_S_NODE_101822_length_325_cov_1.773810_g100808_i0 | PRJNA690592 | 101822 | 325 | 1.77381 | 5.7648825 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 313 | 1.27e-80 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g100808 | i0 | 84.049 | 3.78153846153846 | 326 | 50 | 100 | 2 | 1 | 325 | 4095 | 3771 | Lepidodermella squamata mitochondrion, complete genome | blastn | 1229 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 1948000 | 1948000 | PRJNA690592_S_NODE_7482_length_1024_cov_3.382755_g6850_i0 | PRJNA690592 | 7482 | 1024 | 3.382755 | 34.6394112 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1074 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g6850 | i0 | 85.785 | 9.9560546875 | 1013 | 144 | 99 | 0 | 12 | 1024 | 2919 | 1907 | Lepidodermella squamata mitochondrion, complete genome | blastn | 10195 | 1074 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 7556937 | 7556937 | PRJNA690592_S_NODE_214786_length_241_cov_1.232143_g213772_i0 | PRJNA690592 | 214786 | 241 | 1.232143 | 2.96946463 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 144 | 1.42e-38 | NR | YP_009136573.1 | 1194616 | g213772 | i0 | 97.4 | 0.95850622406639 | 77 | 2 | 95.9 | 0 | 11 | 241 | 207 | 283 | YP_009136573.1 NADH dehydrogenase subunit 5 [Lepidodermella squamata] | diamond | 231 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 8324828 | 8324828 | PRJNA690592_S_NODE_36707_length_503_cov_5.232558_g35697_i0 | PRJNA690592 | 36707 | 503 | 5.232558 | 26.31976674 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 636 | 1.0699999999999998e-177 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g35697 | i0 | 89.463 | 2.26640159045726 | 503 | 53 | 100 | 0 | 1 | 503 | 9534 | 10036 | Lepidodermella squamata mitochondrion, complete genome | blastn | 1140 | 636 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 9599352 | 9599352 | PRJNA690592_S_NODE_121368_length_303_cov_1.182609_g120354_i0 | PRJNA690592 | 121368 | 303 | 1.182609 | 3.58330527 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 538 | 1.7799999999999995e-148 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g120354 | i0 | 98.684 | 20.1980198019802 | 304 | 3 | 100 | 1 | 1 | 303 | 7997 | 8300 | Lepidodermella squamata mitochondrion, complete genome | blastn | 6120 | 538 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 9599985 | 9599985 | PRJNA690592_S_NODE_212708_length_242_cov_0.911243_g211694_i0 | PRJNA690592 | 212708 | 242 | 0.911243 | 2.20520806 | Chaetonotus sp. p AK-2024 | 3232324 | Gastrotricha | other_Eukaryota | 108 | 4.59e-19 | NTclustered | gi|2758337515|gb|PQ009211.1| | 3232324 | g211694 | i0 | 100 | 25.603305785124 | 58 | 0 | 24 | 0 | 1 | 58 | 2522 | 2465 | Chaetonotus sp. p AK-2024 voucher W6 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 6196 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Chaetonotus | Chaetonotus sp. p AK-2024 | ||
| 10876174 | 10876174 | PRJNA690592_S_NODE_93309_length_337_cov_1.079545_g92295_i0 | PRJNA690592 | 93309 | 337 | 1.079545 | 3.63806665 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 601 | 2.52e-167 | NTclustered | gi|478683567|gb|KC193103.1| | 1194616 | g92295 | i0 | 98.813 | 100.121661721068 | 337 | 4 | 100 | 0 | 1 | 337 | 2492 | 2156 | Lepidodermella squamata 28S ribosomal RNA gene, partial sequence | blastn | 33741 | 601 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 15973494 | 15973494 | PRJNA690592_S_NODE_11093_length_868_cov_4.901887_g10308_i0 | PRJNA690592 | 11093 | 868 | 4.901887 | 42.54837916 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 994 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g10308 | i0 | 87.342 | 2.00691244239631 | 869 | 109 | 100 | 1 | 1 | 868 | 7565 | 6697 | Lepidodermella squamata mitochondrion, complete genome | blastn | 1742 | 994 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 23624644 | 23624644 | PRJNA690592_S_NODE_6519_length_1082_cov_223.839445_g5933_i0 | PRJNA690592 | 6519 | 1082 | 223.839445 | 2421.9427949 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1886 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g5933 | i0 | 98.327 | 4.12661737523105 | 1076 | 17 | 99 | 1 | 3 | 1077 | 8387 | 9462 | Lepidodermella squamata mitochondrion, complete genome | blastn | 4465 | 1886 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 24897840 | 24897840 | PRJNA690592_S_NODE_2280_length_1576_cov_4.391218_g1965_i0 | PRJNA690592 | 2280 | 1576 | 4.391218 | 69.20559568 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1953 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g1965 | i0 | 89.165 | 44.6142131979695 | 1569 | 166 | 99 | 3 | 8 | 1573 | 12781 | 14348 | Lepidodermella squamata mitochondrion, complete genome | blastn | 70312 | 1953 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 24898455 | 24898455 | PRJNA690592_S_NODE_99540_length_328_cov_1.607843_g98526_i0 | PRJNA690592 | 99540 | 328 | 1.607843 | 5.27372504 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 278 | 4.68e-70 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g98526 | i0 | 82.243 | 3.1859756097561 | 321 | 57 | 98 | 0 | 4 | 324 | 1134 | 814 | Lepidodermella squamata mitochondrion, complete genome | blastn | 1045 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 27145300 | 27145300 | PRJNA690592_S_NODE_30322_length_550_cov_1.756813_g29318_i0 | PRJNA690592 | 30322 | 550 | 1.756813 | 9.6624715 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 278 | 4.7e-89 | NR | YP_009136572.1 | 1194616 | g29318 | i0 | 98.1 | 0.845454545454545 | 155 | 3 | 84.5 | 0 | 85 | 549 | 254 | 408 | YP_009136572.1 NADH dehydrogenase subunit 4 [Lepidodermella squamata] | diamond | 465 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 28566737 | 28566737 | PRJNA690592_S_NODE_208767_length_243_cov_1.358824_g207753_i0 | PRJNA690592 | 208767 | 243 | 1.358824 | 3.30194232 | Litigonotus ghinii | 3104745 | Gastrotricha | other_Eukaryota | 124 | 1.2499999999999998e-32 | NR | XCN99742.1 | 3104745 | g207753 | i0 | 78.5 | 0.975308641975309 | 79 | 17 | 97.5 | 0 | 239 | 3 | 10 | 88 | XCN99742.1 NADH dehydrogenase subunit 2 [Litigonotus ghinii] | diamond | 237 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Litigonotus | Litigonotus ghinii | ||
| 31757675 | 31757675 | PRJNA690592_S_NODE_68697_length_383_cov_1.680645_g67683_i0 | PRJNA690592 | 68697 | 383 | 1.680645 | 6.43687035 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 224 | 3.2e-68 | NR | YP_009136573.1 | 1194616 | g67683 | i0 | 95.3 | 0.994778067885117 | 127 | 6 | 99.5 | 0 | 3 | 383 | 13 | 139 | YP_009136573.1 NADH dehydrogenase subunit 5 [Lepidodermella squamata] | diamond | 381 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 32769045 | 32769045 | PRJNA690592_S_NODE_43240_length_468_cov_1.987342_g42226_i0 | PRJNA690592 | 43240 | 468 | 1.987342 | 9.30076056 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 216 | 5.59e-67 | NR | YP_009136579.1 | 1194616 | g42226 | i0 | 91.4 | 0.82051282051282 | 128 | 11 | 82.1 | 0 | 8 | 391 | 164 | 291 | YP_009136579.1 NADH dehydrogenase subunit 2 [Lepidodermella squamata] | diamond | 384 | 216 | 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);;