contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA594101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 567165 | 567165 | PRJNA594101_S_NODE_45201_length_260_cov_1.235294_g44899_i0 | PRJNA594101 | 45201 | 260 | 1.235294 | 3.2117644 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g44899 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 8 | 36 | 13260706 | 13260678 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15869751 | 15869751 | PRJNA594101_S_NODE_30953_length_308_cov_1.668085_g30651_i0 | PRJNA594101 | 30953 | 308 | 1.668085 | 5.1377018 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|1603784044|ref|XM_028539526.1| | 151771 | g30651 | i0 | 100 | 0.181818181818182 | 28 | 0 | 9 | 0 | 93 | 120 | 1981 | 1954 | PREDICTED: Dendronephthya gigantea serine/threonine-protein kinase MRCK beta-like (LOC114519400), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 15869964 | 15869964 | PRJNA594101_S_NODE_58633_length_231_cov_2.348101_g58331_i0 | PRJNA594101 | 58633 | 231 | 2.348101 | 5.42411331 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 220 | 5.35e-53 | NTclustered | gi|2782857601|ref|XM_067058150.1| | 252671 | g58331 | i0 | 86.207 | 81.2943722943723 | 203 | 28 | 88 | 0 | 17 | 219 | 88 | 290 | PREDICTED: Clytia hemisphaerica actin, non-muscle 6.2-like (LOC136801512), mRNA | blastn | 18779 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 17144757 | 17144757 | PRJNA594101_S_NODE_36894_length_285_cov_2.471698_g36592_i0 | PRJNA594101 | 36894 | 285 | 2.471698 | 7.0443393 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 219 | 2.4499999999999994e-52 | NTclustered | gi|2782943885|ref|XM_067076883.1| | 252671 | g36592 | i0 | 81.784 | 129.480701754386 | 269 | 42 | 93 | 7 | 1 | 266 | 409 | 145 | PREDICTED: Clytia hemisphaerica ubiquitin-ribosomal protein eL40 fusion protein (LOC136820684), mRNA | blastn | 36902 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 19693578 | 19693578 | PRJNA594101_S_NODE_4596_length_753_cov_3.394118_g4323_i0 | PRJNA594101 | 4596 | 753 | 3.394118 | 25.55770854 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 60.2 | 4.51e-4 | NTclustered | gi|1176112044|ref|XM_020771380.1| | 48498 | g4323 | i0 | 94.737 | 0.127490039840637 | 38 | 2 | 5 | 0 | 39 | 76 | 3598 | 3635 | PREDICTED: Orbicella faveolata uncharacterized LOC110064336 (LOC110064336), partial mRNA | blastn | 96 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 24793128 | 24793128 | PRJNA594101_S_NODE_19400_length_380_cov_1.442997_g19098_i0 | PRJNA594101 | 19400 | 380 | 1.442997 | 5.4833886 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 261 | 5.53e-65 | NTclustered | gi|2744794010|ref|XM_012698561.3| | 6087 | g19098 | i0 | 81.994 | 25.8131578947368 | 311 | 52 | 81 | 4 | 72 | 380 | 217 | 525 | PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA | blastn | 9809 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;