metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA177642" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA177642" and tax_phylum = "Chordata"

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
26775415	26775415	PRJNA177642_P_NODE_17901_length_165_cov_1.058824_g16676_i0	PRJNA177642	17901	165	1.058824	1.7470596	root	1	Root_unresolved	Root_unresolved	43.1	0.0094	NR	CAB3266990.1	59560	g16676	i0	41.5	4.74545454545455	53	29	92.7	1	6	158	395	447	CAB3266990.1 reverse transcriptase [Phallusia mammillata]	diamond	783	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Ascidiidae	Phallusia	Phallusia mammillata
30186409	30186409	PRJNA177642_P_NODE_11312_length_328_cov_1.307692_g10087_i0	PRJNA177642	11312	328	1.307692	4.28922976	Xenopus	8353	Chordata	Chordata	47	0.00328	NR	XP_018102548.1	8355	g10087	i0	55.9	1.55487804878049	34	15	31.1	0	2	103	386	419	XP_018102548.1 neuronal PAS domain-containing protein 2 isoform X1 [Xenopus laevis]	diamond	510	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
31717428	31717428	PRJNA177642_P_NODE_14657_length_205_cov_1.227273_g13432_i0	PRJNA177642	14657	205	1.227273	2.51590965	Bombina bombina	8345	Chordata	Chordata	74.7	1.25e-13	NR	XP_053571558.1	8345	g13432	i0	62.9	1.81463414634146	62	23	90.7	0	193	8	802	863	XP_053571558.1 uncharacterized protein LOC128661312 [Bombina bombina]	diamond	372	74.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
31717431	31717431	PRJNA177642_P_NODE_16617_length_171_cov_1.014085_g15392_i0	PRJNA177642	16617	171	1.014085	1.73408535	Callorhinchus milii	7868	Chordata	Chordata	62.8	1.18e-9	NR	XP_042201711.1	7868	g15392	i0	56.9	5.07017543859649	58	20	94.7	2	3	164	564	620	XP_042201711.1 LOW QUALITY PROTEIN: uncharacterized protein LOC121851711, partial [Callorhinchus milii]	diamond	867	62.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Chimaeriformes	Callorhinchidae	Callorhinchus	Callorhinchus milii

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