metadata: contig_metadata: 17 rows where bioproject = "PRJNA1136957" and tax

17 rows where bioproject = "PRJNA1136957" 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
1032009	1032009	PRJNA1136957_S_NODE_11361_length_254_cov_1.415385_g11264_i0	PRJNA1136957	11361	254	1.415385	3.5950779	Streptococcus	1301	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|2563200286\|dbj\|AP028603.1\|	1313	g11264	i0	99.606	339	254	1	100	0	1	254	18537	18284	Streptococcus pneumoniae Pne2 DNA, complete genome	blastn	86106	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
2835280	2835280	PRJNA1136957_S_NODE_5623_length_339_cov_1.728571_g5526_i0	PRJNA1136957	5623	339	1.728571	5.85985569	Bacillus manliponensis	574376	Bacteria	Bacteria	60.2	1.91e-4	NTclustered	gi\|2785673827\|gb\|CP165965.1\|	574376	g5526	i0	97.143	6.80530973451327	35	1	10	0	56	90	2808510	2808476	Bacillus manliponensis strain jeju3-1 chromosome, complete genome	blastn	2307	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus manliponensis
7409947	7409947	PRJNA1136957_S_NODE_926_length_586_cov_15.631879_g843_i0	PRJNA1136957	926	586	15.631879	91.60281094	Clostridioides	1870884	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2319031117\|gb\|CP107108.1\|	1496	g843	i0	97.059	5.29863481228669	34	1	6	0	55	88	3418885	3418918	Clostridioides difficile strain R_phiCD75-3 chromosome, complete genome	blastn	3105	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
12510739	12510739	PRJNA1136957_S_NODE_12330_length_245_cov_1.725806_g12233_i0	PRJNA1136957	12330	245	1.725806	4.2282247	Streptococcus	1301	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g12233	i0	100	353.277551020408	245	0	100	0	1	245	1571225	1571469	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	86553	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
13038276	13038276	PRJNA1136957_S_NODE_13531_length_234_cov_63.160000_g13434_i0	PRJNA1136957	13531	234	63.16	147.7944	Romboutsia ilealis	1115758	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1172272411\|emb\|LN555523.1\|	1115758	g13434	i0	100	0.123931623931624	29	0	12	0	165	193	1274284	1274312	Romboutsia ilealis strain CRIB genome assembly, chromosome: chr1	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis
13785387	13785387	PRJNA1136957_S_NODE_8571_length_288_cov_0.986900_g8474_i0	PRJNA1136957	8571	288	0.9869	2.842272	root	1	Root_unresolved	Root_unresolved	505	1.7e-138	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g8474	i0	98.264	103.493055555556	288	5	100	0	1	288	1212	925	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	29806	510	0.990196078431373	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
15059695	15059695	PRJNA1136957_S_NODE_18192_length_204_cov_1.489655_g18095_i0	PRJNA1136957	18192	204	1.489655	3.0388962	Granulicatella	117563	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|2315116068\|gb\|CP106751.1\|	46124	g18095	i0	99.02	473.779411764706	204	2	100	0	1	204	13687	13890	Granulicatella adiacens strain KHUD_009 chromosome, complete genome	blastn	96651	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella adiacens
21961325	21961325	PRJNA1136957_S_NODE_13758_length_233_cov_1.051724_g13661_i0	PRJNA1136957	13758	233	1.051724	2.45051692	Ligilactobacillus aviarius	1606	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2729058697\|emb\|OZ006997.1\|	1606	g13661	i0	100	575.296137339056	233	0	100	0	1	233	318192	318424	MAG: Ligilactobacillus aviarius isolate pooled_s2189.ctg002983c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	134044	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus aviarius
21961349	21961349	PRJNA1136957_S_NODE_1698_length_498_cov_19.769932_g1602_i0	PRJNA1136957	1698	498	19.769932	98.45426136	root	1	Root_unresolved	Root_unresolved	171	6.64e-51	NR	MDJ8942385.1	1502	g1602	i0	79.4	1.8433734939759	102	21	61.4	0	495	190	94	195	MDJ8942385.1 hypothetical protein [Clostridium perfringens]	diamond	918	171	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
24510525	24510525	PRJNA1136957_S_NODE_1560_length_510_cov_148.902439_g1465_i0	PRJNA1136957	1560	510	148.902439	759.4024389	root	1	Root_unresolved	Root_unresolved	187	3.2800000000000004e-58	NR	MRC56835.1	1428	g1465	i0	80	12.7117647058824	115	22	67.6	1	447	103	10	123	MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis]	diamond	6483	188	0.99468085106383	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
25258318	25258318	PRJNA1136957_S_NODE_13900_length_232_cov_1.005780_g13803_i0	PRJNA1136957	13900	232	1.00578	2.3334096	Bacillati	1783272	Bacteria	Bacteria	412	8.26e-111	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g13803	i0	98.707	117.086206896552	232	3	100	0	1	232	738	507	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	27164	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
26880710	26880710	PRJNA1136957_S_NODE_3381_length_404_cov_19.742029_g3284_i0	PRJNA1136957	3381	404	19.742029	79.75779716	Bacillus thuringiensis	1428	Bacteria	Bacteria	68.2	2.82e-12	NR	MRA94196.1	1428	g3284	i0	50.9	0.423267326732673	57	28	42.3	0	4	174	12	68	MRA94196.1 hypothetical protein [Bacillus thuringiensis]	diamond	171	68.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
28554863	28554863	PRJNA1136957_S_NODE_13847_length_232_cov_1.763006_g13750_i0	PRJNA1136957	13847	232	1.763006	4.09017392	Streptococcus agalactiae	1311	Bacteria	Bacteria	40.4	0.0445	NR	WP_341775314.1	1311	g13750	i0	57.1	0.362068965517241	28	12	36.2	0	86	169	25	52	WP_341775314.1 reverse transcriptase domain-containing protein, partial [Streptococcus agalactiae]	diamond	84	40.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
29059971	29059971	PRJNA1136957_S_NODE_21228_length_190_cov_2.160305_g21131_i0	PRJNA1136957	21228	190	2.160305	4.1045795	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	52.8	5.15e-6	NR	NLO21705.1	2093811	g21131	i0	57.9	2.4	38	16	60	0	188	75	13	50	NLO21705.1 DEAD/DEAH box helicase [Syntrophomonadaceae bacterium]	diamond	456	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
29407122	29407122	PRJNA1136957_S_NODE_789_length_611_cov_2.594203_g711_i0	PRJNA1136957	789	611	2.594203	15.85058033	Bacillus thuringiensis	1428	Bacteria	Bacteria	82.8	1.24e-16	NR	MRA75726.1	1428	g711	i0	44.3	0.854337152209493	97	54	47.6	0	296	6	4	100	MRA75726.1 hypothetical protein [Bacillus thuringiensis]	diamond	522	82.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
29881013	29881013	PRJNA1136957_S_NODE_18791_length_201_cov_1.119718_g18694_i0	PRJNA1136957	18791	201	1.119718	2.25063318	Hominilimicola	3073565	Bacteria	Bacteria	53.5	5.05e-7	NR	WP_022230028.1	3073565	g18694	i0	43.9	0.850746268656716	57	32	85.1	0	3	173	61	117	WP_022230028.1 MULTISPECIES: hypothetical protein [Hominilimicola]	diamond	171	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Hominilimicola
31397714	31397714	PRJNA1136957_S_NODE_1976_length_475_cov_3.278846_g1879_i0	PRJNA1136957	1976	475	3.278846	15.5745185	Ammoniphilus sp. YIM 78166	1644106	Bacteria	Bacteria	60.8	1.68e-7	NR	WP_134702773.1	1644106	g1879	i0	49.1	0.334736842105263	53	26	32.8	1	437	282	317	369	WP_134702773.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Ammoniphilus sp. YIM 78166]	diamond	159	60.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Ammoniphilus	Ammoniphilus sp. YIM 78166

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