metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA806354" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA806354" 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
1222400	1222400	PRJNA806354_P_NODE_41581_length_239_cov_2.759036_g41472_i0	PRJNA806354	41581	239	2.759036	6.59409604	Streptococcus	1301	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g41472	i0	99.582	325	239	1	100	0	1	239	1570635	1570397	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	77675	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
2497940	2497940	PRJNA806354_P_NODE_30342_length_270_cov_0.771574_g30233_i0	PRJNA806354	30342	270	0.771574	2.0832498	Bacillati	1783272	Bacteria	Bacteria	479	9.58e-131	NTclustered	gi\|2094469357\|gb\|OK103765.1\|	69967	g30233	i0	98.881	99.237037037037	268	3	99	0	3	270	44	311	Macrococcus equipercicus strain LT-01 16S ribosomal RNA gene, partial sequence	blastn	26794	479	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus equipercicus
3357021	3357021	PRJNA806354_P_NODE_39643_length_243_cov_2.258824_g39534_i0	PRJNA806354	39643	243	2.258824	5.48894232	Ezakiella coagulans	46507	Bacteria	Bacteria	381	2.4599999999999995e-101	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g39534	i0	96.916	0.934156378600823	227	7	93	0	17	243	1177721	1177947	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	227	381	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
5050464	5050464	PRJNA806354_P_NODE_29724_length_272_cov_1.653266_g29615_i0	PRJNA806354	29724	272	1.653266	4.49688352	Staphylococcus	1279	Bacteria	Bacteria	497	2.67e-136	NTclustered	gi\|1844054309\|gb\|CP053477.1\|	1292	g29615	i0	99.632	22.9227941176471	272	1	100	0	1	272	233808	234079	Staphylococcus warneri strain WB224 chromosome, complete genome	blastn	6235	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
5909398	5909398	PRJNA806354_P_NODE_28165_length_278_cov_5.063415_g28056_i0	PRJNA806354	28165	278	5.063415	14.0762937	uncultured Listeria sp.	592375	Bacteria	Bacteria	351	2.25e-92	NTclustered	gi\|453201751\|gb\|JQ999659.1\|	592375	g28056	i0	90.217	373.262589928058	276	17	97	9	2	270	510	238	Uncultured Listeria sp. clone GKJWQY101AOVRM 23S ribosomal RNA gene, partial sequence	blastn	103767	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	uncultured Listeria sp.
6326368	6326368	PRJNA806354_P_NODE_26585_length_286_cov_1.431925_g26476_i0	PRJNA806354	26585	286	1.431925	4.0953055	Staphylococcus	1279	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g26476	i0	100	100	286	0	100	0	1	286	917563	917848	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	28600	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8459041	8459041	PRJNA806354_P_NODE_36167_length_249_cov_1.732955_g36058_i0	PRJNA806354	36167	249	1.732955	4.31505795	Staphylococcus epidermidis	1282	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g36058	i0	100	99.995983935743	249	0	100	0	1	249	1915167	1915415	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24899	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8459103	8459103	PRJNA806354_P_NODE_41887_length_235_cov_4.049383_g41778_i0	PRJNA806354	41887	235	4.049383	9.51605005	Abyssicoccus albus	1817405	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g41778	i0	100	569.225531914894	235	0	100	0	1	235	292866	293100	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	133768	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
10150936	10150936	PRJNA806354_P_NODE_42168_length_232_cov_2.603774_g42059_i0	PRJNA806354	42168	232	2.603774	6.04075568	root	1	Root_unresolved	Root_unresolved	429	8.2e-116	NTclustered	gi\|2484409883\|gb\|OQ804706.1\|	1282	g42059	i0	100	180	232	0	100	0	1	232	586	817	Staphylococcus epidermidis strain RPB-57 16S ribosomal RNA gene, partial sequence	blastn	41760	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11426197	11426197	PRJNA806354_P_NODE_15809_length_360_cov_3.066202_g15700_i0	PRJNA806354	15809	360	3.066202	11.0383272	Macrococcus	69965	Bacteria	Bacteria	412	1.3599999999999994e-110	NTclustered	gi\|2899141610\|gb\|CP179728.1\|	3395466	g15700	i0	94.118	376.2	272	14	75	2	91	360	1157849	1158120	Macrococcus sp. 18KM676 chromosome, complete genome	blastn	135432	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus sp. 18KM676
11426198	11426198	PRJNA806354_P_NODE_17589_length_343_cov_7.659259_g17480_i0	PRJNA806354	17589	343	7.659259	26.27125837	root	1	Root_unresolved	Root_unresolved	634	2.5299999999999996e-177	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g17480	i0	100	99.3061224489796	343	0	100	0	1	343	2463320	2463662	Staphylococcus aureus strain WH9628 chromosome	blastn	34062	634	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13559564	13559564	PRJNA806354_P_NODE_26451_length_286_cov_3.211268_g26342_i0	PRJNA806354	26451	286	3.211268	9.18422648	Abyssicoccus albus	1817405	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1142909432\|gb\|CP019573.1\|	1817405	g26342	i0	100	587.727272727273	286	0	100	0	1	286	292213	292498	Abyssicoccus albus strain S31 chromosome, complete genome	blastn	168090	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Abyssicoccaceae	Abyssicoccus	Abyssicoccus albus
13976271	13976271	PRJNA806354_P_NODE_41591_length_239_cov_2.656627_g41482_i0	PRJNA806354	41591	239	2.656627	6.34933853	Enterococcus	1350	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|2236304959\|gb\|CP097038.1\|	1351	g41482	i0	100	100	239	0	100	0	1	239	143790	144028	Enterococcus faecalis strain AT39 chromosome, complete genome	blastn	23900	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
16108576	16108576	PRJNA806354_P_NODE_8173_length_488_cov_2.279518_g8064_i0	PRJNA806354	8173	488	2.279518	11.12404784	Staphylococcus warneri	1292	Bacteria	Bacteria	564	4.94e-156	NTclustered	gi\|1714036495\|gb\|CP031269.1\|	1292	g8064	i0	87.6	508.340163934426	500	45	99	14	3	487	2267399	2266902	Staphylococcus warneri strain 16A chromosome, complete genome	blastn	248070	564	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
17384336	17384336	PRJNA806354_P_NODE_33794_length_256_cov_1.448087_g33685_i0	PRJNA806354	33794	256	1.448087	3.70710272	Faecalitalea cylindroides	39483	Bacteria	Bacteria	418	1.9899999999999994e-112	NTclustered	gi\|295098739\|emb\|FP929041.1\|	717960	g33685	i0	98.723	444.171875	235	3	92	0	18	252	137478	137244	Eubacterium cylindroides T2-87 draft genome	blastn	113708	418	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Faecalitalea	Faecalitalea cylindroides
17799964	17799964	PRJNA806354_P_NODE_31814_length_264_cov_1.151832_g31705_i0	PRJNA806354	31814	264	1.151832	3.04083648	Weissella	46255	Bacteria	Bacteria	390	4.5e-104	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g31705	i0	96.596	555.681818181818	235	8	90	0	30	264	20341	20107	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	146700	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
17799974	17799974	PRJNA806354_P_NODE_7454_length_510_cov_1.421053_g7345_i0	PRJNA806354	7454	510	1.421053	7.2473703	Aerococcus	1375	Bacteria	Bacteria	832	0	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g7345	i0	98.517	667.421568627451	472	6	92	1	3	473	19100	18629	Aerococcus viridans strain CCUG4311, complete genome	blastn	340385	837	0.994026284348865	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
20348769	20348769	PRJNA806354_P_NODE_28976_length_275_cov_1.886139_g28867_i0	PRJNA806354	28976	275	1.886139	5.18688225	Streptococcus	1301	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|1578096036\|emb\|LR216035.1\|	1313	g28867	i0	100	334.312727272727	272	0	99	0	4	275	1835238	1834967	Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1	blastn	91936	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
25032478	25032478	PRJNA806354_P_NODE_32460_length_261_cov_1.632979_g32351_i0	PRJNA806354	32460	261	1.632979	4.26207519	Streptococcus sp. NPS 308	1902136	Bacteria	Bacteria	464	2.5799999999999994e-126	NTclustered	gi\|1080114141\|dbj\|AP017652.1\|	1902136	g32351	i0	98.846	99.3371647509579	260	3	99	0	2	261	1395628	1395887	Streptococcus sp. NPS 308 DNA, complete genome	blastn	25927	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. NPS 308
25032544	25032544	PRJNA806354_P_NODE_40380_length_242_cov_1.674556_g40271_i0	PRJNA806354	40380	242	1.674556	4.05242552	Staphylococcus epidermidis	1282	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g40271	i0	100	100	242	0	100	0	1	242	241208	240967	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	24200	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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