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

4 rows where analysis = "diamond", bioproject = "PRJNA299585" and tax_phylum = "Arthropoda"

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
11853941	11853941	PRJNA299585_S_NODE_8590_length_239_cov_4.690476_g8360_i0	PRJNA299585	8590	239	4.690476	11.21023764	Artemia franciscana	6661	Arthropoda	Arthropoda	86.3	1.44e-19	NR	XP_065560387.1	6661	g8360	i0	75.9	0.677824267782427	54	13	67.8	0	2	163	73	126	XP_065560387.1 endocuticle structural glycoprotein SgAbd-1-like [Artemia franciscana]	diamond	162	86.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
28369010	28369010	PRJNA299585_S_NODE_9906_length_213_cov_3.010870_g9676_i0	PRJNA299585	9906	213	3.01087	6.4131531	Artemia franciscana	6661	Arthropoda	Arthropoda	76.6	6.12e-16	NR	XP_065560387.1	6661	g9676	i0	62.1	0.929577464788732	66	23	93	1	199	2	17	80	XP_065560387.1 endocuticle structural glycoprotein SgAbd-1-like [Artemia franciscana]	diamond	198	76.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
30737604	30737604	PRJNA299585_S_NODE_11914_length_185_cov_2.743590_g11684_i0	PRJNA299585	11914	185	2.74359	5.0756415	Artemia franciscana	6661	Arthropoda	Arthropoda	45.8	0.00141	NR	XP_065574250.1	6661	g11684	i0	100	0.356756756756757	22	0	35.7	0	2	67	338	359	XP_065574250.1 myb-like protein X [Artemia franciscana]	diamond	66	45.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32002469	32002469	PRJNA299585_S_NODE_15838_length_151_cov_2.754098_g15608_i0	PRJNA299585	15838	151	2.754098	4.15868798	Tribolium castaneum	7070	Arthropoda	Arthropoda	43.9	0.00342	NR	XP_015832951.2	7070	g15608	i0	45.8	0.95364238410596	48	25	95.4	1	1	144	112	158	XP_015832951.2 glutathione S-transferase [Tribolium castaneum]	diamond	144	43.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum

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