contig_metadata
15 rows where bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9675363 | 9675363 | PRJNA770826_P_NODE_3608_length_454_cov_1.629630_g3437_i0 | PRJNA770826 | 3608 | 454 | 1.62963 | 7.3985202 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 451 | 3.71e-122 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g3437 | i0 | 84.615 | 7.84801762114537 | 455 | 68 | 100 | 2 | 1 | 454 | 2504 | 2957 | Lepidodermella squamata mitochondrion, complete genome | blastn | 3563 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 11410514 | 11410514 | PRJNA770826_P_NODE_16689_length_198_cov_1.322148_g16518_i0 | PRJNA770826 | 16689 | 198 | 1.322148 | 2.61785304 | Chaetonotidae | 41372 | Gastrotricha | other_Eukaryota | 361 | 2.51e-95 | NTclustered | gi|478683567|gb|KC193103.1| | 1194616 | g16518 | i0 | 99.495 | 100.126262626263 | 198 | 1 | 100 | 0 | 1 | 198 | 1947 | 2144 | Lepidodermella squamata 28S ribosomal RNA gene, partial sequence | blastn | 19825 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 12686358 | 12686358 | PRJNA770826_P_NODE_9610_length_261_cov_0.948113_g9439_i0 | PRJNA770826 | 9610 | 261 | 0.948113 | 2.47457493 | Lepidodermella | 41322 | Gastrotricha | other_Eukaryota | 322 | 1.64e-83 | NTclustered | gi|1418591758|gb|MF325900.1| | 2259395 | g9439 | i0 | 93.213 | 80.9425287356322 | 221 | 12 | 84 | 2 | 44 | 261 | 3629 | 3409 | Lepidodermella polaris isolate AMU234.16 28S ribosomal RNA gene, partial sequence | blastn | 21126 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella polaris | ||
| 16509626 | 16509626 | PRJNA770826_P_NODE_25373_length_168_cov_1.310924_g25202_i0 | PRJNA770826 | 25373 | 168 | 1.310924 | 2.20235232 | Chaetonotidae | 41372 | Gastrotricha | other_Eukaryota | 311 | 2.11e-80 | NTclustered | gi|478683567|gb|KC193103.1| | 1194616 | g25202 | i0 | 100 | 98.5833333333333 | 168 | 0 | 100 | 0 | 1 | 168 | 2865 | 2698 | Lepidodermella squamata 28S ribosomal RNA gene, partial sequence | blastn | 16562 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 17325285 | 17325285 | PRJNA770826_P_NODE_5094_length_377_cov_1.625000_g4923_i0 | PRJNA770826 | 5094 | 377 | 1.625 | 6.12625 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 475 | 1.8e-129 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g4923 | i0 | 89.946 | 2.09549071618037 | 368 | 37 | 98 | 0 | 10 | 377 | 9901 | 9534 | Lepidodermella squamata mitochondrion, complete genome | blastn | 790 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 19873745 | 19873745 | PRJNA770826_P_NODE_596_length_1044_cov_11.972864_g502_i0 | PRJNA770826 | 596 | 1044 | 11.972864 | 124.99670016 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1849 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g502 | i0 | 98.658 | 11.7978927203065 | 1043 | 14 | 99 | 0 | 2 | 1044 | 9456 | 8414 | Lepidodermella squamata mitochondrion, complete genome | blastn | 12317 | 1849 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 19873767 | 19873767 | PRJNA770826_P_NODE_8416_length_280_cov_1.653680_g8245_i0 | PRJNA770826 | 8416 | 280 | 1.65368 | 4.630304 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 472 | 1.6699999999999998e-128 | NTclustered | gi|389075619|gb|JN185518.1| | 1194616 | g8245 | i0 | 97.143 | 95.5142857142857 | 280 | 6 | 100 | 2 | 1 | 280 | 383 | 660 | Lepidodermella squamata voucher TK163 28S ribosomal RNA gene, partial sequence | blastn | 26744 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 22424268 | 22424268 | PRJNA770826_P_NODE_4838_length_389_cov_1.376471_g4667_i0 | PRJNA770826 | 4838 | 389 | 1.376471 | 5.35447219 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 425 | 1.9e-114 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g4667 | i0 | 86.375 | 1.19280205655527 | 389 | 53 | 100 | 0 | 1 | 389 | 10601 | 10989 | Lepidodermella squamata mitochondrion, complete genome | blastn | 464 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 22424302 | 22424302 | PRJNA770826_P_NODE_8598_length_277_cov_1.210526_g8427_i0 | PRJNA770826 | 8598 | 277 | 1.210526 | 3.35315702 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 394 | 3.68e-105 | NTclustered | gi|389075756|gb|JN185551.1| | 1194616 | g8427 | i0 | 94.51 | 64.7942238267148 | 255 | 14 | 92 | 0 | 1 | 255 | 255 | 1 | Lepidodermella squamata voucher TK163 cytochrome c oxidase subunit I gene, partial cds; mitochondrial | blastn | 17948 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 22424306 | 22424306 | PRJNA770826_P_NODE_9378_length_264_cov_1.693023_g9207_i0 | PRJNA770826 | 9378 | 264 | 1.693023 | 4.46958072 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 272 | 1.6999999999999999e-68 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g9207 | i0 | 85.441 | 0.988636363636364 | 261 | 38 | 99 | 0 | 1 | 261 | 7114 | 7374 | Lepidodermella squamata mitochondrion, complete genome | blastn | 261 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 23699960 | 23699960 | PRJNA770826_P_NODE_7419_length_302_cov_1.849802_g7248_i0 | PRJNA770826 | 7419 | 302 | 1.849802 | 5.58640204 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 551 | 2.2699999999999992e-152 | NTclustered | gi|389075443|gb|JN185481.1| | 1194616 | g7248 | i0 | 99.669 | 100.069536423841 | 302 | 0 | 100 | 1 | 1 | 302 | 865 | 565 | Lepidodermella squamata voucher TK173 18S ribosomal RNA gene, partial sequence | blastn | 30221 | 551 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 24973600 | 24973600 | PRJNA770826_P_NODE_7740_length_294_cov_1.273469_g7569_i0 | PRJNA770826 | 7740 | 294 | 1.273469 | 3.74399886 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 141 | 2.36e-38 | NR | YP_009136570.1 | 1194616 | g7569 | i0 | 91.9 | 0.755102040816326 | 74 | 6 | 75.5 | 0 | 289 | 68 | 90 | 163 | YP_009136570.1 cytochrome b [Lepidodermella squamata] | diamond | 222 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 24973613 | 24973613 | PRJNA770826_P_NODE_900_length_884_cov_2.149701_g781_i0 | PRJNA770826 | 900 | 884 | 2.149701 | 19.00335684 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 1085 | 0 | NTclustered | gi|817528470|ref|NC_026985.1| | 1194616 | g781 | i0 | 88.801 | 56.6074660633484 | 884 | 99 | 100 | 0 | 1 | 884 | 13359 | 14242 | Lepidodermella squamata mitochondrion, complete genome | blastn | 50041 | 1085 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 28190017 | 28190017 | PRJNA770826_P_NODE_14846_length_209_cov_1.943750_g14675_i0 | PRJNA770826 | 14846 | 209 | 1.94375 | 4.0624375 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 89.4 | 3.32e-21 | NR | YP_009136578.1 | 1194616 | g14675 | i0 | 95.9 | 0.703349282296651 | 49 | 2 | 70.3 | 0 | 147 | 1 | 19 | 67 | YP_009136578.1 NADH dehydrogenase subunit 3 [Lepidodermella squamata] | diamond | 147 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 31507218 | 31507218 | PRJNA770826_P_NODE_9116_length_268_cov_1.821918_g8945_i0 | PRJNA770826 | 9116 | 268 | 1.821918 | 4.88274024 | Litigonotus ghinii | 3104745 | Gastrotricha | other_Eukaryota | 103 | 5.61e-25 | NR | XCN99738.1 | 3104745 | g8945 | i0 | 71.3 | 0.895522388059702 | 80 | 23 | 89.6 | 0 | 5 | 244 | 31 | 110 | XCN99738.1 ATP synthase F0 subunit 6 [Litigonotus ghinii] | diamond | 240 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Litigonotus | Litigonotus ghinii |
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);;