metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax_kingdom = "Bacillati"

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
22482954	22482954	PRJNA806354_P_NODE_32758_length_260_cov_1.443850_g32649_i0	PRJNA806354	32758	260	1.44385	3.75401	Arthrobacter sp. efr-133-TYG-118	3040279	Bacteria	Bacteria	144	4.68e-40	NR	WP_284981519.1	3040279	g32649	i0	87.2	0.992307692307692	86	11	99.2	0	260	3	3	88	WP_284981519.1 aldo/keto reductase [Arthrobacter sp. efr-133-TYG-118]	diamond	258	144	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. efr-133-TYG-118
27884281	27884281	PRJNA806354_P_NODE_37705_length_247_cov_0.885057_g37596_i0	PRJNA806354	37705	247	0.885057	2.18609079	Bacillota	1239	Bacteria	Bacteria	130	3.85e-37	NR	ERJ83094.1	1321784	g37596	i0	89.3	4.45748987854251	75	8	91.1	0	23	247	1	75	ERJ83094.1 ribosomal protein S10 [Peptostreptococcaceae bacterium oral taxon 113 str. W5053]	diamond	1101	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae		Peptostreptococcaceae bacterium oral taxon 113
27906747	27906747	PRJNA806354_P_NODE_34885_length_252_cov_1.564246_g34776_i0	PRJNA806354	34885	252	1.564246	3.94189992	Actinomadura lepetitiana	2126066	Bacteria	Bacteria	169	9.97e-51	NR	NDU78054.1	2126066	g34776	i0	94	1.97619047619048	83	5	98.8	0	2	250	123	205	NDU78054.1 alanine racemase [Actinomadura lepetitiana]	diamond	498	169	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura lepetitiana
29485449	29485449	PRJNA806354_P_NODE_33330_length_257_cov_3.548913_g33221_i0	PRJNA806354	33330	257	3.548913	9.12070641	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	108	3.2300000000000003e-27	NR	WP_296212864.1	159447	g33221	i0	56.5	0.992217898832685	85	37	99.2	0	256	2	107	191	WP_296212864.1 hypothetical protein [uncultured Corynebacterium sp.]	diamond	255	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
29706305	29706305	PRJNA806354_P_NODE_41130_length_241_cov_0.916667_g41021_i0	PRJNA806354	41130	241	0.916667	2.20916747	Flavonifractor plautii	292800	Bacteria	Bacteria	52	1.29e-5	NR	WP_271956687.1	292800	g41021	i0	62.2	0.970954356846473	37	14	46.1	0	114	4	3	39	WP_271956687.1 SDR family NAD(P)-dependent oxidoreductase [Flavonifractor plautii]	diamond	234	52	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
30053986	30053986	PRJNA806354_P_NODE_39331_length_244_cov_0.900585_g39222_i0	PRJNA806354	39331	244	0.900585	2.1974274	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	160	7.51e-45	NR	MBP6489525.1	2497619	g39222	i0	96.2	0.971311475409836	79	3	97.1	0	4	240	276	354	MBP6489525.1 terminase family protein [Ilumatobacteraceae bacterium]	diamond	237	160	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
30307426	30307426	PRJNA806354_P_NODE_35392_length_251_cov_0.865169_g35283_i0	PRJNA806354	35392	251	0.865169	2.17157419	Sporomusa sp. KB1	943346	Bacteria	Bacteria	91.7	3.17e-21	NR	WP_145093600.1	943346	g35283	i0	57.7	1.87649402390438	78	33	93.2	0	5	238	24	101	WP_145093600.1 phage protein [Sporomusa sp. KB1]	diamond	471	91.7	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa sp. KB1
30402165	30402165	PRJNA806354_P_NODE_38053_length_246_cov_0.890173_g37944_i0	PRJNA806354	38053	246	0.890173	2.18982558	Chloroflexota bacterium	2026724	Bacteria	Bacteria	46.6	0.00157	NR	MBI5933282.1	2026724	g37944	i0	85.7	0.341463414634146	28	3	32.9	1	244	164	298	325	MBI5933282.1 integron integrase [Chloroflexota bacterium]	diamond	84	46.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30591227	30591227	PRJNA806354_P_NODE_2813_length_799_cov_2.140496_g2716_i0	PRJNA806354	2813	799	2.140496	17.10256304	Cutibacterium acnes	1747	Bacteria	Bacteria	45.4	0.0153	NR	MCQ8209668.1	1734925	g2716	i0	93.2	0.165206508135169	44	3	16.5	0	641	510	1	44	MCQ8209668.1 hypothetical protein [Cutibacterium acnes subsp. acnes]	diamond	132	45.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
31381516	31381516	PRJNA806354_P_NODE_38116_length_246_cov_0.890173_g38007_i0	PRJNA806354	38116	246	0.890173	2.18982558	Staphylococcus aureus	1280	Bacteria	Bacteria	105	1.2099999999999999e-27	NR	WP_228595085.1	1280	g38007	i0	64.3	0.853658536585366	70	25	85.4	0	240	31	1	70	WP_228595085.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	210	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31413013	31413013	PRJNA806354_P_NODE_37196_length_247_cov_2.695402_g37087_i0	PRJNA806354	37196	247	2.695402	6.65764294	Clostridiales bacterium	1898207	Bacteria	Bacteria	106	1.02e-26	NR	MCI6603410.1	1898207	g37087	i0	100	0.619433198380567	51	0	61.9	0	246	94	148	198	MCI6603410.1 sulfurtransferase-like selenium metabolism protein YedF [Clostridiales bacterium]	diamond	153	106	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
31792338	31792338	PRJNA806354_P_NODE_39937_length_243_cov_0.905882_g39828_i0	PRJNA806354	39937	243	0.905882	2.20129326	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	69.3	2.82e-13	NR	MFK5282075.1	1597	g39828	i0	72.5	0.62962962962963	51	13	61.7	1	72	221	7	57	MFK5282075.1 hypothetical protein [Lacticaseibacillus paracasei]	diamond	153	69.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
32362327	32362327	PRJNA806354_P_NODE_36919_length_248_cov_0.880000_g36810_i0	PRJNA806354	36919	248	0.88	2.1824	Candidatus Nanopelagicaceae bacterium	2518609	Bacteria	Bacteria	73.9	1.97e-15	NR	MFA9201950.1	2518609	g36810	i0	87.8	0.495967741935484	41	5	49.6	0	1	123	18	58	MFA9201950.1 hypothetical protein [Candidatus Nanopelagicaceae bacterium]	diamond	123	73.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales	Candidatus Nanopelagicaceae		Candidatus Nanopelagicaceae 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);;