metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA177642" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA177642" 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
365478	365478	PRJNA177642_P_NODE_17581_length_166_cov_1.051095_g16356_i0	PRJNA177642	17581	166	1.051095	1.7448177	Flaviflexus huanghaiensis	1111473	Bacteria	Bacteria	109	2.23e-26	NR	WP_182353736.1	1111473	g16356	i0	94.5	0.993975903614458	55	3	99.4	0	2	166	255	309	WP_182353736.1 FAD-dependent oxidoreductase [Flaviflexus huanghaiensis]	diamond	165	109	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Flaviflexus	Flaviflexus huanghaiensis
1640356	1640356	PRJNA177642_P_NODE_4302_length_715_cov_2.069971_g3333_i0	PRJNA177642	4302	715	2.069971	14.80029265	Bacteria	2	Bacteria	Bacteria	71.6	1.66e-12	NR	WP_308503853.1	249061	g3333	i0	100	0.268531468531469	32	0	13.4	0	620	715	1	32	WP_308503853.1 hypothetical protein, partial [uncultured Actinomyces sp.]	diamond	192	71.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
2330401	2330401	PRJNA177642_P_NODE_17702_length_166_cov_1.021898_g16477_i0	PRJNA177642	17702	166	1.021898	1.6963506800000001	Actinomycetes	1760	Bacteria	Bacteria	116	1.08e-28	NR	WP_026430964.1	52768	g16477	i0	100	3.97590361445783	55	0	99.4	0	2	166	306	360	WP_026430964.1 translation elongation factor 4 [Schaalia georgiae]	diamond	660	116	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia georgiae
5468978	5468978	PRJNA177642_P_NODE_6165_length_557_cov_2.727273_g5050_i0	PRJNA177642	6165	557	2.727273	15.19091061	uncultured Actinomyces sp.	249061	Bacteria	Bacteria	149	1.17e-38	NR	WP_308504851.1	249061	g5050	i0	100	0.447037701974865	83	0	44.7	0	547	299	435	517	WP_308504851.1 AI-2E family transporter [uncultured Actinomyces sp.]	diamond	249	149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
6743144	6743144	PRJNA177642_P_NODE_16406_length_172_cov_1.860140_g15181_i0	PRJNA177642	16406	172	1.86014	3.1994408	Pseudoclavibacter sp.	1915061	Bacteria	Bacteria	107	4.2e-26	NR	HHW50778.1	1915061	g15181	i0	98.2	0.976744186046512	56	1	97.7	0	170	3	330	385	HHW50778.1 galactokinase [Pseudoclavibacter sp.]	diamond	168	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter sp.
15668459	15668459	PRJNA177642_P_NODE_6573_length_529_cov_1.922000_g5429_i0	PRJNA177642	6573	529	1.922	10.16738	Bacteria	2	Bacteria	Bacteria	204	1.93e-62	NR	WP_308504511.1	249061	g5429	i0	99.1	1.20226843100189	106	0	59.5	1	3	317	39	144	WP_308504511.1 NAD-dependent epimerase/dehydratase family protein [uncultured Actinomyces sp.]	diamond	636	204	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
20767189	20767189	PRJNA177642_P_NODE_6357_length_545_cov_2.546512_g5227_i0	PRJNA177642	6357	545	2.546512	13.8784904	uncultured Actinomyces sp.	249061	Bacteria	Bacteria	143	1.45e-36	NR	WP_308504851.1	249061	g5227	i0	100	0.445871559633028	81	0	44.6	0	245	3	435	515	WP_308504851.1 AI-2E family transporter [uncultured Actinomyces sp.]	diamond	243	143	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
26630804	26630804	PRJNA177642_P_NODE_18341_length_163_cov_1.074627_g17116_i0	PRJNA177642	18341	163	1.074627	1.75164201	Pseudoclavibacter sp. JAI123	2723065	Bacteria	Bacteria	97.8	5.090000000000001e-22	NR	WP_179557865.1	2723065	g17116	i0	100	0.993865030674847	54	0	99.4	0	1	162	329	382	WP_179557865.1 phosphate acetyltransferase [Pseudoclavibacter sp. JAI123]	diamond	162	97.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter sp. JAI123
26743181	26743181	PRJNA177642_P_NODE_18421_length_163_cov_1.037313_g17196_i0	PRJNA177642	18421	163	1.037313	1.69082019	root	1	Root_unresolved	Root_unresolved	101	2.27e-24	NR	HLT85930.1	1873458	g17196	i0	92.5	1.95092024539877	53	4	97.5	0	160	2	110	162	HLT85930.1 hypothetical protein [Georgenia sp.]	diamond	318	101	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Bogoriellaceae	Georgenia	Georgenia sp.
27105357	27105357	PRJNA177642_P_NODE_17122_length_168_cov_1.539568_g15897_i0	PRJNA177642	17122	168	1.539568	2.58647424	Corynebacterium stercoris	2943490	Bacteria	Bacteria	115	5.36e-30	NR	WP_253576375.1	2943490	g15897	i0	90.9	4.91071428571429	55	5	98.2	0	167	3	139	193	WP_253576375.1 fumarylacetoacetate hydrolase family protein [Corynebacterium stercoris]	diamond	825	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium stercoris
27895087	27895087	PRJNA177642_P_NODE_11085_length_333_cov_1.128289_g9860_i0	PRJNA177642	11085	333	1.128289	3.75720237	Dactylosporangium darangshiense	579108	Bacteria	Bacteria	48.5	0.00102	NR	WP_345143185.1	579108	g9860	i0	61.8	0.306306306306306	34	13	30.6	0	3	104	813	846	WP_345143185.1 CHAT domain-containing protein [Dactylosporangium darangshiense]	diamond	102	48.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium darangshiense
28400385	28400385	PRJNA177642_P_NODE_3986_length_750_cov_2.013870_g3049_i0	PRJNA177642	3986	750	2.01387	15.104025	Streptomyces benahoarensis	2595054	Bacteria	Bacteria	206	1.66e-63	NR	TSB05815.1	2595054	g3049	i0	100	0.424	106	0	42.4	0	589	272	71	176	TSB05815.1 hypothetical protein FNJ62_31500, partial [Streptomyces benahoarensis]	diamond	318	206	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces benahoarensis
28747691	28747691	PRJNA177642_P_NODE_18147_length_164_cov_1.044444_g16922_i0	PRJNA177642	18147	164	1.044444	1.71288816	Pseudonocardia sp.	60912	Bacteria	Bacteria	52.4	1.01e-6	NR	HSU08554.1	60912	g16922	i0	84	0.914634146341463	25	4	45.7	0	163	89	103	127	HSU08554.1 hypothetical protein [Pseudonocardia sp.]	diamond	150	52.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp.
28779127	28779127	PRJNA177642_P_NODE_17947_length_165_cov_1.029412_g16722_i0	PRJNA177642	17947	165	1.029412	1.6985298	Actinomycetota bacterium	2900548	Bacteria	Bacteria	72.4	4.28e-13	NR	MDQ3965271.1	2900548	g16722	i0	63.5	0.945454545454545	52	19	94.5	0	10	165	8	59	MDQ3965271.1 PBSX family phage terminase large subunit [Actinomycetota bacterium]	diamond	156	72.4	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
28842269	28842269	PRJNA177642_P_NODE_16008_length_177_cov_1.750000_g14783_i0	PRJNA177642	16008	177	1.75	3.0975	Brevibacterium sp. ACRRH	2918183	Bacteria	Bacteria	120	3.14e-31	NR	WP_239271093.1	2918183	g14783	i0	100	1	59	0	100	0	177	1	34	92	WP_239271093.1 ABC transporter permease [Brevibacterium sp. ACRRH]	diamond	177	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium sp. ACRRH
30327220	30327220	PRJNA177642_P_NODE_18752_length_160_cov_2.152672_g17527_i0	PRJNA177642	18752	160	2.152672	3.4442752	Pseudoclavibacter sp.	1915061	Bacteria	Bacteria	107	2.04e-25	NR	HHW51090.1	1915061	g17527	i0	100	0.99375	53	0	99.4	0	2	160	466	518	HHW51090.1 DNA polymerase I [Pseudoclavibacter sp.]	diamond	159	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pseudoclavibacter	Pseudoclavibacter sp.
30547830	30547830	PRJNA177642_P_NODE_16613_length_171_cov_1.014085_g15388_i0	PRJNA177642	16613	171	1.014085	1.73408535	Corynebacterium haemomassiliense	2754726	Bacteria	Bacteria	101	6.3e-25	NR	WP_301613460.1	2754726	g15388	i0	87.5	0.982456140350877	56	7	98.2	0	169	2	3	58	WP_301613460.1 YigZ family protein [Corynebacterium haemomassiliense]	diamond	168	101	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium haemomassiliense
30800511	30800511	PRJNA177642_P_NODE_19134_length_150_cov_4.396694_g17909_i0	PRJNA177642	19134	150	4.396694	6.595041	Solirubrobacterales bacterium	1909295	Bacteria	Bacteria	87	8.98e-19	NR	HEX5956710.1	1909295	g17909	i0	87.2	3.7	47	6	94	0	142	2	5	51	HEX5956710.1 transketolase C-terminal domain-containing protein [Solirubrobacterales bacterium]	diamond	555	87	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
30863753	30863753	PRJNA177642_P_NODE_18574_length_162_cov_1.082707_g17349_i0	PRJNA177642	18574	162	1.082707	1.75398534	Brevibacterium senegalense	1033736	Bacteria	Bacteria	74.3	3.36e-14	NR	WP_019157354.1	1033736	g17349	i0	81	0.777777777777778	42	8	77.8	0	36	161	6	47	WP_019157354.1 IS21-like element helper ATPase IstB [Brevibacterium senegalense]	diamond	126	74.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium senegalense
31260830	31260830	PRJNA177642_P_NODE_8335_length_418_cov_1.912596_g7127_i0	PRJNA177642	8335	418	1.912596	7.99465128	Bacteria	2	Bacteria	Bacteria	128	8.77e-36	NR	WP_316316156.1	28447	g7127	i0	100	0.976076555023923	68	0	48.8	0	204	1	13	80	WP_316316156.1 hypothetical protein, partial [Clavibacter michiganensis]	diamond	408	128	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis

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