metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_clade = "Stenosarchaea group"

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
26907770	26907770	PRJEB83711_P_NODE_68222_length_247_cov_1.522989_g67956_i0	PRJEB83711	68222	247	1.522989	3.76178283	Natronoarchaeum rubrum	755311	Archaea	Archaea	43.5	0.0197	NR	WP_256391750.1	755311	g67956	i0	37.5	0.97165991902834	80	39	88.7	3	18	236	59	134	WP_256391750.1 ATP-binding protein [Natronoarchaeum rubrum]	diamond	240	43.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Natronoarchaeum	Natronoarchaeum rubrum
27634733	27634733	PRJEB83711_P_NODE_42004_length_284_cov_1.473934_g41738_i0	PRJEB83711	42004	284	1.473934	4.18597256	Halococcus dombrowskii	179637	Archaea	Archaea	155	2.16e-41	NR	WP_244706568.1	179637	g41738	i0	76.6	0.992957746478873	94	22	99.3	0	282	1	1231	1324	WP_244706568.1 hypothetical protein [Halococcus dombrowskii]	diamond	282	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
27950413	27950413	PRJEB83711_P_NODE_77085_length_243_cov_0.917647_g76819_i0	PRJEB83711	77085	243	0.917647	2.22988221	Halosimplex carlsbadense	171164	Archaea	Archaea	94.4	9.62e-21	NR	WP_006881789.1	171164	g76819	i0	58	2	81	34	100	0	1	243	88	168	WP_006881789.1 aminopeptidase [Halosimplex carlsbadense]	diamond	486	94.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halosimplex	Halosimplex carlsbadense
29908138	29908138	PRJEB83711_P_NODE_44631_length_278_cov_1.502439_g44365_i0	PRJEB83711	44631	278	1.502439	4.17678042	Natronomonas sp. LN261	2750669	Archaea	Archaea	116	1.6699999999999999e-31	NR	WP_181693274.1	2750669	g44365	i0	94.9	0.636690647482014	59	3	63.7	0	2	178	55	113	WP_181693274.1 hypothetical protein [Natronomonas sp. LN261]	diamond	177	116	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
32595300	32595300	PRJEB83711_P_NODE_76840_length_243_cov_0.917647_g76574_i0	PRJEB83711	76840	243	0.917647	2.22988221	Methanosarcina sp. UBA5	1915593	Archaea	Archaea	48.9	5.57e-5	NR	WP_292387852.1	1915593	g76574	i0	88	0.308641975308642	25	3	30.9	0	87	161	98	122	WP_292387852.1 DDE-type integrase/transposase/recombinase, partial [Methanosarcina sp. UBA5]	diamond	75	48.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp. UBA5

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