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

27 rows where analysis = "blastn", bioproject = "PRJNA596870" 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
568474	568474	PRJNA596870_P_NODE_30681_length_250_cov_0.870056_g30548_i0	PRJNA596870	30681	250	0.870056	2.17514	Carnobacterium maltaromaticum	2751	Bacteria	Bacteria	370	5.499999999999999e-98	NTclustered	gi\|1782715578\|gb\|CP045040.1\|	2751	g30548	i0	93.548	1.984	248	16	99	0	1	248	1005820	1005573	Carnobacterium maltaromaticum strain 18ISCm chromosome, complete genome	blastn	496	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
568612	568612	PRJNA596870_P_NODE_37781_length_243_cov_0.905882_g37648_i0	PRJNA596870	37781	243	0.905882	2.20129326	Agathobacter rectalis	39491	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2264318351\|gb\|CP100127.1\|	39491	g37648	i0	99.588	7	243	1	100	0	1	243	1912487	1912729	Agathobacter rectalis strain NB2A-17-FMU chromosome	blastn	1701	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
1140533	1140533	PRJNA596870_P_NODE_33641_length_247_cov_0.885057_g33508_i0	PRJNA596870	33641	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g33508	i0	100	100	247	0	100	0	1	247	2108447	2108693	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24700	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
1843880	1843880	PRJNA596870_P_NODE_21082_length_291_cov_1.697248_g20949_i0	PRJNA596870	21082	291	1.697248	4.93899168	Carnobacterium maltaromaticum	2751	Bacteria	Bacteria	281	3.16e-71	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g20949	i0	100	3.08247422680412	152	0	100	0	1	152	1929725	1929876	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	897	281	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
1844191	1844191	PRJNA596870_P_NODE_36742_length_244_cov_0.900585_g36609_i0	PRJNA596870	36742	244	0.900585	2.1974274	Staphylococcus arlettae	29378	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2090321548\|gb\|CP082337.1\|	29378	g36609	i0	100	60.8770491803279	244	0	100	0	1	244	7314	7557	Staphylococcus arlettae strain AHKW2e plasmid pAHKW2e, complete sequence	blastn	14854	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus arlettae
3119377	3119377	PRJNA596870_P_NODE_25623_length_268_cov_1.579487_g25490_i0	PRJNA596870	25623	268	1.579487	4.23302516	Streptococcus sp. SN-1	3074854	Bacteria	Bacteria	490	4.39e-134	NTclustered	gi\|2747375947\|dbj\|AP028929.1\|	3074854	g25490	i0	99.627	100	268	1	100	0	1	268	1663023	1662756	Streptococcus sp. SN-1 DNA, complete genome	blastn	26800	490	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. SN-1
3119526	3119526	PRJNA596870_P_NODE_33123_length_248_cov_0.880000_g32990_i0	PRJNA596870	33123	248	0.88	2.1824	Roseburia faecis	301302	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2858572291\|gb\|CP173697.1\|	301302	g32990	i0	95.968	1	248	10	100	0	1	248	787369	787616	Roseburia faecis strain JCM 17581 chromosome, complete genome	blastn	248	403	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia faecis
4395981	4395981	PRJNA596870_P_NODE_26584_length_263_cov_1.621053_g26451_i0	PRJNA596870	26584	263	1.621053	4.26336939	Carnobacterium maltaromaticum	2751	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|1782715578\|gb\|CP045040.1\|	2751	g26451	i0	99.62	5	263	1	100	0	1	263	2980605	2980867	Carnobacterium maltaromaticum strain 18ISCm chromosome, complete genome	blastn	1315	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
4968618	4968618	PRJNA596870_P_NODE_21464_length_289_cov_1.425926_g21331_i0	PRJNA596870	21464	289	1.425926	4.12092614	Veillonella	29465	Bacteria	Bacteria	518	2.19e-142	NTclustered	gi\|1231683529\|emb\|LT906445.1\|	29466	g21331	i0	98.962	9.8961937716263	289	3	100	0	1	289	329784	329496	Veillonella parvula strain NCTC11810 genome assembly, chromosome: 1	blastn	2860	518	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
5672229	5672229	PRJNA596870_P_NODE_29545_length_251_cov_0.865169_g29412_i0	PRJNA596870	29545	251	0.865169	2.17157419	Lactobacillus iners	147802	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g29412	i0	100	13	251	0	100	0	1	251	695877	695627	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	3263	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
7518343	7518343	PRJNA596870_P_NODE_33486_length_247_cov_0.885057_g33353_i0	PRJNA596870	33486	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g33353	i0	100	100	247	0	100	0	1	247	1285681	1285435	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24700	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8793317	8793317	PRJNA596870_P_NODE_27287_length_259_cov_1.655914_g27154_i0	PRJNA596870	27287	259	1.655914	4.28881726	Staphylococcus	1279	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|1958228241\|gb\|CP068069.1\|	246432	g27154	i0	100	22	259	0	100	0	1	259	1490226	1489968	Staphylococcus equorum strain FDAARGOS_1149 chromosome, complete genome	blastn	5698	479	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus equorum
9496962	9496962	PRJNA596870_P_NODE_35768_length_245_cov_0.895349_g35635_i0	PRJNA596870	35768	245	0.895349	2.19360505	Staphylococcus epidermidis	1282	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2866914176\|gb\|CP064642.1\|	1282	g35635	i0	100	97.1918367346939	245	0	100	0	1	245	20404	20160	Staphylococcus epidermidis strain UMCG337 plasmid pUMCG-29A, complete sequence	blastn	23812	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9497002	9497002	PRJNA596870_P_NODE_37568_length_243_cov_0.905882_g37435_i0	PRJNA596870	37568	243	0.905882	2.20129326	Clostridioides difficile	1496	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1469392145\|gb\|CP020380.1\|	1496	g37435	i0	94.286	0.60082304526749	35	1	14	1	188	222	1221062	1221029	Clostridioides difficile strain DSM 102978, complete genome	blastn	146	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
9497007	9497007	PRJNA596870_P_NODE_37808_length_243_cov_0.905882_g37675_i0	PRJNA596870	37808	243	0.905882	2.20129326	[Ruminococcus] torques	33039	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2530912390\|dbj\|AP028249.1\|	33039	g37675	i0	100	14.1646090534979	243	0	100	0	1	243	1465435	1465193	[Ruminococcus] torques 17EGH124 DNA, complete genome	blastn	3442	449	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	[Ruminococcus] torques
10069182	10069182	PRJNA596870_P_NODE_39428_length_241_cov_1.595238_g39295_i0	PRJNA596870	39428	241	1.595238	3.84452358	Carnobacterium	2747	Bacteria	Bacteria	150	7.48e-32	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g39295	i0	100	27.6680497925311	81	0	34	0	1	81	463506	463426	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	6668	150	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
10772609	10772609	PRJNA596870_P_NODE_21749_length_288_cov_1.074419_g21616_i0	PRJNA596870	21749	288	1.074419	3.09432672	Lactobacillus iners	147802	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|1772510659\|gb\|CP045664.1\|	147802	g21616	i0	100	13	288	0	100	0	1	288	951160	951447	Lactobacillus iners strain LI335 chromosome	blastn	3744	532	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
13322389	13322389	PRJNA596870_P_NODE_29291_length_251_cov_0.865169_g29158_i0	PRJNA596870	29291	251	0.865169	2.17157419	Enterococcus casseliflavus	37734	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2913646542\|gb\|CP181086.1\|	37734	g29158	i0	99.203	20.0637450199203	251	2	100	0	1	251	3091694	3091444	Enterococcus casseliflavus strain B6 chromosome, complete genome	blastn	5036	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
14597200	14597200	PRJNA596870_P_NODE_22692_length_283_cov_1.466667_g22559_i0	PRJNA596870	22692	283	1.466667	4.15066761	Streptococcus gordonii	1302	Bacteria	Bacteria	460	3.66e-125	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g22559	i0	96.416	28.1625441696113	279	10	99	0	5	283	660230	659952	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	7970	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
14597402	14597402	PRJNA596870_P_NODE_33052_length_248_cov_0.880000_g32919_i0	PRJNA596870	33052	248	0.88	2.1824	Enterococcus faecium	1352	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|83940966\|gb\|DQ321786.1\|	1352	g32919	i0	99.597	218.487903225806	248	1	100	0	1	248	19003	18756	Enterococcus faecium strain D344R transposon Tn5386, complete sequence	blastn	54185	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
15168581	15168581	PRJNA596870_P_NODE_18292_length_311_cov_0.789916_g18159_i0	PRJNA596870	18292	311	0.789916	2.45663876	Lactobacillus	1578	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g18159	i0	100	1421.38585209003	311	0	100	0	1	311	37096	37406	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	442051	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
18420365	18420365	PRJNA596870_P_NODE_29095_length_251_cov_0.865169_g28962_i0	PRJNA596870	29095	251	0.865169	2.17157419	Agathobacter rectalis	39491	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|291526582\|emb\|FP929043.1\|	657317	g28962	i0	98.008	1	251	5	100	0	1	251	1302506	1302756	Eubacterium rectale M104/1 draft genome	blastn	251	436	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
18420572	18420572	PRJNA596870_P_NODE_40115_length_241_cov_0.916667_g39982_i0	PRJNA596870	40115	241	0.916667	2.20916747	Lactobacillus jensenii	109790	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2769791464\|gb\|CP160084.1\|	109790	g39982	i0	100	98.7510373443983	241	0	100	0	1	241	735846	736086	Lactobacillus jensenii strain 188_F1_4 chromosome, complete genome	blastn	23799	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus jensenii
20970528	20970528	PRJNA596870_P_NODE_22037_length_286_cov_1.807512_g21904_i0	PRJNA596870	22037	286	1.807512	5.16948432	Fenollaria massiliensis	938288	Bacteria	Bacteria	307	5.1100000000000005e-79	NTclustered	gi\|2238281809\|gb\|CP096649.1\|	938288	g21904	i0	86.441	2.03846153846154	295	22	97	13	1	278	1357100	1356807	Fenollaria massiliensis strain C0061C2 chromosome, complete genome	blastn	583	307	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Fenollaria	Fenollaria massiliensis
23520824	23520824	PRJNA596870_P_NODE_30319_length_250_cov_0.870056_g30186_i0	PRJNA596870	30319	250	0.870056	2.17514	Lactobacillus iners	147802	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2769751966\|gb\|CP160079.1\|	147802	g30186	i0	99.6	13.304	250	1	100	0	1	250	1058205	1058454	Lactobacillus iners strain Liners_2503_V10-0 chromosome, complete genome	blastn	3326	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
23520999	23520999	PRJNA596870_P_NODE_38739_length_242_cov_0.911243_g38606_i0	PRJNA596870	38739	242	0.911243	2.20520806	Metasolibacillus sp. FSL H7-0170	2921431	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2723342317\|gb\|CP151964.1\|	2921431	g38606	i0	100	0.119834710743802	29	0	12	0	214	242	2220906	2220878	Metasolibacillus sp. FSL H7-0170 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Metasolibacillus	Metasolibacillus sp. FSL H7-0170
25366903	25366903	PRJNA596870_P_NODE_40400_length_240_cov_2.347305_g40267_i0	PRJNA596870	40400	240	2.347305	5.633532	Carnobacterium	2747	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g40267	i0	100	31.9625	240	0	100	0	1	240	1317913	1317674	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	7671	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum

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