metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA393181" 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
2353916	2353916	PRJNA393181_S_NODE_32202_length_195_cov_3.113924_g32096_i0	PRJNA393181	32202	195	3.113924	6.0721518	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g32096	i0	100	100.097435897436	195	0	100	0	1	195	2742151	2741957	Staphylococcus aureus strain WH3018 chromosome	blastn	19519	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4906584	4906584	PRJNA393181_S_NODE_39144_length_171_cov_10.343284_g39038_i0	PRJNA393181	39144	171	10.343284	17.68701564	root	1	Root_unresolved	Root_unresolved	296	5.99e-76	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g39038	i0	100	95.1695906432749	160	0	94	0	1	160	2463677	2463836	Staphylococcus aureus strain WH9628 chromosome	blastn	16274	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4906588	4906588	PRJNA393181_S_NODE_39484_length_170_cov_3.827068_g39378_i0	PRJNA393181	39484	170	3.827068	6.5060156	Bacteria	2	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2240231723\|gb\|CP097282.1\|	292800	g39378	i0	100	16.6941176470588	30	0	19	0	18	47	134773	134802	Flavonifractor plautii strain NB2A-20-GAM chromosome	blastn	2838	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
9338626	9338626	PRJNA393181_S_NODE_29848_length_205_cov_3.458333_g29742_i0	PRJNA393181	29848	205	3.458333	7.08958265	Caldinitratiruptor microaerophilus	671077	Bacteria	Bacteria	99	2.27e-16	NTclustered	gi\|2317219343\|dbj\|AP025628.1\|	671077	g29742	i0	81.301	0.770731707317073	123	21	60	2	49	170	1063266	1063145	Caldinitratiruptor microaerophilus JCM 16183 DNA, complete genome	blastn	158	99	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae	Caldinitratiruptor	Caldinitratiruptor microaerophilus
10006738	10006738	PRJNA393181_S_NODE_43468_length_160_cov_1.569106_g43362_i0	PRJNA393181	43468	160	1.569106	2.5105696	Blautia	572511	Bacteria	Bacteria	239	9.49e-59	NTclustered	gi\|2884834591\|gb\|CP176627.1\|	40520	g43362	i0	93.711	74.2	159	10	99	0	2	160	2578	2736	Blautia obeum strain SFAD70 chromosome, complete genome	blastn	11872	239	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia obeum
10614604	10614604	PRJNA393181_S_NODE_40269_length_168_cov_2.549618_g40163_i0	PRJNA393181	40269	168	2.549618	4.28335824	Flavonifractor plautii	292800	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1173509597\|gb\|CP015406.2\|	292800	g40163	i0	94.286	2.25595238095238	35	2	21	0	35	69	3497001	3497035	Flavonifractor plautii strain YL31 chromosome, complete genome	blastn	379	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
11889913	11889913	PRJNA393181_S_NODE_9230_length_396_cov_3.905292_g9124_i0	PRJNA393181	9230	396	3.905292	15.46495632	Catenibacterium sp. co_0103	2478954	Bacteria	Bacteria	708	0	NTclustered	gi\|1997760561\|emb\|LR994472.1\|	2478954	g9124	i0	99.486	230.335858585859	389	2	98	0	3	391	681501	681113	Catenibacterium sp. co_0103 isolate Catenibacterium canine HQ MAG genome assembly, chromosome: 1	blastn	91213	708	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium sp. co_0103
12557357	12557357	PRJNA393181_S_NODE_47190_length_151_cov_2.350877_g47084_i0	PRJNA393181	47190	151	2.350877	3.54982427	Catenibacterium	135858	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2299336055\|gb\|CP102271.1\|	100886	g47084	i0	100	201.635761589404	151	0	100	0	1	151	143284	143434	Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome	blastn	30447	279	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium mitsuokai
15713186	15713186	PRJNA393181_S_NODE_29533_length_207_cov_2.047059_g29427_i0	PRJNA393181	29533	207	2.047059	4.23741213	Acetilactobacillus jinshanensis	1720083	Bacteria	Bacteria	58.4	3.89e-4	NTclustered	gi\|2833683980\|gb\|CP171343.1\|	1720083	g29427	i0	100	0.285024154589372	31	0	15	0	42	72	534297	534267	MAG: Acetilactobacillus jinshanensis isolate AJITA chromosome	blastn	59	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Acetilactobacillus	Acetilactobacillus jinshanensis
15713429	15713429	PRJNA393181_S_NODE_39673_length_170_cov_1.759398_g39567_i0	PRJNA393181	39673	170	1.759398	2.9909766	Catenibacterium sp. co_0103	2478954	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1997760561\|emb\|LR994472.1\|	2478954	g39567	i0	100	70.2529411764706	170	0	100	0	1	170	142453	142284	Catenibacterium sp. co_0103 isolate Catenibacterium canine HQ MAG genome assembly, chromosome: 1	blastn	11943	315	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium sp. co_0103
16987640	16987640	PRJNA393181_S_NODE_17514_length_284_cov_2.761134_g17408_i0	PRJNA393181	17514	284	2.761134	7.84162056	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2621704007\|emb\|OY762962.1\|	2054177	g17408	i0	100	0.0985915492957746	28	0	10	0	91	118	2006332	2006359	MAG: Christensenellaceae bacterium isolate 71fbd196-4d72-4d9d-b023-dc0a1f92e7b0 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
17656042	17656042	PRJNA393181_S_NODE_25834_length_225_cov_2.037234_g25728_i0	PRJNA393181	25834	225	2.037234	4.5837765	Bacteria	2	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2240231723\|gb\|CP097282.1\|	292800	g25728	i0	100	2.24	28	0	12	0	1	28	507712	507739	Flavonifractor plautii strain NB2A-20-GAM chromosome	blastn	504	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
18261631	18261631	PRJNA393181_S_NODE_11355_length_358_cov_2.373832_g11249_i0	PRJNA393181	11355	358	2.373832	8.49831856	Cytobacillus gottheilii	859144	Bacteria	Bacteria	63.9	1.57e-5	NTclustered	gi\|2046389985\|gb\|CP071709.1\|	859144	g11249	i0	95	0.268156424581006	40	2	11	0	97	136	2831017	2830978	Cytobacillus gottheilii strain 1839 chromosome, complete genome	blastn	96	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus gottheilii
20204738	20204738	PRJNA393181_S_NODE_37856_length_175_cov_3.086957_g37750_i0	PRJNA393181	37856	175	3.086957	5.40217475	Blautia	572511	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2884834591\|gb\|CP176627.1\|	40520	g37750	i0	98.857	429.885714285714	175	2	100	0	1	175	2199026	2198852	Blautia obeum strain SFAD70 chromosome, complete genome	blastn	75230	313	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia obeum
22087112	22087112	PRJNA393181_S_NODE_35538_length_183_cov_2.061644_g35432_i0	PRJNA393181	35538	183	2.061644	3.77280852	Paenibacillus albicereus	2726185	Bacteria	Bacteria	152	1.49e-32	NTclustered	gi\|1833310551\|gb\|CP051428.1\|	2726185	g35432	i0	84.375	73.1639344262295	160	19	86	6	12	168	539955	539799	Paenibacillus albicereus strain UniB2 chromosome, complete genome	blastn	13389	152	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus albicereus

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