contig_metadata
7 rows where bioproject = "PRJNA753704", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15230591 | 15230591 | PRJNA753704_P_NODE_2332_length_716_cov_8.872473_g1996_i0 | PRJNA753704 | 2332 | 716 | 8.872473 | 63.52690668 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 187 | 1.8799999999999994e-42 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g1996 | i0 | 81.858 | 45.9357541899441 | 226 | 37 | 33 | 4 | 407 | 632 | 26608682 | 26608461 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 32890 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 24957461 | 24957461 | PRJNA753704_P_NODE_10560_length_363_cov_25.389655_g10199_i0 | PRJNA753704 | 10560 | 363 | 25.389655 | 92.16444765 | Mastigias albipunctata | 3143520 | Cnidaria | other_Eukaryota | 128 | 5.56e-25 | NTclustered | gi|2862235117|gb|PQ647264.1| | 3143520 | g10199 | i0 | 93.103 | 24.1652892561983 | 87 | 6 | 32 | 0 | 274 | 360 | 3045 | 2959 | Mastigias albipunctata isolate AGC18067 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8772 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Mastigiidae | Mastigias | Mastigias albipunctata | |
| 26967754 | 26967754 | PRJNA753704_P_NODE_18882_length_279_cov_1.257282_g18521_i0 | PRJNA753704 | 18882 | 279 | 1.257282 | 3.50781678 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 58.5 | 9.29e-8 | NR | XP_031550831.1 | 6105 | g18521 | i0 | 41.9 | 3.02150537634409 | 93 | 47 | 98.9 | 3 | 2 | 277 | 73 | 159 | XP_031550831.1 uncharacterized protein LOC116288214 [Actinia tenebrosa] | diamond | 843 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 26989387 | 26989387 | PRJNA753704_P_NODE_28342_length_242_cov_0.923077_g27981_i0 | PRJNA753704 | 28342 | 242 | 0.923077 | 2.23384634 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 65.1 | 4.75e-10 | NR | EDO45408.1 | 45351 | g27981 | i0 | 40 | 3.47107438016529 | 75 | 45 | 93 | 0 | 242 | 18 | 229 | 303 | EDO45408.1 predicted protein [Nematostella vectensis] | diamond | 840 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28884452 | 28884452 | PRJNA753704_P_NODE_12428_length_337_cov_1.609848_g12067_i0 | PRJNA753704 | 12428 | 337 | 1.609848 | 5.42518776 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 45.4 | 0.012 | NR | XP_068739685.1 | 246305 | g12067 | i0 | 53.5 | 1.76261127596439 | 43 | 19 | 38.3 | 1 | 2 | 130 | 415 | 456 | XP_068739685.1 tripartite motif-containing protein 3-like [Montipora capricornis] | diamond | 594 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 29200471 | 29200471 | PRJNA753704_P_NODE_20569_length_268_cov_2.856410_g20208_i0 | PRJNA753704 | 20569 | 268 | 2.85641 | 7.6551788 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 42.7 | 0.0494 | NR | CAH3174760.1 | 104759 | g20208 | i0 | 50 | 0.402985074626866 | 36 | 18 | 40.3 | 0 | 91 | 198 | 363 | 398 | CAH3174760.1 unnamed protein product [Porites lobata] | diamond | 108 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32402423 | 32402423 | PRJNA753704_P_NODE_27079_length_245_cov_0.906977_g26718_i0 | PRJNA753704 | 27079 | 245 | 0.906977 | 2.22209365 | Porites | 46719 | Cnidaria | other_Eukaryota | 102 | 4.279999999999999e-23 | NR | CAH3015529.1 | 104178 | g26718 | i0 | 58.8 | 3.93061224489796 | 80 | 33 | 98 | 0 | 1 | 240 | 344 | 423 | CAH3015529.1 unnamed protein product, partial [Porites evermanni] | diamond | 963 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni |
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);;