metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1196384" 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
15625477	15625477	PRJNA1196384_S_NODE_4553_length_188_cov_2.589404_g4489_i0	PRJNA1196384	4553	188	2.589404	4.86807952	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	92.4	4.59e-20	NR	HPT30421.1	2053594	g4489	i0	91.5	6.09574468085106	47	4	75	0	6	146	426	472	HPT30421.1 adenosylhomocysteinase [Prolixibacteraceae bacterium]	diamond	1146	92.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
26882782	26882782	PRJNA1196384_S_NODE_6341_length_166_cov_1.193798_g6277_i0	PRJNA1196384	6341	166	1.193798	1.98170468	Cytophagales bacterium	2053541	Bacteria	Bacteria	42	0.0252	NR	HEX8532100.1	2053541	g6277	i0	42.6	1.78915662650602	54	31	97.6	0	1	162	54	107	HEX8532100.1 DUF1565 domain-containing protein [Cytophagales bacterium]	diamond	297	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium
29459497	29459497	PRJNA1196384_S_NODE_5390_length_177_cov_1.100000_g5326_i0	PRJNA1196384	5390	177	1.1	1.947	Pseudomonadati	3379134	Bacteria	Bacteria	90.9	1.95e-20	NR	MBK7147921.1	1898104	g5326	i0	69.5	11	59	18	100	0	177	1	109	167	MBK7147921.1 3-deoxy-8-phosphooctulonate synthase [Bacteroidota bacterium]	diamond	1947	91.7	0.991275899672846	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30230411	30230411	PRJNA1196384_S_NODE_2812_length_231_cov_2.304124_g2748_i0	PRJNA1196384	2812	231	2.304124	5.32252644	Bacteroidia bacterium	2044936	Bacteria	Bacteria	50.1	8.34e-5	NR	MCX8113298.1	2044936	g2748	i0	43.1	0.753246753246753	58	30	71.4	1	165	1	254	311	MCX8113298.1 NAD(P)-binding domain-containing protein [Bacteroidia bacterium]	diamond	174	50.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30230412	30230412	PRJNA1196384_S_NODE_3092_length_221_cov_2.255435_g3028_i0	PRJNA1196384	3092	221	2.255435	4.98451135	Bacteroidota bacterium	1898104	Bacteria	Bacteria	68.6	1.31e-11	NR	MBS1738818.1	1898104	g3028	i0	52	1.01809954751131	75	33	97.7	1	1	216	151	225	MBS1738818.1 50S ribosomal protein L2 [Bacteroidota bacterium]	diamond	225	68.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30294030	30294030	PRJNA1196384_S_NODE_812_length_426_cov_3.802057_g748_i0	PRJNA1196384	812	426	3.802057	16.19676282	Spirosoma utsteinense	2585773	Bacteria	Bacteria	52.4	6.82e-5	NR	WP_186750249.1	2585773	g748	i0	27.7	2.70422535211268	119	71	74.6	4	66	383	7	123	WP_186750249.1 HNH endonuclease [Spirosoma utsteinense]	diamond	1152	52.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma utsteinense
30799020	30799020	PRJNA1196384_S_NODE_8214_length_152_cov_0.991304_g8150_i0	PRJNA1196384	8214	152	0.991304	1.50678208	Bacteroidota bacterium	1898104	Bacteria	Bacteria	75.5	2.97e-14	NR	MBL0046497.1	1898104	g8150	i0	72	1.97368421052632	50	14	98.7	0	3	152	188	237	MBL0046497.1 Glu/Leu/Phe/Val dehydrogenase [Bacteroidota bacterium]	diamond	300	75.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32570491	32570491	PRJNA1196384_S_NODE_6059_length_169_cov_1.007576_g5995_i0	PRJNA1196384	6059	169	1.007576	1.70280344	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	47	4.35e-4	NR	MDA3818470.1	2053594	g5995	i0	46.2	0.692307692307692	39	21	69.2	0	52	168	286	324	MDA3818470.1 zinc-binding dehydrogenase [Prolixibacteraceae bacterium]	diamond	117	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae 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);;