metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1073183" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1073183" 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	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
187193	187193	PRJNA1073183_P_NODE_20921_length_286_cov_1.305164_g20826_i0	PRJNA1073183	20921	286	1.305164	3.73276904	Crassaminicella indica	2855394	Bacteria	Bacteria	58.4	5.68e-4	NTclustered	gi\|2065932699\|gb\|CP078093.1\|	2855394	g20826	i0	100	0.108391608391608	31	0	11	8	38	2682719	2682749	Crassaminicella indica strain 143-21 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Crassaminicella	Crassaminicella indica
187359	187359	PRJNA1073183_P_NODE_31581_length_245_cov_0.889535_g31486_i0	PRJNA1073183	31581	245	0.889535	2.17936075	Weissella confusa	1583	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g31486	i0	99.592	9	245	1	100	1	245	2110739	2110983	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	2205	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
3566696	3566696	PRJNA1073183_P_NODE_29663_length_247_cov_0.885057_g29568_i0	PRJNA1073183	29663	247	0.885057	2.18609079	Streptococcus	1301	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|1988318086\|gb\|CP070238.1\|	1335	g29568	i0	98.381	15.9757085020243	247	4	100	1	247	45423	45669	Streptococcus equinus strain Colony399 chromosome	blastn	3946	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
3566713	3566713	PRJNA1073183_P_NODE_34763_length_235_cov_2.049383_g34668_i0	PRJNA1073183	34763	235	2.049383	4.81605005	Staphylococcus	1279	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g34668	i0	100	558.268085106383	235	0	100	1	235	968680	968914	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	131193	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4844145	4844145	PRJNA1073183_P_NODE_29044_length_248_cov_0.880000_g28949_i0	PRJNA1073183	29044	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	429	8.869999999999998e-116	NTclustered	gi\|1948576487\|gb\|CP065994.1\|	102684	g28949	i0	97.976	10.7258064516129	247	5	99	1	247	409267	409513	Streptococcus infantarius strain FDAARGOS_1019 chromosome, complete genome	blastn	2660	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantarius
4844170	4844170	PRJNA1073183_P_NODE_33924_length_242_cov_0.875740_g33829_i0	PRJNA1073183	33924	242	0.87574	2.1192908	Listeria	1637	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2611946659\|gb\|CP137276.1\|	1639	g33829	i0	99.587	100	242	1	100	1	242	345347	345106	Listeria monocytogenes strain FV3 chromosome, complete genome	blastn	24200	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
4844177	4844177	PRJNA1073183_P_NODE_34804_length_232_cov_2.238994_g34709_i0	PRJNA1073183	34804	232	2.238994	5.19446608	Weissella	46255	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g34709	i0	100	625.818965517241	232	0	100	1	232	20092	20323	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	145190	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
6119216	6119216	PRJNA1073183_P_NODE_22745_length_274_cov_5.363184_g22650_i0	PRJNA1073183	22745	274	5.363184	14.69512416	root	1	Root_unresolved	Root_unresolved	507	4.47e-139	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g22650	i0	100	113.003649635036	274	0	100	1	274	4002055	4001782	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	30963	507	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
6565056	6565056	PRJNA1073183_P_NODE_17106_length_316_cov_2.279835_g17011_i0	PRJNA1073183	17106	316	2.279835	7.2042786	Ruminococcaceae bacterium BL-6	2799561	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1862835799\|emb\|LR778135.1\|	2799561	g17011	i0	100	0.0886075949367089	28	0	9	86	113	337186	337159	Clostridiales bacterium isolate BL-6 genome assembly, chromosome: CLOSBL6	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Ruminococcaceae bacterium BL-6
6565356	6565356	PRJNA1073183_P_NODE_32686_length_243_cov_0.905882_g32591_i0	PRJNA1073183	32686	243	0.905882	2.20129326	Staphylococcus cohnii	29382	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g32591	i0	100	24.7242798353909	243	0	100	1	243	1949423	1949665	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	6008	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
9944274	9944274	PRJNA1073183_P_NODE_33668_length_242_cov_0.911243_g33573_i0	PRJNA1073183	33668	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1395792743\|gb\|CP029653.1\|	1280	g33573	i0	99.587	72.8347107438017	242	1	100	1	242	76708	76949	Staphylococcus aureus strain AR_0470 chromosome, complete genome	blastn	17626	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
11219521	11219521	PRJNA1073183_P_NODE_26589_length_251_cov_0.865169_g26494_i0	PRJNA1073183	26589	251	0.865169	2.17157419	Streptococcus	1301	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|1948576487\|gb\|CP065994.1\|	102684	g26494	i0	98.008	101.569721115538	251	5	100	1	251	1818964	1819214	Streptococcus infantarius strain FDAARGOS_1019 chromosome, complete genome	blastn	25494	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantarius
12940996	12940996	PRJNA1073183_P_NODE_25231_length_258_cov_1.572973_g25136_i0	PRJNA1073183	25231	258	1.572973	4.05827034	Staphylococcus hominis	1290	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1780389983\|gb\|CP046301.1\|	1290	g25136	i0	100	73.0271317829457	258	0	100	1	258	1760161	1760418	Staphylococcus hominis strain FDAARGOS_747 chromosome, complete genome	blastn	18841	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
14215883	14215883	PRJNA1073183_P_NODE_22932_length_273_cov_1.540000_g22837_i0	PRJNA1073183	22932	273	1.54	4.2042	Anaerococcus prevotii	33034	Bacteria	Bacteria	460	3.5099999999999996e-125	NTclustered	gi\|256797400\|gb\|CP001708.1\|	525919	g22837	i0	97.07	2.83516483516484	273	8	100	1	273	46362	46634	Anaerococcus prevotii DSM 20548, complete genome	blastn	774	460	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
16764190	16764190	PRJNA1073183_P_NODE_27194_length_250_cov_0.870056_g27099_i0	PRJNA1073183	27194	250	0.870056	2.17514	Staphylococcus hominis	1290	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2870745991\|gb\|CP134693.1\|	1290	g27099	i0	100	547	250	0	100	1	250	11403	11154	Staphylococcus hominis strain acrlw chromosome, complete genome	blastn	136750	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
16764245	16764245	PRJNA1073183_P_NODE_30054_length_247_cov_0.885057_g29959_i0	PRJNA1073183	30054	247	0.885057	2.18609079	Weissella confusa	1583	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1611612124\|gb\|CP027563.1\|	1583	g29959	i0	100	9.0080971659919	247	0	100	1	247	1518742	1518496	Weissella confusa strain VTT E-133279 chromosome, complete genome	blastn	2225	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
17593847	17593847	PRJNA1073183_P_NODE_24814_length_261_cov_1.404255_g24719_i0	PRJNA1073183	24814	261	1.404255	3.66510555	Staphylococcus	1279	Bacteria	Bacteria	472	1.54e-128	NTclustered	gi\|944018403\|gb\|KJ923785.1\|	1280	g24719	i0	99.234	157.003831417625	261	2	100	1	261	439	179	Staphylococcus aureus strain SBANHCA2 16S ribosomal RNA gene, partial sequence	blastn	40978	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
18039068	18039068	PRJNA1073183_P_NODE_32595_length_243_cov_0.905882_g32500_i0	PRJNA1073183	32595	243	0.905882	2.20129326	Weissella cibaria	137591	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2213883668\|gb\|CP058240.1\|	137591	g32500	i0	99.177	22.8559670781893	243	2	100	1	243	4035	3793	Weissella cibaria strain JW15 plasmid pCBA3612-03, complete sequence	blastn	5554	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
18039097	18039097	PRJNA1073183_P_NODE_34075_length_241_cov_0.916667_g33980_i0	PRJNA1073183	34075	241	0.916667	2.20916747	Weissella confusa	1583	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g33980	i0	100	16.7883817427386	241	0	100	1	241	172224	172464	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	4046	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
18867636	18867636	PRJNA1073183_P_NODE_14855_length_337_cov_2.685606_g14760_i0	PRJNA1073183	14855	337	2.685606	9.05049222	Streptococcus	1301	Bacteria	Bacteria	601	2.52e-167	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g14760	i0	98.813	544.008902077151	337	4	100	1	337	424319	423983	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	183331	601	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
18867711	18867711	PRJNA1073183_P_NODE_6835_length_486_cov_2.639225_g6741_i0	PRJNA1073183	6835	486	2.639225	12.8266335	Enterococcus	1350	Bacteria	Bacteria	793	0	NTclustered	gi\|2737618408\|gb\|CP144496.1\|	44008	g6741	i0	96.091	574.518518518518	486	19	100	1	486	1758890	1758405	Enterococcus cecorum strain 67 chromosome, complete genome	blastn	279216	793	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus cecorum
20588263	20588263	PRJNA1073183_P_NODE_23537_length_269_cov_1.244898_g23442_i0	PRJNA1073183	23537	269	1.244898	3.34877562	Weissella confusa	1583	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|1815810266\|gb\|CP049097.1\|	1583	g23442	i0	99.628	6.98513011152416	269	1	100	1	269	1083392	1083660	Weissella confusa strain N17 chromosome, complete genome	blastn	1879	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
21418146	21418146	PRJNA1073183_P_NODE_31457_length_245_cov_0.895349_g31362_i0	PRJNA1073183	31457	245	0.895349	2.19360505	Bacillus	1386	Bacteria	Bacteria	451	1.87e-122	NTclustered	gi\|2263617782\|gb\|CP099801.1\|	2026186	g31362	i0	100	100.081632653061	244	0	99	1	244	4176843	4176600	Bacillus paranthracis strain SSBC101 chromosome, complete genome	blastn	24520	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
21418162	21418162	PRJNA1073183_P_NODE_3817_length_644_cov_2.038529_g3728_i0	PRJNA1073183	3817	644	2.038529	13.12812676	Weissella	46255	Bacteria	Bacteria	1190	0	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g3728	i0	100	627.366459627329	644	0	100	1	644	20997	20354	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	404024	1190	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
23139738	23139738	PRJNA1073183_P_NODE_34579_length_241_cov_0.916667_g34484_i0	PRJNA1073183	34579	241	0.916667	2.20916747	Weissella confusa	1583	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1815810266\|gb\|CP049097.1\|	1583	g34484	i0	100	24.0912863070539	241	0	100	1	241	1538865	1538625	Weissella confusa strain N17 chromosome, complete genome	blastn	5806	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa

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