metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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
319955	319955	PRJNA1186363_P_NODE_9061_length_695_cov_2.077170_g8205_i0	PRJNA1186363	9061	695	2.07717	14.4363315	Brevibacillus sp. 7WMA2	2683193	Bacteria	Bacteria	315	8.02e-81	NTclustered	gi\|1810936193\|gb\|CP048799.1\|	2683193	g8205	i0	78.925	6.32517985611511	465	96	79	2	151	614	1418991	1419454	Brevibacillus sp. 7WMA2 chromosome, complete genome	blastn	4396	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus sp. 7WMA2
1041988	1041988	PRJNA1186363_P_NODE_31601_length_303_cov_1.356522_g30713_i0	PRJNA1186363	31601	303	1.356522	4.11026166	Staphylococcus	1279	Bacteria	Bacteria	560	3.79e-155	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g30713	i0	100	101	303	0	100	0	1	303	2702674	2702372	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	30603	560	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
2870540	2870540	PRJNA1186363_P_NODE_27603_length_338_cov_1.177358_g26715_i0	PRJNA1186363	27603	338	1.177358	3.97947004	Loigolactobacillus coryniformis	1610	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1269843330\|gb\|CP017713.1\|	913848	g26715	i0	100	0.0887573964497041	30	0	9	0	50	79	2728204	2728233	Loigolactobacillus coryniformis subsp. coryniformis KCTC 3167 = DSM 20001 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Loigolactobacillus	Loigolactobacillus coryniformis
5422701	5422701	PRJNA1186363_P_NODE_10165_length_649_cov_1.861111_g9288_i0	PRJNA1186363	10165	649	1.861111	12.07861039	Brevibacillus sp. 7WMA2	2683193	Bacteria	Bacteria	239	4.62e-58	NTclustered	gi\|1810936193\|gb\|CP048799.1\|	2683193	g9288	i0	79.24	2.92141756548536	342	71	53	0	307	648	1419428	1419087	Brevibacillus sp. 7WMA2 chromosome, complete genome	blastn	1896	239	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus sp. 7WMA2
5422897	5422897	PRJNA1186363_P_NODE_34285_length_282_cov_1.679426_g33397_i0	PRJNA1186363	34285	282	1.679426	4.73598132	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2473421757\|gb\|CP120660.1\|	1590	g33397	i0	100	0.099290780141844	28	0	10	0	52	79	1138588	1138615	Lactiplantibacillus plantarum strain CYLB47 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
7973025	7973025	PRJNA1186363_P_NODE_32687_length_294_cov_1.466063_g31799_i0	PRJNA1186363	32687	294	1.466063	4.31022522	Jeotgalibaca dankookensis	708126	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1148966307\|gb\|CP019728.1\|	708126	g31799	i0	100	0.102040816326531	30	0	10	0	4	33	58616	58587	Jeotgalibaca dankookensis strain EX-07 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Jeotgalibaca	Jeotgalibaca dankookensis
9247641	9247641	PRJNA1186363_P_NODE_25008_length_363_cov_3.431034_g24120_i0	PRJNA1186363	25008	363	3.431034	12.45465342	Paenibacillus sp. FSL R10-2734	2954691	Bacteria	Bacteria	67.6	1.23e-6	NTclustered	gi\|2709511489\|gb\|CP150170.1\|	2954691	g24120	i0	90.196	0.371900826446281	51	5	15	0	104	154	4563220	4563170	Paenibacillus sp. FSL R10-2734 chromosome, complete genome	blastn	135	67.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R10-2734
9970105	9970105	PRJNA1186363_P_NODE_5728_length_890_cov_1.902081_g5027_i0	PRJNA1186363	5728	890	1.902081	16.9285209	Streptococcus	1301	Bacteria	Bacteria	1644	0	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g5027	i0	100	557.073033707865	890	0	100	0	1	890	163343	162454	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	495795	1644	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
10523424	10523424	PRJNA1186363_P_NODE_26089_length_352_cov_1.713262_g25201_i0	PRJNA1186363	26089	352	1.713262	6.03068224	Sporosarcina psychrophila	1476	Bacteria	Bacteria	108	7e-19	NTclustered	gi\|2693390699\|gb\|CP146246.1\|	1476	g25201	i0	74.219	1.63068181818182	256	66	73	0	42	297	916366	916621	Sporosarcina psychrophila strain TMP10 chromosome, complete genome	blastn	574	108	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina psychrophila
10523533	10523533	PRJNA1186363_P_NODE_44049_length_232_cov_2.452830_g43161_i0	PRJNA1186363	44049	232	2.45283	5.6905656	Streptococcus mutans	1309	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|1757080685\|gb\|CP044492.1\|	1309	g43161	i0	100	35.0043103448276	232	0	100	0	1	232	1695489	1695258	Streptococcus mutans strain T8 chromosome, complete genome	blastn	8121	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mutans
12520698	12520698	PRJNA1186363_P_NODE_9970_length_657_cov_1.422945_g9094_i0	PRJNA1186363	9970	657	1.422945	9.34874865	Paenibacillus	44249	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|2738717165\|gb\|CP157265.1\|	59893	g9094	i0	97.059	0.207001522070015	34	0	5	1	590	623	3897639	3897671	Paenibacillus peoriae strain MHJL1 chromosome, complete genome	blastn	136	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus peoriae
13073276	13073276	PRJNA1186363_P_NODE_21971_length_398_cov_0.920000_g21083_i0	PRJNA1186363	21971	398	0.92	3.6616	Bacillus mycoides	1405	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1735067312\|gb\|CP031071.1\|	1405	g21083	i0	92.308	1.39195979899497	39	3	10	0	165	203	2833220	2833258	Bacillus mycoides strain BPN401 chromosome, complete genome	blastn	554	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
18171307	18171307	PRJNA1186363_P_NODE_2195_length_1332_cov_7.072280_g1699_i1	PRJNA1186363	2195	1332	7.07228	94.2027696	Lactiplantibacillus carotarum	2993456	Bacteria	Bacteria	183	4.63e-41	NTclustered	gi\|2452990073\|emb\|OX443570.1\|	2993456	g1699	i1	81.735	8.62912912912913	219	40	16	0	583	801	2919150	2918932	Lactiplantibacillus sp. AMBF275 isolate AMBF275_2 genome assembly, chromosome: S	blastn	11494	183	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus carotarum
23271961	23271961	PRJNA1186363_P_NODE_33439_length_289_cov_0.986111_g32551_i0	PRJNA1186363	33439	289	0.986111	2.84986079	Clostridium estertheticum	238834	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2385494032\|gb\|CP086140.1\|	238834	g32551	i0	100	0.103806228373702	30	0	10	0	183	212	378791	378762	Clostridium estertheticum strain CF016 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium estertheticum
23271983	23271983	PRJNA1186363_P_NODE_37319_length_259_cov_11.543011_g36431_i0	PRJNA1186363	37319	259	11.543011	29.89639849	Paenibacillus sp. FSL K6-1318	2975291	Bacteria	Bacteria	69.4	2.34e-7	NTclustered	gi\|2709953277\|gb\|CP150270.1\|	2975291	g36431	i0	92.157	0.196911196911197	51	1	19	1	38	85	3971470	3971420	Paenibacillus sp. FSL K6-1318 chromosome, complete genome	blastn	51	69.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL K6-1318
25268217	25268217	PRJNA1186363_P_NODE_35880_length_270_cov_1.284264_g34992_i0	PRJNA1186363	35880	270	1.284264	3.4675128	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2713116007\|gb\|CP150491.1\|	45462	g34992	i0	100	1.43703703703704	30	0	22	0	198	227	5174146	5174117	Brevibacillus borstelensis strain S8 chromosome, complete genome	blastn	388	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus borstelensis

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