metadata: contig_metadata: 27 rows where bioproject = "PRJNA382558" and tax

27 rows where bioproject = "PRJNA382558" 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
1075677	1075677	PRJNA382558_S_NODE_3141_length_240_cov_6.147783_g3137_i0	PRJNA382558	3141	240	6.147783	14.7546792	Staphylococcus	1279	Bacteria	Bacteria	411	3.089999999999999e-110	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g3137	i0	97.5	478.004166666667	240	6	100	0	1	240	1785587	1785348	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	114721	411	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2351115	2351115	PRJNA382558_S_NODE_6022_length_200_cov_11.269939_g6018_i0	PRJNA382558	6022	200	11.269939	22.539878	Bacillus	1386	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2273857370\|gb\|CP101399.1\|	293387	g6018	i0	94.595	16.62	37	1	19	1	59	95	3435919	3435884	Bacillus altitudinis strain HM-7 chromosome, complete genome	blastn	3324	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus altitudinis
3626465	3626465	PRJNA382558_S_NODE_9323_length_176_cov_8.395683_g9319_i0	PRJNA382558	9323	176	8.395683	14.77640208	Bacteria	2	Bacteria	Bacteria	80.9	5.47e-16	NR	WP_326152808.1	1454	g9319	i0	62.1	4.875	58	22	98.9	0	174	1	772	829	WP_326152808.1 PAS domain S-box protein [Schinkia azotoformans]	diamond	858	81.3	0.995079950799508	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Schinkia	Schinkia azotoformans
4232098	4232098	PRJNA382558_S_NODE_5724_length_204_cov_4.041916_g5720_i0	PRJNA382558	5724	204	4.041916	8.24550864	Bacillus cereus	1396	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|301030550\|gb\|GU230872.1\|	1396	g5720	i0	99.51	1	204	1	100	0	1	204	358	155	Bacillus cereus strain ATCC 12480 transposase gene, partial cds	blastn	204	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
6178653	6178653	PRJNA382558_S_NODE_11305_length_166_cov_9.581395_g11301_i0	PRJNA382558	11305	166	9.581395	15.9051157	Bacillales	1385	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g11301	i0	100	510.024096385542	166	0	100	0	1	166	748775	748610	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	84664	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6782737	6782737	PRJNA382558_S_NODE_9306_length_176_cov_9.107914_g9302_i0	PRJNA382558	9306	176	9.107914	16.02992864	Streptococcus oralis	1303	Bacteria	Bacteria	300	4.8e-77	NTclustered	gi\|288522\|emb\|X68427.1\|	1303	g9302	i0	97.701	323.130681818182	174	4	99	0	2	175	1411	1238	S.oralis gene for 23S rRNA	blastn	56871	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15707500	15707500	PRJNA382558_S_NODE_10393_length_171_cov_4.425373_g10389_i0	PRJNA382558	10393	171	4.425373	7.56738783	Thomasclavelia ramosa	1547	Bacteria	Bacteria	111	1.98e-30	NR	WP_226816758.1	1547	g10389	i0	100	1	57	0	100	0	171	1	5	61	WP_226816758.1 DJ-1/PfpI family protein, partial [Thomasclavelia ramosa]	diamond	171	111	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Thomasclavelia	Thomasclavelia ramosa
16378240	16378240	PRJNA382558_S_NODE_9313_length_176_cov_8.791367_g9309_i0	PRJNA382558	9313	176	8.791367	15.47280592	Staphylococcus	1279	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g9309	i0	99.432	500.914772727273	176	1	100	0	1	176	784016	783841	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	88161	320	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
16982419	16982419	PRJNA382558_S_NODE_9874_length_173_cov_8.566176_g9870_i0	PRJNA382558	9874	173	8.566176	14.81948448	Hathewaya histolytica	1498	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g9870	i0	100	733.791907514451	170	0	98	0	4	173	1185	1016	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	126946	315	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
18927190	18927190	PRJNA382558_S_NODE_13835_length_156_cov_11.042017_g13831_i0	PRJNA382558	13835	156	11.042017	17.22554652	Streptococcus	1301	Bacteria	Bacteria	278	1.95e-70	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g13831	i0	98.718	325.794871794872	156	2	100	0	1	156	1569626	1569471	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	50824	278	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
19530853	19530853	PRJNA382558_S_NODE_7956_length_185_cov_5.385135_g7952_i0	PRJNA382558	7956	185	5.385135	9.96249975	Bacillus cereus	1396	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|301030550\|gb\|GU230872.1\|	1396	g7952	i0	100	1	185	0	100	0	1	185	694	510	Bacillus cereus strain ATCC 12480 transposase gene, partial cds	blastn	185	342	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
20806398	20806398	PRJNA382558_S_NODE_13077_length_159_cov_7.090164_g13073_i0	PRJNA382558	13077	159	7.090164	11.27336076	Thomasclavelia ramosa	1547	Bacteria	Bacteria	87	5.990000000000001e-21	NR	WP_226986319.1	1547	g13073	i0	100	0.830188679245283	44	0	83	0	28	159	1	44	WP_226986319.1 LysR family transcriptional regulator, partial [Thomasclavelia ramosa]	diamond	132	87	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Thomasclavelia	Thomasclavelia ramosa
27218243	27218243	PRJNA382558_S_NODE_1422_length_293_cov_8.703125_g1418_i0	PRJNA382558	1422	293	8.703125	25.50015625	Bacteria	2	Bacteria	Bacteria	99	6.17e-25	NR	WP_264293122.1	1547	g1418	i0	100	1.00341296928328	47	0	48.1	0	1	141	24	70	WP_264293122.1 transposase, partial [Thomasclavelia ramosa]	diamond	294	100	0.99	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Thomasclavelia	Thomasclavelia ramosa
27503003	27503003	PRJNA382558_S_NODE_14123_length_156_cov_3.512605_g14119_i0	PRJNA382558	14123	156	3.512605	5.4796638	Bacteria	2	Bacteria	Bacteria	99.4	4.56e-25	NR	MBL6010807.1	260554	g14119	i0	98	2.90384615384615	49	1	94.2	0	154	8	92	140	MBL6010807.1 hypothetical protein [Bacillus halotolerans]	diamond	453	99.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus halotolerans
28071140	28071140	PRJNA382558_S_NODE_9265_length_177_cov_3.964286_g9261_i0	PRJNA382558	9265	177	3.964286	7.01678622	Bacteria	2	Bacteria	Bacteria	90.1	5.54e-22	NR	MCB5531944.1	1547	g9261	i0	100	2.64406779661017	42	0	71.2	0	127	2	1	42	MCB5531944.1 hypothetical protein [Thomasclavelia ramosa]	diamond	468	90.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Thomasclavelia	Thomasclavelia ramosa
28875196	28875196	PRJNA382558_S_NODE_2048_length_268_cov_5.943723_g2044_i0	PRJNA382558	2048	268	5.943723	15.92917764	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.5	0.0278	NR	MBR3575135.1	1898203	g2044	i0	37	0.817164179104478	73	43	79.5	2	264	52	809	880	MBR3575135.1 glycoside hydrolase family 9 protein [Lachnospiraceae bacterium]	diamond	219	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29807652	29807652	PRJNA382558_S_NODE_13251_length_159_cov_0.885246_g13247_i0	PRJNA382558	13251	159	0.885246	1.40754114	root	1	Root_unresolved	Root_unresolved	55.1	3.78e-7	NR	WP_208704085.1	1280	g13247	i0	82.9	95.7358490566038	35	6	66	0	158	54	18	52	WP_208704085.1 50S ribosomal protein L4 [Staphylococcus aureus]	diamond	15222	55.5	0.992792792792793	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29870923	29870923	PRJNA382558_S_NODE_10431_length_170_cov_9.646617_g10427_i0	PRJNA382558	10431	170	9.6466170000000009	16.3992489	Peribacillus	2675229	Bacteria	Bacteria	70.1	2.05e-12	NR	WP_377429596.1	421767	g10427	i0	70.6	1.8	51	15	90	0	1	153	66	116	WP_377429596.1 alpha/beta hydrolase domain-containing protein [Peribacillus butanolivorans]	diamond	306	70.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus butanolivorans
30169772	30169772	PRJNA382558_S_NODE_15192_length_152_cov_7.452174_g15188_i0	PRJNA382558	15192	152	7.452174	11.32730448	Flavonifractor plautii	292800	Bacteria	Bacteria	73.2	1.97e-13	NR	WP_238047630.1	292800	g15188	i0	75	0.947368421052632	48	12	94.7	0	9	152	194	241	WP_238047630.1 site-specific DNA-methyltransferase [Flavonifractor plautii]	diamond	144	73.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
30218368	30218368	PRJNA382558_S_NODE_6332_length_197_cov_10.512500_g6328_i0	PRJNA382558	6332	197	10.5125	20.709625	Bacteria	2	Bacteria	Bacteria	126	1.34e-35	NR	WP_214976747.1	74706	g6328	i0	100	20.7868020304569	65	0	99	0	196	2	53	117	WP_214976747.1 DUF1631 family protein, partial [Staphylococcus coagulans]	diamond	4095	126	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus coagulans
30282030	30282030	PRJNA382558_S_NODE_1152_length_308_cov_6.328413_g1148_i0	PRJNA382558	1152	308	6.328413	19.49151204	Bacillati	1783272	Bacteria	Bacteria	180	6.609999999999999e-55	NR	WP_168993544.1	29388	g1148	i0	100	2.98051948051948	102	0	99.4	0	308	3	102	203	WP_168993544.1 IS110 family transposase, partial [Staphylococcus capitis]	diamond	918	180	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
30391579	30391579	PRJNA382558_S_NODE_473_length_379_cov_10.567251_g469_i0	PRJNA382558	473	379	10.567251	40.04988129	Paenibacillus sp. Leaf72	1736234	Bacteria	Bacteria	94.7	1.1e-19	NR	WP_056042418.1	1736234	g469	i0	73.8	2.94459102902375	61	16	48.3	0	183	1	5	65	WP_056042418.1 ATP-binding protein [Paenibacillus sp. Leaf72]	diamond	1116	94.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. Leaf72
31465828	31465828	PRJNA382558_S_NODE_12236_length_162_cov_9.000000_g12232_i0	PRJNA382558	12236	162	9	14.58	Staphylococcus aureus	1280	Bacteria	Bacteria	88.6	1.98e-21	NR	MDN8771517.1	1280	g12232	i0	90.2	0.759259259259259	41	4	75.9	0	125	3	1	41	MDN8771517.1 hypothetical protein [Staphylococcus aureus]	diamond	123	88.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31735426	31735426	PRJNA382558_S_NODE_9277_length_176_cov_13.913669_g9273_i0	PRJNA382558	9277	176	13.913669	24.48805744	Bacteria	2	Bacteria	Bacteria	95.5	3.44e-24	NR	WP_158084700.1	1313	g9273	i0	79.3	1.97727272727273	58	12	98.9	0	2	175	3	60	WP_158084700.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	348	95.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
31750136	31750136	PRJNA382558_S_NODE_13917_length_156_cov_7.159664_g13913_i0	PRJNA382558	13917	156	7.159664	11.16907584	Negativicutes bacterium	2499140	Bacteria	Bacteria	43.1	0.00862	NR	MFC2337820.1	2499140	g13913	i0	41.2	0.980769230769231	51	29	98.1	1	4	156	438	487	MFC2337820.1 DNA topoisomerase 3 [Negativicutes bacterium]	diamond	153	43.1	1	Bacteria	Bacillati	Bacillota	Negativicutes				Negativicutes bacterium
32224974	32224974	PRJNA382558_S_NODE_8958_length_178_cov_8.503546_g8954_i0	PRJNA382558	8958	178	8.503546	15.13631188	Thomasclavelia ramosa	1547	Bacteria	Bacteria	75.5	2.03e-16	NR	MCB5532165.1	1547	g8954	i0	100	0.691011235955056	41	0	69.1	0	178	56	20	60	MCB5532165.1 hypothetical protein [Thomasclavelia ramosa]	diamond	123	75.5	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Thomasclavelia	Thomasclavelia ramosa
32667245	32667245	PRJNA382558_S_NODE_6720_length_194_cov_8.152866_g6716_i0	PRJNA382558	6720	194	8.152866	15.81656004	Bacillus anthracis	1392	Bacteria	Bacteria	123	2.1199999999999993e-34	NR	WP_197715744.1	1392	g6716	i0	93.8	0.989690721649485	64	4	99	0	194	3	64	127	WP_197715744.1 hypothetical protein, partial [Bacillus anthracis]	diamond	192	123	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis

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