metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

3 rows where analysis = "diamond", bioproject = "PRJNA724039" 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
27030926	27030926	PRJNA724039_S_NODE_6902_length_257_cov_2.481818_g6695_i0	PRJNA724039	6902	257	2.481818	6.37827226	Metazoa	33208	Cnidaria	other_Eukaryota	120	2.65e-32	NR	XP_001637830.2	45351	g6695	i0	70.6	21.9805447470817	85	23	98.1	2	254	3	68	151	XP_001637830.2 40S ribosomal protein S15 [Nematostella vectensis]	diamond	5649	120	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
29451880	29451880	PRJNA724039_S_NODE_16510_length_157_cov_1.350000_g16303_i0	PRJNA724039	16510	157	1.35	2.1195	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	56.6	1.48e-7	NR	KXJ14349.1	2652724	g16303	i0	54	2.86624203821656	50	21	95.5	1	157	8	187	234	KXJ14349.1 Leucine--tRNA ligase, cytoplasmic [Exaiptasia diaphana]	diamond	450	56.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
31885427	31885427	PRJNA724039_S_NODE_13477_length_174_cov_3.167883_g13270_i0	PRJNA724039	13477	174	3.167883	5.51211642	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	82.8	8.36e-17	NR	XP_066933787.1	252671	g13270	i0	74.5	4.60344827586207	55	14	94.8	0	3	167	310	364	XP_066933787.1 large ribosomal subunit protein uL3-like [Clytia hemisphaerica]	diamond	801	82.8	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);;