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

15 rows where analysis = "blastn", bioproject = "PRJNA543299" 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
509603	509603	PRJNA543299_P_NODE_18341_length_175_cov_2.142857_g18184_i0	PRJNA543299	18341	175	2.142857	3.74999975	Clostridium disporicum	84024	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|333830419\|gb\|HM245956.1\|	84024	g18184	i0	98.857	883.068571428571	175	2	100	0	1	175	130	304	Clostridium disporicum strain DSM 5521 23S ribosomal RNA gene, partial sequence	blastn	154537	313	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium disporicum
1118532	1118532	PRJNA543299_P_NODE_10241_length_233_cov_0.880435_g10084_i0	PRJNA543299	10241	233	0.880435	2.05141355	Clostridium	1485	Bacteria	Bacteria	342	1.0999999999999999e-89	NTclustered	gi\|2869643049\|gb\|CP175543.1\|	1502	g10084	i0	93.506	904.922746781116	231	13	99	1	3	233	211405	211633	Clostridium perfringens strain GZ-3 chromosome, complete genome	blastn	210847	344	0.994186046511628	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
3060664	3060664	PRJNA543299_P_NODE_6023_length_299_cov_1.164000_g5867_i0	PRJNA543299	6023	299	1.164	3.48036	Lysinibacillus fusiformis	28031	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2451318646\|gb\|CP118714.1\|	28031	g5867	i0	100	0.678929765886288	29	0	10	0	213	241	780646	780618	Lysinibacillus fusiformis strain G5.M11b chromosome, complete genome	blastn	203	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus fusiformis
3669943	3669943	PRJNA543299_P_NODE_13743_length_202_cov_1.313725_g13586_i0	PRJNA543299	13743	202	1.313725	2.6537245	Clostridium	1485	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|358250948\|gb\|JN834642.1\|	59620	g13586	i0	100	125.925742574257	202	0	100	0	1	202	225	24	Uncultured Clostridium sp. clone 386E14TEAT 16S ribosomal RNA gene, partial sequence	blastn	25437	374	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
6222261	6222261	PRJNA543299_P_NODE_7625_length_268_cov_1.461187_g7468_i0	PRJNA543299	7625	268	1.461187	3.91598116	Staphylococcus	1279	Bacteria	Bacteria	490	4.39e-134	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g7468	i0	99.627	515.925373134328	268	1	100	0	1	268	383	116	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	138268	490	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
7496787	7496787	PRJNA543299_P_NODE_24406_length_163_cov_0.894737_g24249_i0	PRJNA543299	24406	163	0.894737	1.45842131	Staphylococcus	1279	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g24249	i0	100	99.8711656441718	163	0	100	0	1	163	1558372	1558534	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	16279	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
8771663	8771663	PRJNA543299_P_NODE_3887_length_367_cov_0.874214_g3732_i0	PRJNA543299	3887	367	0.874214	3.20836538	Bacteria	2	Bacteria	Bacteria	667	0	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g3732	i0	99.455	106.615803814714	367	2	100	0	1	367	979	1345	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	39128	673	0.991084695393759	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
8771664	8771664	PRJNA543299_P_NODE_4527_length_342_cov_1.982935_g4372_i0	PRJNA543299	4527	342	1.982935	6.7816377	Staphylococcus	1279	Bacteria	Bacteria	604	1.979999999999999e-168	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g4372	i0	98.538	525.014619883041	342	5	100	0	1	342	2028	2369	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	179555	610	0.99016393442623	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
12597656	12597656	PRJNA543299_P_NODE_8590_length_253_cov_2.941176_g8433_i0	PRJNA543299	8590	253	2.941176	7.44117528	Streptococcus	1301	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1578069334\|emb\|LR216032.1\|	1313	g8433	i0	100	322	253	0	100	0	1	253	23246	23498	Streptococcus pneumoniae strain 2245STDY5775874 genome assembly, chromosome: 1	blastn	81466	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
13872502	13872502	PRJNA543299_P_NODE_14751_length_195_cov_2.671233_g14594_i0	PRJNA543299	14751	195	2.671233	5.20890435	Staphylococcus	1279	Bacteria	Bacteria	353	4.12e-93	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g14594	i0	99.487	516.989743589744	195	0	100	1	1	195	1488	1295	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	100813	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
17696579	17696579	PRJNA543299_P_NODE_15614_length_190_cov_1.085106_g15457_i0	PRJNA543299	15614	190	1.085106	2.0617014	Bacillales	1385	Bacteria	Bacteria	346	6.690000000000001e-91	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g15457	i0	99.474	455.852631578947	190	1	100	0	1	190	772780	772969	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	86612	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
21520693	21520693	PRJNA543299_P_NODE_15557_length_190_cov_1.638298_g15400_i0	PRJNA543299	15557	190	1.638298	3.1127662	Streptococcus	1301	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1438634269\|gb\|CP031248.1\|	1313	g15400	i0	100	325	190	0	100	0	1	190	1467457	1467646	Streptococcus pneumoniae strain M26365 chromosome, complete genome	blastn	61750	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
22795856	22795856	PRJNA543299_P_NODE_20138_length_167_cov_1.728814_g19981_i0	PRJNA543299	20138	167	1.728814	2.88711938	root	1	Root_unresolved	Root_unresolved	309	7.53e-80	NTclustered	gi\|1851774573\|gb\|MT585552.1\|	1304	g19981	i0	100	105	167	0	100	0	1	167	1089	1255	Streptococcus salivarius strain 868 16S ribosomal RNA gene, partial sequence	blastn	17535	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
23461918	23461918	PRJNA543299_P_NODE_24719_length_162_cov_1.185841_g24562_i0	PRJNA543299	24719	162	1.185841	1.92106242	Streptococcus sp. LPB0220	2610896	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|1752759834\|gb\|CP044230.1\|	2610896	g24562	i0	90.798	489.858024691358	163	13	100	2	1	162	449166	449005	Streptococcus sp. LPB0220 chromosome, complete genome	blastn	79357	217	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. LPB0220
25344980	25344980	PRJNA543299_P_NODE_25500_length_161_cov_1.821429_g25343_i0	PRJNA543299	25500	161	1.821429	2.93250069	root	1	Root_unresolved	Root_unresolved	298	1.56e-76	NTclustered	gi\|289541377\|gb\|GU395995.1\|	29394	g25343	i0	100	103	161	0	100	0	1	161	758	598	Dolosigranulum pigrum strain 33929-06 16S ribosomal RNA gene, partial sequence	blastn	16583	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum

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