metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1028258" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1028258" and tax_phylum = "Vulcanimicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
26813539	26813539	PRJNA1028258_P_NODE_112881_length_250_cov_1.392265_g112318_i0	PRJNA1028258	112881	250	1.392265	3.4806625	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	87.8	5.1e-18	NR	MFN8613385.1	3107663	g112318	i0	62	0.852	71	22	85.2	1	236	24	4	69	MFN8613385.1 DUF1800 domain-containing protein [Vulcanimicrobiota bacterium]	diamond	213	87.8	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
28677363	28677363	PRJNA1028258_P_NODE_110167_length_252_cov_1.551913_g109604_i0	PRJNA1028258	110167	252	1.551913	3.91082076	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	117	1.59e-28	NR	MFA7480674.1	3107663	g109604	i0	71.1	0.988095238095238	83	24	98.8	0	2	250	140	222	MFA7480674.1 tetratricopeptide repeat protein [Vulcanimicrobiota bacterium]	diamond	249	117	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
28740440	28740440	PRJNA1028258_P_NODE_152027_length_231_cov_0.876543_g151464_i0	PRJNA1028258	152027	231	0.876543	2.02481433	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	90.5	5.34e-20	NR	HZV58939.1	3069296	g151464	i0	55.4	1.92207792207792	74	33	96.1	0	224	3	154	227	HZV58939.1 aspartate kinase [Candidatus Eremiobacteraceae bacterium]	diamond	444	90.5	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae	Candidatus Eremiobacteraceae bacterium
29466234	29466234	PRJNA1028258_P_NODE_139810_length_233_cov_1.609756_g139247_i0	PRJNA1028258	139810	233	1.609756	3.75073148	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	117	1.29e-28	NR	MFA7483330.1	3107663	g139247	i0	66.7	0.965665236051502	75	25	96.6	0	225	1	603	677	MFA7483330.1 DEAD/DEAH box helicase [Vulcanimicrobiota bacterium]	diamond	225	117	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
29877223	29877223	PRJNA1028258_P_NODE_147831_length_232_cov_0.871166_g147268_i0	PRJNA1028258	147831	232	0.871166	2.02110512	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	69.3	1.34e-11	NR	HEY1728394.1	2952909	g147268	i0	53.9	0.982758620689655	76	32	98.3	1	230	3	564	636	HEY1728394.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Baltobacteraceae bacterium]	diamond	228	69.3	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Baltobacteraceae bacterium
30572008	30572008	PRJNA1028258_P_NODE_94913_length_266_cov_1.335025_g94350_i0	PRJNA1028258	94913	266	1.335025	3.5511665	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	120	8.16e-30	NR	GMU55623.1	3036772	g94350	i0	71.8	0.958646616541353	85	24	95.9	0	257	3	324	408	GMU55623.1 MAG: hypothetical protein AMXMBFR33_47690 [Candidatus Xenobia bacterium]	diamond	255	120	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia			Candidatus Xenobia bacterium

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