metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Margulisiibacteriota"

5 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Margulisiibacteriota"

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_species
23999786	23999786	PRJNA1237347_P_NODE_205619_length_426_cov_0.869688_g199047_i0	PRJNA1237347	205619	426	0.869688	3.70487088	Candidatus Marinamargulisbacteria bacterium SCGC AG-41	2933166	Bacteria	Bacteria	169	6.27e-46	NR	RAP32558.1	2184345	g199047	i0	62.5	2.93661971830986	136	44	95.8	1	11	418	166	294	RAP32558.1 hypothetical protein DID75_04680 [Candidatus Marinamargulisbacteria bacterium SCGC AG-410-N11]	diamond	1251	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota	Candidatus Marinamargulisbacteria	Candidatus Marinamargulisbacteria bacterium SCGC AG-410-N11
26883227	26883227	PRJNA1237347_P_NODE_200841_length_432_cov_2.144847_g194269_i0	PRJNA1237347	200841	432	2.144847	9.26573904	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	49.3	2.68e-4	NR	MFH1683276.1	2053573	g194269	i0	35.8	0.465277777777778	67	42	46.5	1	430	230	63	128	MFH1683276.1 protease inhibitor I42 family protein [Candidatus Margulisiibacteriota bacterium]	diamond	201	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota		Candidatus Margulisiibacteriota bacterium
29252109	29252109	PRJNA1237347_P_NODE_83889_length_762_cov_6.047896_g77725_i0	PRJNA1237347	83889	762	6.047896	46.08496752	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	94.7	1.82e-20	NR	NQY73462.1	2053573	g77725	i0	43.3	0.52755905511811	134	71	52	3	742	347	1	131	NQY73462.1 hypothetical protein [Candidatus Margulisiibacteriota bacterium]	diamond	402	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota		Candidatus Margulisiibacteriota bacterium
30231196	30231196	PRJNA1237347_P_NODE_449652_length_259_cov_1.666667_g443079_i0	PRJNA1237347	449652	259	1.666667	4.31666753	Candidatus Marinamargulisbacteria bacterium SCGC AAA	2933166	Bacteria	Bacteria	86.7	1.12e-17	NR	RAP38237.1	2184347	g443079	i0	48.8	0.94980694980695	82	42	95	0	257	12	74	155	RAP38237.1 hypothetical protein DID80_02815 [Candidatus Marinamargulisbacteria bacterium SCGC AAA071-K20]	diamond	246	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota	Candidatus Marinamargulisbacteria	Candidatus Marinamargulisbacteria bacterium SCGC AAA071-K20
32476314	32476314	PRJNA1237347_P_NODE_483379_length_250_cov_0.870056_g476806_i0	PRJNA1237347	483379	250	0.870056	2.17514	Candidatus Marinamargulisbacteria bacterium SCGC AG-41	2933166	Bacteria	Bacteria	68.2	4.64e-11	NR	RAP32559.1	2184345	g476806	i0	41.7	1.008	84	46	99.6	2	250	2	1009	1090	RAP32559.1 hypothetical protein DID75_04685 [Candidatus Marinamargulisbacteria bacterium SCGC AG-410-N11]	diamond	252	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota	Candidatus Marinamargulisbacteria	Candidatus Marinamargulisbacteria bacterium SCGC AG-410-N11

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