metadata: contig_metadata: 16 rows where bioproject = "PRJNA512103" and tax

16 rows where bioproject = "PRJNA512103" 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
4939104	4939104	PRJNA512103_P_NODE_29984_length_170_cov_1.958678_g29572_i0	PRJNA512103	29984	170	1.958678	3.3297526	Bacillati	1783272	Bacteria	Bacteria	143	8.2e-30	NTclustered	gi\|2753147090\|gb\|CP148032.1\|	55583	g29572	i0	86.923	92.7294117647059	130	13	75	4	16	142	233546	233418	MAG: Dehalobacter restrictus isolate SAD chromosome, complete genome	blastn	15764	143	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Dehalobacter	Dehalobacter restrictus
8763855	8763855	PRJNA512103_P_NODE_17207_length_238_cov_1.190476_g16795_i0	PRJNA512103	17207	238	1.190476	2.83333288	Streptococcus	1301	Bacteria	Bacteria	407	3.9599999999999994e-109	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g16795	i0	100	394.802521008403	220	0	92	0	10	229	18061	17842	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	93963	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
10039394	10039394	PRJNA512103_P_NODE_24288_length_191_cov_1.577465_g23876_i0	PRJNA512103	24288	191	1.577465	3.01295815	root	1	Root_unresolved	Root_unresolved	320	4.08e-83	NTclustered	gi\|2450068752\|gb\|OQ540790.1\|	1303	g23876	i0	100	90.5759162303665	173	0	91	0	10	182	443	271	Streptococcus oralis strain DM3 16S ribosomal RNA gene, partial sequence	blastn	17300	320	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11314038	11314038	PRJNA512103_P_NODE_31629_length_167_cov_1.042373_g31217_i0	PRJNA512103	31629	167	1.042373	1.74076291	Peribacillus	2675229	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|1002184699\|gb\|CP011009.1\|	1478	g31217	i0	98.734	965.784431137725	158	2	95	0	1	158	165685	165842	Bacillus simplex strain SH-B26 plasmid pSHB26, complete sequence	blastn	161286	281	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus simplex
12589807	12589807	PRJNA512103_P_NODE_22830_length_198_cov_1.060403_g22418_i0	PRJNA512103	22830	198	1.060403	2.09959794	root	1	Root_unresolved	Root_unresolved	364	1.9399999999999995e-96	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g22418	i0	100	26.6565656565657	197	0	99	0	2	198	2428000	2428196	Staphylococcus aureus strain WH9628 chromosome	blastn	5278	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13864646	13864646	PRJNA512103_P_NODE_8031_length_451_cov_2.368159_g7622_i0	PRJNA512103	8031	451	2.368159	10.68039709	Bacillati	1783272	Bacteria	Bacteria	817	0	NTclustered	gi\|2328902616\|gb\|CP110363.1\|	1604	g7622	i0	100	369.155210643015	442	0	98	0	10	451	652485	652926	Lactobacillus amylovorus strain CICC 6090 chromosome, complete genome	blastn	166489	817	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus amylovorus
15138913	15138913	PRJNA512103_P_NODE_18752_length_225_cov_0.909091_g18340_i0	PRJNA512103	18752	225	0.909091	2.04545475	Streptococcus	1301	Bacteria	Bacteria	357	3.79e-94	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g18340	i0	97.596	511.226666666667	208	5	92	0	9	216	162489	162696	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	115026	357	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
17688731	17688731	PRJNA512103_P_NODE_32894_length_165_cov_0.896552_g32482_i0	PRJNA512103	32894	165	0.896552	1.4793108	Staphylococcus	1279	Bacteria	Bacteria	268	1.26e-67	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g32482	i0	99.324	77.4969696969697	148	1	90	0	10	157	1958160	1958013	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	12787	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
18337172	18337172	PRJNA512103_P_NODE_12695_length_308_cov_1.370656_g12283_i0	PRJNA512103	12695	308	1.370656	4.22162048	Hathewaya histolytica	1498	Bacteria	Bacteria	198	3.4899999999999993e-46	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g12283	i0	81.59	27.7402597402597	239	44	78	0	68	306	1403202	1403440	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	8544	198	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
22162661	22162661	PRJNA512103_P_NODE_21418_length_206_cov_0.942675_g21006_i0	PRJNA512103	21418	206	0.942675	1.9419105	Paenibacillus urinalis	521520	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|2446590601\|gb\|CP118106.1\|	521520	g21006	i0	85.075	19.0582524271845	67	7	32	3	20	84	2087659	2087724	Paenibacillus urinalis strain 2022CK-00833 chromosome, complete genome	blastn	3926	65.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus urinalis
22787892	22787892	PRJNA512103_P_NODE_13858_length_285_cov_0.987288_g13446_i0	PRJNA512103	13858	285	0.987288	2.8137708	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|975008075\|gb\|CP011146.1\|	1396	g13446	i0	100	0.792982456140351	29	0	10	0	190	218	237600	237628	Bacillus cereus strain FORC_013 plasmid pFORC13, complete sequence	blastn	226	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
26824137	26824137	PRJNA512103_P_NODE_27381_length_179_cov_1.346154_g26969_i0	PRJNA512103	27381	179	1.346154	2.40961566	Paenibacillus sp. 1	198340	Bacteria	Bacteria	41.6	0.0378	NR	WP_119801618.1	1675787	g26969	i0	45.5	0.737430167597765	44	21	68.7	1	167	45	118	161	WP_119801618.1 FAD-dependent oxidoreductase [Paenibacillus sp. 1011MAR3C5]	diamond	132	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
26965967	26965967	PRJNA512103_P_NODE_19082_length_222_cov_1.057803_g18670_i0	PRJNA512103	19082	222	1.057803	2.34832266	root	1	Root_unresolved	Root_unresolved	150	1.73e-45	NR	WP_279750363.1	1280	g18670	i0	98.6	92.972972972973	73	1	98.6	0	1	219	10	82	WP_279750363.1 50S ribosomal protein L37Ae, partial [Staphylococcus aureus]	diamond	20640	151	0.993377483443709	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28245500	28245500	PRJNA512103_P_NODE_34906_length_156_cov_2.074766_g34494_i0	PRJNA512103	34906	156	2.074766	3.23663496	Clostridium sp. OF13-4	2293040	Bacteria	Bacteria	55.5	2.83e-8	NR	RHV70535.1	2293040	g34494	i0	61.7	0.903846153846154	47	18	90.4	0	14	154	4	50	RHV70535.1 hypothetical protein DXB05_14070, partial [Clostridium sp. OF13-4]	diamond	141	55.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. OF13-4
31341141	31341141	PRJNA512103_P_NODE_34076_length_163_cov_0.877193_g33664_i0	PRJNA512103	34076	163	0.877193	1.42982459	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	54.7	7.74e-7	NR	MBS3812162.1	2094029	g33664	i0	61.9	0.773006134969325	42	13	71.8	1	130	14	690	731	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	126	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32227052	32227052	PRJNA512103_P_NODE_21098_length_208_cov_0.874214_g20686_i0	PRJNA512103	21098	208	0.874214	1.81836512	Negativicutes bacterium	2499140	Bacteria	Bacteria	43.5	0.00633	NR	MDR3563352.1	2499140	g20686	i0	44.6	0.807692307692308	56	28	80.8	2	12	179	78	130	MDR3563352.1 hypothetical protein [Negativicutes bacterium]	diamond	168	43.5	1	Bacteria	Bacillati	Bacillota	Negativicutes				Negativicutes bacterium

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