metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA756891" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA756891" 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
731949	731949	PRJNA756891_P_NODE_16481_length_241_cov_0.916667_g16412_i0	PRJNA756891	16481	241	0.916667	2.20916747	Streptococcus gordonii	1302	Bacteria	Bacteria	302	1.95e-77	NTclustered	gi\|1348270962\|gb\|CP020450.2\|	1302	g16412	i0	89.669	70.5933609958506	242	18	99	6	1	239	111244	111007	Streptococcus gordonii strain FDAARGOS_257 chromosome, complete genome	blastn	17013	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
2008072	2008072	PRJNA756891_P_NODE_8962_length_290_cov_1.617512_g8893_i0	PRJNA756891	8962	290	1.617512	4.6907848	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2814788368\|emb\|OY764195.2\|	3030912	g8893	i0	96.774	0.106896551724138	31	1	11	0	66	96	1732652	1732622	MAG: Anaerovoracaceae bacterium isolate cdaadf04-e2f3-4fd8-80f9-b39a06479d73 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
3753967	3753967	PRJNA756891_P_NODE_13443_length_248_cov_0.880000_g13374_i0	PRJNA756891	13443	248	0.88	2.1824	Lactococcus	1357	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g13374	i0	98.438	299.112903225806	192	2	78	1	1	191	558027	558218	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	74180	337	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
3753983	3753983	PRJNA756891_P_NODE_4703_length_389_cov_1.243671_g4634_i0	PRJNA756891	4703	389	1.243671	4.83788019	Bacillaceae	186817	Bacteria	Bacteria	636	8.069999999999999e-178	NTclustered	gi\|2046389985\|gb\|CP071709.1\|	859144	g4634	i0	96.144	1146.24164524422	389	15	100	0	1	389	13422	13034	Cytobacillus gottheilii strain 1839 chromosome, complete genome	blastn	445888	636	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus gottheilii
5030522	5030522	PRJNA756891_P_NODE_12264_length_251_cov_0.865169_g12195_i0	PRJNA756891	12264	251	0.865169	2.17157419	Bacillus	1386	Bacteria	Bacteria	292	1.2299999999999999e-74	NTclustered	gi\|2582827010\|gb\|CP135060.1\|	1396	g12195	i0	100	62.9561752988048	158	0	63	0	94	251	2723422	2723265	Bacillus cereus strain B126_1 chromosome, complete genome	blastn	15802	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
5835572	5835572	PRJNA756891_P_NODE_5085_length_375_cov_1.529801_g5016_i0	PRJNA756891	5085	375	1.529801	5.73675375	Ornithinibacillus sp. 4-3	3231488	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2780420940\|gb\|CP162599.1\|	3231488	g5016	i0	100	0.0746666666666667	28	0	7	0	52	79	169081	169108	Ornithinibacillus sp. 4-3 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ornithinibacillus	Ornithinibacillus sp. 4-3
6306305	6306305	PRJNA756891_P_NODE_16565_length_241_cov_0.916667_g16496_i0	PRJNA756891	16565	241	0.916667	2.20916747	Lactococcus	1357	Bacteria	Bacteria	270	5.499999999999999e-68	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g16496	i0	99.329	51.3278008298755	149	1	62	0	93	241	2272421	2272273	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	12370	270	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
6306320	6306320	PRJNA756891_P_NODE_6625_length_333_cov_0.892308_g6556_i0	PRJNA756891	6625	333	0.892308	2.97138564	Bacillus	1386	Bacteria	Bacteria	361	4.59e-95	NTclustered	gi\|2582827010\|gb\|CP135060.1\|	1396	g6556	i0	100	58.5585585585586	195	0	59	0	1	195	174687	174881	Bacillus cereus strain B126_1 chromosome, complete genome	blastn	19500	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
7110665	7110665	PRJNA756891_P_NODE_10086_length_275_cov_1.311881_g10017_i0	PRJNA756891	10086	275	1.311881	3.60767275	Cytobacillus gottheilii	859144	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2046389985\|gb\|CP071709.1\|	859144	g10017	i0	100	1	275	0	100	0	1	275	3841240	3841514	Cytobacillus gottheilii strain 1839 chromosome, complete genome	blastn	275	508	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus gottheilii
7110696	7110696	PRJNA756891_P_NODE_15426_length_243_cov_1.670588_g15357_i0	PRJNA756891	15426	243	1.670588	4.05952884	Streptococcus sanguinis	1305	Bacteria	Bacteria	322	1.51e-83	NTclustered	gi\|1539215237\|emb\|LR134002.1\|	1305	g15357	i0	95.588	8.12345679012346	204	4	82	4	1	199	2294757	2294960	Streptococcus sanguinis strain NCTC10904 genome assembly, chromosome: 1	blastn	1974	322	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
7110752	7110752	PRJNA756891_P_NODE_9306_length_285_cov_1.891509_g9237_i0	PRJNA756891	9306	285	1.891509	5.39080065	Psychrobacillus sp. FSL H8-0483	2921389	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2723725089\|gb\|CP152052.1\|	2921389	g9237	i0	100	0.0982456140350877	28	0	10	0	117	144	1784772	1784799	Psychrobacillus sp. FSL H8-0483 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Psychrobacillus	Psychrobacillus sp. FSL H8-0483
8385277	8385277	PRJNA756891_P_NODE_13847_length_247_cov_0.885057_g13778_i0	PRJNA756891	13847	247	0.885057	2.18609079	Miniphocaeibacter halophilus	2931922	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1951789833\|gb\|CP066744.1\|	2931922	g13778	i0	100	0.11336032388664	28	0	11	0	10	37	1825990	1826017	Miniphocaeibacter halophilus strain AMB_01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Miniphocaeibacter	Miniphocaeibacter halophilus
8855240	8855240	PRJNA756891_P_NODE_13547_length_248_cov_0.880000_g13478_i0	PRJNA756891	13547	248	0.88	2.1824	Bacillus	1386	Bacteria	Bacteria	254	5.73e-63	NTclustered	gi\|2212326042\|gb\|CP093928.1\|	1396	g13478	i0	100	56.0120967741936	137	0	55	0	1	137	2473062	2473198	Bacillus cereus strain AH7-7 chromosome, complete genome	blastn	13891	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
10130892	10130892	PRJNA756891_P_NODE_14368_length_246_cov_0.890173_g14299_i0	PRJNA756891	14368	246	0.890173	2.18982558	Bacillus	1386	Bacteria	Bacteria	302	2e-77	NTclustered	gi\|2212326042\|gb\|CP093928.1\|	1396	g14299	i0	100	66.6463414634146	163	0	66	0	1	163	2970518	2970680	Bacillus cereus strain AH7-7 chromosome, complete genome	blastn	16395	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
10130903	10130903	PRJNA756891_P_NODE_16128_length_242_cov_0.911243_g16059_i0	PRJNA756891	16128	242	0.911243	2.20520806	Bacillus	1386	Bacteria	Bacteria	446	8.559999999999998e-121	NTclustered	gi\|756004731\|gb\|CP009606.1\|	1396	g16059	i0	100	26.7685950413223	241	0	99	0	2	242	249225	249465	Bacillus cereus strain S2-8 plasmid pBFR_2, complete sequence	blastn	6478	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
11406062	11406062	PRJNA756891_P_NODE_9829_length_278_cov_1.878049_g9760_i0	PRJNA756891	9829	278	1.878049	5.22097622	Companilactobacillus	2767879	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2781060683\|gb\|CP162899.1\|	1612	g9760	i0	100	0.302158273381295	28	0	10	0	137	164	42029	42056	Companilactobacillus farciminis strain YLR-1 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus farciminis
12681940	12681940	PRJNA756891_P_NODE_15630_length_243_cov_0.905882_g15561_i0	PRJNA756891	15630	243	0.905882	2.20129326	Lactococcus	1357	Bacteria	Bacteria	361	3.2e-95	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g15561	i0	98.077	85.6337448559671	208	2	85	2	37	243	360426	360220	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	20809	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
12681953	12681953	PRJNA756891_P_NODE_6130_length_344_cov_2.287823_g6061_i0	PRJNA756891	6130	344	2.287823	7.87011112	Bacillaceae	186817	Bacteria	Bacteria	604	1.9899999999999992e-168	NTclustered	gi\|1893059056\|gb\|CP060137.1\|	2760090	g6061	i0	99.697	929.261627906977	330	1	96	0	2	331	915396	915725	Bacillus sp. PAMC26568 chromosome, complete genome	blastn	319666	604	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. PAMC26568
13956220	13956220	PRJNA756891_P_NODE_15171_length_244_cov_0.900585_g15102_i0	PRJNA756891	15171	244	0.900585	2.1974274	Bacillus	1386	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|2033736802\|gb\|CP072774.1\|	1396	g15102	i0	98.75	65.5737704918033	160	2	66	0	1	160	105483	105324	Bacillus cereus strain BC33 chromosome, complete genome	blastn	16000	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
14760951	14760951	PRJNA756891_P_NODE_2472_length_529_cov_2.190789_g2404_i0	PRJNA756891	2472	529	2.190789	11.58927381	Staphylococcus aureus	1280	Bacteria	Bacteria	67.6	1.85e-6	NTclustered	gi\|2045432977\|gb\|CP075511.1\|	1280	g2404	i0	100	0.406427221172023	36	0	7	0	434	469	616952	616987	Staphylococcus aureus strain Colony103 chromosome	blastn	215	67.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15230786	15230786	PRJNA756891_P_NODE_13912_length_247_cov_0.885057_g13843_i0	PRJNA756891	13912	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g13843	i0	100	46.4858299595142	247	0	100	0	1	247	710220	710466	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	11482	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
15230805	15230805	PRJNA756891_P_NODE_8292_length_301_cov_2.324561_g8223_i0	PRJNA756891	8292	301	2.324561	6.99692861	Staphylococcus	1279	Bacteria	Bacteria	556	4.87e-154	NTclustered	gi\|1042399354\|gb\|KU555851.1\|	29382	g8223	i0	100	481.305647840532	301	0	100	0	1	301	438	738	Staphylococcus cohnii strain SCO15222-2 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	144873	556	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
17310155	17310155	PRJNA756891_P_NODE_4814_length_384_cov_2.877814_g4745_i0	PRJNA756891	4814	384	2.877814	11.05080576	Staphylococcus agnetis	985762	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1822095818\|gb\|CP045927.1\|	985762	g4745	i0	100	0.0755208333333333	29	0	8	0	260	288	758689	758717	Staphylococcus agnetis strain 1379 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus agnetis
24153928	24153928	PRJNA756891_P_NODE_12299_length_251_cov_0.865169_g12230_i0	PRJNA756891	12299	251	0.865169	2.17157419	Bacillus	1386	Bacteria	Bacteria	135	2.2e-27	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g12230	i0	100	29.0836653386454	73	0	29	0	1	73	1997192	1997264	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	7300	135	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
24958544	24958544	PRJNA756891_P_NODE_15920_length_242_cov_0.911243_g15851_i0	PRJNA756891	15920	242	0.911243	2.20520806	Streptococcus oralis	1303	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1247204361\|gb\|CP023507.1\|	1303	g15851	i0	100	83.4462809917355	242	0	100	0	1	242	1058776	1058535	Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome	blastn	20194	448	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);;