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

17 rows where analysis = "diamond", bioproject = "PRJNA1108009" 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
2764075	2764075	PRJNA1108009_P_NODE_8503_length_470_cov_1.148615_g8186_i0	PRJNA1108009	8503	470	1.148615	5.3984905	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	199	2.08e-62	NR	MCP3885490.1	2021380	g8186	i0	72.2	0.848936170212766	133	37	84.9	0	401	3	3	135	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	399	199	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
27343734	27343734	PRJNA1108009_P_NODE_26103_length_249_cov_0.875000_g25785_i0	PRJNA1108009	26103	249	0.875	2.17875	Coriobacteriia	84998	Bacteria	Bacteria	170	3.12e-50	NR	WP_078687723.1	604330	g25785	i0	98.8	2	83	1	100	0	249	1	205	287	WP_078687723.1 choloylglycine hydrolase [Parafannyhessea umbonata]	diamond	498	171	0.994152046783626	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Parafannyhessea	Parafannyhessea umbonata
27762944	27762944	PRJNA1108009_P_NODE_21944_length_272_cov_1.221106_g21626_i0	PRJNA1108009	21944	272	1.221106	3.32140832	Janibacter alkaliphilus	1069963	Bacteria	Bacteria	79.3	6.87e-16	NR	WP_179463459.1	1069963	g21626	i0	87	0.595588235294118	54	7	59.6	0	111	272	3	56	WP_179463459.1 D-sedoheptulose-7-phosphate isomerase [Janibacter alkaliphilus]	diamond	162	79.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter alkaliphilus
28173038	28173038	PRJNA1108009_P_NODE_26926_length_248_cov_0.880000_g26608_i0	PRJNA1108009	26926	248	0.88	2.1824	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0377	NR	WP_384600005.1	3346847	g26608	i0	39.5	0.979838709677419	81	42	91.9	4	14	241	15	93	WP_384600005.1 DNA-3-methyladenine glycosylase family protein [Streptomyces sp. NPDC059477]	diamond	243	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC059477
28385428	28385428	PRJNA1108009_P_NODE_20046_length_287_cov_1.397196_g19728_i0	PRJNA1108009	20046	287	1.397196	4.00995252	Micrococcales	85006	Bacteria	Bacteria	97.8	1.4699999999999999e-24	NR	WP_296364403.1	172040	g19728	i0	73.8	5.0801393728223	61	16	63.8	0	105	287	2	62	WP_296364403.1 cold-shock protein [Arthrobacter russicus]	diamond	1458	97.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter russicus
28954020	28954020	PRJNA1108009_P_NODE_13388_length_362_cov_1.733564_g13070_i0	PRJNA1108009	13388	362	1.733564	6.27550168	root	1	Root_unresolved	Root_unresolved	65.9	1.1e-9	NR	MCW2763450.1	1909296	g13070	i0	43.2	2.87569060773481	74	40	61.3	1	357	136	256	327	MCW2763450.1 hypothetical protein [Marmoricola sp.]	diamond	1041	66.2	0.995468277945619	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Marmoricola	Marmoricola sp.
29183688	29183688	PRJNA1108009_P_NODE_21069_length_279_cov_1.393204_g20751_i0	PRJNA1108009	21069	279	1.393204	3.88703916	Collinsella sp.	1965294	Bacteria	Bacteria	43.5	0.0303	NR	MDY4647685.1	1965294	g20751	i0	33.3	0.838709677419355	78	51	83.9	1	12	245	388	464	MDY4647685.1 AAA family ATPase [Collinsella sp.]	diamond	234	43.5	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella sp.
29278055	29278055	PRJNA1108009_P_NODE_19789_length_289_cov_1.300926_g19471_i0	PRJNA1108009	19789	289	1.300926	3.75967614	unclassified Streptomyces	2593676	Bacteria	Bacteria	42.4	0.0415	NR	WP_384801485.1	2593676	g19471	i0	36.4	0.685121107266436	66	39	65.4	1	285	97	79	144	WP_384801485.1 MULTISPECIES: DUF6278 family protein [unclassified Streptomyces]	diamond	198	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
29467338	29467338	PRJNA1108009_P_NODE_30490_length_243_cov_0.905882_g30172_i0	PRJNA1108009	30490	243	0.905882	2.20129326	Olsenella massiliensis	1622075	Bacteria	Bacteria	62.8	1.04e-9	NR	WP_235815094.1	1622075	g30172	i0	57.4	0.580246913580247	47	20	58	0	3	143	160	206	WP_235815094.1 zinc-binding dehydrogenase [Olsenella massiliensis]	diamond	141	62.8	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Olsenella	Olsenella massiliensis
29720002	29720002	PRJNA1108009_P_NODE_27470_length_247_cov_0.885057_g27152_i0	PRJNA1108009	27470	247	0.885057	2.18609079	Allokutzneria albata	211114	Bacteria	Bacteria	43.5	0.0212	NR	WP_030426657.1	211114	g27152	i0	30.6	1.7246963562753	85	45	86.2	2	34	246	117	201	WP_030426657.1 sensor histidine kinase [Allokutzneria albata]	diamond	426	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Allokutzneria	Allokutzneria albata
29814899	29814899	PRJNA1108009_P_NODE_27531_length_247_cov_0.885057_g27213_i0	PRJNA1108009	27531	247	0.885057	2.18609079	Eggerthellaceae bacterium	1972561	Bacteria	Bacteria	132	1.42e-34	NR	MBQ9955257.1	1972561	g27213	i0	91.4	0.983805668016194	81	7	98.4	0	245	3	125	205	MBQ9955257.1 D-alanyl-D-alanine carboxypeptidase [Eggerthellaceae bacterium]	diamond	243	132	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae		Eggerthellaceae bacterium
29878305	29878305	PRJNA1108009_P_NODE_32031_length_229_cov_2.775641_g31713_i0	PRJNA1108009	32031	229	2.775641	6.35621789	Olsenella sp. An188	1965579	Bacteria	Bacteria	81.6	6.21e-16	NR	WP_158096128.1	1965579	g31713	i0	56.6	1.89956331877729	76	32	99.6	1	228	1	59	133	WP_158096128.1 NUDIX hydrolase [Olsenella sp. An188]	diamond	435	81.6	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Olsenella	Olsenella sp. An188
30668001	30668001	PRJNA1108009_P_NODE_26993_length_248_cov_0.880000_g26675_i0	PRJNA1108009	26993	248	0.88	2.1824	Aeriscardovia sp.	1872397	Bacteria	Bacteria	62.8	1.37e-10	NR	MBQ1347955.1	1872397	g26675	i0	55.1	1.18548387096774	49	22	59.3	0	147	1	7	55	MBQ1347955.1 hypothetical protein [Aeriscardovia sp.]	diamond	294	62.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Aeriscardovia	Aeriscardovia sp.
30920983	30920983	PRJNA1108009_P_NODE_21434_length_276_cov_1.423645_g21116_i0	PRJNA1108009	21434	276	1.423645	3.9292602	Streptomyces inhibens	2293571	Bacteria	Bacteria	43.5	0.025	NR	WP_397883519.1	2293571	g21116	i0	35.1	0.83695652173913	77	47	83.7	1	21	251	143	216	WP_397883519.1 SDR family NAD(P)-dependent oxidoreductase [Streptomyces inhibens]	diamond	231	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces inhibens
31395065	31395065	PRJNA1108009_P_NODE_7076_length_519_cov_4.284753_g6762_i0	PRJNA1108009	7076	519	4.284753	22.23786807	Rugosimonospora acidiphila	556531	Bacteria	Bacteria	120	5.19e-32	NR	WP_345639472.1	556531	g6762	i0	79.3	0.502890173410405	87	11	50.3	1	251	511	1	80	WP_345639472.1 hypothetical protein, partial [Rugosimonospora acidiphila]	diamond	261	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Rugosimonospora	Rugosimonospora acidiphila
31426522	31426522	PRJNA1108009_P_NODE_27656_length_247_cov_0.885057_g27338_i0	PRJNA1108009	27656	247	0.885057	2.18609079	Atopobiaceae bacterium	2485926	Bacteria	Bacteria	127	2.62e-32	NR	MBQ9315422.1	2485926	g27338	i0	91.8	0.740890688259109	61	5	74.1	0	1	183	430	490	MBQ9315422.1 glycoside hydrolase family 1 protein [Atopobiaceae bacterium]	diamond	183	127	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae		Atopobiaceae bacterium
31995989	31995989	PRJNA1108009_P_NODE_6878_length_528_cov_1.182418_g6564_i0	PRJNA1108009	6878	528	1.182418	6.24316704	Dermatophilaceae bacterium	2728912	Bacteria	Bacteria	48.9	0.00351	NR	MEI2733288.1	2728912	g6564	i0	44.4	0.409090909090909	72	35	39.2	3	121	327	303	372	MEI2733288.1 molybdopterin-synthase adenylyltransferase MoeB [Dermatophilaceae bacterium]	diamond	216	48.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae		Dermatophilaceae 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);;