contig_metadata
6 rows where bioproject = "PRJNA994052", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976852 | 976852 | PRJNA994052_P_NODE_79281_length_201_cov_80.687500_g78024_i0 | PRJNA994052 | 79281 | 201 | 80.6875 | 162.181875 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 1.04e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g78024 | i0 | 100 | 3.3134328358209 | 32 | 0 | 16 | 0 | 159 | 190 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 11180004 | 11180004 | PRJNA994052_P_NODE_62169_length_223_cov_6.426667_g60913_i0 | PRJNA994052 | 62169 | 223 | 6.426667 | 14.33146741 | Margelopsis haeckelii | 2876032 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2095440634|gb|OK139084.1| | 2876032 | g60913 | i0 | 94.595 | 0.417040358744395 | 37 | 1 | 16 | 1 | 1 | 36 | 37 | 1 | Margelopsis haeckelii strain Ost2019 small subunit ribosomal RNA gene, partial sequence | blastn | 93 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Margelopsidae | Margelopsis | Margelopsis haeckelii | |
| 12752490 | 12752490 | PRJNA994052_P_NODE_64310_length_220_cov_10.312925_g63054_i0 | PRJNA994052 | 64310 | 220 | 10.312925 | 22.688435 | Cubozoa | 6137 | Cnidaria | other_Eukaryota | 228 | 3.019999999999999e-55 | NTclustered | gi|261854611|gb|GQ860995.1| | 168719 | g63054 | i0 | 88.205 | 87.8409090909091 | 195 | 18 | 88 | 5 | 28 | 220 | 1412 | 1221 | Carybdea xaymacana isolate AGC137 28S ribosomal RNA gene, partial sequence | blastn | 19325 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Cubozoa | Carybdeida | Carybdeidae | Carybdea | Carybdea xaymacana | |
| 26646352 | 26646352 | PRJNA994052_P_NODE_14761_length_313_cov_35.116667_g13540_i0 | PRJNA994052 | 14761 | 313 | 35.116667 | 109.91516771 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 55.1 | 4.09e-6 | NR | XP_031558850.1 | 6105 | g13540 | i0 | 55.1 | 0.469648562300319 | 49 | 22 | 47 | 0 | 313 | 167 | 821 | 869 | XP_031558850.1 multidrug resistance-associated protein 4-like, partial [Actinia tenebrosa] | diamond | 147 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28226402 | 28226402 | PRJNA994052_P_NODE_71006_length_211_cov_28.289855_g69750_i0 | PRJNA994052 | 71006 | 211 | 28.289855 | 59.69159405 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 48.9 | 1.56e-4 | NR | XP_048586127.1 | 45351 | g69750 | i0 | 43.4 | 1.50710900473934 | 53 | 27 | 71.1 | 1 | 209 | 60 | 193 | 245 | XP_048586127.1 ADP-ribose glycohydrolase MACROD1 isoform X1 [Nematostella vectensis] | diamond | 318 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31859611 | 31859611 | PRJNA994052_P_NODE_23497_length_299_cov_16.070796_g22265_i0 | PRJNA994052 | 23497 | 299 | 16.070796 | 48.05168004 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 104 | 2.85e-26 | NR | XP_068702776.1 | 591990 | g22265 | i0 | 67.9 | 3.2809364548495 | 81 | 24 | 79.3 | 1 | 295 | 59 | 53 | 133 | XP_068702776.1 large ribosomal subunit protein eL32-like [Montipora foliosa] | diamond | 981 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa |
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);;