metadata: contig_metadata: 20 rows where bioproject = "PRJNA685060" and tax

20 rows where bioproject = "PRJNA685060" 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
1942132	1942132	PRJNA685060_P_NODE_16922_length_243_cov_0.823529_g16832_i0	PRJNA685060	16922	243	0.823529	2.00117547	Metasolibacillus sp. FSL H7-0170	2921431	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2723342317\|gb\|CP151964.1\|	2921431	g16832	i0	100	1073.15226337449	243	0	100	0	1	243	2373141	2372899	Metasolibacillus sp. FSL H7-0170 chromosome, complete genome	blastn	260776	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Metasolibacillus	Metasolibacillus sp. FSL H7-0170
4494034	4494034	PRJNA685060_P_NODE_11704_length_273_cov_1.345000_g11614_i0	PRJNA685060	11704	273	1.345	3.67185	Enterococcus faecalis	1351	Bacteria	Bacteria	477	3.489999999999999e-130	NTclustered	gi\|2576124523\|gb\|CP133758.1\|	1351	g11614	i0	98.168	179.59706959707	273	5	100	0	1	273	1043273	1043001	Enterococcus faecalis strain GG-Efs-0013 chromosome	blastn	49030	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
4494086	4494086	PRJNA685060_P_NODE_17304_length_242_cov_0.911243_g17214_i0	PRJNA685060	17304	242	0.911243	2.20520806	Staphylococcus hominis	1290	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g17214	i0	100	43.2148760330578	242	0	100	0	1	242	970171	970412	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	10458	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
8319278	8319278	PRJNA685060_P_NODE_16587_length_243_cov_0.905882_g16497_i0	PRJNA685060	16587	243	0.905882	2.20129326	Streptococcus thermophilus	1308	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1052539173\|gb\|CP016877.1\|	1308	g16497	i0	100	100	243	0	100	0	1	243	1178613	1178855	Streptococcus thermophilus strain KLDS 3.1003, complete genome	blastn	24300	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
10104688	10104688	PRJNA685060_P_NODE_16408_length_244_cov_0.900585_g16318_i0	PRJNA685060	16408	244	0.900585	2.1974274	Peptoniphilus	162289	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g16318	i0	97.951	520.401639344262	244	5	100	0	1	244	765384	765141	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	126978	424	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
10104689	10104689	PRJNA685060_P_NODE_16448_length_244_cov_0.900585_g16358_i0	PRJNA685060	16448	244	0.900585	2.1974274	Leuconostoc	1243	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|507148371\|ref\|NR_103174.1\|	1244	g16358	i0	99.588	339.647540983607	243	1	99	0	1	243	31	273	Leuconostoc gelidum strain JB7 23S ribosomal RNA gene, complete sequence	blastn	82874	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc gelidum
10870149	10870149	PRJNA685060_P_NODE_14109_length_249_cov_1.312500_g14019_i0	PRJNA685060	14109	249	1.3125	3.268125	Gemella morbillorum	29391	Bacteria	Bacteria	69.4	2.24e-7	NTclustered	gi\|1403530627\|emb\|LS483440.1\|	29391	g14019	i0	75.309	28.289156626506	162	30	69	7	83	244	10680	10529	Gemella morbillorum strain NCTC11323 genome assembly, chromosome: 1	blastn	7044	69.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella morbillorum
11379579	11379579	PRJNA685060_P_NODE_16969_length_242_cov_1.355030_g16879_i0	PRJNA685060	16969	242	1.35503	3.2791726	Streptococcus	1301	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|552060241\|gb\|CP006805.1\|	1156431	g16879	i0	99.587	555.5	242	1	100	0	1	242	1539179	1538938	Streptococcus sp. I-G2, complete genome	blastn	134431	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus ilei
12145478	12145478	PRJNA685060_P_NODE_14090_length_249_cov_1.511364_g14000_i0	PRJNA685060	14090	249	1.511364	3.76329636	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2288179604\|gb\|CP102659.1\|	1283	g14000	i0	99.197	96.4618473895582	249	2	100	0	1	249	1396671	1396423	Staphylococcus haemolyticus strain 4M chromosome, complete genome	blastn	24019	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
16478862	16478862	PRJNA685060_P_NODE_17653_length_241_cov_0.916667_g17563_i0	PRJNA685060	17653	241	0.916667	2.20916747	Clostridia	186801	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2238281809\|gb\|CP096649.1\|	938288	g17563	i0	99.174	398.020746887967	242	1	100	1	1	241	17852	17611	Fenollaria massiliensis strain C0061C2 chromosome, complete genome	blastn	95923	435	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Fenollaria	Fenollaria massiliensis
17244086	17244086	PRJNA685060_P_NODE_14054_length_250_cov_0.864407_g13964_i0	PRJNA685060	14054	250	0.864407	2.1610175	Staphylococcus epidermidis	1282	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2811870118\|gb\|CP170248.1\|	1282	g13964	i0	100	98.628	250	0	100	0	1	250	1100438	1100687	Staphylococcus epidermidis strain PS25 chromosome, complete genome	blastn	24657	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18518282	18518282	PRJNA685060_P_NODE_5975_length_393_cov_0.925000_g5885_i0	PRJNA685060	5975	393	0.925	3.63525	Enterococcus durans	53345	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1723306449\|gb\|CP042597.1\|	53345	g5885	i0	100	0.498727735368957	28	0	7	0	86	113	2356796	2356769	Enterococcus durans strain VREdu chromosome	blastn	196	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus durans
25402556	25402556	PRJNA685060_P_NODE_16260_length_244_cov_0.900585_g16170_i0	PRJNA685060	16260	244	0.900585	2.1974274	Leuconostoc	1243	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1049190680\|gb\|CP016598.1\|	1246	g16170	i0	99.59	332.004098360656	244	1	100	0	1	244	432023	432266	Leuconostoc lactis strain WiKim40, complete sequence.	blastn	81009	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc lactis
29135102	29135102	PRJNA685060_P_NODE_6349_length_379_cov_1.183007_g6259_i0	PRJNA685060	6349	379	1.183007	4.48359653	Bacillota bacterium	1879010	Bacteria	Bacteria	44.3	0.0383	NR	NLU41568.1	1879010	g6259	i0	37.3	0.656992084432718	83	42	57.8	3	1	219	119	201	NLU41568.1 carbon-nitrogen hydrolase family protein [Bacillota bacterium]	diamond	249	44.3	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29481862	29481862	PRJNA685060_P_NODE_5970_length_393_cov_1.062500_g5880_i0	PRJNA685060	5970	393	1.0625	4.175625	Mediterraneibacter gnavus	33038	Bacteria	Bacteria	44.7	0.026	NR	WP_101885712.1	33038	g5880	i0	27.2	0.618320610687023	81	55	61.8	1	113	355	2	78	WP_101885712.1 helix-turn-helix domain-containing protein [Mediterraneibacter gnavus]	diamond	243	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
29987454	29987454	PRJNA685060_P_NODE_13031_length_255_cov_1.269231_g12941_i0	PRJNA685060	13031	255	1.269231	3.23653905	Paraclostridium ghonii	29358	Bacteria	Bacteria	73.2	5.49e-13	NR	WP_307508597.1	29358	g12941	i0	45.2	2.55294117647059	73	39	85.9	1	35	253	6	77	WP_307508597.1 catalase [Paraclostridium ghonii]	diamond	651	73.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium ghonii
30272051	30272051	PRJNA685060_P_NODE_10492_length_291_cov_0.990826_g10402_i0	PRJNA685060	10492	291	0.990826	2.88330366	uncultured Brevibacillus sp.	169970	Bacteria	Bacteria	44.7	0.0126	NR	WP_289139644.1	169970	g10402	i0	28.4	0.690721649484536	67	48	69.1	0	40	240	207	273	WP_289139644.1 MerR family transcriptional regulator [uncultured Brevibacillus sp.]	diamond	201	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	uncultured Brevibacillus sp.
30493008	30493008	PRJNA685060_P_NODE_13433_length_251_cov_0.865169_g13343_i0	PRJNA685060	13433	251	0.865169	2.17157419	Staphylococcus hominis	1290	Bacteria	Bacteria	163	1.45e-44	NR	WP_143129574.1	1290	g13343	i0	100	0.99203187250996006	83	0	99.2	0	249	1	683	765	WP_143129574.1 CapA family protein [Staphylococcus hominis]	diamond	249	163	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
31610896	31610896	PRJNA685060_P_NODE_11596_length_274_cov_1.915423_g11506_i0	PRJNA685060	11596	274	1.915423	5.24825902	Bacillati	1783272	Bacteria	Bacteria	45.4	0.00505	NR	PCZ68894.1	1639	g11506	i0	51.1	4.01824817518248	47	20	48.2	1	156	25	181	227	PCZ68894.1 excinuclease ABC subunit B, partial [Listeria monocytogenes]	diamond	1101	45.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
32528515	32528515	PRJNA685060_P_NODE_6479_length_375_cov_1.317881_g6389_i0	PRJNA685060	6479	375	1.317881	4.94205375	Bacteria	2	Bacteria	Bacteria	80.1	7.23e-15	NR	MBQ6569760.1	2044939	g6389	i0	44.1	4.568	102	55	80	1	375	76	172	273	MBQ6569760.1 UDP-glucose 4-epimerase GalE [Clostridia bacterium]	diamond	1713	80.9	0.990111248454882	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium

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