metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA235310" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA235310" 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
367380	367380	PRJNA235310_P_NODE_4901_length_169_cov_0.866667_g4875_i0	PRJNA235310	4901	169	0.866667	1.46466723	Ezakiella coagulans	46507	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g4875	i0	99.408	1.48520710059172	169	1	100	0	1	169	177590	177758	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	251	307	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
1056686	1056686	PRJNA235310_P_NODE_3181_length_213_cov_0.981707_g3155_i0	PRJNA235310	3181	213	0.981707	2.09103591	Streptococcus	1301	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|1654254190\|emb\|LR594049.1\|	1302	g3155	i0	100	341.009389671361	213	0	100	0	1	213	641078	640866	Streptococcus gordonii strain NCTC10231 genome assembly, chromosome: 1	blastn	72635	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
3607124	3607124	PRJNA235310_P_NODE_3063_length_217_cov_1.160714_g3037_i0	PRJNA235310	3063	217	1.160714	2.51874938	Bacillales	1385	Bacteria	Bacteria	390	3.579999999999999e-104	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3037	i0	99.078	518.797235023041	217	2	100	0	1	217	748622	748838	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	112579	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4194490	4194490	PRJNA235310_P_NODE_5924_length_164_cov_0.904348_g5898_i0	PRJNA235310	5924	164	0.904348	1.48313072	Desulfosporosinus acidiphilus	885581	Bacteria	Bacteria	63.9	6.33e-6	NTclustered	gi\|391353422\|gb\|CP003639.1\|	646529	g5898	i0	91.489	21.4756097560976	47	2	27	2	97	141	4150207	4150161	Desulfosporosinus acidiphilus SJ4, complete genome	blastn	3522	63.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfosporosinus	Desulfosporosinus acidiphilus
6159377	6159377	PRJNA235310_P_NODE_2865_length_225_cov_1.454545_g2839_i0	PRJNA235310	2865	225	1.454545	3.27272625	Bacillus	1386	Bacteria	Bacteria	416	6.159999999999998e-112	NTclustered	gi\|745286235\|gb\|KJ721202.1\|	1392	g2839	i0	100	357	225	0	100	0	1	225	28	252	Bacillus anthracis strain IHB B 7021 16S ribosomal RNA gene, partial sequence	blastn	80325	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
7434559	7434559	PRJNA235310_P_NODE_6226_length_162_cov_3.292035_g6200_i0	PRJNA235310	6226	162	3.292035	5.3330967	Bacillales	1385	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|384365253\|gb\|JQ818419.1\|	1392	g6200	i0	99.383	158.179012345679	162	1	100	0	1	162	507	346	Bacillus anthracis strain NIOS 16S ribosomal RNA gene, partial sequence	blastn	25625	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
10571444	10571444	PRJNA235310_P_NODE_4689_length_171_cov_1.631148_g4663_i0	PRJNA235310	4689	171	1.631148	2.78926308	Staphylococcus epidermidis	1282	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2179628937\|gb\|CP090924.1\|	1282	g4663	i0	100	485.017543859649	171	0	100	0	1	171	522339	522169	Staphylococcus epidermidis strain 48 chromosome, complete genome	blastn	82938	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13121200	13121200	PRJNA235310_P_NODE_571_length_505_cov_115.611842_g546_i0	PRJNA235310	571	505	115.611842	583.8398021	Clostridium perfringens	1502	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2029167656\|gb\|CP073070.1\|	1502	g546	i0	100	0.166336633663366	28	0	6	0	384	411	1708194	1708167	Clostridium perfringens strain 19TSBNCP chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
13121209	13121209	PRJNA235310_P_NODE_6211_length_163_cov_0.912281_g6185_i0	PRJNA235310	6211	163	0.912281	1.48701803	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|2006240191\|gb\|CP071508.1\|	1283	g6185	i0	99.387	47.4294478527607	163	1	100	0	1	163	346155	345993	Staphylococcus haemolyticus strain 7b chromosome, complete genome	blastn	7731	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
19493332	19493332	PRJNA235310_P_NODE_4236_length_182_cov_1.488722_g4210_i0	PRJNA235310	4236	182	1.488722	2.70947404	Dysosmobacter sp. Marseille-Q4140	2830675	Bacteria	Bacteria	75	3.3e-9	NTclustered	gi\|2031400201\|gb\|CP073694.1\|	2830675	g4210	i0	92.453	0.291208791208791	53	2	29	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
20182673	20182673	PRJNA235310_P_NODE_2136_length_268_cov_0.949772_g2110_i0	PRJNA235310	2136	268	0.949772	2.54538896	Bacillaceae	186817	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2530477131\|gb\|CP128801.1\|	189381	g2110	i0	100	0.43283582089552203	29	0	11	0	227	255	3576657	3576629	Rossellomorea marisflavi strain SRCM125375 chromosome, complete genome	blastn	116	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea marisflavi
20182676	20182676	PRJNA235310_P_NODE_2576_length_239_cov_3.305263_g2550_i0	PRJNA235310	2576	239	3.305263	7.89957857	Streptococcus	1301	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|2179899321\|gb\|CP046523.1\|	1303	g2550	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
21458360	21458360	PRJNA235310_P_NODE_1937_length_284_cov_1.459574_g1911_i0	PRJNA235310	1937	284	1.459574	4.14519016	Bacillus	1386	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g1911	i0	99.648	1241.10211267606	284	1	100	0	1	284	13041	12758	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	352473	520	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
21458363	21458363	PRJNA235310_P_NODE_2437_length_248_cov_1.291457_g2411_i0	PRJNA235310	2437	248	1.291457	3.20281336	Ezakiella	1582879	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g2411	i0	98.79	98.3709677419355	248	3	100	0	1	248	162456	162703	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	24396	442	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
24008601	24008601	PRJNA235310_P_NODE_5679_length_165_cov_1.344828_g5653_i0	PRJNA235310	5679	165	1.344828	2.2189662	Streptococcus	1301	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g5653	i0	100	336	165	0	100	0	1	165	625319	625483	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	55440	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
25282727	25282727	PRJNA235310_P_NODE_3160_length_213_cov_1.920732_g3134_i0	PRJNA235310	3160	213	1.920732	4.09115916	Streptococcus	1301	Bacteria	Bacteria	289	1.3099999999999998e-73	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g3134	i0	92.929	516.192488262911	198	14	93	0	16	213	18294	18491	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	109949	291	0.993127147766323	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius

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