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

10 rows where analysis = "diamond", bioproject = "PRJEB73599" 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
2270626	2270626	PRJEB73599_P_NODE_4482_length_318_cov_2.484429_g4195_i0	PRJEB73599	4482	318	2.484429	7.90048422	Streptomyces polyasparticus	2767826	Bacteria	Bacteria	172	1.9799999999999994e-52	NR	WP_187820194.1	2767826	g4195	i0	87.9	0.933962264150943	99	10	93.4	1	20	316	35	131	WP_187820194.1 chlorophyll a-b binding domain-containing protein, partial [Streptomyces polyasparticus]	diamond	297	172	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces polyasparticus
7787572	7787572	PRJEB73599_P_NODE_727_length_886_cov_2.033839_g583_i0	PRJEB73599	727	886	2.033839	18.01981354	Nocardiopsis alborubida	146802	Bacteria	Bacteria	95.5	7.78e-18	NR	WP_168443938.1	146802	g583	i0	36	1.01580135440181	150	79	47.7	4	878	456	258	399	WP_168443938.1 type I polyketide synthase [Nocardiopsis alborubida]	diamond	900	95.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis alborubida
27539762	27539762	PRJEB73599_P_NODE_5364_length_276_cov_2.048583_g5077_i0	PRJEB73599	5364	276	2.048583	5.65408908	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	43.5	0.0295	NR	WP_363135002.1	3157097	g5077	i0	43.8	0.521739130434783	48	27	52.2	0	88	231	84	131	WP_363135002.1 PQQ-binding-like beta-propeller repeat protein [Streptomyces sp. NPDC050610]	diamond	144	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC050610
27729500	27729500	PRJEB73599_P_NODE_1004_length_751_cov_4.897507_g827_i0	PRJEB73599	1004	751	4.897507	36.78027757	Actinomadura sp.	1989	Bacteria	Bacteria	108	1.56e-24	NR	HEV7933428.1	1989	g827	i0	32.4	0.838881491344874	210	135	81.5	4	704	93	18	226	HEV7933428.1 hypothetical protein [Actinomadura sp.]	diamond	630	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp.
28739515	28739515	PRJEB73599_P_NODE_6767_length_226_cov_2.060914_g6480_i0	PRJEB73599	6767	226	2.060914	4.65766564	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	101	2.45e-24	NR	MCB0958566.1	2201156	g6480	i0	60	1.99115044247788	75	30	99.6	0	1	225	153	227	MCB0958566.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium]	diamond	450	101	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
30350614	30350614	PRJEB73599_P_NODE_6872_length_223_cov_2.262887_g6585_i0	PRJEB73599	6872	223	2.262887	5.04623801	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	90.9	3.2e-20	NR	MCB0958566.1	2201156	g6585	i0	53.4	5.91928251121076	73	34	98.2	0	221	3	153	225	MCB0958566.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium]	diamond	1320	90.9	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
31132465	31132465	PRJEB73599_P_NODE_755_length_868_cov_2.537545_g524_i2	PRJEB73599	755	868	2.537545	22.0258906	FCB group	1783270	Bacteria	Bacteria	170	1.5899999999999996e-43	NR	MCW2687244.1	1785	g524	i2	39.5	21.1624423963134	263	152	89.9	6	7	786	595	853	MCW2687244.1 Polyketide synthase [Mycobacterium sp.]	diamond	18369	170	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
31354163	31354163	PRJEB73599_P_NODE_7996_length_192_cov_1.754601_g7709_i0	PRJEB73599	7996	192	1.754601	3.36883392	FCB group	1783270	Bacteria	Bacteria	71.6	4.62e-13	NR	MEZ5183991.1	2201156	g7709	i0	46	4.90625	63	34	98.4	0	2	190	152	214	MEZ5183991.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium]	diamond	942	71.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
31512449	31512449	PRJEB73599_P_NODE_676_length_915_cov_2.551919_g524_i1	PRJEB73599	676	915	2.551919	23.35005885	delta/epsilon subdivisions	68525	Bacteria	Bacteria	171	7.699999999999998e-44	NR	WP_085249783.1	486698	g524	i1	38	21.2065573770492	266	154	85.9	5	46	831	571	829	WP_085249783.1 type I polyketide synthase [Mycobacterium riyadhense]	diamond	19404	172	0.994186046511628	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium riyadhense
32057199	32057199	PRJEB73599_P_NODE_10038_length_152_cov_2.853659_g9751_i0	PRJEB73599	10038	152	2.853659	4.33756168	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	73.6	4.86e-14	NR	MCB0958566.1	2201156	g9751	i0	61.7	0.927631578947368	47	18	92.8	0	3	143	183	229	MCB0958566.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium]	diamond	141	73.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales 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);;