metadata: contig_metadata: 10 rows where bioproject = "PRJNA1168532" and tax

10 rows where bioproject = "PRJNA1168532" 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
1040232	1040232	PRJNA1168532_S_NODE_226421_length_203_cov_1.762500_g223478_i0	PRJNA1168532	226421	203	1.7625	3.577875	root	1	Root_unresolved	Root_unresolved	375	9.24e-100	NTclustered	gi\|2497259144\|gb\|OQ874907.1\|	1306	g223478	i0	100	100	203	0	100	0	1	203	498	296	Streptococcus sp. strain QT-53 16S ribosomal RNA gene, partial sequence	blastn	20300	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
5418264	5418264	PRJNA1168532_S_NODE_295985_length_170_cov_1.645669_g293042_i0	PRJNA1168532	295985	170	1.645669	2.7976373	Staphylococcus auricularis	29379	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g293042	i0	100	495.6	170	0	100	0	1	170	1486561	1486730	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	84252	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
5418288	5418288	PRJNA1168532_S_NODE_9285_length_801_cov_2.121372_g7745_i0	PRJNA1168532	9285	801	2.121372	16.99218972	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	143	2.87e-39	NR	POH17992.1	1625	g7745	i0	60.3	0.49063670411985	131	52	49.1	0	102	494	1	131	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	393	143	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
6143095	6143095	PRJNA1168532_S_NODE_221685_length_206_cov_1.159509_g218742_i0	PRJNA1168532	221685	206	1.159509	2.38858854	root	1	Root_unresolved	Root_unresolved	241	3.5800000000000007e-59	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g218742	i0	100	69.8155339805825	130	0	100	0	1	130	1185	1314	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	14382	241	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7418092	7418092	PRJNA1168532_S_NODE_242326_length_194_cov_2.337748_g239383_i0	PRJNA1168532	242326	194	2.337748	4.53523112	Streptococcus	1301	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g239383	i0	99.485	428.329896907216	194	1	100	0	1	194	424105	424298	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	83096	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8693201	8693201	PRJNA1168532_S_NODE_288207_length_173_cov_1.446154_g285264_i0	PRJNA1168532	288207	173	1.446154	2.50184642	root	1	Root_unresolved	Root_unresolved	309	7.81e-80	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g285264	i0	98.844	97.9479768786127	173	2	100	0	1	173	259	87	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	16945	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11243535	11243535	PRJNA1168532_S_NODE_250889_length_190_cov_1.102041_g247946_i0	PRJNA1168532	250889	190	1.102041	2.0938779	Staphylococcus	1279	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g247946	i0	100	84.2473684210526	190	0	100	0	1	190	2002019	2001830	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	16007	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
16342763	16342763	PRJNA1168532_S_NODE_55373_length_409_cov_1.568306_g52501_i0	PRJNA1168532	55373	409	1.568306	6.41437154	Bacillati	1783272	Bacteria	Bacteria	715	0	NTclustered	gi\|9623518\|gb\|AF269622.1\|AF269622	1282	g52501	i0	98.997	505.672371638142	399	4	98	0	11	409	3766	3368	Staphylococcus epidermidis strain SR1 clone step.1014c03 genomic sequence	blastn	206820	715	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20166591	20166591	PRJNA1168532_S_NODE_226536_length_203_cov_1.625000_g223593_i0	PRJNA1168532	226536	203	1.625	3.29875	Staphylococcus	1279	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g223593	i0	100	545.768472906404	203	0	100	0	1	203	699770	699972	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	110791	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
28146170	28146170	PRJNA1168532_S_NODE_232565_length_200_cov_0.885350_g229622_i0	PRJNA1168532	232565	200	0.88535	1.7707	Staphylococcus aureus	1280	Bacteria	Bacteria	54.7	1.26e-6	NR	QHG80002.1	1280	g229622	i0	50	1.02	68	28	99	3	198	1	297	360	QHG80002.1 hypothetical protein D7B62_12520 [Staphylococcus aureus]	diamond	204	54.7	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);;