contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3219413 | 3219413 | PRJNA688931_P_NODE_35423_length_169_cov_0.866667_g35210_i0 | PRJNA688931 | 35423 | 169 | 0.866667 | 1.46466723 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 58.4 | 3.03e-4 | NTclustered | gi|1778021552|ref|XM_031718255.1| | 6105 | g35210 | i0 | 94.595 | 1.96449704142012 | 37 | 2 | 22 | 0 | 130 | 166 | 2551 | 2587 | PREDICTED: Actinia tenebrosa octopamine receptor 1-like (LOC116307894), transcript variant X6, mRNA | blastn | 332 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 3219457 | 3219457 | PRJNA688931_P_NODE_40563_length_164_cov_0.904348_g40350_i0 | PRJNA688931 | 40563 | 164 | 0.904348 | 1.48313072 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g40350 | i0 | 100 | 0.176829268292683 | 29 | 0 | 18 | 0 | 133 | 161 | 13260706 | 13260678 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 5006445 | 5006445 | PRJNA688931_P_NODE_9984_length_335_cov_1.279720_g9771_i0 | PRJNA688931 | 9984 | 335 | 1.27972 | 4.287062 | Montipora | 46703 | Cnidaria | other_Eukaryota | 243 | 1.75e-59 | NTclustered | gi|2812115753|ref|XM_068870713.1| | 246305 | g9771 | i0 | 80.495 | 35.8089552238806 | 323 | 57 | 96 | 6 | 12 | 331 | 1806 | 1487 | PREDICTED: Montipora capricornis transitional endoplasmic reticulum ATPase (LOC138023670), mRNA | blastn | 11996 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 6282029 | 6282029 | PRJNA688931_P_NODE_13785_length_279_cov_2.026087_g13572_i0 | PRJNA688931 | 13785 | 279 | 2.026087 | 5.65278273 | root | 1 | Root_unresolved | Root_unresolved | 76.8 | 1.52e-9 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g13572 | i0 | 100 | 15.7060931899642 | 41 | 0 | 15 | 0 | 235 | 275 | 14180166 | 14180206 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 4382 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7047269 | 7047269 | PRJNA688931_P_NODE_7146_length_406_cov_4.543417_g6933_i0 | PRJNA688931 | 7146 | 406 | 4.543417 | 18.44627302 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 392 | 2.02e-104 | NTclustered | gi|2518998737|ref|XM_057450856.1| | 13093 | g6933 | i0 | 84.694 | 216.009852216749 | 392 | 60 | 97 | 0 | 15 | 406 | 1203 | 812 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA | blastn | 87700 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 13422478 | 13422478 | PRJNA688931_P_NODE_37171_length_167_cov_0.881356_g36958_i0 | PRJNA688931 | 37171 | 167 | 0.881356 | 1.47186452 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g36958 | i0 | 100 | 0.173652694610778 | 29 | 0 | 17 | 0 | 20 | 48 | 13065412 | 13065384 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 13422506 | 13422506 | PRJNA688931_P_NODE_41011_length_164_cov_0.895652_g40798_i0 | PRJNA688931 | 41011 | 164 | 0.895652 | 1.46886928 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 73.1 | 1.05e-8 | NTclustered | gi|2782893498|ref|XM_067066835.1| | 252671 | g40798 | i0 | 92.157 | 0.621951219512195 | 51 | 4 | 31 | 0 | 69 | 119 | 422 | 372 | PREDICTED: Clytia hemisphaerica small ribosomal subunit protein eS24-like (LOC136810263), transcript variant X1, mRNA | blastn | 102 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 22346026 | 22346026 | PRJNA688931_P_NODE_6418_length_431_cov_6.793194_g6205_i0 | PRJNA688931 | 6418 | 431 | 6.793194 | 29.27866614 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 433 | 1.2699999999999995e-116 | NTclustered | gi|2744846516|ref|XM_065790771.1| | 6087 | g6205 | i0 | 85.372 | 286.900232018561 | 417 | 61 | 97 | 0 | 9 | 425 | 403 | 819 | PREDICTED: Hydra vulgaris polyubiquitin-B (LOC100212621), transcript variant X2, mRNA | blastn | 123654 | 433 | 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);;