metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA715461" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA715461" 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
1192214	1192214	PRJNA715461_S_NODE_601_length_344_cov_314.014760_g527_i0	PRJNA715461	601	344	314.01476	1080.2107744	Staphylococcus	1279	Bacteria	Bacteria	409	1.68e-109	NTclustered	gi\|2067468998\|gb\|CP078159.1\|	1283	g527	i0	99.119	297.162790697674	227	2	66	0	115	341	758965	758739	Staphylococcus haemolyticus strain NY5 chromosome, complete genome	blastn	102224	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
1192219	1192219	PRJNA715461_S_NODE_981_length_250_cov_426.768362_g907_i0	PRJNA715461	981	250	426.768362	1066.920905	Blautia	572511	Bacteria	Bacteria	254	5.78e-63	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g907	i0	100	242.068	137	0	56	0	114	250	2891	2755	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	60517	254	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
3256505	3256505	PRJNA715461_S_NODE_643_length_328_cov_21476.584314_g569_i0	PRJNA715461	643	328	21476.584314	70443.19654992	Staphylococcus saccharolyticus	33028	Bacteria	Bacteria	403	7.39e-108	NTclustered	gi\|1948644436\|gb\|CP066042.1\|	33028	g569	i0	98.678	363.335365853659	227	3	69	0	4	230	69023	68797	Staphylococcus saccharolyticus strain FDAARGOS_1074 chromosome, complete genome	blastn	119174	403	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saccharolyticus
3743922	3743922	PRJNA715461_S_NODE_323_length_484_cov_244.854015_g256_i0	PRJNA715461	323	484	244.854015	1185.0934326	Blautia	572511	Bacteria	Bacteria	664	0	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g256	i0	100	353.512396694215	359	0	74	0	1	359	1860024	1859666	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	171100	664	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
3743926	3743926	PRJNA715461_S_NODE_563_length_361_cov_5.180556_g489_i0	PRJNA715461	563	361	5.180556	18.70180716	Blautia	572511	Bacteria	Bacteria	597	3.499999999999999e-166	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g489	i0	100	407.191135734072	323	0	89	0	36	358	4096	3774	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	146996	597	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
7083787	7083787	PRJNA715461_S_NODE_1086_length_241_cov_1.863095_g1012_i0	PRJNA715461	1086	241	1.863095	4.49005895	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	272	1.5299999999999999e-68	NTclustered	gi\|1721134157\|emb\|LR698958.1\|	1898203	g1012	i0	91.133	17.6721991701245	203	14	83	3	38	238	2132951	2133151	Lachnospiraceae bacterium isolate MGYG-HGUT-01373 genome assembly, chromosome: 1	blastn	4259	272	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
7570069	7570069	PRJNA715461_S_NODE_726_length_300_cov_20969.872247_g652_i0	PRJNA715461	726	300	20969.872247	62909.616741	Staphylococcus	1279	Bacteria	Bacteria	405	1.86e-108	NTclustered	gi\|2814765382\|gb\|CP170661.1\|	1282	g652	i0	98.684	402.85	228	3	76	0	4	231	793071	793298	Staphylococcus epidermidis strain CCARM 3A686 chromosome, complete genome	blastn	120855	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8358452	8358452	PRJNA715461_S_NODE_1127_length_235_cov_14973.037037_g1053_i0	PRJNA715461	1127	235	14973.037037	35186.63703695	Staphylococcus aureus	1280	Bacteria	Bacteria	296	8.81e-76	NTclustered	gi\|1909943138\|dbj\|LC576395.1\|	1280	g1053	i0	99.387	73.3489361702128	163	1	69	0	1	163	464	626	Staphylococcus aureus IRQBAS98 gene for 16S rRNA, partial sequence	blastn	17237	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
10120763	10120763	PRJNA715461_S_NODE_1108_length_238_cov_28443.987879_g1034_i0	PRJNA715461	1108	238	28443.987879	67696.69115202	root	1	Root_unresolved	Root_unresolved	259	1.17e-64	NTclustered	gi\|2006240103\|gb\|CP071514.1\|	1283	g1034	i0	98	59.890756302521	150	1	62	2	85	232	3690	3541	Staphylococcus haemolyticus strain 1b plasmid pSH_1b_2, complete sequence	blastn	14254	259	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
10120777	10120777	PRJNA715461_S_NODE_488_length_388_cov_7476.622222_g414_i0	PRJNA715461	488	388	7476.622222	29009.29422136	Blautia	572511	Bacteria	Bacteria	553	8.329999999999998e-153	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g414	i0	99.026	344.100515463918	308	3	79	0	1	308	3076	3383	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	133511	553	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
12671799	12671799	PRJNA715461_S_NODE_1210_length_228_cov_2.045161_g1136_i0	PRJNA715461	1210	228	2.045161	4.66296708	Blautia	572511	Bacteria	Bacteria	363	8.269999999999999e-96	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g1136	i0	99.497	98.3157894736842	199	1	87	0	27	225	489	291	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	22416	363	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
13458834	13458834	PRJNA715461_S_NODE_1831_length_201_cov_4.164062_g1757_i0	PRJNA715461	1831	201	4.164062	8.36976462	Lactobacillus iners	147802	Bacteria	Bacteria	302	1.5700000000000001e-77	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g1757	i0	100	271.119402985075	163	0	81	0	38	200	2297	2135	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	54495	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
14734116	14734116	PRJNA715461_S_NODE_712_length_302_cov_10287.938865_g638_i0	PRJNA715461	712	302	10287.938865	31069.5753723	Blautia hansenii	1322	Bacteria	Bacteria	411	4.0299999999999996e-110	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g638	i0	99.123	355.73178807947	228	2	75	0	74	301	1859943	1860170	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	107431	411	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
15220729	15220729	PRJNA715461_S_NODE_1112_length_238_cov_2.769697_g1038_i0	PRJNA715461	1112	238	2.769697	6.59187886	Romboutsia	1501226	Bacteria	Bacteria	429	8.45e-116	NTclustered	gi\|2034578690\|gb\|CP048740.1\|	2708052	g1038	i0	100	1078.17226890756	232	0	98	0	3	234	2386336	2386567	Romboutsia sp. 13154 chromosome	blastn	256605	433	0.990762124711316	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. 13154
16495124	16495124	PRJNA715461_S_NODE_833_length_277_cov_1.563725_g759_i0	PRJNA715461	833	277	1.563725	4.33151825	Blautia	572511	Bacteria	Bacteria	407	4.72e-109	NTclustered	gi\|2884829887\|gb\|CP176622.1\|	1322	g759	i0	100	22.5667870036101	220	0	79	0	1	220	2757475	2757694	Blautia hansenii strain SFAD90 chromosome, complete genome	blastn	6251	407	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia hansenii
18556973	18556973	PRJNA715461_S_NODE_795_length_284_cov_602.061611_g721_i0	PRJNA715461	795	284	602.061611	1709.85497524	Gemella sanguinis	84135	Bacteria	Bacteria	200	8.85e-47	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g721	i0	97.436	88.4753521126761	117	3	41	0	55	171	519032	519148	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	25127	200	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
19043976	19043976	PRJNA715461_S_NODE_1195_length_229_cov_3.814103_g1121_i0	PRJNA715461	1195	229	3.814103	8.73429587	Bacillales	1385	Bacteria	Bacteria	243	1.13e-59	NTclustered	gi\|2522199385\|gb\|CP127869.1\|	1282	g1121	i0	99.254	319.248908296943	134	1	59	0	43	176	991948	992081	Staphylococcus epidermidis strain NG02 chromosome, complete genome	blastn	73108	243	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
22869674	22869674	PRJNA715461_S_NODE_638_length_330_cov_1.291829_g564_i0	PRJNA715461	638	330	1.291829	4.2630357	Candidatus Desulforudis	471826	Bacteria	Bacteria	126	1.7999999999999997e-24	NTclustered	gi\|1584737417\|gb\|CP034260.2\|	471827	g564	i0	75.676	74.4575757575758	296	49	86	19	46	327	148270	147984	Candidatus Desulforudis audaxviator strain BYF chromosome, complete genome	blastn	24571	126	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Candidatus Desulforudaceae	Candidatus Desulforudis	Candidatus Desulforudis audaxviator
23658196	23658196	PRJNA715461_S_NODE_939_length_258_cov_1.216216_g865_i0	PRJNA715461	939	258	1.216216	3.13783728	Levilactobacillus brevis	1580	Bacteria	Bacteria	403	5.63e-108	NTclustered	gi\|2699346193\|gb\|CP147490.1\|	1580	g865	i0	98.678	399.143410852713	227	3	88	0	29	255	1184207	1183981	Levilactobacillus brevis strain LMT1-73 chromosome, complete genome	blastn	102979	403	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Levilactobacillus	Levilactobacillus brevis

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