metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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
321486	321486	PRJNA1195374_P_NODE_34961_length_381_cov_1.120130_g34617_i0	PRJNA1195374	34961	381	1.12013	4.2676953	Oscillospiraceae bacterium MB24-C1	3070655	Bacteria	Bacteria	89.8	2.77e-13	NTclustered	gi\|2570622773\|gb\|CP133187.1\|	3070655	g34617	i0	83.333	0.658792650918635	96	16	25	0	17	112	2335934	2336029	Oscillospiraceae bacterium MB24-C1 chromosome, complete genome	blastn	251	89.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium MB24-C1
322202	322202	PRJNA1195374_P_NODE_72581_length_250_cov_0.870056_g72237_i0	PRJNA1195374	72581	250	0.870056	2.17514	Ruoffia tabacinasalis	87458	Bacteria	Bacteria	429	8.949999999999998e-116	NTclustered	gi\|2686201366\|gb\|CP144682.1\|	87458	g72237	i0	97.6	63.648	250	6	100	0	1	250	237018	236769	Ruoffia tabacinasalis strain jzb001 chromosome, complete genome	blastn	15912	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Ruoffia	Ruoffia tabacinasalis
1042591	1042591	PRJNA1195374_P_NODE_26961_length_437_cov_1.425824_g26617_i0	PRJNA1195374	26961	437	1.425824	6.23085088	Bacteria	2	Bacteria	Bacteria	780	0	NTclustered	gi\|1147724948\|gb\|KY622910.1\|	1290	g26617	i0	98.856	100	437	5	100	0	1	437	65	501	Staphylococcus hominis strain OA313 16S ribosomal RNA gene, partial sequence	blastn	43700	785	0.993630573248408	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
1042835	1042835	PRJNA1195374_P_NODE_57561_length_286_cov_1.323944_g57217_i0	PRJNA1195374	57561	286	1.323944	3.78647984	Paenibacillus	44249	Bacteria	Bacteria	462	1.03e-125	NTclustered	gi\|2709392188\|gb\|CP150149.1\|	1536775	g57217	i0	95.804	36.6048951048951	286	12	100	0	1	286	5864574	5864289	Paenibacillus sp. FSL H7-0737 chromosome, complete genome	blastn	10469	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H7-0737
4149352	4149352	PRJNA1195374_P_NODE_82944_length_242_cov_1.497041_g82600_i0	PRJNA1195374	82944	242	1.497041	3.62283922	Staphylococcus coagulans	74706	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2207334516\|gb\|CP092966.1\|	74706	g82600	i0	100	7	242	0	100	0	1	242	1603354	1603113	Staphylococcus coagulans strain 1031336 chromosome	blastn	1694	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus coagulans
4870986	4870986	PRJNA1195374_P_NODE_71304_length_251_cov_0.865169_g70960_i0	PRJNA1195374	71304	251	0.865169	2.17157419	Paenibacillus	44249	Bacteria	Bacteria	396	9.119999999999996e-106	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g70960	i0	95.219	35.8804780876494	251	10	100	2	1	251	6353123	6352875	Paenibacillus sp. FSL R5-0345, complete genome	blastn	9006	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
5425331	5425331	PRJNA1195374_P_NODE_70265_length_252_cov_1.391061_g69921_i0	PRJNA1195374	70265	252	1.391061	3.50547372	Alkalihalophilus pseudofirmus	79885	Bacteria	Bacteria	377	3.32e-100	NTclustered	gi\|2452493757\|gb\|CP117835.1\|	79885	g69921	i0	93.651	3	252	16	100	0	1	252	2417812	2417561	Alkalihalophilus pseudofirmus strain DSM 8715 chromosome, complete genome	blastn	756	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalophilus	Alkalihalophilus pseudofirmus
6145618	6145618	PRJNA1195374_P_NODE_4825_length_944_cov_2.675086_g4568_i0	PRJNA1195374	4825	944	2.675086	25.25281184	Paenibacillus	44249	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g4568	i0	94.595	0.218220338983051	37	2	4	0	617	653	240094	240130	Paenibacillus sp. FSL R5-0345, complete genome	blastn	206	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
6699514	6699514	PRJNA1195374_P_NODE_44306_length_333_cov_1.703846_g43962_i0	PRJNA1195374	44306	333	1.703846	5.67380718	Caldinitratiruptor microaerophilus	671077	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2317219343\|dbj\|AP025628.1\|	671077	g43962	i0	90.698	0.129129129129129	43	1	12	3	209	248	2939094	2939136	Caldinitratiruptor microaerophilus JCM 16183 DNA, complete genome	blastn	43	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae	Caldinitratiruptor	Caldinitratiruptor microaerophilus
11800373	11800373	PRJNA1195374_P_NODE_53430_length_298_cov_2.377778_g53086_i0	PRJNA1195374	53430	298	2.377778	7.08577844	Paenibacillus roseopurpureus	2918901	Bacteria	Bacteria	62.1	4.6e-5	NTclustered	gi\|2587247824\|gb\|CP130319.1\|	2918901	g53086	i0	100	0.986577181208054	33	0	11	0	72	104	2110808	2110776	Paenibacillus sp. MBLB1832 chromosome, complete genome	blastn	294	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus roseopurpureus
11800504	11800504	PRJNA1195374_P_NODE_60810_length_278_cov_0.858537_g60466_i0	PRJNA1195374	60810	278	0.858537	2.38673286	Bacillus thuringiensis	1428	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|409177032\|gb\|CP003890.1\|	527021	g60466	i0	100	0.100719424460432	28	0	10	0	180	207	85414	85387	Bacillus thuringiensis Bt407 strain 407 plasmid BTB_502p, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
12521532	12521532	PRJNA1195374_P_NODE_64570_length_268_cov_0.943590_g64226_i0	PRJNA1195374	64570	268	0.94359	2.5288212	Streptococcus	1301	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|537629960\|gb\|CP003858.1\|	862966	g64226	i0	100	376.369402985075	268	0	100	0	1	268	22923	22656	Streptococcus intermedius C270, complete genome	blastn	100867	496	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus intermedius
13074654	13074654	PRJNA1195374_P_NODE_14791_length_587_cov_0.869650_g14451_i0	PRJNA1195374	14791	587	0.86965	5.1048455	Bacillus thuringiensis	1428	Bacteria	Bacteria	202	5.4399999999999985e-47	NTclustered	gi\|942009880\|gb\|CP013000.1\|	1428	g14451	i0	83.886	7.8381601362862	211	34	38	0	111	321	2009286	2009076	Bacillus thuringiensis strain XL6 chromosome, complete genome	blastn	4601	202	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
13075132	13075132	PRJNA1195374_P_NODE_38611_length_360_cov_1.958188_g38267_i0	PRJNA1195374	38611	360	1.958188	7.0494768	Radiobacillus deserti	2594883	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1707798502\|gb\|CP041666.1\|	2594883	g38267	i0	100	0.547222222222222	29	0	8	0	34	62	3016857	3016885	Radiobacillus deserti strain TKL69 chromosome, complete genome	blastn	197	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Radiobacillus	Radiobacillus deserti
13796246	13796246	PRJNA1195374_P_NODE_69091_length_255_cov_1.692308_g68747_i0	PRJNA1195374	69091	255	1.692308	4.3153854	Staphylococcus	1279	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g68747	i0	100	98.5137254901961	255	0	100	0	1	255	1324912	1325166	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	25121	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
15625117	15625117	PRJNA1195374_P_NODE_79053_length_245_cov_1.250000_g78709_i0	PRJNA1195374	79053	245	1.25	3.0625	Clostridium beijerinckii	1520	Bacteria	Bacteria	300	7.15e-77	NTclustered	gi\|2324517193\|gb\|CP107022.1\|	1520	g78709	i0	88.889	2.97551020408163	243	27	99	0	3	245	4411598	4411356	Clostridium beijerinckii strain CloBei18h chromosome, complete genome	blastn	729	300	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
16345319	16345319	PRJNA1195374_P_NODE_52453_length_302_cov_1.152838_g52109_i0	PRJNA1195374	52453	302	1.152838	3.48157076	Clostridium	1485	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2094037488\|gb\|CP082942.1\|	1509	g52109	i0	100	0.278145695364238	28	0	9	0	213	240	2753073	2753046	Clostridium sporogenes strain FDAARGOS_1471 chromosome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sporogenes
17620759	17620759	PRJNA1195374_P_NODE_77474_length_246_cov_1.739884_g77130_i0	PRJNA1195374	77474	246	1.739884	4.28011464	Staphylococcus	1279	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g77130	i0	99.187	457.020325203252	246	2	100	0	1	246	707259	707014	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	112427	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
20168918	20168918	PRJNA1195374_P_NODE_33736_length_388_cov_2.006349_g33392_i0	PRJNA1195374	33736	388	2.006349	7.78463412	Streptococcus	1301	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2165380901\|gb\|CP088916.1\|	1328	g33392	i0	100	1.94329896907216	29	0	7	0	130	158	928112	928140	Streptococcus anginosus strain 47S1 chromosome	blastn	754	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
20723694	20723694	PRJNA1195374_P_NODE_78057_length_246_cov_0.890173_g77713_i0	PRJNA1195374	78057	246	0.890173	2.18982558	Staphylococcus coagulans	74706	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|2207332086\|gb\|CP092965.1\|	74706	g77713	i0	98.374	7.02032520325203	246	4	100	0	1	246	1391715	1391960	Staphylococcus coagulans strain 1031373 chromosome	blastn	1727	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus coagulans
20723790	20723790	PRJNA1195374_P_NODE_83457_length_242_cov_0.911243_g83113_i0	PRJNA1195374	83457	242	0.911243	2.20520806	Pediococcus ethanolidurans	319653	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2739944708\|emb\|OZ061250.1\|	319653	g83113	i0	100	0.115702479338843	28	0	12	0	131	158	664530	664503	Pediococcus ethanolidurans isolate Pediococcus ethanolidurans CIRM-BIA2669 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus ethanolidurans
23273820	23273820	PRJNA1195374_P_NODE_42599_length_341_cov_1.149254_g42255_i0	PRJNA1195374	42599	341	1.149254	3.91895614	Crassaminicella profunda	1286698	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2090201836\|gb\|CP082326.1\|	1286698	g42255	i0	100	0.0850439882697947	29	0	9	0	5	33	2909839	2909811	Crassaminicella profunda strain Ra1766H chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Crassaminicella	Crassaminicella profunda
23274537	23274537	PRJNA1195374_P_NODE_78219_length_246_cov_0.890173_g77875_i0	PRJNA1195374	78219	246	0.890173	2.18982558	Lachnospiraceae bacterium KM106-2	2093742	Bacteria	Bacteria	171	5.879999999999999e-38	NTclustered	gi\|1776939693\|dbj\|AP018794.1\|	2093742	g77875	i0	80.543	6.66666666666667	221	43	90	0	10	230	720260	720040	Lachnospiraceae bacterium KM106-2 DNA, complete genome	blastn	1640	171	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium KM106-2
24548074	24548074	PRJNA1195374_P_NODE_58740_length_283_cov_1.261905_g58396_i0	PRJNA1195374	58740	283	1.261905	3.57119115	Alkalihalophilus pseudofirmus	79885	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|315111345\|gb\|CP001878.2\|	398511	g58396	i0	100	3.22614840989399	283	0	100	0	1	283	1252177	1252459	Bacillus pseudofirmus OF4, complete genome	blastn	913	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalophilus	Alkalihalophilus pseudofirmus

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