metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA299585" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA299585" 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
375167	375167	PRJNA299585_S_NODE_5921_length_323_cov_7.782313_g5691_i0	PRJNA299585	5921	323	7.782313	25.13687099	uncultured Actinomyces sp.	249061	Bacteria	Bacteria	203	1.31e-60	NR	WP_308504851.1	249061	g5691	i0	100	0.993808049535604	107	0	99.4	0	323	3	328	434	WP_308504851.1 AI-2E family transporter [uncultured Actinomyces sp.]	diamond	321	203	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
4202429	4202429	PRJNA299585_S_NODE_7524_length_267_cov_4.752101_g7294_i0	PRJNA299585	7524	267	4.752101	12.68810967	Bacteria	2	Bacteria	Bacteria	169	7.04e-50	NR	WP_308503729.1	249061	g7294	i0	100	4	89	0	100	0	1	267	170	258	WP_308503729.1 SulP family inorganic anion transporter, partial [uncultured Actinomyces sp.]	diamond	1068	169	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
5478767	5478767	PRJNA299585_S_NODE_9205_length_226_cov_4.771574_g8975_i0	PRJNA299585	9205	226	4.771574	10.78375724	Bacteria	2	Bacteria	Bacteria	158	3.949999999999999e-48	NR	WP_323385675.1	1485586	g8975	i0	100	2.98672566371681	75	0	99.6	0	226	2	23	97	WP_323385675.1 FGGY family carbohydrate kinase, partial [Streptomyces calidiresistens]	diamond	675	158	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces calidiresistens
9303329	9303329	PRJNA299585_S_NODE_6348_length_306_cov_3.787004_g6118_i0	PRJNA299585	6348	306	3.787004	11.58823224	Bacteria	2	Bacteria	Bacteria	206	1.16e-66	NR	WP_261595950.1	1773	g6118	i0	100	3.96078431372549	101	0	99	0	305	3	19	119	WP_261595950.1 patatin-like phospholipase family protein, partial [Mycobacterium tuberculosis]	diamond	1212	206	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
11853927	11853927	PRJNA299585_S_NODE_8010_length_254_cov_4.311111_g7780_i0	PRJNA299585	8010	254	4.311111	10.95022194	Micromonospora deserti	2070366	Bacteria	Bacteria	176	1.1999999999999999e-54	NR	WP_146604124.1	2070366	g7780	i0	100	0.992125984251969	84	0	99.2	0	252	1	54	137	WP_146604124.1 6-pyruvoyl trahydropterin synthase family protein, partial [Micromonospora deserti]	diamond	252	176	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora deserti
23327239	23327239	PRJNA299585_S_NODE_4299_length_406_cov_4.392573_g4069_i0	PRJNA299585	4299	406	4.392573	17.83384638	Actinomadura lepetitiana	2126066	Bacteria	Bacteria	104	1.01e-25	NR	NDU79705.1	2126066	g4069	i0	99.3	0.997536945812808	135	1	99.8	0	406	2	6	140	NDU79705.1 hypothetical protein [Actinomadura lepetitiana]	diamond	405	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura lepetitiana
27502786	27502786	PRJNA299585_S_NODE_8323_length_246_cov_2.631336_g8093_i0	PRJNA299585	8323	246	2.631336	6.47308656	Bacteria	2	Bacteria	Bacteria	160	1.7899999999999998e-48	NR	WP_316316563.1	28447	g8093	i0	100	4.8780487804878	80	0	97.6	0	241	2	39	118	WP_316316563.1 hypothetical protein, partial [Clavibacter michiganensis]	diamond	1200	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
27800886	27800886	PRJNA299585_S_NODE_12624_length_177_cov_3.520270_g12394_i0	PRJNA299585	12624	177	3.52027	6.2308779	Streptomyces scabiei	1930	Bacteria	Bacteria	108	3.3600000000000003e-29	NR	WP_409100513.1	1930	g12394	i0	98.1	0.915254237288136	54	1	91.5	0	2	163	25	78	WP_409100513.1 hypothetical protein, partial [Streptomyces scabiei]	diamond	162	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces scabiei
29158620	29158620	PRJNA299585_S_NODE_13549_length_168_cov_3.884892_g13319_i0	PRJNA299585	13549	168	3.884892	6.52661856	uncultured Actinomyces sp.	249061	Bacteria	Bacteria	88.2	1.57e-20	NR	WP_308504504.1	249061	g13319	i0	97.8	0.803571428571429	45	1	80.4	0	152	18	102	146	WP_308504504.1 GNAT family N-acetyltransferase [uncultured Actinomyces sp.]	diamond	135	88.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
29176204	29176204	PRJNA299585_S_NODE_11909_length_185_cov_2.871795_g11679_i0	PRJNA299585	11909	185	2.871795	5.31282075	Bacteria	2	Bacteria	Bacteria	121	1.6199999999999998e-32	NR	WP_308504591.1	249061	g11679	i0	100	1.97837837837838	61	0	98.9	0	184	2	44	104	WP_308504591.1 FAD:protein FMN transferase, partial [uncultured Actinomyces sp.]	diamond	366	121	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
29270575	29270575	PRJNA299585_S_NODE_14029_length_164_cov_4.355556_g13799_i0	PRJNA299585	14029	164	4.355556	7.14311184	Bacteria	2	Bacteria	Bacteria	99.8	2.16e-25	NR	WP_316311810.1	28447	g13799	i0	100	2.96341463414634	54	0	98.8	0	163	2	35	88	WP_316311810.1 MFS transporter, partial [Clavibacter michiganensis]	diamond	486	99.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
29775801	29775801	PRJNA299585_S_NODE_7551_length_266_cov_4.843882_g7321_i0	PRJNA299585	7551	266	4.843882	12.88472612	Bacteria	2	Bacteria	Bacteria	134	4.4e-39	NR	WP_316316156.1	28447	g7321	i0	100	1.46616541353383	65	0	73.3	0	196	2	1	65	WP_316316156.1 hypothetical protein, partial [Clavibacter michiganensis]	diamond	390	134	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
30295813	30295813	PRJNA299585_S_NODE_8232_length_248_cov_4.785388_g8002_i0	PRJNA299585	8232	248	4.785388	11.86776224	Streptomyces europaeiscabiei	146819	Bacteria	Bacteria	162	6.64e-50	NR	WP_409134407.1	146819	g8002	i0	100	0.979838709677419	81	0	98	0	2	244	15	95	WP_409134407.1 hypothetical protein, partial [Streptomyces europaeiscabiei]	diamond	243	162	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces europaeiscabiei
31875738	31875738	PRJNA299585_S_NODE_14197_length_163_cov_2.694030_g13967_i0	PRJNA299585	14197	163	2.69403	4.3912689	Saccharomonospora sp. NPDC	33913	Bacteria	Bacteria	43.9	0.0043	NR	WP_358543840.1	3156921	g13967	i0	51.2	0.791411042944785	43	20	79.1	1	23	151	106	147	WP_358543840.1 phosphopantetheine-binding protein, partial [Saccharomonospora sp. NPDC046836]	diamond	129	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharomonospora	Saccharomonospora sp. NPDC046836
32368349	32368349	PRJNA299585_S_NODE_6919_length_285_cov_55.621094_g6689_i0	PRJNA299585	6919	285	55.621094	158.5201179	Bifidobacterium	1678	Bacteria	Bacteria	43.5	0.0311	NR	WP_291526982.1	1946112	g6689	i0	37.7	1.14736842105263	61	37	63.2	1	215	36	203	263	WP_291526982.1 glycosyltransferase family 2 protein [Bifidobacterium sp. UBA744]	diamond	327	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium sp. UBA744
32399894	32399894	PRJNA299585_S_NODE_4819_length_375_cov_3.939306_g4589_i0	PRJNA299585	4819	375	3.939306	14.7723975	Bacteria	2	Bacteria	Bacteria	94.7	1.23e-22	NR	WP_316316877.1	28447	g4589	i0	100	1.624	50	0	40	0	225	374	1	50	WP_316316877.1 EamA family transporter, partial [Clavibacter michiganensis]	diamond	609	95.5	0.991623036649215	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
32792150	32792150	PRJNA299585_S_NODE_16000_length_150_cov_3.082645_g15770_i0	PRJNA299585	16000	150	3.082645	4.6239675	Streptomyces galilaeus	33899	Bacteria	Bacteria	105	3.75e-28	NR	WP_409098957.1	33899	g15770	i0	100	1.96	49	0	98	0	149	3	34	82	WP_409098957.1 LytR/AlgR family response regulator transcription factor, partial [Streptomyces galilaeus]	diamond	294	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces galilaeus

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