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

16 rows where analysis = "diamond", bioproject = "PRJNA287283" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26821163	26821163	PRJNA287283_P_NODE_8441_length_183_cov_0.861538_g8217_i0	PRJNA287283	8441	183	0.861538	1.57661454	Rhodococcus sp. EPR-157	1813677	Bacteria	Bacteria	120	4.03e-32	NR	WP_068367966.1	1813677	g8217	i0	98.4	3	61	1	100	0	183	1	24	84	WP_068367966.1 HpcH/HpaI aldolase/citrate lyase family protein, partial [Rhodococcus sp. EPR-157]	diamond	549	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. EPR-157
27232172	27232172	PRJNA287283_P_NODE_8743_length_182_cov_0.868217_g8519_i0	PRJNA287283	8743	182	0.868217	1.58015494	Anaerolineae bacterium	2052143	Bacteria	Bacteria	87.8	2.16e-18	NR	HLF25218.1	2052143	g8519	i0	68.4	0.93956043956044	57	18	94	0	182	12	233	289	HLF25218.1 sialidase family protein [Anaerolineae bacterium]	diamond	171	87.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27358794	27358794	PRJNA287283_P_NODE_3843_length_323_cov_4.848148_g3619_i0	PRJNA287283	3843	323	4.848148	15.65951804	Exiguobacterium aurantiacum	33987	Bacteria	Bacteria	47.4	1.52e-4	NR	WP_233005565.1	33987	g3619	i0	88.9	0.25077399380805	27	3	25.1	0	112	32	30	56	WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum]	diamond	81	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
27390386	27390386	PRJNA287283_P_NODE_10403_length_175_cov_0.918033_g10179_i0	PRJNA287283	10403	175	0.918033	1.60655775	Lawsonella	1847725	Bacteria	Bacteria	113	5.62e-28	NR	WP_290598508.1	1847725	g10179	i0	100	0.977142857142857	57	0	97.7	0	173	3	19	75	WP_290598508.1 MULTISPECIES: MinD/ParA family ATP-binding protein [Lawsonella]	diamond	171	113	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
27390387	27390387	PRJNA287283_P_NODE_7363_length_201_cov_0.945946_g7139_i0	PRJNA287283	7363	201	0.945946	1.90135146	Listeria monocytogenes	1639	Bacteria	Bacteria	54.7	4.75e-8	NR	WP_369698196.1	1639	g7139	i0	100	0.343283582089552	23	0	34.3	0	49	117	38	60	WP_369698196.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	69	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28260188	28260188	PRJNA287283_P_NODE_7666_length_195_cov_0.964789_g7442_i0	PRJNA287283	7666	195	0.964789	1.88133855	root	1	Root_unresolved	Root_unresolved	40.4	0.0348	NR	WP_146844862.1	311234	g7442	i0	50	1.38461538461538	38	19	58.5	0	23	136	30	67	WP_146844862.1 hypothetical protein [Cellulomonas terrae]	diamond	270	40.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas terrae
28400605	28400605	PRJNA287283_P_NODE_7786_length_193_cov_0.864286_g7562_i0	PRJNA287283	7786	193	0.864286	1.66807198	Listeria monocytogenes	1639	Bacteria	Bacteria	53.1	1.86e-7	NR	WP_369698293.1	1639	g7562	i0	82.4	1.50777202072539	34	2	46.6	1	191	102	31	64	WP_369698293.1 hypothetical protein [Listeria monocytogenes]	diamond	291	53.5	0.992523364485981	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29000860	29000860	PRJNA287283_P_NODE_6088_length_234_cov_1.138122_g5864_i0	PRJNA287283	6088	234	1.138122	2.66320548	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.4	0.0442	NR	MBI4498881.1	2026724	g5864	i0	41	0.782051282051282	61	30	78.2	1	38	220	374	428	MBI4498881.1 ammonium transporter [Chloroflexota bacterium]	diamond	183	42.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29252840	29252840	PRJNA287283_P_NODE_9349_length_179_cov_0.888889_g9125_i0	PRJNA287283	9349	179	0.888889	1.59111131	Streptococcus mitis	28037	Bacteria	Bacteria	120	4.17e-31	NR	WP_414309482.1	28037	g9125	i0	100	0.988826815642458	59	0	98.9	0	178	2	125	183	WP_414309482.1 AAA family ATPase [Streptococcus mitis]	diamond	177	120	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
29284474	29284474	PRJNA287283_P_NODE_7229_length_204_cov_0.920530_g7005_i0	PRJNA287283	7229	204	0.92053	1.8778812	Listeria monocytogenes	1639	Bacteria	Bacteria	67.4	4.16e-12	NR	WP_369698292.1	1639	g7005	i0	62.7	0.985294117647059	67	23	98.5	1	2	202	77	141	WP_369698292.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	201	67.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29821181	29821181	PRJNA287283_P_NODE_9891_length_177_cov_0.903226_g9667_i0	PRJNA287283	9891	177	0.903226	1.59871002	Sediminivirga luteola	1774748	Bacteria	Bacteria	87.4	1.99e-18	NR	WP_229745146.1	1774748	g9667	i0	75	0.949152542372881	56	14	94.9	0	9	176	211	266	WP_229745146.1 exonuclease domain-containing protein [Sediminivirga luteola]	diamond	168	87.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Sediminivirga	Sediminivirga luteola
30471125	30471125	PRJNA287283_P_NODE_5273_length_260_cov_0.864734_g5049_i0	PRJNA287283	5273	260	0.864734	2.2483084	PVC group	1783257	Bacteria	Bacteria	42.7	0.0236	NR	WP_376810015.1	1337874	g5049	i0	44.1	0.992307692307692	59	26	66.9	3	67	240	62	114	WP_376810015.1 hypothetical protein [Catellatospora aurea]	diamond	258	43.1	0.990719257540603	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Catellatospora	Catellatospora aurea
31622724	31622724	PRJNA287283_P_NODE_7276_length_203_cov_0.773333_g7052_i0	PRJNA287283	7276	203	0.773333	1.56986599	Listeria monocytogenes	1639	Bacteria	Bacteria	127	1.7399999999999997e-35	NR	WP_369698296.1	1639	g7052	i0	100	3.96059113300493	67	0	99	0	2	202	62	128	WP_369698296.1 RNA-directed DNA polymerase, partial [Listeria monocytogenes]	diamond	804	127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
31907434	31907434	PRJNA287283_P_NODE_4797_length_279_cov_1.451327_g4573_i0	PRJNA287283	4797	279	1.451327	4.04920233	Salinibacterium hongtaonis	2079791	Bacteria	Bacteria	43.5	0.0295	NR	WP_108518238.1	2079791	g4573	i0	51.1	0.483870967741935	45	20	46.2	2	187	59	205	249	WP_108518238.1 MmgE/PrpD family protein [Salinibacterium hongtaonis]	diamond	135	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Homoserinimonas	Homoserinimonas hongtaonis
32097257	32097257	PRJNA287283_P_NODE_9138_length_180_cov_0.881890_g8914_i0	PRJNA287283	9138	180	0.88189	1.587402	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	42	0.03	NR	HZJ48322.1	2080302	g8914	i0	41.2	0.85	51	21	70	1	48	173	335	385	HZJ48322.1 isoamylase [Acidimicrobiia bacterium]	diamond	153	42	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
32445600	32445600	PRJNA287283_P_NODE_3279_length_353_cov_0.956667_g3055_i0	PRJNA287283	3279	353	0.956667	3.37703451	Listeria monocytogenes	1639	Bacteria	Bacteria	67.8	8.23e-12	NR	WP_369698193.1	1639	g3055	i0	91.7	0.305949008498584	36	2	30.6	1	215	322	1	35	WP_369698193.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	108	67.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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