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

14 rows where bioproject = "PRJNA596867" 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
8793225	8793225	PRJNA596867_P_NODE_767_length_753_cov_2.283824_g704_i0	PRJNA596867	767	753	2.283824	17.19719472	Turicibacter	191303	Bacteria	Bacteria	737	0	NTclustered	gi\|984737891\|gb\|CP013476.1\|	1712675	g704	i0	86.331	738.853917662683	695	74	92	16	64	752	954968	955647	Turicibacter sp. H121 chromosome, complete genome	blastn	556357	743	0.991924629878869	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sp. H121
10772368	10772368	PRJNA596867_P_NODE_9409_length_273_cov_2.880000_g9334_i0	PRJNA596867	9409	273	2.88	7.8624	Firmicutes bacterium ZOR0006	1339252	Bacteria	Bacteria	488	1.6099999999999996e-133	NTclustered	gi\|734593677\|gb\|KM585593.1\|	1339252	g9334	i0	98.901	148.043956043956	273	3	100	0	1	273	1377	1105	Firmicutes bacterium ZOR0006 16S ribosomal RNA gene, partial sequence	blastn	40416	488	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium ZOR0006
12619488	12619488	PRJNA596867_P_NODE_7710_length_295_cov_4.324324_g7635_i0	PRJNA596867	7710	295	4.324324	12.7567558	Gottschalkia	1505664	Bacteria	Bacteria	176	1.56e-39	NTclustered	gi\|470489846\|ref\|NR_076953.1\|	1556	g7635	i0	79.839	419.061016949153	248	44	83	6	1	245	31	275	Gottschalkia acidurici strain 9a 23S ribosomal RNA gene, complete sequence	blastn	123623	176	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Gottschalkiaceae	Gottschalkia	Gottschalkia acidurici
13321930	13321930	PRJNA596867_P_NODE_11811_length_250_cov_0.870056_g11736_i0	PRJNA596867	11811	250	0.870056	2.17514	Exiguobacterium acetylicum	41170	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2800727153\|gb\|CP126135.1\|	41170	g11736	i0	100	531.216	250	0	100	0	1	250	32627	32378	Exiguobacterium acetylicum strain G1-33 chromosome, complete genome	blastn	132804	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
13321940	13321940	PRJNA596867_P_NODE_12551_length_248_cov_0.880000_g12476_i0	PRJNA596867	12551	248	0.88	2.1824	Staphylococcus pasteuri	45972	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g12476	i0	100	7	248	0	100	0	1	248	472984	472737	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	1736	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
13322018	13322018	PRJNA596867_P_NODE_9791_length_269_cov_1.295918_g9716_i0	PRJNA596867	9791	269	1.295918	3.48601942	Staphylococcus pasteuri	45972	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g9716	i0	100	7.0185873605948	269	0	100	0	1	269	75676	75408	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	1888	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
17145653	17145653	PRJNA596867_P_NODE_12554_length_248_cov_0.880000_g12479_i0	PRJNA596867	12554	248	0.88	2.1824	Dolosigranulum pigrum	29394	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2020660521\|gb\|CP040422.1\|	29394	g12479	i0	98.79	25	248	3	100	0	1	248	1756509	1756756	Dolosigranulum pigrum strain KPL3050 chromosome, complete genome	blastn	6200	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
17718244	17718244	PRJNA596867_P_NODE_13374_length_246_cov_0.890173_g13299_i0	PRJNA596867	13374	246	0.890173	2.18982558	Staphylococcus	1279	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g13299	i0	100	41.9878048780488	246	0	100	0	1	246	2267034	2267279	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10329	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
18419930	18419930	PRJNA596867_P_NODE_15215_length_241_cov_0.916667_g15140_i0	PRJNA596867	15215	241	0.916667	2.20916747	Staphylococcus pasteuri	45972	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g15140	i0	100	7	241	0	100	0	1	241	973191	972951	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	1687	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
22817618	22817618	PRJNA596867_P_NODE_10158_length_265_cov_1.197917_g10083_i0	PRJNA596867	10158	265	1.197917	3.17448005	root	1	Root_unresolved	Root_unresolved	420	5.76e-113	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g10083	i0	98.333	84.9358490566038	240	3	90	1	27	265	2741590	2741351	Staphylococcus aureus strain WH3018 chromosome	blastn	22508	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
26731230	26731230	PRJNA596867_P_NODE_12381_length_248_cov_1.320000_g12306_i0	PRJNA596867	12381	248	1.32	3.2736	Staphylococcus equorum	246432	Bacteria	Bacteria	125	7.62e-36	NR	WP_269354497.1	246432	g12306	i0	100	0.713709677419355	59	0	71.4	0	248	72	2	60	WP_269354497.1 hypothetical protein, partial [Staphylococcus equorum]	diamond	177	125	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus equorum
26795023	26795023	PRJNA596867_P_NODE_9941_length_267_cov_1.572165_g9866_i0	PRJNA596867	9941	267	1.572165	4.19768055	Clostridia bacterium	2044939	Bacteria	Bacteria	42	0.0318	NR	MEG1204422.1	2044939	g9866	i0	32.8	0.685393258426966	61	38	65.2	2	255	82	32	92	MEG1204422.1 hypothetical protein [Clostridia bacterium]	diamond	183	42	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28753530	28753530	PRJNA596867_P_NODE_12147_length_249_cov_0.875000_g12072_i0	PRJNA596867	12147	249	0.875	2.17875	Clostridium sp.	1506	Bacteria	Bacteria	43.5	0.0109	NR	MFQ7536942.1	1506	g12072	i0	39	1.48192771084337	41	25	49.4	0	114	236	56	96	MFQ7536942.1 isoaspartyl peptidase/L-asparaginase [Clostridium sp.]	diamond	369	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
32735144	32735144	PRJNA596867_P_NODE_14880_length_242_cov_0.911243_g14805_i0	PRJNA596867	14880	242	0.911243	2.20520806	Aedoeadaptatus coli	2058292	Bacteria	Bacteria	149	2.3299999999999993e-40	NR	WP_108831055.1	2058292	g14805	i0	96.3	0.991735537190083	80	3	99.2	0	3	242	196	275	WP_108831055.1 histidine kinase N-terminal 7TM domain-containing protein [Aedoeadaptatus coli]	diamond	240	149	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Aedoeadaptatus	Aedoeadaptatus coli

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