metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1159911" 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
1038042	1038042	PRJNA1159911_P_NODE_99381_length_242_cov_0.911243_g98839_i0	PRJNA1159911	99381	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1859018450\|gb\|CP054831.1\|	29385	g98839	i0	100	24	242	0	100	0	1	242	2625659	2625418	Staphylococcus saprophyticus strain UTI-045 chromosome, complete genome	blastn	5808	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saprophyticus
1583314	1583314	PRJNA1159911_P_NODE_87162_length_251_cov_0.865169_g86620_i0	PRJNA1159911	87162	251	0.865169	2.17157419	Aerococcus viridans	1377	Bacteria	Bacteria	414	2.52e-111	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g86620	i0	96.414	7	251	9	100	0	1	251	101505	101255	Aerococcus viridans strain CCUG4311, complete genome	blastn	1757	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
2313167	2313167	PRJNA1159911_P_NODE_104802_length_208_cov_13.703704_g104260_i0	PRJNA1159911	104802	208	13.703704	28.50370432	root	1	Root_unresolved	Root_unresolved	383	5.69e-102	NTclustered	gi\|2567118815\|gb\|CP132968.1\|	649756	g104260	i0	100	489.442307692308	207	0	99	0	2	208	13042	12836	Anaerostipes hadrus strain BA1 chromosome, complete genome	blastn	101804	383	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerostipes	Anaerostipes hadrus
4865972	4865972	PRJNA1159911_P_NODE_46724_length_362_cov_3.141869_g46182_i0	PRJNA1159911	46724	362	3.141869	11.37356578	root	1	Root_unresolved	Root_unresolved	652	0	NTclustered	gi\|1720595190\|gb\|CP031776.1\|	1404	g46182	i0	99.171	99.8756906077348	362	3	100	0	1	362	6151583	6151944	Priestia megaterium strain Ni2-3 chromosome	blastn	36155	658	0.990881458966565	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
4866067	4866067	PRJNA1159911_P_NODE_92324_length_247_cov_0.885057_g91782_i0	PRJNA1159911	92324	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g91782	i0	100	42	247	0	100	0	1	247	1327886	1328132	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10374	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
6140750	6140750	PRJNA1159911_P_NODE_13965_length_835_cov_1.817585_g13501_i0	PRJNA1159911	13965	835	1.817585	15.17683475	root	1	Root_unresolved	Root_unresolved	1537	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g13501	i0	99.88	49.4634730538922	835	1	100	0	1	835	2428180	2427346	Staphylococcus aureus strain WH9628 chromosome	blastn	41302	1537	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6140896	6140896	PRJNA1159911_P_NODE_90045_length_249_cov_0.875000_g89503_i0	PRJNA1159911	90045	249	0.875	2.17875	Staphylococcus	1279	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1799396010\|gb\|CP047868.1\|	1280	g89503	i0	100	108.899598393574	249	0	100	0	1	249	836	1084	Staphylococcus aureus strain UP_419 plasmid unnamed, complete sequence	blastn	27116	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6685081	6685081	PRJNA1159911_P_NODE_104926_length_201_cov_5.812500_g104384_i0	PRJNA1159911	104926	201	5.8125	11.683125	Ruminiclostridium cellulolyticum	1521	Bacteria	Bacteria	84.2	6.2e-12	NTclustered	gi\|219997787\|gb\|CP001348.1\|	394503	g104384	i0	87.5	0.358208955223881	72	9	36	0	113	184	4054952	4054881	Ruminiclostridium cellulolyticum H10 chromosome, complete genome	blastn	72	84.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium cellulolyticum
7415904	7415904	PRJNA1159911_P_NODE_66326_length_292_cov_2.324201_g65784_i0	PRJNA1159911	66326	292	2.324201	6.78666692	Staphylococcus	1279	Bacteria	Bacteria	529	1.0299999999999996e-145	NTclustered	gi\|2688295587\|gb\|CP145595.1\|	29388	g65784	i0	99.315	42.9246575342466	292	2	100	0	1	292	1532428	1532719	Staphylococcus capitis strain kcgeb_sa chromosome, complete genome	blastn	12534	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
7415970	7415970	PRJNA1159911_P_NODE_96506_length_244_cov_0.900585_g95964_i0	PRJNA1159911	96506	244	0.900585	2.1974274	Faecalibacterium	216851	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|2739152576\|gb\|CP157369.1\|	853	g95964	i0	98.776	31.3975409836066	245	2	100	1	1	244	2529555	2529311	Faecalibacterium prausnitzii strain 5 chromosome, complete genome	blastn	7661	435	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
8690877	8690877	PRJNA1159911_P_NODE_100907_length_241_cov_0.916667_g100365_i0	PRJNA1159911	100907	241	0.916667	2.20916747	Veillonella	29465	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1175700537\|gb\|CP020566.1\|	39777	g100365	i0	98.34	15.9875518672199	241	4	100	0	1	241	239624	239864	Veillonella atypica strain OK5, complete genome	blastn	3853	424	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
8690986	8690986	PRJNA1159911_P_NODE_70047_length_283_cov_2.476190_g69505_i0	PRJNA1159911	70047	283	2.47619	7.0076177	Streptococcus	1301	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g69505	i0	100	563.144876325088	283	0	100	0	1	283	17861	18143	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	159370	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
8691037	8691037	PRJNA1159911_P_NODE_89007_length_250_cov_0.870056_g88465_i0	PRJNA1159911	89007	250	0.870056	2.17514	Bacillus	1386	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2808210981\|gb\|CP169739.1\|	2026186	g88465	i0	100	99.952	250	0	100	0	1	250	1326835	1327084	Bacillus paranthracis strain mr-1B chromosome, complete genome	blastn	24988	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
9236686	9236686	PRJNA1159911_P_NODE_90388_length_248_cov_2.702857_g89846_i0	PRJNA1159911	90388	248	2.702857	6.70308536	Pseudoflavonifractor gallinarum	2779352	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2777655128\|dbj\|AP031438.1\|	2779352	g89846	i0	96.774	0.237903225806452	31	1	13	0	9	39	1277130	1277100	Pseudoflavonifractor gallinarum i42-0019-1B4 DNA, complete genome	blastn	59	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pseudoflavonifractor	Pseudoflavonifractor gallinarum
9966180	9966180	PRJNA1159911_P_NODE_99528_length_242_cov_0.911243_g98986_i0	PRJNA1159911	99528	242	0.911243	2.20520806	Lactococcus	1357	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|2571117238\|gb\|CP133260.1\|	1358	g98986	i0	99.174	99.4297520661157	242	2	100	0	1	242	627716	627475	Lactococcus lactis strain DRD-49 chromosome	blastn	24062	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
13060840	13060840	PRJNA1159911_P_NODE_103831_length_229_cov_2.185897_g103289_i0	PRJNA1159911	103831	229	2.185897	5.00570413	Eubacterium ventriosum	39496	Bacteria	Bacteria	396	8.1899999999999985e-106	NTclustered	gi\|2299453608\|gb\|CP102282.1\|	39496	g103289	i0	97.817	407.157205240175	229	5	100	0	1	229	187465	187237	Eubacterium ventriosum strain ATCC 27560 chromosome, complete genome	blastn	93239	396	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium ventriosum
13062333	13062333	PRJNA1159911_P_NODE_87571_length_251_cov_0.865169_g87029_i0	PRJNA1159911	87571	251	0.865169	2.17157419	Staphylococcus aureus	1280	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2056397904\|gb\|CP076845.1\|	1280	g87029	i0	99.602	5.02788844621514	251	1	100	0	1	251	1734	1484	Staphylococcus aureus strain 55-100-003 plasmid unnamed2, complete sequence	blastn	1262	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13062436	13062436	PRJNA1159911_P_NODE_93171_length_246_cov_2.439306_g92629_i0	PRJNA1159911	93171	246	2.439306	6.00069276	Finegoldia magna	1260	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g92629	i0	98.374	2	246	4	100	0	1	246	586079	585834	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	492	433	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
13791353	13791353	PRJNA1159911_P_NODE_97971_length_243_cov_0.905882_g97429_i0	PRJNA1159911	97971	243	0.905882	2.20129326	Lactococcus	1357	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g97429	i0	100	99.9506172839506	243	0	100	0	1	243	1859735	1859977	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	24288	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
14336101	14336101	PRJNA1159911_P_NODE_104872_length_204_cov_12.717557_g104330_i0	PRJNA1159911	104872	204	12.717557	25.94381628	Eisenbergiella porci	2652274	Bacteria	Bacteria	339	1.22e-88	NTclustered	gi\|2777680868\|dbj\|AP031441.1\|	2652274	g104330	i0	96.569	477.93137254902	204	7	100	0	1	204	5815891	5815688	Eisenbergiella porci k07-0079-E9-1 DNA, complete genome	blastn	97498	339	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Eisenbergiella	Eisenbergiella porci
14337836	14337836	PRJNA1159911_P_NODE_98112_length_243_cov_0.905882_g97570_i0	PRJNA1159911	98112	243	0.905882	2.20129326	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1015656038\|gb\|CP013911.1\|	1283	g97570	i0	100	89.9876543209877	243	0	100	0	1	243	246060	245818	Staphylococcus haemolyticus strain S167 chromosome, complete genome	blastn	21867	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
15065729	15065729	PRJNA1159911_P_NODE_89572_length_249_cov_1.227273_g89030_i0	PRJNA1159911	89572	249	1.227273	3.05590977	root	1	Root_unresolved	Root_unresolved	52.8	0.023	NTclustered	gi\|2070286234\|gb\|CP067054.1\|	1405	g89030	i0	100	0.449799196787149	28	0	11	0	30	57	531312	531339	Bacillus mycoides strain JAS 83/3 plasmid pl546, complete sequence	blastn	112	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
17615764	17615764	PRJNA1159911_P_NODE_88454_length_250_cov_0.870056_g87912_i0	PRJNA1159911	88454	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2688295587\|gb\|CP145595.1\|	29388	g87912	i0	100	97.984	250	0	100	0	1	250	2364698	2364449	Staphylococcus capitis strain kcgeb_sa chromosome, complete genome	blastn	24496	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
18889569	18889569	PRJNA1159911_P_NODE_86415_length_251_cov_2.876404_g85873_i0	PRJNA1159911	86415	251	2.876404	7.21977404	Bacillales	1385	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g85873	i0	99.602	518.836653386454	251	1	100	0	1	251	748835	748585	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	130228	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20164413	20164413	PRJNA1159911_P_NODE_91196_length_248_cov_0.880000_g90654_i0	PRJNA1159911	91196	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	52.8	0.022	NTclustered	gi\|1725891507\|gb\|CP042874.1\|	1396	g90654	i0	100	1.00403225806452	28	0	11	0	25	52	4712658	4712631	Bacillus cereus strain 09 chromosome, complete genome	blastn	249	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
20164414	20164414	PRJNA1159911_P_NODE_91376_length_248_cov_0.880000_g90834_i0	PRJNA1159911	91376	248	0.88	2.1824	Staphylococcus	1279	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g90834	i0	100	42	248	0	100	0	1	248	1323268	1323021	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10416	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
25264289	25264289	PRJNA1159911_P_NODE_82480_length_258_cov_1.664865_g81938_i0	PRJNA1159911	82480	258	1.664865	4.2953517	Staphylococcus	1279	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2873239904\|gb\|CP176713.1\|	1280	g81938	i0	100	111.992248062016	258	0	100	0	1	258	1512	1769	Staphylococcus aureus strain GTVSS-008 plasmid pCFSAN137043_1, complete sequence	blastn	28894	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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