metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA688414" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA688414" 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
1176867	1176867	PRJNA688414_P_NODE_7001_length_248_cov_0.891429_g6967_i0	PRJNA688414	7001	248	0.891429	2.21074392	Listeria	1637	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2785605396\|gb\|CP165992.1\|	1638	g6967	i0	100	17.9596774193548	248	0	100	0	1	248	1903958	1903711	Listeria ivanovii strain ATCC 19119 chromosome, complete genome	blastn	4454	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria ivanovii
1943040	1943040	PRJNA688414_P_NODE_8062_length_243_cov_0.917647_g8028_i0	PRJNA688414	8062	243	0.917647	2.22988221	Staphylococcus epidermidis	1282	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g8028	i0	99.588	100	243	1	100	0	1	243	2323692	2323934	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	24300	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5005219	5005219	PRJNA688414_P_NODE_4584_length_284_cov_1.350711_g4550_i0	PRJNA688414	4584	284	1.350711	3.83601924	Anoxybacillus	150247	Bacteria	Bacteria	435	2.2300000000000003e-117	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g4550	i0	94.386	886.75	285	13	100	3	1	284	2188797	2188515	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	251837	436	0.997706422018349	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
10871083	10871083	PRJNA688414_P_NODE_6929_length_249_cov_0.875000_g6895_i0	PRJNA688414	6929	249	0.875	2.17875	Staphylococcus aureus	1280	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g6895	i0	100	100	249	0	100	0	1	249	390784	391032	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	24900	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12146395	12146395	PRJNA688414_P_NODE_5970_length_253_cov_0.866667_g5936_i0	PRJNA688414	5970	253	0.866667	2.19266751	Lysinibacillus sp. SGAir0095	2070463	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1654115908\|gb\|CP028083.1\|	2070463	g5936	i0	100	999.683794466403	253	0	100	0	1	253	14674	14422	Lysinibacillus sp. SGAir0095 chromosome, complete genome	blastn	252920	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. SGAir0095
12656266	12656266	PRJNA688414_P_NODE_7990_length_243_cov_1.517647_g7956_i0	PRJNA688414	7990	243	1.517647	3.68788221	Niallia	2837506	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|1848538850\|gb\|CP053989.1\|	1397	g7956	i0	99.177	1049.96296296296	243	2	100	0	1	243	119422	119180	Niallia circulans strain FDAARGOS_783 chromosome, complete genome	blastn	255141	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia circulans
13420908	13420908	PRJNA688414_P_NODE_3091_length_334_cov_1.386973_g3057_i0	PRJNA688414	3091	334	1.386973	4.63248982	Paenibacillus naphthalenovorans	162209	Bacteria	Bacteria	351	2.7699999999999995e-92	NTclustered	gi\|961442200\|gb\|CP013652.1\|	162209	g3057	i0	86.35	560.799401197605	337	28	100	13	1	334	3094216	3094537	Paenibacillus naphthalenovorans strain 32O-Y chromosome, complete genome	blastn	187307	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus naphthalenovorans
15205474	15205474	PRJNA688414_P_NODE_1412_length_464_cov_1.176471_g1378_i0	PRJNA688414	1412	464	1.176471	5.45882544	Enterococcus	1350	Bacteria	Bacteria	852	0	NTclustered	gi\|939198273\|gb\|CP010060.1\|	44008	g1378	i0	99.784	474.418103448276	464	1	100	0	1	464	141135	141598	Enterococcus cecorum strain SA1 genome	blastn	220130	852	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
21069406	21069406	PRJNA688414_P_NODE_3577_length_315_cov_1.256198_g3543_i0	PRJNA688414	3577	315	1.256198	3.9570237	Paenibacillus lycopersici	2704462	Bacteria	Bacteria	324	5.66e-84	NTclustered	gi\|1805094357\|gb\|CP048209.1\|	2704462	g3543	i0	85.669	1013.8	314	37	99	8	1	309	6290681	6290371	Paenibacillus lycopersici strain 12200R-189 chromosome, complete genome	blastn	319347	324	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus lycopersici
24128800	24128800	PRJNA688414_P_NODE_6459_length_251_cov_0.876404_g6425_i0	PRJNA688414	6459	251	0.876404	2.19977404	Listeria	1637	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2785605396\|gb\|CP165992.1\|	1638	g6425	i0	99.602	20.0398406374502	251	1	100	0	1	251	1640367	1640617	Listeria ivanovii strain ATCC 19119 chromosome, complete genome	blastn	5030	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria ivanovii
24893130	24893130	PRJNA688414_P_NODE_5280_length_266_cov_3.746114_g5246_i0	PRJNA688414	5280	266	3.746114	9.96466324	Abyssicoccus albus	1817405	Bacteria	Bacteria	492	1.2099999999999999e-134	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g5246	i0	100	534.770676691729	266	0	100	0	1	266	293275	293010	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	142249	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
25403354	25403354	PRJNA688414_P_NODE_5100_length_271_cov_1.207071_g5066_i0	PRJNA688414	5100	271	1.207071	3.27116241	Paenibacillus	44249	Bacteria	Bacteria	394	3.58e-105	NTclustered	gi\|2204561594\|gb\|CP092779.1\|	1406	g5066	i0	92.754	1096.61992619926	276	15	100	1	1	271	408951	409226	Paenibacillus polymyxa strain ZJ-9 chromosome, complete genome	blastn	297184	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa

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