metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax_phylum = "Bacillota"

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
14400649	14400649	PRJNA280983_P_NODE_2592_length_437_cov_4.440722_g2477_i0	PRJNA280983	2592	437	4.440722	19.40595514	Culicoidibacter larvae	2579976	Bacteria	Bacteria	185	6.399999999999999e-55	NR	WP_138191546.1	2579976	g2477	i0	69.9	0.844393592677345	123	34	82.4	1	68	427	3	125	WP_138191546.1 TIGR01212 family radical SAM protein [Culicoidibacter larvae]	diamond	369	185	1	Bacteria	Bacillati	Bacillota	Culicoidibacteria	Culicoidibacterales	Culicoidibacteraceae	Culicoidibacter	Culicoidibacter larvae
23323698	23323698	PRJNA280983_P_NODE_439_length_1093_cov_2.160920_g374_i0	PRJNA280983	439	1093	2.16092	23.6188556	Bacilli bacterium	1903720	Bacteria	Bacteria	278	1.25e-84	NR	MEG1506368.1	1903720	g374	i0	95.9	0.406221408966148	148	6	40.6	0	445	2	51	198	MEG1506368.1 replication initiation protein [Bacilli bacterium]	diamond	444	278	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
26630961	26630961	PRJNA280983_P_NODE_9721_length_168_cov_0.915966_g9606_i0	PRJNA280983	9721	168	0.915966	1.53882288	Firmicutes bacterium CAG:345	1263020	Bacteria	Bacteria	41.2	0.0457	NR	CDD23844.1	1263020	g9606	i0	48.5	0.589285714285714	33	17	58.9	0	166	68	133	165	CDD23844.1 probable inorganic polyphosphate/ATP-NAD kinase [Firmicutes bacterium CAG:345]	diamond	99	41.2	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium CAG:345
28116285	28116285	PRJNA280983_P_NODE_10265_length_165_cov_0.879310_g10150_i0	PRJNA280983	10265	165	0.87931	1.4508615	Listeria monocytogenes	1639	Bacteria	Bacteria	44.7	2.93e-4	NR	WP_369697475.1	1639	g10150	i0	92.6	0.490909090909091	27	2	49.1	0	165	85	38	64	WP_369697475.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	81	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28260171	28260171	PRJNA280983_P_NODE_3326_length_374_cov_1.796923_g3211_i0	PRJNA280983	3326	374	1.796923	6.72049202	Thermoactinomycetaceae	186824	Bacteria	Bacteria	104	1.94e-24	NR	WP_107728182.1	500615	g3211	i0	47.4	1.83689839572193	114	60	91.4	0	29	370	128	241	WP_107728182.1 ParB/RepB/Spo0J family partition protein [Desmospora activa]	diamond	687	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Desmospora	Desmospora activa
28463846	28463846	PRJNA280983_P_NODE_10646_length_164_cov_0.886957_g10531_i0	PRJNA280983	10646	164	0.886957	1.45460948	Priestia aryabhattai	412384	Bacteria	Bacteria	50.4	2.4e-5	NR	WP_413028423.1	412384	g10531	i0	48	0.914634146341463	50	25	91.5	1	13	162	178	226	WP_413028423.1 glutathionylspermidine synthase family protein [Priestia aryabhattai]	diamond	150	50.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia aryabhattai
28716378	28716378	PRJNA280983_P_NODE_2887_length_409_cov_1.036111_g2772_i0	PRJNA280983	2887	409	1.036111	4.23769399	Culicoidibacter larvae	2579976	Bacteria	Bacteria	56.2	3.24e-6	NR	WP_138189773.1	2579976	g2772	i0	59.5	0.271393643031785	37	15	27.1	0	12	122	258	294	WP_138189773.1 ParB/RepB/Spo0J family partition protein [Culicoidibacter larvae]	diamond	111	56.2	1	Bacteria	Bacillati	Bacillota	Culicoidibacteria	Culicoidibacterales	Culicoidibacteraceae	Culicoidibacter	Culicoidibacter larvae
29095313	29095313	PRJNA280983_P_NODE_7208_length_216_cov_1.526946_g7093_i0	PRJNA280983	7208	216	1.526946	3.29820336	Thermicanus aegyptius	94009	Bacteria	Bacteria	48.1	3.16e-4	NR	WP_028986873.1	94009	g7093	i0	40.9	0.916666666666667	66	37	88.9	1	17	208	248	313	WP_028986873.1 cell division protein FtsA [Thermicanus aegyptius]	diamond	198	48.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
29316183	29316183	PRJNA280983_P_NODE_10069_length_166_cov_0.871795_g9954_i0	PRJNA280983	10069	166	0.871795	1.4471797	Clostridia bacterium	2044939	Bacteria	Bacteria	43.9	4.27e-4	NR	MBQ6324469.1	2044939	g9954	i0	57.7	0.469879518072289	26	11	47	0	123	46	21	46	MBQ6324469.1 hypothetical protein [Clostridia bacterium]	diamond	78	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29694757	29694757	PRJNA280983_P_NODE_1410_length_627_cov_3.856401_g1303_i0	PRJNA280983	1410	627	3.856401	24.17963427	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	50.8	0.00142	NR	MBO4267086.1	1898203	g1303	i0	28.9	0.679425837320574	142	81	60.3	5	501	124	185	322	MBO4267086.1 tetratricopeptide repeat protein [Lachnospiraceae bacterium]	diamond	426	50.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29789659	29789659	PRJNA280983_P_NODE_11111_length_162_cov_0.902655_g10996_i0	PRJNA280983	11111	162	0.902655	1.4623011	Bacillota bacterium	1879010	Bacteria	Bacteria	48.5	5.67e-5	NR	MCL6557201.1	1879010	g10996	i0	88.9	0.5	27	3	50	0	81	161	1	27	MCL6557201.1 HK97 gp10 family phage protein [Bacillota bacterium]	diamond	81	48.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29821142	29821142	PRJNA280983_P_NODE_4171_length_325_cov_1.847826_g4056_i0	PRJNA280983	4171	325	1.847826	6.0054345	Clostridioides difficile	1496	Bacteria	Bacteria	56.2	3.73e-7	NR	WP_320076599.1	1496	g4056	i0	75.8	0.304615384615385	33	8	30.5	0	104	202	114	146	WP_320076599.1 hypothetical protein, partial [Clostridioides difficile]	diamond	99	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29902333	29902333	PRJNA280983_P_NODE_3771_length_346_cov_2.387205_g3656_i0	PRJNA280983	3771	346	2.387205	8.2597293	Bacillales	1385	Bacteria	Bacteria	104	7.35e-26	NR	WP_128122244.1	2292355	g3656	i0	68	12.9884393063584	75	24	65	0	346	122	59	133	WP_128122244.1 rRNA maturation RNase YbeY [Exiguobacterium sp. AM39-5BH]	diamond	4494	105	0.990476190476191	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium sp. AM39-5BH
30611098	30611098	PRJNA280983_P_NODE_4513_length_308_cov_6.007722_g4398_i0	PRJNA280983	4513	308	6.007722	18.50378376	Clostridioides difficile	1496	Bacteria	Bacteria	111	1.05e-28	NR	WP_320076599.1	1496	g4398	i0	91.4	0.564935064935065	58	5	56.5	0	133	306	1	58	WP_320076599.1 hypothetical protein, partial [Clostridioides difficile]	diamond	174	111	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
31165721	31165721	PRJNA280983_P_NODE_2195_length_484_cov_3.521839_g2082_i0	PRJNA280983	2195	484	3.521839	17.04570076	Romboutsia	1501226	Bacteria	Bacteria	205	3.5400000000000004e-64	NR	WP_071119150.1	1776391	g2082	i0	63.2	2.82644628099174	152	56	94.2	0	465	10	55	206	WP_071119150.1 PH domain-containing protein [Romboutsia timonensis]	diamond	1368	207	0.990338164251208	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia timonensis
31432910	31432910	PRJNA280983_P_NODE_2256_length_474_cov_2.247059_g2143_i0	PRJNA280983	2256	474	2.247059	10.65105966	Culicoidibacter larvae	2579976	Bacteria	Bacteria	186	3.1099999999999988e-55	NR	WP_138190957.1	2579976	g2143	i0	60.8	1	158	61	100	1	1	474	61	217	WP_138190957.1 2-oxoacid:acceptor oxidoreductase family protein [Culicoidibacter larvae]	diamond	474	186	1	Bacteria	Bacillati	Bacillota	Culicoidibacteria	Culicoidibacterales	Culicoidibacteraceae	Culicoidibacter	Culicoidibacter larvae

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