metadata: contig_metadata: 14 rows where bioproject = "PRJNA1068513", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA1068513", tax_kingdom = "Bacillati" 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
181877	181877	PRJNA1068513_S_NODE_12261_length_251_cov_1.494382_g12215_i0	PRJNA1068513	12261	251	1.494382	3.75089882	Streptomyces sp. NBC_01497	2903885	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2661748798\|gb\|CP109427.1\|	2903885	g12215	i0	100	0.111553784860558	28	0	11	0	83	110	5557671	5557644	Streptomyces sp. NBC_01497 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01497
1013636	1013636	PRJNA1068513_S_NODE_5701_length_381_cov_2.649351_g5655_i0	PRJNA1068513	5701	381	2.649351	10.09402731	Streptomyces	1883	Bacteria	Bacteria	130	1.63e-25	NTclustered	gi\|2424005877\|gb\|CP114203.1\|	1920	g5655	i0	80.46	34.5223097112861	174	31	45	3	210	381	9245518	9245690	Streptomyces nigrescens strain DSM 40276 chromosome, complete genome	blastn	13153	130	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces nigrescens
12935595	12935595	PRJNA1068513_S_NODE_2291_length_545_cov_5.430085_g2249_i0	PRJNA1068513	2291	545	5.430085	29.59396325	Micromonospora carbonacea	47853	Bacteria	Bacteria	54.7	0.015	NTclustered	gi\|1877131014\|gb\|CP058905.1\|	47853	g2249	i0	100	0.0532110091743119	29	0	5	0	333	361	3037975	3037947	Micromonospora carbonacea strain africana chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora carbonacea
15484583	15484583	PRJNA1068513_S_NODE_4193_length_438_cov_8.832877_g4148_i0	PRJNA1068513	4193	438	8.832877	38.68800126	Actinomycetes	1760	Bacteria	Bacteria	176	5.6e-53	NR	WP_357328706.1	58117	g4148	i0	69.9	19.3698630136986	123	33	84.2	2	2	370	84	202	WP_357328706.1 adenosylhomocysteinase, partial [Microbispora rosea]	diamond	8484	177	0.994350282485876	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Microbispora	Microbispora rosea
19307472	19307472	PRJNA1068513_S_NODE_4696_length_417_cov_10.267442_g4651_i0	PRJNA1068513	4696	417	10.267442	42.81523314	Streptomyces sp. NBC_00857	2975851	Bacteria	Bacteria	58.4	8.62e-4	NTclustered	gi\|2655540414\|gb\|CP108829.1\|	2975851	g4651	i0	92.5	0.0959232613908873	40	3	10	0	89	128	2448830	2448791	Streptomyces sp. NBC_00857 chromosome, complete genome	blastn	40	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00857
26592230	26592230	PRJNA1068513_S_NODE_6401_length_361_cov_1.729167_g6355_i0	PRJNA1068513	6401	361	1.729167	6.24229287	Mycobacterium sp.	1785	Bacteria	Bacteria	42.7	0.0442	NR	WP_325613105.1	1785	g6355	i0	43.9	0.340720221606648	41	23	34.1	0	282	160	87	127	WP_325613105.1 hypothetical protein [Mycobacterium sp.]	diamond	123	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27225151	27225151	PRJNA1068513_S_NODE_11943_length_254_cov_0.983425_g11897_i0	PRJNA1068513	11943	254	0.983425	2.4978995	Thermoleophilales bacterium	2760806	Bacteria	Bacteria	67	8.91e-11	NR	MEA2444252.1	2760806	g11897	i0	45	2.5748031496063	80	36	88.6	3	252	28	191	267	MEA2444252.1 malate dehydrogenase [Thermoleophilales bacterium]	diamond	654	67	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Thermoleophilales			Thermoleophilales bacterium
28101045	28101045	PRJNA1068513_S_NODE_6585_length_356_cov_1.713781_g6539_i0	PRJNA1068513	6585	356	1.713781	6.10106036	Bacteria	2	Bacteria	Bacteria	115	2.25e-27	NR	WP_307326838.1	3041785	g6539	i0	57.3	9.70786516853933	96	41	80.9	0	1	288	359	454	WP_307326838.1 NAD-dependent succinate-semialdehyde dehydrogenase [Microbacterium sp. SORGH_AS_1204]	diamond	3456	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. SORGH_AS_1204
29837652	29837652	PRJNA1068513_S_NODE_4611_length_421_cov_2.100575_g4566_i0	PRJNA1068513	4611	421	2.100575	8.84342075	root	1	Root_unresolved	Root_unresolved	73.6	4.92e-14	NR	MCE7884015.1	2293627	g4566	i0	46.2	4.07600950118765	78	40	54.2	2	250	23	3	80	MCE7884015.1 RNA-binding protein [Actinobacteria bacterium ATB1]	diamond	1716	73.6	1	Bacteria	Bacillati	Actinomycetota					Actinobacteria bacterium ATB1
30067238	30067238	PRJNA1068513_S_NODE_5092_length_402_cov_1.778116_g5047_i0	PRJNA1068513	5092	402	1.778116	7.14802632	Actinoalloteichus hymeniacidonis	340345	Bacteria	Bacteria	55.1	8.05e-6	NR	WP_069845689.1	340345	g5047	i0	45.2	0.462686567164179	62	30	46.3	1	395	210	207	264	WP_069845689.1 S49 family peptidase [Actinoalloteichus hymeniacidonis]	diamond	186	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinoalloteichus	Actinoalloteichus hymeniacidonis
30383670	30383670	PRJNA1068513_S_NODE_5273_length_395_cov_4.888199_g5228_i0	PRJNA1068513	5273	395	4.888199	19.30838605	Kitasatospora sp. NPDC	1871188	Bacteria	Bacteria	84.7	3.32e-16	NR	WP_396608538.1	3364059	g5228	i0	50.8	0.493670886075949	65	32	49.4	0	1	195	374	438	WP_396608538.1 L-fuconate dehydratase [Kitasatospora sp. NPDC051984]	diamond	195	84.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora sp. NPDC051984
31236244	31236244	PRJNA1068513_S_NODE_12875_length_246_cov_1.294798_g12829_i0	PRJNA1068513	12875	246	1.294798	3.18520308	Solirubrobacterales bacterium	1909295	Bacteria	Bacteria	52.8	9.16e-6	NR	MEZ5122938.1	1909295	g12829	i0	42.4	1.03658536585366	85	44	97.6	2	3	242	154	238	MEZ5122938.1 aquaporin [Solirubrobacterales bacterium]	diamond	255	52.8	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
31868854	31868854	PRJNA1068513_S_NODE_10197_length_280_cov_1.038647_g10151_i0	PRJNA1068513	10197	280	1.038647	2.9082116	Actinomycetes bacterium	1883427	Bacteria	Bacteria	46.6	0.00255	NR	MCH9729987.1	1883427	g10151	i0	58.8	1.45714285714286	34	14	36.4	0	119	220	176	209	MCH9729987.1 sensor domain-containing protein [Actinomycetes bacterium]	diamond	408	46.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
32217061	32217061	PRJNA1068513_S_NODE_10698_length_272_cov_3.407035_g10652_i0	PRJNA1068513	10698	272	3.407035	9.2671352	Actinomycetota bacterium	2900548	Bacteria	Bacteria	64.3	1.34e-9	NR	MEX2394385.1	2900548	g10652	i0	61.7	2.17279411764706	47	17	51.8	1	80	220	590	635	MEX2394385.1 S9 family peptidase [Actinomycetota bacterium]	diamond	591	64.3	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota 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);;