metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA721440" 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
1193623	1193623	PRJNA721440_S_NODE_10121_length_204_cov_1.058065_g9995_i0	PRJNA721440	10121	204	1.058065	2.1584526	Streptococcus	1301	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|2579561176\|gb\|CP134469.1\|	1307	g9995	i0	99.51	391.019607843137	204	1	100	0	1	204	21521	21724	Streptococcus suis strain M104170_C2 chromosome, complete genome	blastn	79768	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
1193627	1193627	PRJNA721440_S_NODE_16081_length_172_cov_1.536585_g15955_i0	PRJNA721440	16081	172	1.536585	2.6429262	Catenibacterium	135858	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2299336055\|gb\|CP102271.1\|	100886	g15955	i0	100	0.348837209302326	30	0	17	0	113	142	577955	577926	Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome	blastn	60	56.5	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium mitsuokai
1193628	1193628	PRJNA721440_S_NODE_17721_length_167_cov_1.245763_g17595_i0	PRJNA721440	17721	167	1.245763	2.08042421	Bacillati	1783272	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g17595	i0	98.802	496.850299401198	167	2	100	0	1	167	2278287	2278121	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	82974	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4538520	4538520	PRJNA721440_S_NODE_10004_length_205_cov_0.871795_g9878_i0	PRJNA721440	10004	205	0.871795	1.78717975	Lactobacillus sp. IBH004	2879107	Bacteria	Bacteria	329	7.39e-86	NTclustered	gi\|2426115884\|gb\|CP110217.2\|	2879107	g9878	i0	95.61	338.375609756098	205	9	100	0	1	205	1321156	1321360	Lactobacillus sp. IBH004 chromosome, complete genome	blastn	69367	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus sp. IBH004
6297672	6297672	PRJNA721440_S_NODE_19325_length_163_cov_1.728070_g19199_i0	PRJNA721440	19325	163	1.72807	2.8167541	Pediococcus	1253	Bacteria	Bacteria	298	1.58e-76	NTclustered	gi\|1035434175\|gb\|CP015918.1\|	1255	g19199	i0	100	450.398773006135	161	0	99	0	3	163	128686	128846	Pediococcus pentosaceus strain wikim20, complete genome	blastn	73415	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
6297677	6297677	PRJNA721440_S_NODE_7385_length_229_cov_1.355556_g7259_i0	PRJNA721440	7385	229	1.355556	3.10422324	root	1	Root_unresolved	Root_unresolved	424	3.76e-114	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g7259	i0	100	174.991266375546	229	0	100	0	1	229	1410	1182	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	40073	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7571461	7571461	PRJNA721440_S_NODE_8466_length_217_cov_3.398810_g8340_i0	PRJNA721440	8466	217	3.39881	7.3754177	root	1	Root_unresolved	Root_unresolved	379	7.739999999999998e-101	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g8340	i0	99.052	97.2073732718894	211	2	97	0	1	211	3985092	3985302	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	21094	379	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
11397234	11397234	PRJNA721440_S_NODE_4729_length_272_cov_2.376682_g4603_i0	PRJNA721440	4729	272	2.376682	6.46457504	Erysipelotrichales	526525	Bacteria	Bacteria	62.1	4.15e-5	NTclustered	gi\|2777632677\|dbj\|AP031432.1\|	1982626	g4603	i0	97.297	0.544117647058823	37	0	13	1	27	62	1565408	1565444	Faecalibacillus intestinalis i32-0019-2J8 DNA, complete genome	blastn	148	62.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Faecalibacillus	Faecalibacillus intestinalis
11397236	11397236	PRJNA721440_S_NODE_6189_length_244_cov_3.769231_g6063_i0	PRJNA721440	6189	244	3.769231	9.19692364	root	1	Root_unresolved	Root_unresolved	121	5.949999999999999e-23	NTclustered	gi\|1878067685\|dbj\|LC566215.1\|	1352	g6063	i0	93.976	34.4467213114754	83	0	32	4	161	239	128	47	Enterococcus faecium EV0426-12 plasmid pIHVA-EV0426-12 DNA, complete sequence	blastn	8405	122	0.991803278688525	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
12673244	12673244	PRJNA721440_S_NODE_20930_length_157_cov_2.157407_g20804_i0	PRJNA721440	20930	157	2.157407	3.38712899	Pediococcus	1253	Bacteria	Bacteria	279	5.46e-71	NTclustered	gi\|2811772618\|gb\|PQ396677.1\|	1255	g20804	i0	98.726	111.866242038217	157	2	100	0	1	157	675	831	Pediococcus pentosaceus strain V9313 16S ribosomal RNA gene, partial sequence	blastn	17563	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
13947469	13947469	PRJNA721440_S_NODE_17851_length_167_cov_0.796610_g17725_i0	PRJNA721440	17851	167	0.79661	1.3303387	Staphylococcus	1279	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g17725	i0	98.204	583.365269461078	167	3	100	0	1	167	786217	786051	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	97422	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
15222183	15222183	PRJNA721440_S_NODE_11492_length_195_cov_1.082192_g11366_i0	PRJNA721440	11492	195	1.082192	2.1102744	Pediococcus	1253	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|1035434175\|gb\|CP015918.1\|	1255	g11366	i0	100	472.676923076923	195	0	100	0	1	195	127266	127072	Pediococcus pentosaceus strain wikim20, complete genome	blastn	92172	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
17288175	17288175	PRJNA721440_S_NODE_12614_length_188_cov_0.956835_g12488_i0	PRJNA721440	12614	188	0.956835	1.7988498	Staphylococcus epidermidis	1282	Bacteria	Bacteria	315	1.8599999999999999e-81	NTclustered	gi\|2180323311\|gb\|CP090985.1\|	1282	g12488	i0	96.809	520.739361702128	188	6	100	0	1	188	1636913	1637100	Staphylococcus epidermidis strain 50D chromosome, complete genome	blastn	97899	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20320061	20320061	PRJNA721440_S_NODE_9856_length_206_cov_1.528662_g9730_i0	PRJNA721440	9856	206	1.528662	3.14904372	Streptococcus	1301	Bacteria	Bacteria	359	9.47e-95	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g9730	i0	98.058	563.203883495146	206	4	100	0	1	206	17919	18124	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	116020	359	1	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);;