metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA897077" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA897077" 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
3424416	3424416	PRJNA897077_P_NODE_17483_length_248_cov_0.891429_g17356_i0	PRJNA897077	17483	248	0.891429	2.21074392	Bacteroidota bacterium	1898104	Bacteria	Bacteria	105	4.53e-24	NR	MEN9347876.1	1898104	g17356	i0	69.1	0.979838709677419	81	25	98	0	243	1	519	599	MEN9347876.1 hypothetical protein [Bacteroidota bacterium]	diamond	243	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
11077094	11077094	PRJNA897077_P_NODE_15169_length_253_cov_0.866667_g15042_i0	PRJNA897077	15169	253	0.866667	2.19266751	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	139	1.2899999999999999e-38	NR	MBN2637135.1	2053594	g15042	i0	79.8	0.99604743083004	84	16	99.6	1	252	1	153	235	MBN2637135.1 prephenate dehydratase [Prolixibacteraceae bacterium]	diamond	252	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
17451811	17451811	PRJNA897077_P_NODE_17734_length_247_cov_0.896552_g17607_i0	PRJNA897077	17734	247	0.896552	2.21448344	Flavobacterium sp. N2	468057	Bacteria	Bacteria	70.5	2.33e-12	NR	WP_264551877.1	2986829	g17607	i0	69.2	1.40890688259109	39	12	47.4	0	245	129	212	250	WP_264551877.1 hypothetical protein [Flavobacterium sp. N2038]	diamond	348	70.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
21646311	21646311	PRJNA897077_P_NODE_16977_length_249_cov_0.886364_g16850_i0	PRJNA897077	16977	249	0.886364	2.20704636	Bacteroidota bacterium	1898104	Bacteria	Bacteria	171	3.4099999999999996e-48	NR	MBS1920145.1	1898104	g16850	i0	100	0.987951807228916	82	0	98.8	0	247	2	494	575	MBS1920145.1 acetate--CoA ligase [Bacteroidota bacterium]	diamond	246	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28255761	28255761	PRJNA897077_P_NODE_16646_length_250_cov_0.881356_g16519_i0	PRJNA897077	16646	250	0.881356	2.20339	Cytophagales bacterium CG18_big_fil_WC_8_21_14_2_5	2053541	Bacteria	Bacteria	139	4.01e-37	NR	PIQ22398.1	1973956	g16519	i0	81.9	1.992	83	15	99.6	0	2	250	35	117	PIQ22398.1 MAG: UDP-glucose 6-dehydrogenase [Cytophagales bacterium CG18_big_fil_WC_8_21_14_2_50_42_9]	diamond	498	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium CG18_big_fil_WC_8_21_14_2_50_42_9
28263395	28263395	PRJNA897077_P_NODE_5846_length_401_cov_2.426829_g5719_i0	PRJNA897077	5846	401	2.426829	9.73158429	root	1	Root_unresolved	Root_unresolved	44.7	0.0421	NR	WP_290872743.1	239	g5719	i0	34.3	1.61596009975062	99	63	72.6	1	18	308	189	287	WP_290872743.1 Tex family protein [Flavobacterium sp.]	diamond	648	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30055562	30055562	PRJNA897077_P_NODE_15871_length_252_cov_0.871508_g15744_i0	PRJNA897077	15871	252	0.871508	2.19620016	Bacteroidales bacterium	2030927	Bacteria	Bacteria	137	8.49e-38	NR	HEY5471184.1	2030927	g15744	i0	75.9	0.988095238095238	83	20	98.8	0	4	252	200	282	HEY5471184.1 class I SAM-dependent methyltransferase [Bacteroidales bacterium]	diamond	249	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30118783	30118783	PRJNA897077_P_NODE_16432_length_250_cov_0.881356_g16305_i0	PRJNA897077	16432	250	0.881356	2.20339	Desertivirga xinjiangensis	539206	Bacteria	Bacteria	55.1	1.88e-6	NR	WP_256012532.1	539206	g16305	i0	45.3	1.512	64	26	76.8	1	240	49	921	975	WP_256012532.1 hypothetical protein [Desertivirga xinjiangensis]	diamond	378	55.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Desertivirga	Desertivirga xinjiangensis
31224641	31224641	PRJNA897077_P_NODE_16515_length_250_cov_0.881356_g16388_i0	PRJNA897077	16515	250	0.881356	2.20339	Bacteroidales bacterium	2030927	Bacteria	Bacteria	174	2.89e-50	NR	NLY22912.1	2030927	g16388	i0	100	0.984	82	0	98.4	0	248	3	266	347	NLY22912.1 hypothetical protein [Bacteroidales bacterium]	diamond	246	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32553786	32553786	PRJNA897077_P_NODE_59_length_2443_cov_6.406329_g50_i0	PRJNA897077	59	2443	6.406329	156.50661747	Flavobacterium collinsii	1114861	Bacteria	Bacteria	52	0.00681	NR	WP_395341608.1	1114861	g50	i0	26.7	0.353663528448629	288	156	31.7	14	200	973	47	309	WP_395341608.1 hypothetical protein [Flavobacterium collinsii]	diamond	864	52	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium collinsii

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