metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax

12 rows where analysis = "blastn", bioproject = "PRJEB43370" 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
2610140	2610140	PRJEB43370_P_NODE_5423_length_195_cov_1.369863_g5380_i0	PRJEB43370	5423	195	1.369863	2.67123285	Ligilactobacillus salivarius	1624	Bacteria	Bacteria	159	9.65e-35	NTclustered	gi\|2246265477\|gb\|CP097639.1\|	1624	g5380	i0	85.256	63.974358974359	156	21	79	2	40	194	629769	629923	Ligilactobacillus salivarius strain S01 chromosome, complete genome	blastn	12475	159	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
12813707	12813707	PRJEB43370_P_NODE_3731_length_228_cov_1.452514_g3688_i0	PRJEB43370	3731	228	1.452514	3.31173192	Clostridium carboxidivorans	217159	Bacteria	Bacteria	111	3.31e-20	NTclustered	gi\|848258874\|gb\|CP011803.1\|	536227	g3688	i0	84.348	1.83333333333333	115	16	50	2	26	139	5092042	5091929	Clostridium carboxidivorans P7, complete genome	blastn	418	111	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium carboxidivorans
15017759	15017759	PRJEB43370_P_NODE_3232_length_243_cov_0.876289_g3189_i0	PRJEB43370	3232	243	0.876289	2.12938227	root	1	Root_unresolved	Root_unresolved	449	6.65e-122	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g3189	i0	100	99.522633744856	243	0	100	0	1	243	2753771	2753529	Staphylococcus aureus strain WH3018 chromosome	blastn	24184	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15362433	15362433	PRJEB43370_P_NODE_7373_length_169_cov_1.300000_g7330_i0	PRJEB43370	7373	169	1.3	2.197	Candidatus Sarcina troglodytae	2726954	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1938574842\|gb\|CP051754.1\|	2726954	g7330	i0	80.795	4.31952662721894	151	27	89	2	15	164	287670	287521	Sarcina sp. JB2 chromosome, complete genome	blastn	730	117	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Sarcina	Candidatus Sarcina troglodytae
15362438	15362438	PRJEB43370_P_NODE_8413_length_167_cov_0.881356_g8370_i0	PRJEB43370	8413	167	0.881356	1.47186452	Companilactobacillus ginsenosidimutans	1007676	Bacteria	Bacteria	159	8.02e-35	NTclustered	gi\|873923078\|gb\|CP012034.1\|	1007676	g8370	i0	84.568	3.18562874251497	162	23	96	2	7	167	1412338	1412178	Companilactobacillus ginsenosidimutans strain EMML 3041 chromosome, complete genome	blastn	532	159	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus ginsenosidimutans
16637006	16637006	PRJEB43370_P_NODE_5054_length_201_cov_1.368421_g5011_i0	PRJEB43370	5054	201	1.368421	2.75052621	Clostridium intestinale	36845	Bacteria	Bacteria	132	2.18e-26	NTclustered	gi\|1880427247\|gb\|CP059378.1\|	36845	g5011	i0	83.333	66.0497512437811	144	22	71	2	59	201	1113462	1113604	Clostridium intestinale strain Lx1 chromosome, complete genome	blastn	13276	132	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
17567736	17567736	PRJEB43370_P_NODE_1394_length_368_cov_2.576803_g1351_i0	PRJEB43370	1394	368	2.576803	9.48263504	Turicibacter	191303	Bacteria	Bacteria	292	1.89e-74	NTclustered	gi\|984737891\|gb\|CP013476.1\|	1712675	g1351	i0	81.843	752.304347826087	369	48	98	14	7	368	954890	955246	Turicibacter sp. H121 chromosome, complete genome	blastn	276848	292	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sp. H121
18841618	18841618	PRJEB43370_P_NODE_6335_length_182_cov_1.563910_g6292_i0	PRJEB43370	6335	182	1.56391	2.8463162	Lactiplantibacillus	2767842	Bacteria	Bacteria	73.1	1.19e-8	NTclustered	gi\|2788798707\|gb\|CP166731.1\|	1590	g6292	i0	90.741	29.456043956044	54	5	30	0	107	160	1687523	1687576	Lactiplantibacillus plantarum strain HD02 chromosome, complete genome	blastn	5361	73.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
22666827	22666827	PRJEB43370_P_NODE_5998_length_187_cov_0.891304_g5955_i0	PRJEB43370	5998	187	0.891304	1.66673848	Metabacillus	2675233	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|1891105402\|gb\|CP055263.1\|	2745198	g5955	i0	95	0.427807486631016	40	2	21	0	141	180	946174	946135	Metabacillus sp. KUDC1714 chromosome, complete genome	blastn	80	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus elymi
22666829	22666829	PRJEB43370_P_NODE_6638_length_178_cov_1.503876_g6595_i0	PRJEB43370	6638	178	1.503876	2.67689928	Staphylococcaceae	90964	Bacteria	Bacteria	121	4.0699999999999996e-23	NTclustered	gi\|2073000562\|gb\|CP079109.1\|	489910	g6595	i0	79.444	191.522471910112	180	30	99	7	1	176	208442	208618	Nosocomiicoccus ampullae strain 19-00310 chromosome, complete genome	blastn	34091	122	0.991803278688525	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Nosocomiicoccus	Nosocomiicoccus ampullae
23942248	23942248	PRJEB43370_P_NODE_2159_length_295_cov_1.991870_g2116_i0	PRJEB43370	2159	295	1.99187	5.8760165	Exiguobacterium	33986	Bacteria	Bacteria	427	3.8899999999999996e-115	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g2116	i0	93.127	799.566101694915	291	20	99	0	1	291	14250	13960	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	235872	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
25216049	25216049	PRJEB43370_P_NODE_7060_length_172_cov_4.219512_g7017_i0	PRJEB43370	7060	172	4.219512	7.25756064	root	1	Root_unresolved	Root_unresolved	318	1.2899999999999999e-82	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g7017	i0	100	59.8372093023256	172	0	100	0	1	172	2682517	2682346	Staphylococcus aureus strain WH3018 chromosome	blastn	10292	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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