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

9 rows where analysis = "diamond", bioproject = "PRJNA645397" 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
19746429	19746429	PRJNA645397_P_NODE_4836_length_240_cov_1.445026_g4763_i0	PRJNA645397	4836	240	1.445026	3.4680624	Planobacterium oryzisoli	2771435	Bacteria	Bacteria	156	1.99e-44	NR	WP_194739227.1	2771435	g4763	i0	98.8	1	80	1	100	0	240	1	148	227	WP_194739227.1 DNA polymerase III subunit gamma/tau [Planobacterium oryzisoli]	diamond	240	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Planobacterium oryzisoli
24845946	24845946	PRJNA645397_S_NODE_500_length_242_cov_1.129534_g498_i0	PRJNA645397	500	242	1.129534	2.73347228	Flavisolibacter sp.	1954249	Bacteria	Bacteria	158	1.24e-46	NR	HEY0059840.1	1954249	g498	i0	91.3	0.991735537190083	80	7	99.2	0	3	242	119	198	HEY0059840.1 monofunctional biosynthetic peptidoglycan transglycosylase [Flavisolibacter sp.]	diamond	240	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter sp.
26828284	26828284	PRJNA645397_S_NODE_741_length_210_cov_0.968944_g739_i0	PRJNA645397	741	210	0.968944	2.0347824	Flaviaestuariibacter sp.	1986182	Bacteria	Bacteria	91.7	1.48e-19	NR	MDB5195670.1	1986182	g739	i0	68.1	3.08571428571429	72	21	100	2	210	1	277	348	MDB5195670.1 family peptidase [Flaviaesturariibacter sp.]	diamond	648	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flaviaestuariibacter	Flaviaestuariibacter sp.
27492172	27492172	PRJNA645397_P_NODE_4503_length_250_cov_1.064677_g4430_i0	PRJNA645397	4503	250	1.064677	2.6616925	Planobacterium oryzisoli	2771435	Bacteria	Bacteria	137	3.1099999999999997e-37	NR	WP_194739227.1	2771435	g4430	i0	94.5	0.876	73	4	87.6	0	2	220	286	358	WP_194739227.1 DNA polymerase III subunit gamma/tau [Planobacterium oryzisoli]	diamond	219	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Planobacterium oryzisoli
27713505	27713505	PRJNA645397_P_NODE_9204_length_169_cov_0.866667_g9131_i0	PRJNA645397	9204	169	0.866667	1.46466723	Flavobacterium sp. J372	2898436	Bacteria	Bacteria	77.8	6.08e-15	NR	WP_257866644.1	2898436	g9131	i0	84.1	0.781065088757396	44	7	78.1	0	168	37	890	933	WP_257866644.1 AsmA family protein [Flavobacterium sp. J372]	diamond	132	77.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. J372
28104094	28104094	PRJNA645397_S_NODE_725_length_212_cov_1.276074_g723_i0	PRJNA645397	725	212	1.276074	2.70527688	Bacteria	2	Bacteria	Bacteria	103	1.97e-25	NR	MBA3675699.1	1869212	g723	i0	81.4	1.9811320754717	70	13	99.1	0	210	1	139	208	MBA3675699.1 LysE family transporter [Chitinophagaceae bacterium]	diamond	420	104	0.990384615384615	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29272299	29272299	PRJNA645397_S_NODE_1569_length_163_cov_0.877193_g1567_i0	PRJNA645397	1569	163	0.877193	1.42982459	Flavisolibacter	398041	Bacteria	Bacteria	102	1.26e-25	NR	RYZ25218.1	1869212	g1567	i0	92.6	2.96319018404908	54	4	99.4	0	163	2	89	142	RYZ25218.1 MAG: glutamate racemase, partial [Chitinophagaceae bacterium]	diamond	483	103	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29607161	29607161	PRJNA645397_P_NODE_7250_length_192_cov_1.048951_g7177_i0	PRJNA645397	7250	192	1.048951	2.01398592	Flavobacterium sp. J372	2898436	Bacteria	Bacteria	112	4.22e-27	NR	WP_257866644.1	2898436	g7177	i0	94.8	0.90625	58	3	90.6	0	19	192	742	799	WP_257866644.1 AsmA family protein [Flavobacterium sp. J372]	diamond	174	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. J372
30081105	30081105	PRJNA645397_S_NODE_672_length_220_cov_1.087719_g670_i0	PRJNA645397	672	220	1.087719	2.3929818	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	92	1.23e-19	NR	WP_146784015.1	661481	g670	i0	85.7	0.668181818181818	49	7	66.8	0	74	220	1	49	WP_146784015.1 prolyl oligopeptidase family serine peptidase [Flavisolibacter ginsenosidimutans]	diamond	147	92	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans

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