metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA897077" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA897077" 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
3424389	3424389	PRJNA897077_P_NODE_15803_length_252_cov_0.871508_g15676_i0	PRJNA897077	15803	252	0.871508	2.19620016	Staphylococcus epidermidis	1282	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g15676	i0	100	100	252	0	100	0	1	252	2067925	2067674	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	25200	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5072194	5072194	PRJNA897077_P_NODE_15724_length_252_cov_0.871508_g15597_i0	PRJNA897077	15724	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	466	6.89e-127	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g15597	i0	100	100	252	0	100	0	1	252	1779744	1779995	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25200	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5976961	5976961	PRJNA897077_P_NODE_18885_length_244_cov_0.912281_g18758_i0	PRJNA897077	18885	244	0.912281	2.22596564	Enterococcus faecalis	1351	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1963759427\|emb\|LR962161.1\|	1351	g18758	i0	100	100	244	0	100	0	1	244	603431	603188	Enterococcus faecalis isolate 26975_2#91 genome assembly, chromosome: 1	blastn	24400	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
7251926	7251926	PRJNA897077_P_NODE_8526_length_336_cov_3.844106_g8399_i0	PRJNA897077	8526	336	3.844106	12.91619616	Aedoeadaptatus ivorii	54006	Bacteria	Bacteria	499	9.42e-137	NTclustered	gi\|1540269385\|emb\|LR134523.1\|	54006	g8399	i0	93.713	392.220238095238	334	19	99	1	3	336	455966	455635	Peptoniphilus ivorii strain NCTC13079 genome assembly, chromosome: 1	blastn	131786	499	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Aedoeadaptatus	Aedoeadaptatus ivorii
7622228	7622228	PRJNA897077_P_NODE_9346_length_322_cov_1.702811_g9219_i0	PRJNA897077	9346	322	1.702811	5.48305142	Streptococcus	1301	Bacteria	Bacteria	590	5.18e-164	NTclustered	gi\|2007100869\|gb\|CP071697.1\|	1307	g9219	i0	99.69	395.003105590062	323	0	100	1	1	322	20301	19979	Streptococcus suis strain 1112S chromosome, complete genome	blastn	127191	595	0.991596638655462	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
11447894	11447894	PRJNA897077_P_NODE_269_length_1596_cov_7.588969_g236_i0	PRJNA897077	269	1596	7.588969	121.11994524	Clostridium	1485	Bacteria	Bacteria	54.7	0.046	NTclustered	gi\|2425298477\|gb\|CP114763.1\|	1492	g236	i0	100	0.381578947368421	29	0	2	0	1441	1469	3511036	3511064	Clostridium butyricum strain LV1 chromosome 1, complete sequence	blastn	609	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
11447924	11447924	PRJNA897077_P_NODE_6789_length_374_cov_1.036545_g6662_i0	PRJNA897077	6789	374	1.036545	3.8766783	Planococcus	1372	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2533127305\|gb\|CP129238.1\|	3058394	g6662	i0	94.444	0.192513368983957	36	0	9	2	186	219	2051090	2051125	Planococcus liqunii strain N056 chromosome, complete genome	blastn	72	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus liqunii
12352564	12352564	PRJNA897077_P_NODE_18110_length_246_cov_0.901734_g17983_i0	PRJNA897077	18110	246	0.901734	2.21826564	Exiguobacterium profundum	307643	Bacteria	Bacteria	383	6.94e-102	NTclustered	gi\|2621702593\|emb\|OY760436.1\|	307643	g17983	i0	94.715	4.97560975609756	246	13	100	0	1	246	2551212	2550967	MAG: Exiguobacterium profundum isolate 8ac3ae97-4b35-4674-8cf6-a299ed097117 genome assembly, chromosome: 1	blastn	1224	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
12352589	12352589	PRJNA897077_P_NODE_19450_length_243_cov_0.917647_g19323_i0	PRJNA897077	19450	243	0.917647	2.22988221	Staphylococcus caprae	29380	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1467488938\|dbj\|AP018587.1\|	29380	g19323	i0	100	99.7448559670782	243	0	100	0	1	243	1512900	1513142	Staphylococcus caprae JMUB898 DNA, complete genome	blastn	24238	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus caprae
12352602	12352602	PRJNA897077_P_NODE_2130_length_656_cov_2.000000_g2004_i0	PRJNA897077	2130	656	2	13.12	Cohnella herbarum	2728023	Bacteria	Bacteria	353	1.6e-92	NTclustered	gi\|1835036924\|gb\|CP051680.1\|	2728023	g2004	i0	76.866	545.78506097561	670	128	100	25	1	656	7674666	7675322	Cohnella herbarum strain MFER-1 chromosome, complete genome	blastn	358035	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella herbarum
12723689	12723689	PRJNA897077_P_NODE_18150_length_246_cov_0.901734_g18023_i0	PRJNA897077	18150	246	0.901734	2.21826564	Staphylococcus	1279	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1908784908\|gb\|CP051991.1\|	1280	g18023	i0	100	100	246	0	100	0	1	246	1829243	1829488	Staphylococcus aureus strain ER08597.3 chromosome, complete genome	blastn	24600	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13998090	13998090	PRJNA897077_P_NODE_4651_length_448_cov_2.418667_g4524_i0	PRJNA897077	4651	448	2.418667	10.83562816	Bacillus	1386	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g4524	i0	100	0.125	28	0	6	0	314	341	353136	353109	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
15272066	15272066	PRJNA897077_P_NODE_18632_length_245_cov_0.906977_g18505_i0	PRJNA897077	18632	245	0.906977	2.22209365	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g18505	i0	100	35.3510204081633	245	0	100	0	1	245	1063787	1063543	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	8661	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
16546629	16546629	PRJNA897077_P_NODE_11233_length_295_cov_1.405405_g11106_i0	PRJNA897077	11233	295	1.405405	4.14594475	Staphylococcus	1279	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1908784908\|gb\|CP051991.1\|	1280	g11106	i0	100	100	295	0	100	0	1	295	874137	873843	Staphylococcus aureus strain ER08597.3 chromosome, complete genome	blastn	29500	545	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19095648	19095648	PRJNA897077_P_NODE_17375_length_248_cov_0.891429_g17248_i0	PRJNA897077	17375	248	0.891429	2.21074392	Bacilli	91061	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2624851785\|gb\|CP120025.1\|	1280	g17248	i0	100	107.54435483871	248	0	100	0	1	248	2702308	2702061	Staphylococcus aureus strain Dog145 chromosome, complete genome	blastn	26671	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19095672	19095672	PRJNA897077_P_NODE_2055_length_667_cov_2.739057_g1929_i0	PRJNA897077	2055	667	2.739057	18.26951019	Streptococcus	1301	Bacteria	Bacteria	1227	0	NTclustered	gi\|2197967995\|gb\|CP031970.1\|	1307	g1929	i0	99.85	391.481259370315	667	1	100	0	1	667	19714	20380	Streptococcus suis strain SFJ44 chromosome, complete genome	blastn	261118	1227	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
20000091	20000091	PRJNA897077_P_NODE_11436_length_292_cov_1.424658_g11309_i0	PRJNA897077	11436	292	1.424658	4.16000136	Staphylococcus hominis	1290	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g11309	i0	100	26.5719178082192	292	0	100	0	1	292	2163213	2163504	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	7759	540	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
21275535	21275535	PRJNA897077_P_NODE_15717_length_252_cov_0.871508_g15590_i0	PRJNA897077	15717	252	0.871508	2.19620016	Anaerococcus sp. WGS1579	3366809	Bacteria	Bacteria	291	4.45e-74	NTclustered	gi\|2831319668\|gb\|CP171106.1\|	3366809	g15590	i0	88.477	0.964285714285714	243	25	96	3	1	243	734644	734405	Anaerococcus sp. WGS1579 chromosome, complete genome	blastn	243	291	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1579
22921744	22921744	PRJNA897077_P_NODE_11898_length_287_cov_1.420561_g11771_i0	PRJNA897077	11898	287	1.420561	4.07701007	Staphylococcus	1279	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g11771	i0	100	100	287	0	100	0	1	287	544043	544329	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	28700	531	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
23825708	23825708	PRJNA897077_P_NODE_13579_length_269_cov_3.882653_g13452_i0	PRJNA897077	13579	269	3.882653	10.44433657	Acetilactobacillus jinshanensis	1720083	Bacteria	Bacteria	453	5.78e-123	NTclustered	gi\|1595678381\|gb\|CP034726.1\|	1720083	g13452	i0	99.597	1.84386617100372	248	1	92	0	22	269	152034	152281	Acetilactobacillus jinshanensis strain HSLZ-75 chromosome, complete genome	blastn	496	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Acetilactobacillus	Acetilactobacillus jinshanensis
23825795	23825795	PRJNA897077_P_NODE_18499_length_245_cov_0.906977_g18372_i0	PRJNA897077	18499	245	0.906977	2.22209365	Acetilactobacillus jinshanensis	1720083	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1595678381\|gb\|CP034726.1\|	1720083	g18372	i0	100	8.7265306122449	245	0	100	0	1	245	227420	227176	Acetilactobacillus jinshanensis strain HSLZ-75 chromosome, complete genome	blastn	2138	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Acetilactobacillus	Acetilactobacillus jinshanensis
25099634	25099634	PRJNA897077_P_NODE_18880_length_244_cov_0.912281_g18753_i0	PRJNA897077	18880	244	0.912281	2.22596564	Staphylococcus hominis	1290	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1780387727\|gb\|CP046306.1\|	1290	g18753	i0	100	26	244	0	100	0	1	244	1366532	1366775	Staphylococcus hominis strain FDAARGOS_746 chromosome, complete genome	blastn	6344	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
25470871	25470871	PRJNA897077_P_NODE_18200_length_246_cov_0.901734_g18073_i0	PRJNA897077	18200	246	0.901734	2.21826564	Staphylococcus	1279	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g18073	i0	99.187	88.8211382113821	246	2	100	0	1	246	1294123	1294368	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	21850	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis

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