metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA484127" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA484127" 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
5552292	5552292	PRJNA484127_P_NODE_36145_length_245_cov_0.906977_g35996_i0	PRJNA484127	36145	245	0.906977	2.22209365	Adlercreutzia	447020	Bacteria	Bacteria	116	8.23e-30	NR	MDO4291543.1	1972561	g35996	i0	74.1	2.96326530612245	81	21	99.2	0	3	245	187	267	MDO4291543.1 ModD protein [Eggerthellaceae bacterium]	diamond	726	117	0.991452991452991	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae		Eggerthellaceae bacterium
18300403	18300403	PRJNA484127_P_NODE_7995_length_418_cov_1.127536_g7846_i0	PRJNA484127	7995	418	1.127536	4.71310048	Bacteria	2	Bacteria	Bacteria	236	2.5e-73	NR	HVN50138.1	2201156	g7846	i0	80.6	50.7846889952153	139	27	99.8	0	417	1	202	340	HVN50138.1 adenosylhomocysteinase [Acidimicrobiales bacterium]	diamond	21228	236	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
19574519	19574519	PRJNA484127_P_NODE_38796_length_242_cov_0.923077_g38647_i0	PRJNA484127	38796	242	0.923077	2.23384634	Paratractidigestivibacter faecalis	2292441	Bacteria	Bacteria	147	2.73e-43	NR	WP_117205903.1	2292441	g38647	i0	100	0.90495867768595	73	0	90.5	0	221	3	1	73	WP_117205903.1 ribose 5-phosphate isomerase B [Paratractidigestivibacter faecalis]	diamond	219	147	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Paratractidigestivibacter	Paratractidigestivibacter faecalis
23400680	23400680	PRJNA484127_P_NODE_18479_length_304_cov_1.307359_g18330_i0	PRJNA484127	18479	304	1.307359	3.97437136	Actinomycetota bacterium	2900548	Bacteria	Bacteria	126	7.309999999999999e-32	NR	MCL4368605.1	2900548	g18330	i0	60.6	11.7434210526316	94	37	92.8	0	300	19	220	313	MCL4368605.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Actinomycetota bacterium]	diamond	3570	126	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
25323569	25323569	PRJNA484127_P_NODE_32660_length_249_cov_0.886364_g32511_i0	PRJNA484127	32660	249	0.886364	2.20704636	Microbacterium	33882	Bacteria	Bacteria	152	2.2099999999999993e-43	NR	WP_231478652.1	33882	g32511	i0	97.6	0.987951807228916	82	2	98.8	0	248	3	20	101	WP_231478652.1 MULTISPECIES: sensor histidine kinase [Microbacterium]	diamond	246	152	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium
26696343	26696343	PRJNA484127_P_NODE_25861_length_267_cov_1.247423_g25712_i0	PRJNA484127	25861	267	1.247423	3.33061941	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	43.5	0.0256	NR	MEX0846683.1	2497619	g25712	i0	25.9	0.955056179775281	85	63	95.5	0	9	263	296	380	MEX0846683.1 HAMP domain-containing sensor histidine kinase [Ilumatobacteraceae bacterium]	diamond	255	43.5	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
27424161	27424161	PRJNA484127_P_NODE_12723_length_349_cov_1.507246_g12574_i0	PRJNA484127	12723	349	1.507246	5.26028854	Frankia sp. Cj3	2880976	Bacteria	Bacteria	42	0.0467	NR	WP_370651596.1	2880976	g12574	i0	39.3	0.481375358166189	56	33	47.3	1	335	171	17	72	WP_370651596.1 helix-turn-helix domain-containing protein [Frankia sp. Cj3]	diamond	168	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Frankia	Frankia sp. Cj3
27771429	27771429	PRJNA484127_P_NODE_11844_length_359_cov_1.048951_g11695_i0	PRJNA484127	11844	359	1.048951	3.76573409	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	219	4.18e-65	NR	WP_252941089.1	2841670	g11695	i0	88.2	0.994428969359331	119	14	99.4	0	3	359	543	661	WP_252941089.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	357	219	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
29286684	29286684	PRJNA484127_P_NODE_32509_length_249_cov_1.625000_g32360_i0	PRJNA484127	32509	249	1.625	4.04625	Actinomycetales bacterium	1911520	Bacteria	Bacteria	45.4	0.00441	NR	MBU6147104.1	1911520	g32360	i0	40	0.783132530120482	65	35	74.7	2	53	238	118	181	MBU6147104.1 hypothetical protein [Actinomycetales bacterium]	diamond	195	45.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales			Actinomycetales bacterium
30345685	30345685	PRJNA484127_P_NODE_15952_length_321_cov_0.870968_g15803_i0	PRJNA484127	15952	321	0.870968	2.79580728	Actinomycetota	201174	Bacteria	Bacteria	131	8.9e-37	NR	MEI6362425.1	1883427	g15803	i0	68.8	3.45794392523365	93	28	86.9	1	1	279	52	143	MEI6362425.1 RbsD/FucU domain-containing protein [Actinomycetes bacterium]	diamond	1110	132	0.992424242424242	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
30914025	30914025	PRJNA484127_P_NODE_11174_length_366_cov_2.129693_g11025_i0	PRJNA484127	11174	366	2.129693	7.79467638	Actinomycetes	1760	Bacteria	Bacteria	64.3	4.16e-9	NR	WP_005458622.1	40989	g11025	i0	41.8	6.76229508196721	91	50	73	3	345	79	373	462	WP_005458622.1 AMP-dependent synthetase/ligase [Saccharomonospora cyanea]	diamond	2475	64.7	0.993817619783617	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharomonospora	Saccharomonospora cyanea
32067696	32067696	PRJNA484127_P_NODE_34278_length_247_cov_1.264368_g34129_i0	PRJNA484127	34278	247	1.264368	3.12298896	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	46.6	0.0017	NR	HEY3183604.1	2838783	g34129	i0	42.3	0.862348178137652	71	21	86.2	3	23	235	22	72	HEY3183604.1 hypothetical protein [Gaiellaceae bacterium]	diamond	213	46.6	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae 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);;