metadata: contig_metadata: 6 rows where bioproject = "PRJNA549880", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA549880", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
511714	511714	PRJNA549880_P_NODE_10021_length_255_cov_1.890110_g9928_i0	PRJNA549880	10021	255	1.89011	4.8197805	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|2744889029\|ref\|XM_065810454.1\|	6087	g9928	i0	100	0.227450980392157	29	0	11	0	52	80	2276	2248	PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
19638131	19638131	PRJNA549880_P_NODE_2556_length_452_cov_1.461741_g2463_i0	PRJNA549880	2556	452	1.461741	6.60706932	Porites lobata	104759	Cnidaria	other_Eukaryota	189	3.43e-58	NR	CAH3117063.1	104759	g2463	i0	73.7	7.46017699115044	137	34	89.6	2	18	422	50	186	CAH3117063.1 unnamed protein product [Porites lobata]	diamond	3372	189	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
23464232	23464232	PRJNA549880_P_NODE_6699_length_306_cov_5.905579_g6606_i0	PRJNA549880	6699	306	5.905579	18.07107174	Acropora digitifera	70779	Cnidaria	other_Eukaryota	130	3.34e-37	NR	XP_015754943.1	70779	g6606	i0	70.2	1.64705882352941	84	24	82.4	1	277	26	1	83	XP_015754943.1 PREDICTED: 40S ribosomal protein S21-like [Acropora digitifera]	diamond	504	130	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
28608660	28608660	PRJNA549880_P_NODE_6027_length_320_cov_1.546559_g5934_i0	PRJNA549880	6027	320	1.546559	4.9489888	Metazoa	33208	Cnidaria	other_Eukaryota	52	3.52e-6	NR	XP_001640922.1	45351	g5934	i0	43.3	1.228125	67	36	60.9	2	271	77	2	68	XP_001640922.1 cytochrome c oxidase subunit NDUFA4 [Nematostella vectensis]	diamond	393	52	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
29099041	29099041	PRJNA549880_P_NODE_3088_length_416_cov_3.221574_g2995_i0	PRJNA549880	3088	416	3.221574	13.40174784	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	184	2.03e-57	NR	XP_028414647.1	151771	g2995	i0	73.8	1.81730769230769	126	33	90.9	0	37	414	1	126	XP_028414647.1 40S ribosomal protein S24-like isoform X1 [Dendronephthya gigantea]	diamond	756	184	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
32037849	32037849	PRJNA549880_P_NODE_5798_length_325_cov_4.436508_g5705_i0	PRJNA549880	5798	325	4.436508	14.418651	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	135	1.5599999999999999e-38	NR	XP_031552790.1	6105	g5705	i0	61.2	4.76307692307692	103	40	95.1	0	310	2	1	103	XP_031552790.1 60S ribosomal protein L35a-like [Actinia tenebrosa]	diamond	1548	135	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa

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);;