contig_metadata
3 rows where bioproject = "PRJEB55122", tax_kingdom = "Metazoa" and tax_phylum = "Brachiopoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6498999 | 6498999 | PRJEB55122_P_NODE_2366_length_1031_cov_4.912424_g2131_i0 | PRJEB55122 | 2366 | 1031 | 4.912424 | 50.64709144 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 377 | 7.29e-127 | NR | XP_013409929.1 | 7574 | g2131 | i0 | 61.3 | 2.47914645974782 | 287 | 107 | 82.3 | 2 | 941 | 93 | 56 | 342 | XP_013409929.1 cathepsin B [Lingula anatina] | diamond | 2556 | 377 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 6499691 | 6499691 | PRJEB55122_P_NODE_606_length_1842_cov_4.447853_g519_i0 | PRJEB55122 | 606 | 1842 | 4.447853 | 81.92945226 | Opisthokonta | 33154 | Brachiopoda | other_Eukaryota | 595 | 4.44e-204 | NR | XP_013400629.1 | 7574 | g519 | i0 | 61 | 152.785016286645 | 497 | 177 | 78.2 | 2 | 1837 | 398 | 103 | 599 | XP_013400629.1 heat shock cognate 71 kDa protein [Lingula anatina] | diamond | 281430 | 601 | 0.990016638935108 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 30981626 | 30981626 | PRJEB55122_P_NODE_36214_length_170_cov_1.289256_g35817_i0 | PRJEB55122 | 36214 | 170 | 1.289256 | 2.1917352 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 97.4 | 6.1e-23 | NR | XP_013420344.1 | 7574 | g35817 | i0 | 80.4 | 4.92352941176471 | 56 | 11 | 98.8 | 0 | 168 | 1 | 52 | 107 | XP_013420344.1 protein SET [Lingula anatina] | diamond | 837 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina |
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);;