metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA222400" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA222400" 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
2331796	2331796	PRJNA222400_P_NODE_2122_length_343_cov_1.408163_g2089_i0	PRJNA222400	2122	343	1.408163	4.82999909	Streptococcus	1301	Bacteria	Bacteria	601	2.57e-167	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2089	i0	99.396	323.081632653061	331	2	97	0	1	331	1570737	1570407	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	110817	606	0.991749174917492	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3607025	3607025	PRJNA222400_P_NODE_5183_length_196_cov_1.544218_g5150_i0	PRJNA222400	5183	196	1.544218	3.02666728	Bacillus	1386	Bacteria	Bacteria	243	9.37e-60	NTclustered	gi\|2509182168\|gb\|CP106987.1\|	1396	g5150	i0	97.872	850.178571428571	141	2	71	1	57	196	1138027	1137887	Bacillus cereus strain IBA1 chromosome, complete genome	blastn	166635	243	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
8709219	8709219	PRJNA222400_P_NODE_1687_length_392_cov_1.253644_g1654_i0	PRJNA222400	1687	392	1.253644	4.91428448	Priestia	2800373	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2780461943\|gb\|CP162497.1\|	1404	g1654	i0	100	0.311224489795918	29	0	7	0	153	181	2411835	2411807	Priestia megaterium strain 10 chromosome, complete genome	blastn	122	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
8709230	8709230	PRJNA222400_P_NODE_3567_length_239_cov_3.505263_g3534_i0	PRJNA222400	3567	239	3.505263	8.37757857	Streptococcus	1301	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|2179899321\|gb\|CP046523.1\|	1303	g3534	i0	100	318	239	0	100	0	1	239	18365	18127	Streptococcus oralis strain SOD chromosome, complete genome	blastn	76002	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9295295	9295295	PRJNA222400_P_NODE_6008_length_183_cov_1.552239_g5975_i0	PRJNA222400	6008	183	1.552239	2.84059737	Secundilactobacillus paracollinoides	240427	Bacteria	Bacteria	80.5	7.15e-11	NTclustered	gi\|1050781558\|gb\|CP014915.1\|	240427	g5975	i0	76.074	14.5956284153005	163	33	87	6	12	171	970733	970574	Secundilactobacillus paracollinoides strain TMW 1.1994 chromosome, complete genome	blastn	2671	80.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Secundilactobacillus	Secundilactobacillus paracollinoides
9295311	9295311	PRJNA222400_P_NODE_6988_length_170_cov_1.636364_g6955_i0	PRJNA222400	6988	170	1.636364	2.7818188	Dysosmobacter sp. Marseille-Q4140	2830675	Bacteria	Bacteria	75	3.03e-9	NTclustered	gi\|2031400201\|gb\|CP073694.1\|	2830675	g6955	i0	92.453	0.311764705882353	53	2	31	2	51	102	2353692	2353743	Dysosmobacter sp. Marseille-Q4140 chromosome	blastn	53	75	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Dysosmobacter	Dysosmobacter sp. Marseille-Q4140
9295312	9295312	PRJNA222400_P_NODE_7128_length_169_cov_1.300000_g7095_i0	PRJNA222400	7128	169	1.3	2.197	Lactobacillus iners	147802	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g7095	i0	100	490.544378698225	168	0	99	0	1	168	3359	3526	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	82902	311	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
16358943	16358943	PRJNA222400_P_NODE_7633_length_167_cov_1.677966_g7600_i0	PRJNA222400	7633	167	1.677966	2.80220322	Bacteria	2	Bacteria	Bacteria	217	4.69e-52	NTclustered	gi\|1147724948\|gb\|KY622910.1\|	1290	g7600	i0	99.174	103.245508982036	121	0	100	1	48	167	246	126	Staphylococcus hominis strain OA313 16S ribosomal RNA gene, partial sequence	blastn	17242	219	0.990867579908676	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
18218874	18218874	PRJNA222400_P_NODE_495_length_725_cov_3.152367_g466_i0	PRJNA222400	495	725	3.152367	22.85466075	Bacillus mycoides	1405	Bacteria	Bacteria	60.2	4.34e-4	NTclustered	gi\|2049754127\|gb\|CP036116.1\|	1405	g466	i0	100	0.437241379310345	32	0	4	0	578	609	74362	74393	Bacillus mycoides strain JAS481 plasmid p124	blastn	317	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
18218917	18218917	PRJNA222400_P_NODE_8635_length_164_cov_1.304348_g8602_i0	PRJNA222400	8635	164	1.304348	2.13913072	Ezakiella coagulans	46507	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g8602	i0	100	294.865853658537	164	0	100	0	1	164	160660	160497	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	48358	303	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
18218924	18218924	PRJNA222400_P_NODE_9535_length_156_cov_2.261682_g9502_i0	PRJNA222400	9535	156	2.261682	3.52822392	Lactobacillus iners	147802	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g9502	i0	100	560.019230769231	156	0	100	0	1	156	3002	2847	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	87363	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners

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