metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA934332" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA934332" 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
2185938	2185938	PRJNA934332_P_NODE_2922_length_371_cov_1.033557_g2835_i0	PRJNA934332	2922	371	1.033557	3.83449647	Bacillus	1386	Bacteria	Bacteria	252	1.6100000000000002e-79	NR	WP_003184257.1	1386	g2835	i0	100	2.98382749326146	123	0	99.5	0	2	370	314	436	WP_003184257.1 MULTISPECIES: L-arabinose isomerase [Bacillus]	diamond	1107	252	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
13664257	13664257	PRJNA934332_P_NODE_9391_length_246_cov_0.890173_g9304_i0	PRJNA934332	9391	246	0.890173	2.18982558	Clostridia bacterium	2044939	Bacteria	Bacteria	125	3.49e-32	NR	MBP3800546.1	2044939	g9304	i0	73.8	0.975609756097561	80	21	97.6	0	244	5	267	346	MBP3800546.1 50S ribosomal protein L3 [Clostridia bacterium]	diamond	240	125	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
22587582	22587582	PRJNA934332_P_NODE_3038_length_364_cov_2.013746_g2951_i0	PRJNA934332	3038	364	2.013746	7.33003544	Bacillus	1386	Bacteria	Bacteria	258	7.94e-82	NR	WP_003184257.1	1386	g2951	i0	100	4.94505494505495	120	0	98.9	0	362	3	1	120	WP_003184257.1 MULTISPECIES: L-arabinose isomerase [Bacillus]	diamond	1800	258	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
27948070	27948070	PRJNA934332_P_NODE_6325_length_272_cov_0.854271_g6238_i0	PRJNA934332	6325	272	0.854271	2.32361712	root	1	Root_unresolved	Root_unresolved	53.5	8.49e-6	NR	MEE0515234.1	1926557	g6238	i0	30.9	4.01470588235294	97	60	99.3	2	3	272	75	171	MEE0515234.1 VWA domain-containing protein [Emergencia sp.]	diamond	1092	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Emergencia	Emergencia sp.
28761803	28761803	PRJNA934332_P_NODE_5327_length_289_cov_1.143519_g5240_i0	PRJNA934332	5327	289	1.143519	3.30476991	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.5	0.0276	NR	GFH95442.1	1898203	g5240	i0	31.3	0.695501730103806	67	42	65.4	1	71	259	68	134	GFH95442.1 hypothetical protein IMSAGC003_01986 [Lachnospiraceae bacterium]	diamond	201	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30189899	30189899	PRJNA934332_P_NODE_9012_length_247_cov_0.885057_g8925_i0	PRJNA934332	9012	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	44.7	0.0071	NR	WP_227277591.1	45462	g8925	i0	57.1	2.5748987854251	35	15	42.5	0	4	108	143	177	WP_227277591.1 ankyrin repeat domain-containing protein [Brevibacillus borstelensis]	diamond	636	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus borstelensis
31295882	31295882	PRJNA934332_P_NODE_11255_length_241_cov_0.916667_g11168_i0	PRJNA934332	11255	241	0.916667	2.20916747	Clostridia	186801	Bacteria	Bacteria	138	9.8e-38	NR	KGF09745.1	1230734	g11168	i0	95.7	1.74273858921162	70	3	87.1	0	3	212	276	345	KGF09745.1 hypothetical protein HMPREF1635_02425 [Clostridiales bacterium S5-A14a]	diamond	420	138	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Clostridiales bacterium S5-A14a
31352221	31352221	PRJNA934332_P_NODE_7236_length_255_cov_1.692308_g7149_i0	PRJNA934332	7236	255	1.692308	4.3153854	Bacillota bacterium	1879010	Bacteria	Bacteria	47.8	2.74e-4	NR	MCE1246774.1	1879010	g7149	i0	47.9	0.564705882352941	48	24	56.5	1	191	48	44	90	MCE1246774.1 OsmC family protein [Bacillota bacterium]	diamond	144	47.8	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
32333200	32333200	PRJNA934332_P_NODE_11039_length_242_cov_0.881657_g10952_i0	PRJNA934332	11039	242	0.881657	2.13360994	Streptococcus pneumoniae	1313	Bacteria	Bacteria	67	2.02e-12	NR	WP_196301241.1	1313	g10952	i0	59.3	2.03305785123967	54	22	66.9	0	214	53	33	86	WP_196301241.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	492	67	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
32333202	32333202	PRJNA934332_P_NODE_2759_length_379_cov_1.915033_g2672_i0	PRJNA934332	2759	379	1.915033	7.25797507	Clostridia bacterium	2044939	Bacteria	Bacteria	105	4.89e-24	NR	MBP3800462.1	2044939	g2672	i0	39.8	1.0131926121372	128	74	98.9	1	376	2	213	340	MBP3800462.1 hypothetical protein [Clostridia bacterium]	diamond	384	105	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia 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);;