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

20 rows where analysis = "diamond", bioproject = "PRJNA688736" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5771555	5771555	PRJNA688736_P_NODE_38565_length_257_cov_1.309783_g38280_i0	PRJNA688736	38565	257	1.309783	3.36614231	Actinomycetales bacterium	1911520	Bacteria	Bacteria	114	3.22e-30	NR	NLI17885.1	1911520	g38280	i0	78.9	1.68093385214008	71	15	82.9	0	1	213	73	143	NLI17885.1 PH domain-containing protein [Actinomycetales bacterium]	diamond	432	114	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales			Actinomycetales bacterium
6281086	6281086	PRJNA688736_P_NODE_14885_length_396_cov_3.362229_g14600_i0	PRJNA688736	14885	396	3.362229	13.31442684	root	1	Root_unresolved	Root_unresolved	192	1.58e-60	NR	MRC56835.1	1428	g14600	i0	91.2	7.00757575757576	102	9	77.3	0	396	91	20	121	MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis]	diamond	2775	192	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
13421969	13421969	PRJNA688736_P_NODE_42951_length_250_cov_0.881356_g42666_i0	PRJNA688736	42951	250	0.881356	2.20339	Oscillatoria princeps	132603	Bacteria	Bacteria	138	1.73e-36	NR	MBW4493070.1	2839661	g42666	i0	73.5	3.984	83	22	99.6	0	250	2	171	253	MBW4493070.1 catalase [Oscillatoria princeps RMCB-10]	diamond	996	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria princeps
24894303	24894303	PRJNA688736_P_NODE_46540_length_246_cov_0.901734_g46255_i0	PRJNA688736	46540	246	0.901734	2.21826564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	149	9.049999999999998e-42	NR	RIK38425.1	2026724	g46255	i0	91.5	2	82	7	100	0	246	1	208	289	RIK38425.1 MAG: type I glyceraldehyde-3-phosphate dehydrogenase [Chloroflexota bacterium]	diamond	492	149	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
26733692	26733692	PRJNA688736_P_NODE_42101_length_251_cov_0.876404_g41816_i0	PRJNA688736	42101	251	0.876404	2.19977404	Cyanobacterium aponinum	379064	Bacteria	Bacteria	69.7	1.2e-11	NR	WP_324282118.1	379064	g41816	i0	42.3	3.70517928286853	78	45	93.2	0	17	250	244	321	WP_324282118.1 transposase [Cyanobacterium aponinum]	diamond	930	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium aponinum
26765791	26765791	PRJNA688736_P_NODE_34781_length_272_cov_1.090452_g34496_i0	PRJNA688736	34781	272	1.090452	2.96602944	Catellatospora sp. TT	54104	Bacteria	Bacteria	42.7	0.0451	NR	WP_212830149.1	2733863	g34496	i0	34.5	0.926470588235294	84	46	87.1	4	257	21	8	87	WP_212830149.1 hypothetical protein [Catellatospora sp. TT07R-123]	diamond	252	42.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Catellatospora	Catellatospora sp. TT07R-123
27682837	27682837	PRJNA688736_P_NODE_44104_length_249_cov_0.886364_g43819_i0	PRJNA688736	44104	249	0.886364	2.20704636	unclassified Rhodococcus (in: high G+C Gram-positive bacteria)	192944	Bacteria	Bacteria	154	2.27e-41	NR	WP_094638973.1	192944	g43819	i0	96.3	0.987951807228916	82	3	98.8	0	248	3	122	203	WP_094638973.1 MULTISPECIES: LuxR C-terminal-related transcriptional regulator [unclassified Rhodococcus (in: high G+C Gram-positive bacteria)]	diamond	246	154	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus
27966590	27966590	PRJNA688736_P_NODE_39225_length_255_cov_1.010989_g38940_i0	PRJNA688736	39225	255	1.010989	2.57802195	Arthrobacter citreus	1670	Bacteria	Bacteria	59.3	4.88e-8	NR	WP_376934700.1	1670	g38940	i0	100	0.329411764705882	28	0	32.9	0	1	84	259	286	WP_376934700.1 hypothetical protein [Arthrobacter citreus]	diamond	84	59.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
27998419	27998419	PRJNA688736_P_NODE_44845_length_248_cov_0.891429_g44560_i0	PRJNA688736	44845	248	0.891429	2.21074392	Lapidilactobacillus concavus	287844	Bacteria	Bacteria	157	2.24e-47	NR	WP_057823203.1	287844	g44560	i0	97.6	0.991935483870968	82	2	99.2	0	248	3	77	158	WP_057823203.1 hypothetical protein [Lapidilactobacillus concavus]	diamond	246	157	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lapidilactobacillus	Lapidilactobacillus concavus
29481923	29481923	PRJNA688736_P_NODE_910_length_1293_cov_43.992623_g790_i0	PRJNA688736	910	1293	43.992623	568.82461539	Arthrobacter citreus	1670	Bacteria	Bacteria	539	2.2399999999999998e-190	NR	WP_376934700.1	1670	g790	i0	100	0.663573085846868	286	0	66.4	0	228	1085	1	286	WP_376934700.1 hypothetical protein [Arthrobacter citreus]	diamond	858	539	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
29619639	29619639	PRJNA688736_P_NODE_15810_length_386_cov_1.476038_g15525_i0	PRJNA688736	15810	386	1.476038	5.69750668	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	86.7	4.71e-18	NR	WP_196524438.1	1178	g15525	i0	45.4	4.73316062176166	97	51	75.4	2	296	6	74	168	WP_196524438.1 CAP domain-containing protein, partial [Nostoc commune]	diamond	1827	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
30145150	30145150	PRJNA688736_P_NODE_42012_length_251_cov_0.876404_g41727_i0	PRJNA688736	42012	251	0.876404	2.19977404	Actinomycetota bacterium	2900548	Bacteria	Bacteria	113	6.870000000000001e-27	NR	MDQ3894990.1	2900548	g41727	i0	67.5	0.99203187250996006	83	26	99.2	1	251	3	254	335	MDQ3894990.1 beta-propeller fold lactonase family protein [Actinomycetota bacterium]	diamond	249	113	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
30998597	30998597	PRJNA688736_P_NODE_94_length_2271_cov_12.526388_g77_i0	PRJNA688736	94	2271	12.526388	284.47427148	Arthrobacter citreus	1670	Bacteria	Bacteria	176	1.69e-48	NR	WP_376934692.1	1670	g77	i0	100	0.121532364597094	92	0	12.2	0	697	422	1	92	WP_376934692.1 hypothetical protein, partial [Arthrobacter citreus]	diamond	276	176	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
31156179	31156179	PRJNA688736_P_NODE_75_length_2358_cov_20.123851_g64_i0	PRJNA688736	75	2358	20.123851	474.52040658	Arthrobacter citreus	1670	Bacteria	Bacteria	823	9.05e-295	NR	WP_376934698.1	1670	g64	i0	100	0.517811704834606	407	0	51.8	0	1010	2230	1	407	WP_376934698.1 hypothetical protein, partial [Arthrobacter citreus]	diamond	1221	823	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
31187785	31187785	PRJNA688736_P_NODE_50875_length_242_cov_0.923077_g50590_i0	PRJNA688736	50875	242	0.923077	2.23384634	uncultured Lachnoanaerobaculum sp.	1662275	Bacteria	Bacteria	112	1.79e-27	NR	WP_314505175.1	1662275	g50590	i0	66.7	0.966942148760331	78	26	96.7	0	1	234	114	191	WP_314505175.1 LacI family DNA-binding transcriptional regulator [uncultured Lachnoanaerobaculum sp.]	diamond	234	112	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	uncultured Lachnoanaerobaculum sp.
31757406	31757406	PRJNA688736_P_NODE_43497_length_249_cov_1.329545_g43212_i0	PRJNA688736	43497	249	1.329545	3.31056705	Thermaerobacter sp.	1937527	Bacteria	Bacteria	43.1	0.0292	NR	HEY8488732.1	1937527	g43212	i0	39.1	0.771084337349398	64	34	72.3	2	16	195	332	394	HEY8488732.1 HD domain-containing phosphohydrolase [Thermaerobacter sp.]	diamond	192	43.1	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiales Family XVII. Incertae Sedis	Thermaerobacter	Thermaerobacter sp.
31852192	31852192	PRJNA688736_P_NODE_7357_length_542_cov_2.515991_g7075_i0	PRJNA688736	7357	542	2.515991	13.63667122	Arthrobacter citreus	1670	Bacteria	Bacteria	79.7	3.23e-14	NR	WP_376934700.1	1670	g7075	i0	36.3	0.808118081180812	146	90	80.3	2	507	73	117	260	WP_376934700.1 hypothetical protein [Arthrobacter citreus]	diamond	438	79.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter citreus
32073811	32073811	PRJNA688736_P_NODE_45858_length_247_cov_0.896552_g45573_i0	PRJNA688736	45858	247	0.896552	2.21448344	Lancefieldella parvula	1382	Bacteria	Bacteria	159	1.15e-43	NR	WP_314950448.1	1382	g45573	i0	92.7	2.98785425101215	82	6	99.6	0	2	247	42	123	WP_314950448.1 class I SAM-dependent DNA methyltransferase [Lancefieldella parvula]	diamond	738	159	1	Bacteria		Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Lancefieldella	Lancefieldella parvula
32358840	32358840	PRJNA688736_P_NODE_49939_length_243_cov_0.917647_g49654_i0	PRJNA688736	49939	243	0.917647	2.22988221	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	132	7.92e-34	NR	HEY9779128.1	3088178	g49654	i0	85.9	1.92592592592593	78	11	96.3	0	2	235	608	685	HEY9779128.1 MobF family relaxase [Leptolyngbyaceae cyanobacterium]	diamond	468	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
32496841	32496841	PRJNA688736_P_NODE_50019_length_243_cov_0.917647_g49734_i0	PRJNA688736	50019	243	0.917647	2.22988221	root	1	Root_unresolved	Root_unresolved	90.9	8.200000000000001e-22	NR	WP_285164290.1	1773	g49734	i0	62.7	19.1604938271605	75	27	91.4	1	224	3	15	89	WP_285164290.1 glutathione S-transferase N-terminal domain-containing protein, partial [Mycobacterium tuberculosis]	diamond	4656	91.7	0.991275899672846	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis

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