metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA397733" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA397733" and tax_kingdom = "Bacillati"

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
27281864	27281864	PRJNA397733_S_NODE_14443_length_161_cov_2.946970_g14355_i0	PRJNA397733	14443	161	2.94697	4.7446217	root	1	Root_unresolved	Root_unresolved	114	1.5599999999999998e-31	NR	WP_407812873.1	1280	g14355	i0	98.1	119.496894409938	53	1	98.8	0	159	1	9	61	WP_407812873.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	19239	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27850074	27850074	PRJNA397733_S_NODE_5144_length_267_cov_26.327731_g5056_i0	PRJNA397733	5144	267	26.327731	70.29504177	root	1	Root_unresolved	Root_unresolved	173	9.44e-54	NR	MDK0657390.1	1502	g5056	i0	98.9	75.2696629213483	87	1	97.8	0	267	7	25	111	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	20097	174	0.994252873563218	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
28370199	28370199	PRJNA397733_S_NODE_14726_length_160_cov_2.099237_g14638_i0	PRJNA397733	14726	160	2.099237	3.3587792	Oscillospiraceae	216572	Bacteria	Bacteria	40.4	0.0345	NR	WP_240286090.1	216572	g14638	i0	33.3	0.61875	33	22	61.9	0	100	2	55	87	WP_240286090.1 MULTISPECIES: hypothetical protein [Oscillospiraceae]	diamond	99	40.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae
28401809	28401809	PRJNA397733_S_NODE_4546_length_286_cov_4.097276_g4458_i0	PRJNA397733	4546	286	4.097276	11.71820936	Streptomyces sp. Act143	2200760	Bacteria	Bacteria	45.8	0.00326	NR	WP_146238297.1	2200760	g4458	i0	47.9	1.00699300699301	48	24	49.3	1	209	69	112	159	WP_146238297.1 VanZ family protein [Streptomyces sp. Act143]	diamond	288	45.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Act143
28671259	28671259	PRJNA397733_S_NODE_11607_length_178_cov_2.463087_g11519_i0	PRJNA397733	11607	178	2.463087	4.38429486	Rhodococcus	1827	Bacteria	Bacteria	43.5	0.00141	NR	WP_172682059.1	1833	g11519	i0	48.4	1.56741573033708	31	16	52.2	0	34	126	6	36	WP_172682059.1 hypothetical protein [Rhodococcus erythropolis]	diamond	279	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
31466041	31466041	PRJNA397733_S_NODE_3176_length_347_cov_134.204403_g3088_i0	PRJNA397733	3176	347	134.204403	465.68927841	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	124	1.29e-34	NR	WP_222114562.1	283734	g3088	i0	98.8	1.45244956772334	84	1	72.6	0	71	322	1	84	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	504	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
31482856	31482856	PRJNA397733_S_NODE_8916_length_201_cov_6.000000_g8828_i0	PRJNA397733	8916	201	6	12.06	root	1	Root_unresolved	Root_unresolved	128	5.969999999999999e-37	NR	MDN8740502.1	1280	g8828	i0	98.4	63.0597014925373	64	1	95.5	0	200	9	14	77	MDN8740502.1 Hsp70 family protein [Staphylococcus aureus]	diamond	12675	129	0.992248062015504	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32003669	32003669	PRJNA397733_S_NODE_10058_length_190_cov_2.919255_g9970_i0	PRJNA397733	10058	190	2.919255	5.5465845	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	42.4	0.00797	NR	MEX1005472.1	2080302	g9970	i0	48.6	0.552631578947368	35	18	55.3	0	1	105	72	106	MEX1005472.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	105	42.4	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
32066789	32066789	PRJNA397733_S_NODE_13058_length_168_cov_14.762590_g12970_i0	PRJNA397733	13058	168	14.76259	24.8011512	Anaerolineales bacterium	2073117	Bacteria	Bacteria	41.6	0.0334	NR	HET9588558.1	2073117	g12970	i0	51.4	0.660714285714286	37	18	66.1	0	148	38	139	175	HET9588558.1 ABC-2 family transporter protein [Anaerolineales bacterium]	diamond	111	41.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32130358	32130358	PRJNA397733_S_NODE_558_length_1172_cov_6.906387_g526_i0	PRJNA397733	558	1172	6.906387	80.94285564	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	49.3	0.0236	NR	HEX6595847.1	2201156	g526	i0	54.4	0.145904436860068	57	23	14.6	2	528	358	29	82	HEX6595847.1 YncE family protein [Acidimicrobiales bacterium]	diamond	171	49.3	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
32368662	32368662	PRJNA397733_S_NODE_10859_length_183_cov_5.045455_g10771_i0	PRJNA397733	10859	183	5.045455	9.23318265	root	1	Root_unresolved	Root_unresolved	113	2.5299999999999993e-31	NR	MBG9491866.1	1428	g10771	i0	96.7	62.9508196721311	60	2	98.4	0	182	3	13	72	MBG9491866.1 hypothetical protein [Bacillus thuringiensis]	diamond	11520	113	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
32383295	32383295	PRJNA397733_S_NODE_7179_length_226_cov_2.289340_g7091_i0	PRJNA397733	7179	226	2.28934	5.1739084	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	42.7	0.0287	NR	HEY2917091.1	2952938	g7091	i0	50	0.557522123893805	42	21	55.8	0	224	99	154	195	HEY2917091.1 nucleotide sugar dehydrogenase [Candidatus Limnocylindrales bacterium]	diamond	126	42.7	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
32825029	32825029	PRJNA397733_S_NODE_14260_length_162_cov_2.691729_g14172_i0	PRJNA397733	14260	162	2.691729	4.36060098	Rhodococcus sp. BS-15	1304954	Bacteria	Bacteria	41.6	0.0208	NR	WP_145977668.1	1304954	g14172	i0	45	0.740740740740741	40	21	74.1	1	157	38	28	66	WP_145977668.1 prepilin peptidase, partial [Rhodococcus sp. BS-15]	diamond	120	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. BS-15
32856406	32856406	PRJNA397733_S_NODE_7300_length_224_cov_2.471795_g7212_i0	PRJNA397733	7300	224	2.471795	5.5368208	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0285	NR	MBQ2512842.1	2044939	g7212	i0	52.9	0.455357142857143	34	14	45.5	1	33	134	204	235	MBQ2512842.1 amidohydrolase family protein [Clostridia bacterium]	diamond	102	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia 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);;