metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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	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
4005440	4005440	PRJNA1061474_P_NODE_53184_length_245_cov_0.895349_g52938_i0	PRJNA1061474	53184	245	0.895349	2.19360505	Paenibacillus polymyxa	1406	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2451066805\|gb\|CP097766.3\|	1406	g52938	i0	100	2	245	0	100	1	245	4213878	4213634	Paenibacillus polymyxa strain R 6.14 chromosome, complete genome	blastn	490	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
6556843	6556843	PRJNA1061474_P_NODE_49766_length_248_cov_0.880000_g49520_i0	PRJNA1061474	49766	248	0.88	2.1824	Desulfofundulus kuznetsovii	58135	Bacteria	Bacteria	156	1.66e-33	NTclustered	gi\|333820987\|gb\|CP002770.1\|	760568	g49520	i0	81.967	0.919354838709677	183	33	74	66	248	524682	524500	Desulfotomaculum kuznetsovii DSM 6115, complete genome	blastn	228	156	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae	Desulfofundulus	Desulfofundulus kuznetsovii
9939788	9939788	PRJNA1061474_P_NODE_26508_length_367_cov_1.666667_g26262_i0	PRJNA1061474	26508	367	1.666667	6.11666789	Aerococcus	1375	Bacteria	Bacteria	678	0	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g26262	i0	100	447.558583106267	367	0	100	1	367	18734	18368	Aerococcus viridans strain CCUG4311, complete genome	blastn	164254	678	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
9939863	9939863	PRJNA1061474_P_NODE_52588_length_245_cov_0.895349_g52342_i0	PRJNA1061474	52588	245	0.895349	2.19360505	Lysinibacillus	400634	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1333950533\|gb\|CP026007.1\|	2072025	g52342	i0	100	72.2040816326531	245	0	100	1	245	111999	111755	Lysinibacillus sp. YS11 chromosome, complete genome	blastn	17690	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. YS11
11657309	11657309	PRJNA1061474_P_NODE_44770_length_253_cov_1.777778_g44524_i0	PRJNA1061474	44770	253	1.777778	4.49777834	Staphylococcus epidermidis	1282	Bacteria	Bacteria	429	9.079999999999999e-116	NTclustered	gi\|2866855000\|gb\|CP064560.1\|	1282	g44524	i0	99.574	440.324110671937	235	1	93	1	235	2354517	2354283	Staphylococcus epidermidis strain UMCG361 chromosome, complete genome	blastn	111402	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13765074	13765074	PRJNA1061474_P_NODE_51651_length_246_cov_0.890173_g51405_i0	PRJNA1061474	51651	246	0.890173	2.18982558	Agathobacter	1766253	Bacteria	Bacteria	420	5.29e-113	NTclustered	gi\|2669501798\|gb\|CP143947.1\|	39491	g51405	i0	100	421.170731707317	227	0	92	20	246	1392798	1392572	Agathobacter rectalis strain DFI.5.28 chromosome, complete genome	blastn	103608	420	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
18030661	18030661	PRJNA1061474_P_NODE_52335_length_245_cov_0.976744_g52089_i0	PRJNA1061474	52335	245	0.976744	2.3930228	Lachnospiraceae bacterium GAM79	2109691	Bacteria	Bacteria	383	6.899999999999998e-102	NTclustered	gi\|2127625274\|gb\|CP085928.1\|	2109691	g52089	i0	97.748	443.191836734694	222	5	91	19	240	819956	819735	Lachnospiraceae bacterium GAM79 strain FDAARGOS_1585 chromosome, complete genome	blastn	108582	383	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium GAM79
18863250	18863250	PRJNA1061474_P_NODE_56335_length_242_cov_0.911243_g56089_i0	PRJNA1061474	56335	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g56089	i0	100	100	242	0	100	1	242	704035	704276	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24200	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21855879	21855879	PRJNA1061474_P_NODE_54598_length_243_cov_2.264706_g54352_i0	PRJNA1061474	54598	243	2.264706	5.50323558	Aerococcus urinaeequi	51665	Bacteria	Bacteria	418	1.8699999999999998e-112	NTclustered	gi\|1919119126\|gb\|CP063065.1\|	51665	g54352	i0	99.563	482.679012345679	229	1	94	15	243	254735	254963	Aerococcus urinaeequi strain T43 chromosome, complete genome	blastn	117291	418	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus urinaeequi

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