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

9 rows where analysis = "blastn", bioproject = "PRJNA915212" 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
3446049	3446049	PRJNA915212_P_NODE_7743_length_210_cov_0.950311_g7705_i0	PRJNA915212	7743	210	0.950311	1.9956531	Clostridium botulinum	1491	Bacteria	Bacteria	58.4	3.96e-4	NTclustered	gi\|2331077869\|dbj\|AP025140.1\|	1491	g7705	i0	97.059	0.161904761904762	34	1	16	0	79	112	2996489	2996522	Clostridium botulinum Osaka2020 DNA, complete genome	blastn	34	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
3446058	3446058	PRJNA915212_P_NODE_9243_length_191_cov_1.246479_g9205_i0	PRJNA915212	9243	191	1.246479	2.38077489	Halothermothrix orenii	31909	Bacteria	Bacteria	143	9.479999999999999e-30	NTclustered	gi\|219992160\|gb\|CP001098.1\|	373903	g9205	i0	83.019	20.7643979057592	159	25	83	2	11	168	1689024	1689181	Halothermothrix orenii H 168, complete genome	blastn	3966	143	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halothermotrichaceae	Halothermothrix	Halothermothrix orenii
4723643	4723643	PRJNA915212_P_NODE_12664_length_165_cov_1.310345_g12626_i0	PRJNA915212	12664	165	1.310345	2.16206925	Selenomonas sp.	2053611	Bacteria	Bacteria	124	2.88e-24	NTclustered	gi\|2913850746\|gb\|CP181254.1\|	2053611	g12626	i0	80.488	85.3090909090909	164	30	99	2	1	163	309614	309776	MAG: Selenomonas sp. isolate UW_FK_SELE1_1 chromosome	blastn	14076	124	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp.
8903878	8903878	PRJNA915212_P_NODE_6667_length_227_cov_0.859551_g6629_i0	PRJNA915212	6667	227	0.859551	1.95118077	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|2513827645\|gb\|CP126446.1\|	265426	g6629	i0	96.875	0.295154185022026	32	1	14	0	191	222	3462833	3462802	Pontibacillus chungwhensis strain HN14 chromosome, complete genome	blastn	67	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus chungwhensis
12374253	12374253	PRJNA915212_P_NODE_13210_length_164_cov_0.886957_g13172_i0	PRJNA915212	13210	164	0.886957	1.45460948	Paenibacillus sp. RC67	3039392	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2506068966\|gb\|CP125098.1\|	3039392	g13172	i0	100	0.170731707317073	28	0	17	0	18	45	287401	287428	Paenibacillus sp. RC67 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. RC67
16197988	16197988	PRJNA915212_P_NODE_11313_length_170_cov_1.264463_g11275_i0	PRJNA915212	11313	170	1.264463	2.1495871	Terribacillus sp. FSL K6-0262	2921447	Bacteria	Bacteria	159	8.139999999999998e-35	NTclustered	gi\|2709996983\|gb\|CP150277.1\|	2921447	g11275	i0	85.621	163.458823529412	153	20	89	2	1	152	1537701	1537852	Terribacillus sp. FSL K6-0262 chromosome, complete genome	blastn	27788	159	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Terribacillus	Terribacillus sp. FSL K6-0262
16198083	16198083	PRJNA915212_P_NODE_7073_length_220_cov_1.157895_g7035_i0	PRJNA915212	7073	220	1.157895	2.547369	Lactococcus garvieae	1363	Bacteria	Bacteria	60.2	1.16e-4	NTclustered	gi\|2706013729\|gb\|CP141717.1\|	1363	g7035	i0	100	0.145454545454545	32	0	15	0	109	140	112206	112237	Lactococcus garvieae strain R22-8 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
16553518	16553518	PRJNA915212_P_NODE_10273_length_180_cov_1.809160_g10235_i0	PRJNA915212	10273	180	1.80916	3.256488	root	1	Root_unresolved	Root_unresolved	69.4	1.52e-7	NTclustered	gi\|2049644612\|gb\|CP036059.1\|	1405	g10235	i0	82.143	8.47777777777778	84	12	45	2	17	97	53685	53768	Bacillus mycoides strain JAS06/1 plasmid p88	blastn	1526	69.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
23847461	23847461	PRJNA915212_P_NODE_9419_length_189_cov_1.450000_g9381_i0	PRJNA915212	9419	189	1.45	2.7405	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2581474101\|gb\|CP134769.1\|	1590	g9381	i0	92.308	0.354497354497354	39	3	21	0	90	128	882489	882451	Lactiplantibacillus plantarum strain SYBC-SM2 chromosome, complete genome	blastn	67	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum

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