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

4 rows where analysis = "diamond", bioproject = "PRJNA206070" 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
15083118	15083118	PRJNA206070_S_NODE_14952_length_265_cov_14.986842_g13076_i0	PRJNA206070	14952	265	14.986842	39.7151313	Artemia franciscana	6661	Arthropoda	Arthropoda	160	3.62e-49	NR	KAK2709965.1	6661	g13076	i0	84.9	3.79245283018868	86	13	97.4	0	263	6	3	88	KAK2709965.1 hypothetical protein QYM36_013593 [Artemia franciscana]	diamond	1005	160	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
27326869	27326869	PRJNA206070_S_NODE_22623_length_187_cov_1.040000_g20747_i0	PRJNA206070	22623	187	1.04	1.9448	Chironomus tepperi	113505	Arthropoda	Arthropoda	88.2	1.75e-18	NR	XP_070507525.1	113505	g20747	i0	63.8	3.41711229946524	69	17	97.9	1	184	2	1	69	XP_070507525.1 vitellogenin-A1-like [Chironomus tepperi]	diamond	639	88.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
30168556	30168556	PRJNA206070_S_NODE_22352_length_188_cov_3.105960_g20476_i0	PRJNA206070	22352	188	3.10596	5.8392048	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.9	0.00689	NR	CAK9813121.1	597819	g20476	i0	48.6	2.79255319148936	35	18	55.9	0	144	40	222	256	CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata]	diamond	525	44.3	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora plagiata
30376539	30376539	PRJNA206070_S_NODE_25872_length_169_cov_1.560606_g23996_i0	PRJNA206070	25872	169	1.560606	2.63742414	Chironomidae	7149	Arthropoda	Arthropoda	63.2	8.69e-10	NR	XP_070499723.1	113505	g23996	i0	60.8	1.61538461538462	51	18	90.5	1	162	10	1390	1438	XP_070499723.1 vitellogenin-A1-like [Chironomus tepperi]	diamond	273	63.5	0.995275590551181	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi

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