metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA937226" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA937226" 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
18763561	18763561	PRJNA937226_S_NODE_13495_length_217_cov_1.547619_g13368_i0	PRJNA937226	13495	217	1.547619	3.35833323	Prevotella sp.	59823	Bacteria	Bacteria	152	6e-41	NR	MBD9230008.1	59823	g13368	i0	94.4	0.981566820276498	71	4	98.2	0	215	3	23	93	MBD9230008.1 DUF4982 domain-containing protein [Prevotella sp.]	diamond	213	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
26961525	26961525	PRJNA937226_S_NODE_10962_length_235_cov_2.763441_g10835_i0	PRJNA937226	10962	235	2.763441	6.49408635	Prevotella sp.	59823	Bacteria	Bacteria	113	1.17e-30	NR	MBR2035444.1	59823	g10835	i0	98.4	0.778723404255319	61	1	77.9	0	53	235	1	61	MBR2035444.1 membrane protein insertase YidC [Prevotella sp.]	diamond	183	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
27625409	27625409	PRJNA937226_S_NODE_12584_length_223_cov_1.195402_g12457_i0	PRJNA937226	12584	223	1.195402	2.66574646	Bacteroidales bacterium	2030927	Bacteria	Bacteria	133	6.289999999999998e-35	NR	MEE1081819.1	2030927	g12457	i0	94.5	0.982062780269058	73	4	98.2	0	3	221	6	78	MEE1081819.1 hypothetical protein [Bacteroidales bacterium]	diamond	219	133	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28484820	28484820	PRJNA937226_S_NODE_16626_length_200_cov_2.754967_g16499_i0	PRJNA937226	16626	200	2.754967	5.509934	Bacteroides	816	Bacteria	Bacteria	113	4.33e-31	NR	MBO5795928.1	29523	g16499	i0	91.4	3.48	58	5	87	0	26	199	1	58	MBO5795928.1 type II toxin-antitoxin system prevent-host-death family antitoxin [Bacteroides sp.]	diamond	696	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
29930405	29930405	PRJNA937226_S_NODE_3491_length_347_cov_2.268456_g3364_i0	PRJNA937226	3491	347	2.268456	7.87154232	Alistipes sp.	1872444	Bacteria	Bacteria	164	2.64e-49	NR	MBO5044251.1	1872444	g3364	i0	100	0.726224783861671	84	0	72.6	0	95	346	1	84	MBO5044251.1 nucleoside deaminase [Alistipes sp.]	diamond	252	164	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
29961810	29961810	PRJNA937226_S_NODE_19811_length_186_cov_2.992701_g19684_i0	PRJNA937226	19811	186	2.992701	5.56642386	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	42	0.0327	NR	MBC7875087.1	1869212	g19684	i0	41.4	0.935483870967742	58	32	93.5	2	12	185	176	231	MBC7875087.1 PspC domain-containing protein [Chitinophagaceae bacterium]	diamond	174	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30663898	30663898	PRJNA937226_S_NODE_28173_length_162_cov_5.327434_g28046_i0	PRJNA937226	28173	162	5.327434	8.63044308	Bacteroidota	976	Bacteria	Bacteria	101	2.87e-26	NR	HLO81779.1	1869212	g28046	i0	86.8	1.96296296296296	53	7	98.1	0	160	2	6	58	HLO81779.1 type II toxin-antitoxin system PemK/MazF family toxin [Chitinophagaceae bacterium]	diamond	318	101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31605261	31605261	PRJNA937226_S_NODE_13476_length_217_cov_1.857143_g13349_i0	PRJNA937226	13476	217	1.857143	4.03000031	Bacteroidales bacterium	2030927	Bacteria	Bacteria	109	1.24e-26	NR	MBR4978503.1	2030927	g13349	i0	94.7	0.788018433179724	57	3	78.8	0	1	171	291	347	MBR4978503.1 type I asparaginase [Bacteroidales bacterium]	diamond	171	109	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31700099	31700099	PRJNA937226_S_NODE_8917_length_253_cov_1.274510_g8790_i0	PRJNA937226	8917	253	1.27451	3.2245103	Segatella copri	165179	Bacteria	Bacteria	169	5.73e-50	NR	MEE1460156.1	165179	g8790	i0	100	0.99604743083004	84	0	99.6	0	253	2	158	241	MEE1460156.1 hypothetical protein [Segatella copri]	diamond	252	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri

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