metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA864829" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA864829" 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
13600992	13600992	PRJNA864829_S_NODE_5531_length_254_cov_1.404878_g5445_i0	PRJNA864829	5531	254	1.404878	3.56839012	Mycobacterium szulgai	1787	Bacteria	Bacteria	151	3.31e-43	NR	WP_085672270.1	1787	g5445	i0	100	0.838582677165354	71	0	83.9	0	2	214	227	297	WP_085672270.1 aldose 1-epimerase [Mycobacterium szulgai]	diamond	213	151	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium szulgai
27971067	27971067	PRJNA864829_S_NODE_12185_length_183_cov_2.014925_g12099_i0	PRJNA864829	12185	183	2.014925	3.68731275	Candidatus Frankia alpina	2699483	Bacteria	Bacteria	42	0.0311	NR	WP_235825961.1	2699483	g12099	i0	64.5	0.508196721311475	31	7	47.5	2	52	138	6	34	WP_235825961.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Frankia alpina]	diamond	93	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Frankia	Candidatus Frankia alpina
28065811	28065811	PRJNA864829_S_NODE_12365_length_182_cov_1.563910_g12279_i0	PRJNA864829	12365	182	1.56391	2.8463162	Mycobacterium szulgai	1787	Bacteria	Bacteria	125	4.569999999999999e-32	NR	WP_085669014.1	1787	g12279	i0	100	0.989010989010989	60	0	98.9	0	180	1	251	310	WP_085669014.1 phytoene desaturase family protein [Mycobacterium szulgai]	diamond	180	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium szulgai
28097354	28097354	PRJNA864829_S_NODE_4005_length_286_cov_2.109705_g3919_i0	PRJNA864829	4005	286	2.109705	6.0337563	Mycobacterium szulgai	1787	Bacteria	Bacteria	193	3.8399999999999995e-57	NR	WP_085670626.1	1787	g3919	i0	100	0.996503496503496	95	0	99.7	0	285	1	10	104	WP_085670626.1 TfuA-like protein [Mycobacterium szulgai]	diamond	285	193	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium szulgai
28097356	28097356	PRJNA864829_S_NODE_6865_length_234_cov_1.167568_g6779_i0	PRJNA864829	6865	234	1.167568	2.73210912	Williamsia sp. CHRR-6	2835871	Bacteria	Bacteria	43.1	0.0243	NR	WP_214242464.1	2835871	g6779	i0	29.8	1.07692307692308	84	51	97.4	1	233	6	427	510	WP_214242464.1 bifunctional FO biosynthesis protein CofGH [Williamsia sp. CHRR-6]	diamond	252	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia sp. CHRR-6
28129101	28129101	PRJNA864829_S_NODE_12485_length_181_cov_1.689394_g12399_i0	PRJNA864829	12485	181	1.689394	3.05780314	Tessaracoccus palaemonis	2829499	Bacteria	Bacteria	41.6	0.0431	NR	WP_219082952.1	2829499	g12399	i0	46.6	0.961325966850829	58	24	87.8	3	20	178	255	310	WP_219082952.1 CHAT domain-containing protein [Tessaracoccus palaemonis]	diamond	174	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus palaemonis
28476309	28476309	PRJNA864829_S_NODE_3026_length_316_cov_1.333333_g2940_i0	PRJNA864829	3026	316	1.333333	4.21333228	Candidatus Nanopelagicaceae bacterium	2518609	Bacteria	Bacteria	43.5	0.0433	NR	HEY3293697.1	2518609	g2940	i0	41.4	0.550632911392405	58	32	53.2	2	144	311	257	314	HEY3293697.1 MFS transporter [Candidatus Nanopelagicaceae bacterium]	diamond	174	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales	Candidatus Nanopelagicaceae		Candidatus Nanopelagicaceae bacterium
29044807	29044807	PRJNA864829_S_NODE_13168_length_177_cov_1.171875_g13082_i0	PRJNA864829	13168	177	1.171875	2.07421875	Streptomyces sp. CG1	1287523	Bacteria	Bacteria	88.2	1.54e-18	NR	WP_369387666.1	1287523	g13082	i0	64.4	1	59	21	100	0	1	177	382	440	WP_369387666.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Streptomyces sp. CG1]	diamond	177	88.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CG1
29360418	29360418	PRJNA864829_S_NODE_14069_length_172_cov_0.869919_g13983_i0	PRJNA864829	14069	172	0.869919	1.49626068	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	71.6	9.36e-13	NR	HMF04966.1	2080302	g13983	i0	67.3	0.959302325581395	55	17	95.9	1	171	7	865	918	HMF04966.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	165	71.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
29549624	29549624	PRJNA864829_S_NODE_3050_length_315_cov_1.815789_g2964_i0	PRJNA864829	3050	315	1.815789	5.71973535	Actinomycetota bacterium	2900548	Bacteria	Bacteria	46.6	0.00383	NR	MBS1844574.1	2900548	g2964	i0	35.9	0.60952380952381	64	41	61	0	14	205	311	374	MBS1844574.1 cation-transporting P-type ATPase [Actinomycetota bacterium]	diamond	192	46.6	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30789921	30789921	PRJNA864829_S_NODE_10894_length_192_cov_2.734266_g10808_i0	PRJNA864829	10894	192	2.734266	5.24979072	Mycobacterium	1763	Bacteria	Bacteria	43.5	0.00172	NR	WP_306237356.1	1763	g10808	i0	65.5	1.359375	29	10	45.3	0	190	104	55	83	WP_306237356.1 MULTISPECIES: hypothetical protein [Mycobacterium]	diamond	261	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium
32236826	32236826	PRJNA864829_S_NODE_15178_length_167_cov_1.745763_g15092_i0	PRJNA864829	15178	167	1.745763	2.91542421	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	77.8	7.9e-17	NR	HET9543341.1	2201156	g15092	i0	72.2	2.89221556886228	54	15	97	0	4	165	2	55	HET9543341.1 TfoX/Sxy family protein [Acidimicrobiales bacterium]	diamond	483	77.8	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
32553163	32553163	PRJNA864829_S_NODE_12319_length_182_cov_2.368421_g12233_i0	PRJNA864829	12319	182	2.368421	4.31052622	Streptomyces atroolivaceus	66869	Bacteria	Bacteria	40	0.0258	NR	WP_382206025.1	66869	g12233	i0	60.7	0.461538461538462	28	9	42.9	1	124	47	7	34	WP_382206025.1 hypothetical protein [Streptomyces atroolivaceus]	diamond	84	40	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces atroolivaceus
32773228	32773228	PRJNA864829_S_NODE_4360_length_278_cov_2.170306_g4274_i0	PRJNA864829	4360	278	2.170306	6.03345068	Actinomycetota bacterium	2900548	Bacteria	Bacteria	61.6	1.27e-8	NR	NLA37054.1	2900548	g4274	i0	61.5	2.80575539568345	52	12	56.1	2	275	120	411	454	NLA37054.1 citramalate synthase [Actinomycetota bacterium]	diamond	780	61.6	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
32867739	32867739	PRJNA864829_S_NODE_8140_length_217_cov_2.136905_g8054_i0	PRJNA864829	8140	217	2.136905	4.63708385	Mycobacterium szulgai	1787	Bacteria	Bacteria	140	5.6899999999999995e-37	NR	WP_085668827.1	1787	g8054	i0	100	0.981566820276498	71	0	98.2	0	215	3	576	646	WP_085668827.1 hypothetical protein [Mycobacterium szulgai]	diamond	213	140	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium szulgai

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