metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA509429" 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
27298453	27298453	PRJNA509429_P_NODE_11383_length_426_cov_20.672634_g10565_i0	PRJNA509429	11383	426	20.672634	88.06542084	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	82.4	5.05e-17	NR	POH17992.1	1625	g10565	i0	78.6	0.492957746478873	70	15	49.3	0	1	210	62	131	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	210	82.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
27298454	27298454	PRJNA509429_P_NODE_31843_length_214_cov_4.865922_g31015_i0	PRJNA509429	31843	214	4.865922	10.41307308	Staphylococcus aureus	1280	Bacteria	Bacteria	65.5	6.9e-12	NR	MCS4580470.1	1280	g31015	i0	100	0.602803738317757	43	0	60.3	0	4	132	1	43	MCS4580470.1 hypothetical protein [Staphylococcus aureus]	diamond	129	65.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28119364	28119364	PRJNA509429_P_NODE_28605_length_233_cov_1.237374_g27777_i0	PRJNA509429	28605	233	1.237374	2.88308142	Priestia megaterium	1404	Bacteria	Bacteria	41.2	0.017	NR	QDZ82736.1	1404	g27777	i0	52.2	0.592274678111588	46	18	56.7	3	225	94	20	63	QDZ82736.1 hypothetical protein D0440_26115 [Priestia megaterium]	diamond	138	41.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
30456667	30456667	PRJNA509429_P_NODE_42653_length_173_cov_1.021739_g41825_i0	PRJNA509429	42653	173	1.021739	1.76760847	Desulfosporosinus sp.	157907	Bacteria	Bacteria	48.9	9.93e-6	NR	MDR3540328.1	157907	g41825	i0	92.6	0.468208092485549	27	2	46.8	0	160	80	2	28	MDR3540328.1 hypothetical protein [Desulfosporosinus sp.]	diamond	81	48.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfosporosinus	Desulfosporosinus sp.
31341135	31341135	PRJNA509429_P_NODE_29576_length_227_cov_2.250000_g28748_i0	PRJNA509429	29576	227	2.25	5.1075	Bacillus sp. SRB_28	1969378	Bacteria	Bacteria	40.8	0.0239	NR	RAN86401.1	1969378	g28748	i0	71.4	0.370044052863436	28	7	37	1	2	85	1	27	RAN86401.1 hypothetical protein B5P41_29460 [Bacillus sp. SRB_28]	diamond	84	40.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. SRB_28
31910471	31910471	PRJNA509429_P_NODE_23877_length_266_cov_1.670996_g23049_i0	PRJNA509429	23877	266	1.670996	4.44484936	Carboxydothermus islandicus	661089	Bacteria	Bacteria	51.2	5.28e-6	NR	GAV26061.1	661089	g23049	i0	48.3	0.676691729323308	60	31	67.7	0	67	246	36	95	GAV26061.1 putative uncharacterized protein, partial [Carboxydothermus islandicus]	diamond	180	51.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Carboxydothermus	Carboxydothermus islandicus
32763759	32763759	PRJNA509429_P_NODE_15980_length_349_cov_25.754777_g15152_i0	PRJNA509429	15980	349	25.754777	89.88417173	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	121	1.0799999999999999e-32	NR	POH17992.1	1625	g15152	i0	65.2	0.988538681948424	115	40	98.9	0	2	346	3	117	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	345	121	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis

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