metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA891846" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA891846" 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
867008	867008	PRJNA891846_P_NODE_24821_length_305_cov_2.034483_g24602_i0	PRJNA891846	24821	305	2.034483	6.20517315	Planococcus sp. 107-1	2908840	Bacteria	Bacteria	451	2.3999999999999996e-122	NTclustered	gi\|2180345768\|gb\|CP090977.1\|	2908840	g24602	i0	93.485	798.963934426229	307	14	99	4	1	304	484683	484986	Planococcus sp. 107-1 chromosome, complete genome	blastn	243684	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus sp. 107-1
1243171	1243171	PRJNA891846_P_NODE_8621_length_503_cov_2.327907_g8406_i0	PRJNA891846	8621	503	2.327907	11.70937221	Bacillus	1386	Bacteria	Bacteria	852	0	NTclustered	gi\|152022606\|gb\|CP000764.1\|	315749	g8406	i0	97.222	1247.50894632207	504	13	100	1	1	503	90912	90409	Bacillus cytotoxicus NVH 391-98, complete genome	blastn	627497	852	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cytotoxicus
3417939	3417939	PRJNA891846_P_NODE_33003_length_266_cov_1.196891_g32784_i0	PRJNA891846	33003	266	1.196891	3.18373006	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	472	1.5799999999999998e-128	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g32784	i0	98.864	328.868421052632	264	3	99	0	3	266	437257	437520	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	87479	472	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
9795484	9795484	PRJNA891846_P_NODE_5968_length_595_cov_1.408046_g5758_i0	PRJNA891846	5968	595	1.408046	8.3778737	Clostridium beijerinckii	1520	Bacteria	Bacteria	1020	0	NTclustered	gi\|1491812680\|gb\|CP011966.3\|	1428454	g5758	i0	97.647	1004.43865546218	595	13	99	1	2	595	2163159	2162565	Clostridium beijerinckii NRRL B-598, complete genome	blastn	597641	1020	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
10171680	10171680	PRJNA891846_P_NODE_37468_length_250_cov_1.305085_g37248_i0	PRJNA891846	37468	250	1.305085	3.2627125	root	1	Root_unresolved	Root_unresolved	462	8.83e-126	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g37248	i0	100	38.708	250	0	100	0	1	250	2427794	2427545	Staphylococcus aureus strain WH9628 chromosome	blastn	9677	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13621199	13621199	PRJNA891846_P_NODE_46511_length_242_cov_0.911243_g46291_i0	PRJNA891846	46511	242	0.911243	2.20520806	Enterococcus cecorum	44008	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2737623164\|gb\|CP144500.1\|	44008	g46291	i0	100	1.15702479338843	28	0	12	0	98	125	981007	981034	Enterococcus cecorum strain 65 chromosome, complete genome	blastn	280	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
17445547	17445547	PRJNA891846_P_NODE_38654_length_249_cov_0.875000_g38434_i0	PRJNA891846	38654	249	0.875	2.17875	Coprococcus phoceensis	1870993	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|2777535726\|dbj\|AP031412.1\|	1870993	g38434	i0	98.795	439.421686746988	249	3	100	0	1	249	40693	40941	Coprococcus phoceensis f14 DNA, complete genome	blastn	109416	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Coprococcus	Coprococcus phoceensis
19094657	19094657	PRJNA891846_P_NODE_38595_length_249_cov_0.875000_g38375_i0	PRJNA891846	38595	249	0.875	2.17875	Clostridium	1485	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2385532608\|gb\|CP086246.1\|	2843318	g38375	i0	100	0.337349397590361	28	0	11	0	169	196	2522151	2522178	Clostridium sp. CF011 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. CF011
22920720	22920720	PRJNA891846_P_NODE_34618_length_259_cov_1.241935_g34398_i0	PRJNA891846	34618	259	1.241935	3.21661165	Clostridia	186801	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|2299490668\|gb\|CP102292.1\|	471875	g34398	i0	100	453.540540540541	259	0	100	0	1	259	373447	373189	[Ruminococcus] lactaris ATCC 29176 chromosome, complete genome	blastn	117467	479	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	[Ruminococcus] lactaris
23819385	23819385	PRJNA891846_P_NODE_34239_length_261_cov_1.180851_g34019_i0	PRJNA891846	34239	261	1.180851	3.08202111	Staphylococcus simulans	1286	Bacteria	Bacteria	58.4	5.12e-4	NTclustered	gi\|2312988506\|gb\|CP094697.1\|	1286	g34019	i0	90.909	0.168582375478927	44	2	16	2	53	95	324494	324452	Staphylococcus simulans strain IVB6244 chromosome, complete genome	blastn	44	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus simulans

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