contig_metadata
6 rows where bioproject = "PRJNA891846", tax_kingdom = "Metazoa" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5970647 | 5970647 | PRJNA891846_P_NODE_42325_length_246_cov_0.890173_g42105_i0 | PRJNA891846 | 42325 | 246 | 0.890173 | 2.18982558 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 80.5 | 1.02e-10 | NTclustered | gi|2744882156|ref|XM_065807238.1| | 6087 | g42105 | i0 | 89.062 | 1.05691056910569 | 64 | 7 | 26 | 0 | 1 | 64 | 4598 | 4661 | PREDICTED: Hydra vulgaris pre-mRNA-processing-splicing factor 8 (LOC100198004), transcript variant X2, mRNA | blastn | 260 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 16545721 | 16545721 | PRJNA891846_P_NODE_47873_length_233_cov_2.800000_g47653_i0 | PRJNA891846 | 47873 | 233 | 2.8 | 6.524 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 135 | 2e-35 | NR | XP_057291046.1 | 13093 | g47653 | i0 | 81.6 | 4.90557939914163 | 76 | 14 | 97.9 | 0 | 231 | 4 | 382 | 457 | XP_057291046.1 glucose-6-phosphate isomerase-like isoform X2 [Hydractinia symbiolongicarpus] | diamond | 1143 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26999915 | 26999915 | PRJNA891846_P_NODE_44542_length_244_cov_0.888889_g44322_i0 | PRJNA891846 | 44542 | 244 | 0.888889 | 2.16888916 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 90.9 | 4.37e-19 | NR | XP_048582661.1 | 45351 | g44322 | i0 | 55.1 | 3.83606557377049 | 78 | 35 | 95.9 | 0 | 235 | 2 | 285 | 362 | XP_048582661.1 uncharacterized protein LOC125561901 [Nematostella vectensis] | diamond | 936 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 27435059 | 27435059 | PRJNA891846_P_NODE_33443_length_264_cov_1.591623_g33224_i0 | PRJNA891846 | 33443 | 264 | 1.591623 | 4.20188472 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 70.5 | 8.08e-12 | NR | XP_046859640.1 | 2897299 | g33224 | i0 | 41.7 | 6.81818181818182 | 84 | 43 | 95.5 | 1 | 2 | 253 | 61 | 138 | XP_046859640.1 poly(A)-specific ribonuclease PARN-like [Xenia sp. Carnegie-2017] | diamond | 1800 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28129555 | 28129555 | PRJNA891846_P_NODE_39885_length_248_cov_0.880000_g39665_i0 | PRJNA891846 | 39885 | 248 | 0.88 | 2.1824 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 43.5 | 0.021 | NR | XP_066930065.1 | 252671 | g39665 | i0 | 30.6 | 0.592741935483871 | 49 | 34 | 59.3 | 0 | 95 | 241 | 376 | 424 | XP_066930065.1 TBC1 domain family member 22B-like [Clytia hemisphaerica] | diamond | 147 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30466635 | 30466635 | PRJNA891846_P_NODE_11273_length_447_cov_2.085561_g11056_i0 | PRJNA891846 | 11273 | 447 | 2.085561 | 9.32245767 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 132 | 1.6200000000000002e-33 | NR | XP_015748371.1 | 70779 | g11056 | i0 | 45.4 | 0.946308724832215 | 141 | 75 | 94.6 | 2 | 424 | 2 | 272 | 410 | XP_015748371.1 PREDICTED: gastric triacylglycerol lipase-like [Acropora digitifera] | diamond | 423 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera |
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);;