contig_metadata
6 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8054331 | 8054331 | PRJNA379145_P_NODE_6287_length_1211_cov_2.252122_g5523_i0 | PRJNA379145 | 6287 | 1211 | 2.252122 | 27.27319742 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 575 | 1.5599999999999995e-202 | NR | YP_009136572.1 | 1194616 | g5523 | i0 | 94 | 0.832369942196532 | 336 | 16 | 83.2 | 1 | 202 | 1209 | 73 | 404 | YP_009136572.1 NADH dehydrogenase subunit 4 [Lepidodermella squamata] | diamond | 1008 | 575 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 13154545 | 13154545 | PRJNA379145_P_NODE_34131_length_362_cov_2.817629_g31986_i0 | PRJNA379145 | 34131 | 362 | 2.817629 | 10.19981698 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 214 | 3.25e-67 | NR | YP_009136568.1 | 1194616 | g31986 | i0 | 94.7 | 0.94475138121547 | 114 | 6 | 94.5 | 0 | 1 | 342 | 173 | 286 | YP_009136568.1 NADH dehydrogenase subunit 1 [Lepidodermella squamata] | diamond | 342 | 214 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 27359582 | 27359582 | PRJNA379145_P_NODE_32163_length_386_cov_2.277620_g30028_i0 | PRJNA379145 | 32163 | 386 | 2.27762 | 8.7916132 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 93.6 | 6.92e-20 | NR | YP_009136579.1 | 1194616 | g30028 | i0 | 63.5 | 0.660621761658031 | 85 | 7 | 47.4 | 1 | 138 | 320 | 28 | 112 | YP_009136579.1 NADH dehydrogenase subunit 2 [Lepidodermella squamata] | diamond | 255 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 28906369 | 28906369 | PRJNA379145_P_NODE_37268_length_328_cov_2.155932_g35118_i0 | PRJNA379145 | 37268 | 328 | 2.155932 | 7.07145696 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 135 | 8.95e-39 | NR | YP_009136578.1 | 1194616 | g35118 | i0 | 90.5 | 0.676829268292683 | 74 | 7 | 67.7 | 0 | 310 | 89 | 1 | 74 | YP_009136578.1 NADH dehydrogenase subunit 3 [Lepidodermella squamata] | diamond | 222 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 29569583 | 29569583 | PRJNA379145_P_NODE_58490_length_194_cov_4.968944_g56336_i0 | PRJNA379145 | 58490 | 194 | 4.968944 | 9.63975136 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 111 | 1.04e-26 | NR | YP_009136573.1 | 1194616 | g56336 | i0 | 81.3 | 0.989690721649485 | 64 | 12 | 99 | 0 | 194 | 3 | 470 | 533 | YP_009136573.1 NADH dehydrogenase subunit 5 [Lepidodermella squamata] | diamond | 192 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Gastrotricha | Chaetonotida | Chaetonotidae | Lepidodermella | Lepidodermella squamata | ||
| 30391349 | 30391349 | PRJNA379145_P_NODE_23113_length_530_cov_2.450704_g21138_i0 | PRJNA379145 | 23113 | 530 | 2.450704 | 12.9887312 | Lepidodermella squamata | 1194616 | Gastrotricha | other_Eukaryota | 298 | 3.069999999999999e-96 | NR | YP_009136573.1 | 1194616 | g21138 | i0 | 88.6 | 0.99622641509434 | 176 | 20 | 99.6 | 0 | 1 | 528 | 238 | 413 | YP_009136573.1 NADH dehydrogenase subunit 5 [Lepidodermella squamata] | diamond | 528 | 298 | 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);;