metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA559720" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA559720" 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
543447	543447	PRJNA559720_P_NODE_13321_length_253_cov_1.377778_g13182_i0	PRJNA559720	13321	253	1.377778	3.48577834	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	104	1.49e-25	NR	WP_367147232.1	1572644	g13182	i0	90.9	0.652173913043478	55	5	65.2	0	166	2	1	55	WP_367147232.1 hypothetical protein [Microbacterium proteolyticum]	diamond	165	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
1819140	1819140	PRJNA559720_P_NODE_10002_length_308_cov_1.310638_g9863_i0	PRJNA559720	10002	308	1.310638	4.03676504	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	129	3.11e-32	NR	HYL53295.1	2080302	g9863	i0	63.4	1.97727272727273	101	37	98.4	0	3	305	181	281	HYL53295.1 adenylate/guanylate cyclase domain-containing protein [Acidimicrobiia bacterium]	diamond	609	129	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
3094441	3094441	PRJNA559720_P_NODE_13743_length_250_cov_1.587571_g13604_i0	PRJNA559720	13743	250	1.587571	3.9689275	FCB group	1783270	Bacteria	Bacteria	105	2.01e-24	NR	HEV7481637.1	1909295	g13604	i0	67.5	8.628	80	25	96	1	248	9	406	484	HEV7481637.1 alkaline phosphatase D family protein [Solirubrobacterales bacterium]	diamond	2157	105	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
5647303	5647303	PRJNA559720_P_NODE_10865_length_291_cov_2.082569_g10726_i0	PRJNA559720	10865	291	2.082569	6.06027579	Paractinoplanes bogorensis	1610840	Bacteria	Bacteria	145	3.06e-41	NR	WP_215796180.1	1610840	g10726	i0	76.6	0.969072164948454	94	22	96.9	0	284	3	132	225	WP_215796180.1 hypothetical protein [Paractinoplanes bogorensis]	diamond	282	145	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Paractinoplanes	Paractinoplanes bogorensis
5647369	5647369	PRJNA559720_P_NODE_15885_length_243_cov_0.905882_g15746_i0	PRJNA559720	15885	243	0.905882	2.20129326	Nostocoides australiense	99480	Bacteria	Bacteria	166	2.5100000000000002e-49	NR	WP_083433786.1	99480	g15746	i0	97.5	0.987654320987654	80	2	98.8	0	241	2	94	173	WP_083433786.1 FAD:protein FMN transferase [Nostocoides australiense]	diamond	240	166	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Nostocoides	Nostocoides australiense
18395423	18395423	PRJNA559720_P_NODE_15735_length_243_cov_0.905882_g15596_i0	PRJNA559720	15735	243	0.905882	2.20129326	Mycobacteroides franklinii	948102	Bacteria	Bacteria	163	1.94e-45	NR	WP_164910229.1	948102	g15596	i0	95.1	1	81	4	100	0	243	1	383	463	WP_164910229.1 fatty acyl-AMP ligase [Mycobacteroides franklinii]	diamond	243	163	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides franklinii
19669993	19669993	PRJNA559720_P_NODE_14276_length_249_cov_0.875000_g14137_i0	PRJNA559720	14276	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	168	2.0599999999999993e-52	NR	WP_264068094.1	1773	g14137	i0	100	5	83	0	100	0	249	1	10	92	WP_264068094.1 LytTR family DNA-binding domain-containing protein, partial [Mycobacterium tuberculosis]	diamond	1245	168	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
26857809	26857809	PRJNA559720_P_NODE_13841_length_250_cov_0.870056_g13702_i0	PRJNA559720	13841	250	0.870056	2.17514	Mycobacteroides franklinii	948102	Bacteria	Bacteria	125	6.519999999999999e-34	NR	WP_134048266.1	948102	g13702	i0	91.4	0.84	70	6	84	0	210	1	1	70	WP_134048266.1 phosphatase PAP2 family protein [Mycobacteroides franklinii]	diamond	210	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides franklinii
27332001	27332001	PRJNA559720_P_NODE_16023_length_242_cov_0.911243_g15884_i0	PRJNA559720	16023	242	0.911243	2.20520806	Rubrobacter sp.	2036010	Bacteria	Bacteria	171	2.52e-50	NR	HET9928995.1	2036010	g15884	i0	100	1.98347107438017	80	0	99.2	0	3	242	158	237	HET9928995.1 PQQ-dependent sugar dehydrogenase [Rubrobacter sp.]	diamond	480	171	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter sp.
27552660	27552660	PRJNA559720_P_NODE_15744_length_243_cov_0.905882_g15605_i0	PRJNA559720	15744	243	0.905882	2.20129326	Thermoleophilaceae bacterium	2732252	Bacteria	Bacteria	108	4.28e-29	NR	MFL5885428.1	2732252	g15605	i0	80.3	5.64197530864198	66	13	81.5	0	242	45	11	76	MFL5885428.1 BolA family protein [Thermoleophilaceae bacterium]	diamond	1371	108	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Thermoleophilales	Thermoleophilaceae		Thermoleophilaceae bacterium
27647778	27647778	PRJNA559720_P_NODE_13384_length_252_cov_1.687151_g13245_i0	PRJNA559720	13384	252	1.687151	4.25162052	Patulibacter medicamentivorans	1097667	Bacteria	Bacteria	73.6	6.18e-13	NR	EHN11899.1	1097667	g13245	i0	85.1	0.55952380952381	47	7	56	0	112	252	681	727	EHN11899.1 Protein-L-isoaspartate O-methyltransferase [Patulibacter medicamentivorans]	diamond	141	73.6	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Patulibacteraceae	Patulibacter	Patulibacter medicamentivorans
28121219	28121219	PRJNA559720_P_NODE_16305_length_241_cov_0.916667_g16166_i0	PRJNA559720	16305	241	0.916667	2.20916747	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	130	6.329999999999999e-35	NR	MDX6376704.1	2838783	g16166	i0	82.5	0.995850622406639	80	14	99.6	0	240	1	162	241	MDX6376704.1 ribonuclease [Gaiellaceae bacterium]	diamond	240	130	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
28278889	28278889	PRJNA559720_P_NODE_13706_length_251_cov_0.865169_g13567_i0	PRJNA559720	13706	251	0.865169	2.17157419	Streptosporangiaceae bacterium	2339230	Bacteria	Bacteria	98.6	6.899999999999999e-24	NR	HEX3305869.1	2339230	g13567	i0	77.6	0.693227091633466	58	13	69.3	0	249	76	106	163	HEX3305869.1 IS1595 family transposase [Streptosporangiaceae bacterium]	diamond	174	98.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium
28342270	28342270	PRJNA559720_P_NODE_12286_length_269_cov_1.535714_g12147_i0	PRJNA559720	12286	269	1.535714	4.13107066	Streptomyces sp. AC512_CC834	2823691	Bacteria	Bacteria	43.5	0.0273	NR	WP_217170943.1	2823691	g12147	i0	39.8	0.925650557620818	83	35	75.8	2	33	236	424	506	WP_217170943.1 mycofactocin system FadH/OYE family oxidoreductase 1 [Streptomyces sp. AC512_CC834]	diamond	249	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. AC512_CC834
30205058	30205058	PRJNA559720_P_NODE_12792_length_261_cov_1.372340_g12653_i0	PRJNA559720	12792	261	1.37234	3.5818074	Rathayibacter sp. VKM Ac-28	1891630	Bacteria	Bacteria	142	5.14e-40	NR	WP_159987551.1	2609256	g12653	i0	80	0.977011494252874	85	17	97.7	0	2	256	172	256	WP_159987551.1 SDR family NAD(P)-dependent oxidoreductase [Rathayibacter sp. VKM Ac-2803]	diamond	255	142	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rathayibacter	Rathayibacter sp. VKM Ac-2803
30710824	30710824	PRJNA559720_P_NODE_15694_length_243_cov_0.905882_g15555_i0	PRJNA559720	15694	243	0.905882	2.20129326	Mycobacteriaceae bacterium NPDC060252	3347083	Bacteria	Bacteria	139	2.89e-36	NR	MFD6197308.1	3347083	g15555	i0	88.8	1.97530864197531	80	9	98.8	0	241	2	136	215	MFD6197308.1 KGGVGR-motif variant AAA ATPase [Mycobacteriaceae bacterium NPDC060252]	diamond	480	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae		Mycobacteriaceae bacterium NPDC060252
31469626	31469626	PRJNA559720_P_NODE_6056_length_417_cov_2.281977_g5917_i0	PRJNA559720	6056	417	2.281977	9.51584409	Actinomycetota bacterium	2900548	Bacteria	Bacteria	44.3	0.0399	NR	MCA1679382.1	2900548	g5917	i0	40.3	0.553956834532374	77	36	48.2	2	373	173	54	130	MCA1679382.1 metal-dependent hydrolase [Actinomycetota bacterium]	diamond	231	44.3	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
31659032	31659032	PRJNA559720_P_NODE_13977_length_250_cov_0.870056_g13838_i0	PRJNA559720	13977	250	0.870056	2.17514	Arthrobacter sp. M2	1667	Bacteria	Bacteria	82.4	4.23e-16	NR	WP_017198210.1	1197706	g13838	i0	50	1.968	82	41	98.4	0	3	248	186	267	WP_017198210.1 ABC transporter ATP-binding protein [Arthrobacter sp. M2012083]	diamond	492	82.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. M2012083

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