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

10 rows where analysis = "diamond", bioproject = "PRJNA853194" and tax_phylum = "Actinomycetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
29518049	29518049	PRJNA853194_S_NODE_68790_length_265_cov_1.151042_g67699_i0	PRJNA853194	68790	265	1.151042	3.0502613	Sinomonas cellulolyticus	2801916	Bacteria	Bacteria	43.5	0.0254	NR	WP_189693105.1	2801916	g67699	i0	35.5	0.860377358490566	76	42	86	1	32	259	97	165	WP_189693105.1 glycosyltransferase 87 family protein [Sinomonas cellulolyticus]	diamond	228	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Sinomonas	Sinomonas cellulolyticus
29833867	29833867	PRJNA853194_S_NODE_65011_length_272_cov_1.663317_g63920_i0	PRJNA853194	65011	272	1.663317	4.52422224	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	44.3	0.0157	NR	WP_399435965.1	3365658	g63920	i0	47.5	0.441176470588235	40	21	44.1	0	71	190	1206	1245	WP_399435965.1 hypothetical protein [Streptomyces sp. NPDC051561]	diamond	120	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC051561
29905424	29905424	PRJNA853194_S_NODE_80631_length_246_cov_1.745665_g79540_i0	PRJNA853194	80631	246	1.745665	4.2943359	root	1	Root_unresolved	Root_unresolved	105	8.870000000000001e-27	NR	NSL78899.1	1902	g79540	i0	74.7	5.78048780487805	79	20	96.3	0	237	1	45	123	NSL78899.1 hypothetical protein [Streptomyces coelicolor]	diamond	1422	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces coelicolor
30592048	30592048	PRJNA853194_S_NODE_62313_length_278_cov_1.029268_g61222_i0	PRJNA853194	62313	278	1.029268	2.86136504	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	43.9	0.0213	NR	WP_388990728.1	3364609	g61222	i0	43.2	0.474820143884892	44	25	47.5	0	174	43	118	161	WP_388990728.1 serine hydroxymethyltransferase [Streptomyces sp. NPDC001796]	diamond	132	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC001796
30853087	30853087	PRJNA853194_S_NODE_85094_length_241_cov_1.773810_g84003_i0	PRJNA853194	85094	241	1.77381	4.2748821	Streptomyces	1883	Bacteria	Bacteria	42.7	0.0288	NR	WP_053657044.1	1415544	g84003	i0	33.3	1.26970954356846	48	32	59.8	0	175	32	51	98	WP_053657044.1 phosphatase PAP2 family protein [Streptomyces sp. MMG1121]	diamond	306	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. MMG1121
31698509	31698509	PRJNA853194_S_NODE_77617_length_250_cov_0.870056_g76526_i0	PRJNA853194	77617	250	0.870056	2.17514	Microbispora sp. H1	1898321	Bacteria	Bacteria	42.4	0.0396	NR	WP_182879688.1	2729111	g76526	i0	35.7	0.84	70	37	74.4	3	9	194	123	192	WP_182879688.1 hypothetical protein [Microbispora sp. H10949]	diamond	210	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Microbispora	Microbispora sp. H10949
32109791	32109791	PRJNA853194_S_NODE_75738_length_252_cov_1.592179_g74647_i0	PRJNA853194	75738	252	1.592179	4.01229108	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	42	0.0204	NR	MFI5040452.1	2201156	g74647	i0	36.4	0.654761904761905	55	35	65.5	0	27	191	19	73	MFI5040452.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	165	42	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
32308155	32308155	PRJNA853194_S_NODE_64439_length_273_cov_1.940000_g63348_i0	PRJNA853194	64439	273	1.94	5.2962	Acidimicrobiales	84993	Bacteria	Bacteria	44.7	0.0104	NR	HBZ62281.1	1872112	g63348	i0	37.3	7.13186813186813	59	36	64.8	1	239	63	63	120	HBZ62281.1 pyruvate dehydrogenase [Acidimicrobium sp.]	diamond	1947	45.1	0.991130820399113	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae	Acidimicrobium	Acidimicrobium sp.
32426253	32426253	PRJNA853194_S_NODE_80379_length_247_cov_0.879310_g79288_i0	PRJNA853194	80379	247	0.87931	2.1718957	Streptosporangium sp. NPDC	47486	Bacteria	Bacteria	43.1	0.0282	NR	WP_362803166.1	3154794	g79288	i0	39.3	0.740890688259109	61	34	72.9	2	231	52	123	181	WP_362803166.1 AAA family ATPase [Streptosporangium sp. NPDC023615]	diamond	183	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Streptosporangium	Streptosporangium sp. NPDC023615
32489661	32489661	PRJNA853194_S_NODE_62919_length_276_cov_2.906404_g61828_i0	PRJNA853194	62919	276	2.906404	8.02167504	Mycobacterium leprae	1769	Bacteria	Bacteria	40.8	0.029	NR	WP_162618264.1	1769	g61828	i0	35	0.434782608695652	40	26	43.5	0	56	175	11	50	WP_162618264.1 hypothetical protein [Mycobacterium leprae]	diamond	120	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium leprae

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