metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA685060" and tax

13 rows where analysis = "blastn", 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

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