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

10 rows where analysis = "diamond", bioproject = "PRJNA380416" 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
15704726	15704726	PRJNA380416_P_NODE_13753_length_161_cov_0.910714_g13606_i0	PRJNA380416	13753	161	0.910714	1.46624954	Leifsonia sp. TF	1870902	Bacteria	Bacteria	100	5.519999999999999e-23	NR	WP_208039097.1	2815212	g13606	i0	98.1	0.987577639751553	53	1	98.8	0	2	160	485	537	WP_208039097.1 magnesium-translocating P-type ATPase [Leifsonia sp. TF02-11]	diamond	159	100	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
27296277	27296277	PRJNA380416_P_NODE_13483_length_162_cov_0.902655_g13336_i0	PRJNA380416	13483	162	0.902655	1.4623011	Mycobacterium sp.	1785	Bacteria	Bacteria	113	3.5199999999999995e-31	NR	MBI3217013.1	1785	g13336	i0	96.2	0.981481481481482	53	2	98.1	0	160	2	7	59	MBI3217013.1 hypothetical protein [Mycobacterium sp.]	diamond	159	113	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27738742	27738742	PRJNA380416_P_NODE_13104_length_163_cov_0.894737_g12957_i0	PRJNA380416	13104	163	0.894737	1.45842131	Kitasatospora sp. NPDC	1871188	Bacteria	Bacteria	66.2	6.51e-11	NR	WP_401088305.1	3364085	g12957	i0	63.4	14.0981595092025	41	15	75.5	0	40	162	760	800	WP_401088305.1 non-ribosomal peptide synthetase [Kitasatospora sp. NPDC091335]	diamond	2298	66.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora sp. NPDC091335
28180220	28180220	PRJNA380416_P_NODE_11946_length_165_cov_3.250000_g11799_i0	PRJNA380416	11946	165	3.25	5.3625	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	42	0.0228	NR	HST17223.1	2838783	g11799	i0	59	0.709090909090909	39	14	67.3	2	47	157	42	80	HST17223.1 hypothetical protein [Gaiellaceae bacterium]	diamond	117	42	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
28401469	28401469	PRJNA380416_P_NODE_9666_length_183_cov_1.783582_g9519_i0	PRJNA380416	9666	183	1.783582	3.26395506	Nocardioides pantholopis	2483798	Bacteria	Bacteria	62.4	1.77e-9	NR	WP_127479640.1	2483798	g9519	i0	72.7	0.540983606557377	33	9	54.1	0	182	84	317	349	WP_127479640.1 glycoside hydrolase family 99-like domain-containing protein [Nocardioides pantholopis]	diamond	99	62.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides pantholopis
29411732	29411732	PRJNA380416_P_NODE_6649_length_223_cov_0.741379_g6502_i0	PRJNA380416	6649	223	0.741379	1.65327517	Rhodococcus erythropolis	1833	Bacteria	Bacteria	43.1	0.0203	NR	KAB2584130.1	1833	g6502	i0	42.6	0.726457399103139	54	26	67.3	2	63	212	373	425	KAB2584130.1 DUF2029 domain-containing protein [Rhodococcus erythropolis]	diamond	162	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
30391446	30391446	PRJNA380416_P_NODE_12313_length_165_cov_0.879310_g12166_i0	PRJNA380416	12313	165	0.87931	1.4508615	Pseudoclavibacter sp.	1915061	Bacteria	Bacteria	57.8	6.26e-8	NR	HHW50484.1	1915061	g12166	i0	91.4	0.636363636363636	35	3	63.6	0	59	163	1	35	HHW50484.1 hypothetical protein [Pseudoclavibacter sp.]	diamond	105	57.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter sp.
31117398	31117398	PRJNA380416_P_NODE_14275_length_154_cov_2.238095_g14128_i0	PRJNA380416	14275	154	2.238095	3.4466663	Nocardioides sp.	35761	Bacteria	Bacteria	55.1	4.68e-7	NR	WP_324499474.1	35761	g14128	i0	58.7	0.896103896103896	46	19	89.6	0	3	140	103	148	WP_324499474.1 hypothetical protein [Nocardioides sp.]	diamond	138	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
31433772	31433772	PRJNA380416_P_NODE_5976_length_236_cov_0.925134_g5829_i0	PRJNA380416	5976	236	0.925134	2.18331624	Nocardia asteroides	1824	Bacteria	Bacteria	40.8	0.0374	NR	WP_378807785.1	1824	g5829	i0	51.2	0.546610169491525	43	21	54.7	0	145	17	36	78	WP_378807785.1 hypothetical protein, partial [Nocardia asteroides]	diamond	129	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia asteroides
32856052	32856052	PRJNA380416_P_NODE_3000_length_348_cov_0.775920_g2853_i0	PRJNA380416	3000	348	0.77592	2.7002016	Actinomycetes bacterium	1883427	Bacteria	Bacteria	48.1	0.00148	NR	MDO5286548.1	1883427	g2853	i0	32.4	0.586206896551724	68	45	57.8	1	229	29	154	221	MDO5286548.1 ABC transporter permease [Actinomycetes bacterium]	diamond	204	48.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes 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);;