metadata: contig_metadata: 11 rows where bioproject = "PRJNA886442", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA886442", tax_kingdom = "Bacillati" 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
3412712	3412712	PRJNA886442_P_NODE_4343_length_357_cov_1.478873_g4179_i0	PRJNA886442	4343	357	1.478873	5.27957661	Clostridium intestinale	36845	Bacteria	Bacteria	654	0	NTclustered	gi\|1880427247\|gb\|CP059378.1\|	36845	g4179	i0	99.72	914.703081232493	357	1	100	0	1	357	233305	233661	Clostridium intestinale strain Lx1 chromosome, complete genome	blastn	326549	654	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
6345489	6345489	PRJNA886442_P_NODE_4245_length_360_cov_1.616725_g4081_i0	PRJNA886442	4245	360	1.616725	5.82021	Lacticaseibacillus	2759736	Bacteria	Bacteria	660	0	NTclustered	gi\|449330456\|gb\|KC161263.1\|	1582	g4081	i0	99.722	472	360	1	100	0	1	360	429	70	Lactobacillus casei strain 431 23S ribosomal RNA gene, partial sequence	blastn	169920	660	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus casei
7619462	7619462	PRJNA886442_P_NODE_10846_length_252_cov_0.871508_g10682_i0	PRJNA886442	10846	252	0.871508	2.19620016	Staphylococcus	1279	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g10682	i0	100	521.007936507937	252	0	100	0	1	252	783293	783544	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	131294	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
11065397	11065397	PRJNA886442_P_NODE_12269_length_248_cov_1.588571_g12105_i0	PRJNA886442	12269	248	1.588571	3.93965608	Novisyntrophococcus fermenticellae	2068655	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|2052596054\|gb\|CP076458.1\|	2068655	g12105	i0	90.323	428.020161290323	248	24	100	0	1	248	654265	654512	Novisyntrophococcus fermenticellae strain JN500902 chromosome, complete genome	blastn	106149	326	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Novisyntrophococcus	Novisyntrophococcus fermenticellae
13615456	13615456	PRJNA886442_P_NODE_12051_length_249_cov_0.886364_g11887_i0	PRJNA886442	12051	249	0.886364	2.20704636	Thermicanus aegyptius	94009	Bacteria	Bacteria	163	4.5499999999999995e-45	NR	WP_005583113.1	94009	g11887	i0	95.2	1.98795180722892	83	4	100	0	1	249	470	552	WP_005583113.1 ATP-dependent zinc metalloprotease FtsH [Thermicanus aegyptius]	diamond	495	163	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
13995373	13995373	PRJNA886442_P_NODE_7791_length_285_cov_2.363208_g7627_i0	PRJNA886442	7791	285	2.363208	6.7351428	Aeribacillus	1055323	Bacteria	Bacteria	279	1.11e-70	NTclustered	gi\|1229099743\|gb\|CP017703.1\|	33936	g7627	i0	85.985	733.315789473684	264	33	92	4	24	285	525613	525352	Aeribacillus pallidus strain KCTC3564 chromosome, complete genome	blastn	208995	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Aeribacillus	Aeribacillus pallidus
23814015	23814015	PRJNA886442_P_NODE_10379_length_253_cov_0.866667_g10215_i0	PRJNA886442	10379	253	0.866667	2.19266751	Paraclostridium bifermentans	1490	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2091226359\|gb\|CP079737.1\|	1490	g10215	i0	96.774	0.367588932806324	31	1	12	0	116	146	1822537	1822507	Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome	blastn	93	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
25468113	25468113	PRJNA886442_P_NODE_11420_length_250_cov_1.887006_g11256_i0	PRJNA886442	11420	250	1.887006	4.717515	Ethanoligenens	253238	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|470487490\|ref\|NR_076821.1\|	253239	g11256	i0	97.2	295.164	250	7	100	0	1	250	1705	1456	Ethanoligenens harbinense strain YUAN-3 23S ribosomal RNA gene, complete sequence	blastn	73791	424	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ethanoligenens	Ethanoligenens harbinense
29108208	29108208	PRJNA886442_P_NODE_2848_length_420_cov_1.573487_g2684_i0	PRJNA886442	2848	420	1.573487	6.6086454	Hydrogenibacillus schlegelii	1484	Bacteria	Bacteria	46.6	0.0108	NR	WP_273000906.1	1484	g2684	i0	48.1	0.771428571428571	54	17	38.6	2	6	167	160	202	WP_273000906.1 bifunctional metallophosphatase/5'-nucleotidase, partial [Hydrogenibacillus schlegelii]	diamond	324	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Hydrogenibacillus	Hydrogenibacillus schlegelii
31604136	31604136	PRJNA886442_P_NODE_7776_length_286_cov_1.098592_g7612_i0	PRJNA886442	7776	286	1.098592	3.14197312	Bacillota bacterium	1879010	Bacteria	Bacteria	56.6	8.41e-8	NR	HOJ49100.1	1879010	g7612	i0	51.7	1.81468531468531	58	28	60.8	0	5	178	54	111	HOJ49100.1 hypothetical protein [Bacillota bacterium]	diamond	519	56.6	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31983598	31983598	PRJNA886442_P_NODE_6438_length_308_cov_1.327660_g6274_i0	PRJNA886442	6438	308	1.32766	4.0891928	Bacillota bacterium	1879010	Bacteria	Bacteria	62	1.62e-9	NR	MBI2914668.1	1879010	g6274	i0	37.6	0.905844155844156	93	55	90.6	1	295	17	55	144	MBI2914668.1 LysM peptidoglycan-binding domain-containing protein [Bacillota bacterium]	diamond	279	62	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium

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