metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA888104" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA888104" 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
27908017	27908017	PRJNA888104_P_NODE_22045_length_230_cov_0.906832_g21976_i0	PRJNA888104	22045	230	0.906832	2.0857136	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	42.4	0.0386	NR	MCR4686858.1	1898203	g21976	i0	33.3	0.9	69	45	90	1	212	6	17	84	MCR4686858.1 hemolysin III family protein [Lachnospiraceae bacterium]	diamond	207	42.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28697844	28697844	PRJNA888104_P_NODE_18187_length_241_cov_1.226744_g18118_i0	PRJNA888104	18187	241	1.226744	2.95645304	Mycobacteriaceae	1762	Bacteria	Bacteria	43.5	0.0187	NR	WP_133427604.1	1762	g18118	i0	47.5	0.995850622406639	40	21	49.8	0	21	140	176	215	WP_133427604.1 MULTISPECIES: phage baseplate assembly protein V [Mycobacteriaceae]	diamond	240	43.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae
28950492	28950492	PRJNA888104_P_NODE_19088_length_236_cov_0.874251_g19019_i0	PRJNA888104	19088	236	0.874251	2.06323236	Leptolyngbyaceae cyanobacterium SM1_3_5	2720458	Bacteria	Bacteria	131	5.6299999999999985e-34	NR	NJL21289.1	2720458	g19019	i0	88	0.953389830508475	75	9	95.3	0	11	235	23	97	NJL21289.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Leptolyngbyaceae cyanobacterium SM1_3_5]	diamond	225	131	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium SM1_3_5
29305366	29305366	PRJNA888104_P_NODE_23389_length_224_cov_2.677419_g23320_i0	PRJNA888104	23389	224	2.677419	5.99741856	Actinomycetes	1760	Bacteria	Bacteria	69.7	5.63e-12	NR	WP_263797007.1	344163	g23320	i0	60	4.09821428571429	60	24	80.4	0	209	30	30	89	WP_263797007.1 phosphotransferase [Microbacterium terricola]	diamond	918	70.1	0.994293865905849	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium terricola
30308714	30308714	PRJNA888104_P_NODE_22612_length_229_cov_0.912500_g22543_i0	PRJNA888104	22612	229	0.9125	2.089625	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.9	0.0116	NR	MBN1178039.1	2052143	g22543	i0	46.7	0.589519650655022	45	23	57.6	1	12	143	340	384	MBN1178039.1 glycosyltransferase family 2 protein [Anaerolineae bacterium]	diamond	135	43.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31224356	31224356	PRJNA888104_P_NODE_10215_length_315_cov_0.865854_g10146_i0	PRJNA888104	10215	315	0.865854	2.7274401	Mycobacterium sp. GA-1841	1834154	Bacteria	Bacteria	44.3	0.0193	NR	WP_076195493.1	1834154	g10146	i0	40.7	0.561904761904762	59	34	55.2	1	176	3	154	212	WP_076195493.1 TetR/AcrR family transcriptional regulator [Mycobacterium sp. GA-1841]	diamond	177	44.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. GA-1841
31256140	31256140	PRJNA888104_P_NODE_475_length_1232_cov_64.892519_g438_i0	PRJNA888104	475	1232	64.892519	799.47583408	Virgibacillus sp. 19R1-5	2834410	Bacteria	Bacteria	242	6.089999999999999e-74	NR	WP_213406776.1	2834410	g438	i0	73.2	0.655032467532468	269	69	64.8	1	2	799	2	270	WP_213406776.1 hypothetical protein, partial [Virgibacillus sp. 19R1-5]	diamond	807	242	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus sp. 19R1-5
31382779	31382779	PRJNA888104_P_NODE_11076_length_304_cov_0.923404_g11007_i0	PRJNA888104	11076	304	0.923404	2.80714816	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	43.5	0.0294	NR	MDP7225415.1	2030829	g11007	i0	35	0.592105263157895	60	31	53.3	2	50	211	99	156	MDP7225415.1 NIPSNAP family protein [SAR202 cluster bacterium]	diamond	180	43.5	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster 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);;