metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA713989" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA713989" 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	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
1191278	1191278	PRJNA713989_S_NODE_11261_length_170_cov_2.082645_g11201_i0	PRJNA713989	11261	170	2.082645	3.5404965	root	1	Root_unresolved	Root_unresolved	315	1.64e-81	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g11201	i0	100	99.7647058823529	170	0	100	1	170	2679767	2679936	Staphylococcus aureus strain WH3018 chromosome	blastn	16960	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
1191286	1191286	PRJNA713989_S_NODE_1561_length_392_cov_1.991254_g1501_i0	PRJNA713989	1561	392	1.991254	7.80571568	root	1	Root_unresolved	Root_unresolved	725	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g1501	i0	100	39.4515306122449	392	0	100	1	392	2427801	2428192	Staphylococcus aureus strain WH9628 chromosome	blastn	15465	725	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
1979420	1979420	PRJNA713989_S_NODE_12222_length_166_cov_0.871795_g12162_i0	PRJNA713989	12222	166	0.871795	1.4471797	Staphylococcus aureus	1280	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2913687056\|gb\|CP181136.1\|	1280	g12162	i0	99.398	100	166	1	100	1	166	822577	822412	Staphylococcus aureus strain AG21-0619 chromosome, complete genome	blastn	16600	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
3742938	3742938	PRJNA713989_S_NODE_4063_length_256_cov_2.009662_g4003_i0	PRJNA713989	4063	256	2.009662	5.14473472	Bacillus	1386	Bacteria	Bacteria	468	1.95e-127	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g4003	i0	99.609	100	256	1	100	1	256	3356621	3356876	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	25600	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
3742940	3742940	PRJNA713989_S_NODE_7083_length_205_cov_2.769231_g7023_i0	PRJNA713989	7083	205	2.769231	5.67692355	Bacillus	1386	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g7023	i0	100	99.2439024390244	205	0	100	1	205	3356343	3356547	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	20345	379	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
3742942	3742942	PRJNA713989_S_NODE_7923_length_196_cov_2.217687_g7863_i0	PRJNA713989	7923	196	2.217687	4.34666652	root	1	Root_unresolved	Root_unresolved	363	6.899999999999998e-96	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g7863	i0	100	100.040816326531	196	0	100	1	196	2742147	2741952	Staphylococcus aureus strain WH3018 chromosome	blastn	19608	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6295270	6295270	PRJNA713989_S_NODE_725_length_546_cov_2.414487_g666_i0	PRJNA713989	725	546	2.414487	13.18309902	root	1	Root_unresolved	Root_unresolved	1009	0	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g666	i0	100	100	546	0	100	1	546	3948631	3948086	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	54600	1009	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
7569086	7569086	PRJNA713989_S_NODE_12066_length_166_cov_2.581197_g12006_i0	PRJNA713989	12066	166	2.581197	4.28478702	Bacillus	1386	Bacteria	Bacteria	213	6.03e-51	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g12006	i0	100	833.728915662651	115	0	69	52	166	13687	13573	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	138399	213	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
9631975	9631975	PRJNA713989_S_NODE_13108_length_164_cov_0.886957_g13048_i0	PRJNA713989	13108	164	0.886957	1.45460948	Streptococcus sanguinis	1305	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|1864130110\|gb\|CP040798.1\|	1305	g13048	i0	93.902	22.9817073170732	164	10	100	1	164	2072245	2072082	Streptococcus sanguinis strain CGMH058 chromosome, complete genome	blastn	3769	248	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
10119796	10119796	PRJNA713989_S_NODE_11348_length_170_cov_1.090909_g11288_i0	PRJNA713989	11348	170	1.090909	1.8545453	root	1	Root_unresolved	Root_unresolved	309	7.64e-80	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g11288	i0	99.412	98.5882352941177	170	1	100	1	170	2463014	2463183	Staphylococcus aureus strain WH9628 chromosome	blastn	16760	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
10119797	10119797	PRJNA713989_S_NODE_11608_length_168_cov_1.302521_g11548_i0	PRJNA713989	11608	168	1.302521	2.18823528	Bacillus	1386	Bacteria	Bacteria	195	2.22e-45	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g11548	i0	100	753.196428571429	105	0	63	1	105	13330	13226	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	126537	195	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
11394848	11394848	PRJNA713989_S_NODE_10989_length_172_cov_1.243902_g10929_i0	PRJNA713989	10989	172	1.243902	2.13951144	Bacillus	1386	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g10929	i0	100	100	172	0	100	1	172	3970983	3971154	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	17200	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
12670808	12670808	PRJNA713989_S_NODE_130_length_1136_cov_15.916283_g102_i0	PRJNA713989	130	1136	15.916283	180.80897488	Bacillus	1386	Bacteria	Bacteria	1458	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g102	i0	100	69.3353873239437	789	0	69	28	816	3964813	3965601	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	78765	1458	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
12670813	12670813	PRJNA713989_S_NODE_150_length_1087_cov_3.560694_g120_i0	PRJNA713989	150	1087	3.560694	38.70474378	Bacillus	1386	Bacteria	Bacteria	1945	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g120	i0	99.811	97.4434222631095	1059	2	97	1	1059	3356871	3357929	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	105921	1945	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
12670815	12670815	PRJNA713989_S_NODE_630_length_580_cov_3.214689_g573_i0	PRJNA713989	630	580	3.214689	18.6451962	Bacillus	1386	Bacteria	Bacteria	743	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g573	i0	99.51	100.51724137931	408	2	100	1	408	3972174	3972581	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	58300	743	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
13945129	13945129	PRJNA713989_S_NODE_4231_length_252_cov_1.852217_g4171_i0	PRJNA713989	4231	252	1.852217	4.66758684	root	1	Root_unresolved	Root_unresolved	466	6.89e-127	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g4171	i0	100	41.8015873015873	252	0	100	1	252	2428185	2428436	Staphylococcus aureus strain WH9628 chromosome	blastn	10534	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
14732354	14732354	PRJNA713989_S_NODE_13112_length_164_cov_0.886957_g13052_i0	PRJNA713989	13112	164	0.886957	1.45460948	Streptococcus sp. Marseille-Q3533	2759692	Bacteria	Bacteria	261	2.09e-65	NTclustered	gi\|2237347942\|emb\|OW724079.1\|	2759692	g13052	i0	95.679	4.91463414634146	162	7	99	3	164	487594	487433	Streptococcus sp. Marseille-Q3533 genome assembly, chromosome: contig00001	blastn	806	261	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q3533
16494154	16494154	PRJNA713989_S_NODE_1313_length_422_cov_1.667560_g1253_i0	PRJNA713989	1313	422	1.66756	7.0371032	Bacillus	1386	Bacteria	Bacteria	704	0	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g1253	i0	100	102.843601895735	381	0	99	41	421	3949651	3950031	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	43400	704	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
17281466	17281466	PRJNA713989_S_NODE_12334_length_166_cov_0.871795_g12274_i0	PRJNA713989	12334	166	0.871795	1.4471797	Staphylococcus arlettae	29378	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2313314935\|gb\|CP094806.1\|	29378	g12274	i0	100	5.96987951807229	166	0	100	1	166	274412	274247	Staphylococcus arlettae strain IVB6234 chromosome, complete genome	blastn	991	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus arlettae
17281505	17281505	PRJNA713989_S_NODE_13834_length_162_cov_0.902655_g13774_i0	PRJNA713989	13834	162	0.902655	1.4623011	Staphylococcus hominis	1290	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g13774	i0	100	100	162	0	100	1	162	683742	683903	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	16200	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
20317633	20317633	PRJNA713989_S_NODE_12956_length_164_cov_0.886957_g12896_i0	PRJNA713989	12956	164	0.886957	1.45460948	Staphylococcus	1279	Bacteria	Bacteria	206	9.93e-49	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g12896	i0	100	26.8963414634146	111	0	100	54	164	597545	597435	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	4411	206	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
20317638	20317638	PRJNA713989_S_NODE_1836_length_364_cov_1.657143_g1776_i0	PRJNA713989	1836	364	1.657143	6.03200052	Bacillus	1386	Bacteria	Bacteria	667	0	NTclustered	gi\|2798377728\|gb\|CP168764.1\|	1392	g1776	i0	99.725	100	364	1	100	1	364	3916908	3916545	Bacillus anthracis strain Z03-J001 chromosome, complete genome	blastn	36400	667	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
21105755	21105755	PRJNA713989_S_NODE_11877_length_167_cov_0.864407_g11817_i0	PRJNA713989	11877	167	0.864407	1.44355969	Streptococcus cristatus	45634	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1823511124\|gb\|CP050133.1\|	889201	g11817	i0	100	4	167	0	100	1	167	1434978	1435144	Streptococcus cristatus ATCC 51100 chromosome, complete genome	blastn	668	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus cristatus
21593502	21593502	PRJNA713989_S_NODE_3917_length_260_cov_1.445498_g3857_i0	PRJNA713989	3917	260	1.445498	3.7582948	Bacillus	1386	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g3857	i0	100	100	260	0	100	1	260	3948042	3947783	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	26000	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
21593506	21593506	PRJNA713989_S_NODE_7777_length_198_cov_1.026846_g7717_i0	PRJNA713989	7777	198	1.026846	2.03315508	Streptococcus	1301	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g7717	i0	100	328.131313131313	198	0	100	1	198	1569551	1569354	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	64970	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22868669	22868669	PRJNA713989_S_NODE_10038_length_179_cov_1.384615_g9978_i0	PRJNA713989	10038	179	1.384615	2.47846085	Bacillus	1386	Bacteria	Bacteria	311	2.27e-80	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g9978	i0	100	173.486033519553	168	0	94	12	179	3968959	3969126	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	31054	311	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
22868679	22868679	PRJNA713989_S_NODE_2718_length_303_cov_2.838583_g2658_i0	PRJNA713989	2718	303	2.838583	8.60090649	Bacillus	1386	Bacteria	Bacteria	560	3.79e-155	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g2658	i0	100	100	303	0	100	1	303	3969663	3969965	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	30300	560	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
23656411	23656411	PRJNA713989_S_NODE_12619_length_165_cov_0.879310_g12559_i0	PRJNA713989	12619	165	0.87931	1.4508615	Staphylococcus kloosii	29384	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|1370550804\|gb\|CP027846.1\|	29384	g12559	i0	98.182	1.98787878787879	165	3	100	1	165	766795	766631	Staphylococcus kloosii strain ATCC 43959 chromosome, complete genome	blastn	328	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus kloosii
25417776	25417776	PRJNA713989_S_NODE_13420_length_163_cov_0.894737_g13360_i0	PRJNA713989	13420	163	0.894737	1.45842131	Staphylococcus	1279	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g13360	i0	100	41.7484662576687	163	0	100	1	163	509682	509844	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	6805	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis

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