contig_metadata
8 rows where bioproject = "PRJEB29441", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10229292 | 10229292 | PRJEB29441_P_NODE_27269_length_201_cov_1.342105_g26828_i0 | PRJEB29441 | 27269 | 201 | 1.342105 | 2.69763105 | Ceratomyxa ayami | 1579381 | Cnidaria | other_Eukaryota | 58.4 | 3.76e-4 | NTclustered | gi|730837045|gb|KM392429.1| | 1579381 | g26828 | i0 | 100 | 0.437810945273632 | 31 | 0 | 15 | 0 | 116 | 146 | 1236 | 1206 | Ceratomyxa ayami isolate LJ-Lepto 28S ribosomal RNA gene, partial sequence | blastn | 88 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa ayami | |
| 14054753 | 14054753 | PRJEB29441_P_NODE_32372_length_184_cov_1.392593_g31931_i0 | PRJEB29441 | 32372 | 184 | 1.392593 | 2.56237112 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 104 | 4.27e-18 | NTclustered | gi|2729089548|ref|XM_065207423.1| | 499914 | g31931 | i0 | 87.64 | 3.48913043478261 | 89 | 11 | 48 | 0 | 1 | 89 | 226 | 138 | PREDICTED: Rhopilema esculentum tubulin alpha-1 chain (LOC135690017), transcript variant X3, mRNA | blastn | 642 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 20114824 | 20114824 | PRJEB29441_P_NODE_4056_length_602_cov_3.137432_g3649_i0 | PRJEB29441 | 4056 | 602 | 3.137432 | 18.88734064 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 344 | 8.78e-90 | NTclustered | gi|2689317317|gb|PP410754.1| | 1458163 | g3649 | i0 | 79.563 | 78.1428571428571 | 504 | 86 | 82 | 13 | 108 | 602 | 956 | 1451 | Nicella obesa voucher USNM:1660440 large subunit ribosomal RNA gene, partial sequence | blastn | 47042 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Ellisellidae | Nicella | Nicella obesa | |
| 26906702 | 26906702 | PRJEB29441_P_NODE_6902_length_446_cov_1.284635_g6463_i0 | PRJEB29441 | 6902 | 446 | 1.284635 | 5.7294721 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 58.2 | 1.21e-6 | NR | XP_031554400.1 | 6105 | g6463 | i0 | 37.8 | 1.42600896860987 | 90 | 46 | 54.5 | 4 | 1 | 243 | 129 | 217 | XP_031554400.1 F-box only protein 42-like [Actinia tenebrosa] | diamond | 636 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27823167 | 27823167 | PRJEB29441_P_NODE_38664_length_167_cov_1.466102_g38223_i0 | PRJEB29441 | 38664 | 167 | 1.466102 | 2.44839034 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 64.3 | 3.26e-10 | NR | XP_048588714.1 | 45351 | g38223 | i0 | 55.6 | 2.82035928143713 | 63 | 15 | 97 | 3 | 3 | 164 | 2291 | 2349 | XP_048588714.1 uncharacterized protein LOC5512653 [Nematostella vectensis] | diamond | 471 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28770136 | 28770136 | PRJEB29441_P_NODE_35627_length_175_cov_1.214286_g35186_i0 | PRJEB29441 | 35627 | 175 | 1.214286 | 2.1250005 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 41.6 | 0.0398 | NR | KXJ16858.1 | 2652724 | g35186 | i0 | 51.4 | 0.634285714285714 | 37 | 16 | 60 | 1 | 168 | 64 | 983 | 1019 | KXJ16858.1 Collagen alpha-6(VI) chain [Exaiptasia diaphana] | diamond | 111 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30381214 | 30381214 | PRJEB29441_P_NODE_22273_length_224_cov_1.457143_g21832_i0 | PRJEB29441 | 22273 | 224 | 1.457143 | 3.26400032 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 44.7 | 0.00622 | NR | KXJ16858.1 | 2652724 | g21832 | i0 | 53.8 | 1.04464285714286 | 39 | 16 | 49.6 | 1 | 217 | 107 | 983 | 1021 | KXJ16858.1 Collagen alpha-6(VI) chain [Exaiptasia diaphana] | diamond | 234 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32246554 | 32246554 | PRJEB29441_P_NODE_45658_length_162_cov_0.902655_g45217_i0 | PRJEB29441 | 45658 | 162 | 0.902655 | 1.4623011 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 42.4 | 0.00539 | NR | XP_066931189.1 | 252671 | g45217 | i0 | 38.1 | 1.53703703703704 | 42 | 26 | 77.8 | 0 | 127 | 2 | 1 | 42 | XP_066931189.1 DNA-directed RNA polymerase III subunit RPC10-like [Clytia hemisphaerica] | diamond | 249 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica |
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);;