metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA879067" 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
9783818	9783818	PRJNA879067_P_NODE_7448_length_1836_cov_11.494044_g5672_i0	PRJNA879067	7448	1836	11.494044	211.03064784	Opisthokonta	33154	Cnidaria	other_Eukaryota	454	3.57e-150	NR	XP_029209170.1	45264	g5672	i0	47.8	12.2369281045752	577	248	91.2	11	51	1724	2	544	XP_029209170.1 pre-mRNA-splicing factor SLU7-like isoform X2 [Acropora millepora]	diamond	22467	456	0.995614035087719	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
23806981	23806981	PRJNA879067_P_NODE_34719_length_690_cov_17.439222_g31330_i0	PRJNA879067	34719	690	17.439222	120.3306318	Acropora digitifera	70779	Cnidaria	other_Eukaryota	81.6	9.01e-14	NR	XP_015755013.1	70779	g31330	i0	29.8	1.6	191	122	81.3	3	658	98	383	565	XP_015755013.1 PREDICTED: protein FAM188B-like [Acropora digitifera]	diamond	1104	81.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
30181570	30181570	PRJNA879067_P_NODE_48352_length_539_cov_2.439914_g44873_i0	PRJNA879067	48352	539	2.439914	13.15113646	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	65.1	1.13e-8	NR	XP_065053501.1	499914	g44873	i0	33.6	2.27643784786642	140	83	74	3	2	400	272	408	XP_065053501.1 RNA polymerase-associated protein LEO1-like [Rhopilema esculentum]	diamond	1227	65.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
30466327	30466327	PRJNA879067_P_NODE_38953_length_635_cov_8.544484_g35514_i0	PRJNA879067	38953	635	8.544484	54.2574734	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	178	4.31e-51	NR	XP_001633193.1	45351	g35514	i0	51	4.44566929133858	155	76	73.2	0	30	494	171	325	XP_001633193.1 replication factor C subunit 5 [Nematostella vectensis]	diamond	2823	178	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
32173534	32173534	PRJNA879067_P_NODE_71858_length_378_cov_2.311475_g68373_i0	PRJNA879067	71858	378	2.311475	8.7373755	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	47.8	0.00294	NR	KXJ07542.1	2652724	g68373	i0	61.5	0.30952380952381	39	15	31	0	161	277	949	987	KXJ07542.1 Titin [Exaiptasia diaphana]	diamond	117	47.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
32561306	32561306	PRJNA879067_P_NODE_10319_length_1534_cov_3.954825_g8187_i0	PRJNA879067	10319	1534	3.954825	60.6670155	Metazoa	33208	Cnidaria	other_Eukaryota	583	1.46e-200	NR	XP_031561619.1	6105	g8187	i0	56.2	14.7262059973924	502	217	98	3	1503	1	155	654	XP_031561619.1 thimet oligopeptidase-like [Actinia tenebrosa]	diamond	22590	583	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);;