metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA342843" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA342843" and tax_phylum = "Bacteroidota"

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
392940	392940	PRJNA342843_S_NODE_15221_length_153_cov_1.178571_g15071_i0	PRJNA342843	15221	153	1.178571	1.80321363	Chitinophaga sp.	1869181	Bacteria	Bacteria	110	1.09e-27	NR	MBA4196447.1	1869181	g15071	i0	100	0.980392156862745	50	0	98	0	152	3	110	159	MBA4196447.1 nucleotidyltransferase [Chitinophaga sp.]	diamond	150	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp.
19518865	19518865	PRJNA342843_S_NODE_56_length_8554_cov_17.812522_g50_i0	PRJNA342843	56	8554	17.812522	1523.68313188	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	1576	0	NR	MBO6253027.1	2212467	g50	i0	80.4	0.352115969137246	1004	156	34.5	6	4230	1279	1	983	MBO6253027.1 PriCT-2 domain-containing protein [Bacteroidaceae bacterium]	diamond	3012	1576	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
26853467	26853467	PRJNA342843_S_NODE_5241_length_296_cov_3.149020_g5091_i0	PRJNA342843	5241	296	3.14902	9.3210992	uncultured Butyricimonas sp.	1268785	Bacteria	Bacteria	109	2.14e-25	NR	WP_303181893.1	1268785	g5091	i0	60.6	1.00337837837838	99	38	99.3	1	296	3	1275	1373	WP_303181893.1 hypothetical protein [uncultured Butyricimonas sp.]	diamond	297	109	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Butyricimonas	uncultured Butyricimonas sp.
29222300	29222300	PRJNA342843_S_NODE_11229_length_183_cov_0.929577_g11079_i0	PRJNA342843	11229	183	0.929577	1.70112591	Bacteroidales bacterium	2030927	Bacteria	Bacteria	95.9	1.1399999999999999e-23	NR	NLD21652.1	2030927	g11079	i0	87.3	0.901639344262295	55	7	90.2	0	165	1	1	55	NLD21652.1 hypothetical protein [Bacteroidales bacterium]	diamond	165	95.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29397178	29397178	PRJNA342843_S_NODE_15689_length_150_cov_1.449541_g15539_i0	PRJNA342843	15689	150	1.449541	2.1743115	root	1	Root_unresolved	Root_unresolved	79	4.05e-16	NR	MCK9482662.1	2044936	g15539	i0	77.8	2.8	45	10	90	0	15	149	170	214	MCK9482662.1 hypothetical protein [Bacteroidia bacterium]	diamond	420	79	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30250155	30250155	PRJNA342843_S_NODE_11852_length_177_cov_0.970588_g11702_i0	PRJNA342843	11852	177	0.970588	1.71794076	Bacteroidota	976	Bacteria	Bacteria	104	3.1999999999999998e-24	NR	MDO9184488.1	2044936	g11702	i0	94.9	2	59	3	100	0	177	1	801	859	MDO9184488.1 DUF1249 domain-containing protein [Bacteroidia bacterium]	diamond	354	104	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30896391	30896391	PRJNA342843_S_NODE_8114_length_225_cov_1.010870_g7964_i0	PRJNA342843	8114	225	1.01087	2.2744575	Weeksellaceae bacterium	2823802	Bacteria	Bacteria	98.2	1.95e-22	NR	MFA5621011.1	2823802	g7964	i0	63.5	0.986666666666667	74	27	98.7	0	3	224	12	85	MFA5621011.1 hypothetical protein [Weeksellaceae bacterium]	diamond	222	98.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium
31528596	31528596	PRJNA342843_S_NODE_5796_length_277_cov_1.042373_g5646_i0	PRJNA342843	5796	277	1.042373	2.88737321	Bacteroidetes bacterium ADurb.Bin	1898104	Bacteria	Bacteria	54.7	8.99e-7	NR	OQC35506.1	1852801	g5646	i0	59	0.422382671480144	39	16	42.2	0	120	4	8	46	OQC35506.1 MAG: Endodeoxyribonuclease RusA [Bacteroidetes bacterium ADurb.Bin041]	diamond	117	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium ADurb.Bin041
32431630	32431630	PRJNA342843_S_NODE_6119_length_267_cov_3.318584_g5969_i0	PRJNA342843	6119	267	3.318584	8.86061928	FCB group	1783270	Bacteria	Bacteria	50.4	9.1e-5	NR	MBU1718758.1	1898104	g5969	i0	61.9	1.42696629213483	42	16	47.2	0	262	137	20	61	MBU1718758.1 beta-propeller fold lactonase family protein [Bacteroidota bacterium]	diamond	381	50.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32683955	32683955	PRJNA342843_S_NODE_12520_length_171_cov_1.276923_g12370_i0	PRJNA342843	12520	171	1.276923	2.18353833	FCB group	1783270	Bacteria	Bacteria	42	0.0259	NR	GHT40850.1	2044936	g12370	i0	40	1.45614035087719	40	24	70.2	0	131	12	141	180	GHT40850.1 hypothetical protein FACS189437_07020 [Bacteroidia bacterium]	diamond	249	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
32698307	32698307	PRJNA342843_S_NODE_10960_length_185_cov_2.416667_g10810_i0	PRJNA342843	10960	185	2.416667	4.47083395	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	60.8	4.03e-9	NR	MCC6447774.1	1869212	g10810	i0	44.2	0.843243243243243	52	28	84.3	1	1	156	60	110	MCC6447774.1 site-specific DNA-methyltransferase [Chitinophagaceae bacterium]	diamond	156	60.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae 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);;