metadata: contig_metadata: 14 rows where bioproject = "PRJEB6055" and tax

14 rows where bioproject = "PRJEB6055" 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
125530	125530	PRJEB6055_S_NODE_1821_length_225_cov_3.115789_g1797_i0	PRJEB6055	1821	225	3.115789	7.01052525	Anaerococcus sp. Marseille-Q7828	3036300	Bacteria	Bacteria	335	1.7699999999999994e-87	NTclustered	gi\|2472116327\|emb\|OX458331.1\|	3036300	g1797	i0	94.86	49.3911111111111	214	11	95	0	1	214	436796	437009	Anaerococcus sp. Marseille-Q7828 genome assembly, chromosome: contig00001	blastn	11113	335	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. Marseille-Q7828
2675627	2675627	PRJEB6055_S_NODE_4783_length_163_cov_2.726562_g4759_i0	PRJEB6055	4783	163	2.726562	4.44429606	Lacticaseibacillus parahuelsenbergensis	3068305	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|2563953291\|gb\|CP132482.1\|	3068305	g4759	i0	98.16	460.030674846626	163	3	100	0	1	163	819933	820095	Lacticaseibacillus parahuelsenbergensis strain NCIMB 15471 chromosome, complete genome	blastn	74985	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus parahuelsenbergensis
6503777	6503777	PRJEB6055_S_NODE_1006_length_275_cov_6.037500_g982_i0	PRJEB6055	1006	275	6.0375	16.603125	Finegoldia magna	1260	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g982	i0	99.636	46.2690909090909	275	1	100	0	1	275	427563	427837	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	12724	503	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
8645373	8645373	PRJEB6055_S_NODE_2407_length_206_cov_1.707602_g2383_i0	PRJEB6055	2407	206	1.707602	3.51766012	Blautia	572511	Bacteria	Bacteria	370	4.38e-98	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g2383	i0	99.029	453.742718446602	206	2	100	0	1	206	1306722	1306517	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	93471	370	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
8645374	8645374	PRJEB6055_S_NODE_5507_length_155_cov_1.350000_g5483_i0	PRJEB6055	5507	155	1.35	2.0925	Lactobacillus	1578	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g5483	i0	100	378.993548387097	155	0	100	0	1	155	89568	89414	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	58744	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
11195573	11195573	PRJEB6055_S_NODE_2249_length_210_cov_5.080000_g2225_i0	PRJEB6055	2249	210	5.08	10.668	Leuconostoc	1243	Bacteria	Bacteria	324	3.54e-84	NTclustered	gi\|1799531339\|gb\|CP028255.1\|	1245	g2225	i0	98.378	241.752380952381	185	2	88	1	17	201	65058	65241	Leuconostoc mesenteroides strain SRCM102735 chromosome, complete genome	blastn	50768	324	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
11195574	11195574	PRJEB6055_S_NODE_2569_length_201_cov_1.765060_g2545_i0	PRJEB6055	2569	201	1.76506	3.5477706	Lacticaseibacillus	2759736	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|1206084366\|gb\|CP017065.1\|	1582	g2545	i0	100	480	201	0	100	0	1	201	779536	779736	Lacticaseibacillus casei strain LC5 chromosome, complete genome	blastn	96480	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus casei
15020101	15020101	PRJEB6055_S_NODE_1252_length_254_cov_42.863014_g1228_i0	PRJEB6055	1252	254	42.863014	108.87205556	Leuconostoc	1243	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2410894178\|gb\|CP113947.1\|	33968	g1228	i0	100	347.405511811024	254	0	100	0	1	254	20827	20574	Leuconostoc pseudomesenteroides strain L64 chromosome, complete genome	blastn	88241	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc pseudomesenteroides
17570112	17570112	PRJEB6055_S_NODE_514_length_334_cov_8.371237_g490_i0	PRJEB6055	514	334	8.371237	27.95993158	Staphylococcus	1279	Bacteria	Bacteria	527	4.289999999999999e-145	NTclustered	gi\|2105689500\|gb\|CP066719.1\|	1288	g490	i0	98.02	436.763473053892	303	6	91	0	32	334	875594	875896	Staphylococcus xylosus strain TMW 2.1602 chromosome, complete genome	blastn	145879	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
20526494	20526494	PRJEB6055_S_NODE_5217_length_158_cov_1.430894_g5193_i0	PRJEB6055	5217	158	1.430894	2.26081252	Parvimonas micra	33033	Bacteria	Bacteria	250	4.31e-62	NTclustered	gi\|2418005075\|gb\|CP101411.1\|	33033	g5193	i0	98.592	87.9367088607595	142	1	89	1	1	141	1107903	1107762	Parvimonas micra strain PM89KC-AC-1 chromosome, complete genome	blastn	13894	250	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
21394345	21394345	PRJEB6055_S_NODE_277_length_398_cov_15.366391_g253_i0	PRJEB6055	277	398	15.366391	61.15823618	Streptococcus	1301	Bacteria	Bacteria	645	1.3699999999999993e-180	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g253	i0	100	299.942211055276	349	0	88	0	19	367	1571256	1571604	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	119377	645	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
23944595	23944595	PRJEB6055_S_NODE_279_length_398_cov_6.666667_g255_i0	PRJEB6055	279	398	6.666667	26.53333466	Streptococcus	1301	Bacteria	Bacteria	617	3e-172	NTclustered	gi\|470489451\|ref\|NR_076930.1\|	1318	g255	i0	98.567	294.479899497487	349	5	88	0	32	380	3	351	Streptococcus parasanguinis strain FW213 23S ribosomal RNA gene, complete sequence	blastn	117203	617	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
25218346	25218346	PRJEB6055_S_NODE_140_length_476_cov_4.648526_g118_i0	PRJEB6055	140	476	4.648526	22.12698376	Leuconostoc	1243	Bacteria	Bacteria	575	2.2199999999999992e-159	NTclustered	gi\|1799531339\|gb\|CP028255.1\|	1245	g118	i0	96.045	255.827731092437	354	13	74	1	1	353	67839	68192	Leuconostoc mesenteroides strain SRCM102735 chromosome, complete genome	blastn	121774	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
25218355	25218355	PRJEB6055_S_NODE_620_length_318_cov_2.893993_g596_i0	PRJEB6055	620	318	2.893993	9.20289774	Streptococcus	1301	Bacteria	Bacteria	560	3.999999999999998e-155	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g596	i0	98.428	385.245283018868	318	5	100	0	1	318	17969	17652	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	122508	560	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis

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