metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1245487" 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
26756897	26756897	PRJNA1245487_P_NODE_10701_length_362_cov_1.179931_g10363_i0	PRJNA1245487	10701	362	1.179931	4.27135022	Weissella cibaria	137591	Bacteria	Bacteria	51.6	2.55e-5	NR	WP_196777313.1	137591	g10363	i0	58.2	0.812154696132597	98	26	72.9	7	4	267	6	98	WP_196777313.1 hypothetical protein, partial [Weissella cibaria]	diamond	294	51.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
26946945	26946945	PRJNA1245487_P_NODE_23342_length_211_cov_4.188406_g23004_i0	PRJNA1245487	23342	211	4.188406	8.83753666	Staphylococcus aureus	1280	Bacteria	Bacteria	129	3.2099999999999997e-37	NR	MDN9006640.1	1280	g23004	i0	100	0.995260663507109	70	0	99.5	0	211	2	6	75	MDN9006640.1 hypothetical protein [Staphylococcus aureus]	diamond	210	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
26978630	26978630	PRJNA1245487_P_NODE_12742_length_325_cov_0.821429_g12404_i0	PRJNA1245487	12742	325	0.821429	2.66964425	uncultured Gemmiger sp.	1623490	Bacteria	Bacteria	45.1	0.0138	NR	WP_294500257.1	1623490	g12404	i0	52.1	0.443076923076923	48	22	44.3	1	121	264	57	103	WP_294500257.1 metallophosphoesterase [uncultured Gemmiger sp.]	diamond	144	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Gemmiger	uncultured Gemmiger sp.
27705784	27705784	PRJNA1245487_P_NODE_8164_length_428_cov_2.053521_g7827_i0	PRJNA1245487	8164	428	2.053521	8.78906988	Heyndrickxia sporothermodurans	46224	Bacteria	Bacteria	54.3	2.21e-5	NR	WP_107981750.1	46224	g7827	i0	50	0.69392523364486	52	26	36.4	0	3	158	80	131	WP_107981750.1 SPRY domain-containing protein [Heyndrickxia sporothermodurans]	diamond	297	54.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia sporothermodurans
28873567	28873567	PRJNA1245487_P_NODE_17328_length_268_cov_1.317949_g16990_i0	PRJNA1245487	17328	268	1.317949	3.53210332	Veillonella sp. VA142	741834	Bacteria	Bacteria	180	1.3e-56	NR	WP_240632606.1	741834	g16990	i0	95.5	1.9365671641791	88	4	98.5	0	3	266	15	102	WP_240632606.1 hypothetical protein [Veillonella sp. VA142]	diamond	519	180	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp. VA142
29094788	29094788	PRJNA1245487_P_NODE_17468_length_267_cov_0.953608_g17130_i0	PRJNA1245487	17468	267	0.953608	2.54613336	Weissella cibaria	137591	Bacteria	Bacteria	42.4	0.0309	NR	WP_196777313.1	137591	g17130	i0	59.8	0.97752808988764	87	27	95.5	4	5	259	10	90	WP_196777313.1 hypothetical protein, partial [Weissella cibaria]	diamond	261	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
29094792	29094792	PRJNA1245487_P_NODE_4968_length_562_cov_2.867076_g4635_i0	PRJNA1245487	4968	562	2.867076	16.11296712	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	108	5.25e-25	NR	MBO6041441.1	2485925	g4635	i0	41.9	1.52669039145907	148	80	76.9	3	1	432	40	185	MBO6041441.1 transcriptional regulator [Oscillospiraceae bacterium]	diamond	858	108	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
31053329	31053329	PRJNA1245487_P_NODE_17015_length_271_cov_1.025253_g16677_i0	PRJNA1245487	17015	271	1.025253	2.77843563	Bacillus sp. WP8	756828	Bacteria	Bacteria	41.6	0.0225	NR	WP_222121568.1	756828	g16677	i0	38.8	0.74169741697417	67	30	73.1	4	73	270	12	68	WP_222121568.1 hypothetical protein, partial [Bacillus sp. WP8]	diamond	201	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. WP8
31970108	31970108	PRJNA1245487_P_NODE_21478_length_244_cov_0.912281_g21140_i0	PRJNA1245487	21478	244	0.912281	2.22596564	Paenibacillus	44249	Bacteria	Bacteria	165	8.559999999999999e-48	NR	WP_024634287.1	44249	g21140	i0	100	0.995901639344262	81	0	99.6	0	2	244	227	307	WP_024634287.1 MULTISPECIES: flavin monoamine oxidase family protein [Paenibacillus]	diamond	243	165	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
32318543	32318543	PRJNA1245487_P_NODE_21439_length_244_cov_0.912281_g21101_i0	PRJNA1245487	21439	244	0.912281	2.22596564	Selenomonas sp. FOBRC9	936573	Bacteria	Bacteria	155	3.13e-44	NR	WP_037351117.1	936573	g21101	i0	96.3	0.995901639344262	81	3	99.6	0	243	1	253	333	WP_037351117.1 ABC transporter substrate-binding protein [Selenomonas sp. FOBRC9]	diamond	243	155	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp. FOBRC9
32634025	32634025	PRJNA1245487_P_NODE_16460_length_276_cov_1.443350_g16122_i0	PRJNA1245487	16460	276	1.44335	3.983646	Staphylococcus aureus	1280	Bacteria	Bacteria	43.1	0.0256	NR	WP_178137617.1	1280	g16122	i0	59.7	0.782608695652174	72	19	73.9	5	64	267	53	118	WP_178137617.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	216	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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