metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA699078" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA699078" 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
682483	682483	PRJNA699078_S_NODE_55161_length_229_cov_2.094444_g54212_i0	PRJNA699078	55161	229	2.094444	4.79627676	Planococcus sp. PAMC 21323	1526927	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|723610590\|gb\|CP009129.1\|	1526927	g54212	i0	100	0.248908296943231	29	0	13	0	36	64	532866	532838	Planococcus sp. PAMC 21323, complete genome	blastn	57	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus sp. PAMC 21323
682915	682915	PRJNA699078_S_NODE_84421_length_182_cov_2.992481_g83472_i0	PRJNA699078	84421	182	2.992481	5.44631542	Roseburia hominis	301301	Bacteria	Bacteria	209	8.68e-50	NTclustered	gi\|1721134209\|emb\|LR699011.1\|	301301	g83472	i0	91.503	346.675824175824	153	11	84	2	31	182	28874	29025	Roseburia hominis isolate MGYG-HGUT-02517 genome assembly, chromosome: 1	blastn	63095	209	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia hominis
1958253	1958253	PRJNA699078_S_NODE_43902_length_260_cov_1.639810_g42953_i0	PRJNA699078	43902	260	1.63981	4.263506	uncultured Oscillospiraceae bacterium	707003	Bacteria	Bacteria	292	1.28e-74	NTclustered	gi\|2445454856\|gb\|OQ450232.1\|	707003	g42953	i0	87.121	123.584615384615	264	27	100	6	1	260	3646	3906	Uncultured Oscillospiraceae bacterium clone Long_Read_Consensus_CS_F1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32132	292	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		uncultured Oscillospiraceae bacterium
2459334	2459334	PRJNA699078_S_NODE_68022_length_204_cov_3.161290_g67073_i0	PRJNA699078	68022	204	3.16129	6.4490316	root	1	Root_unresolved	Root_unresolved	329	7.34e-86	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g67073	i0	100	87.2303921568627	178	0	87	0	1	178	2463672	2463495	Staphylococcus aureus strain WH9628 chromosome	blastn	17795	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
3233464	3233464	PRJNA699078_S_NODE_60483_length_218_cov_1.319527_g59534_i0	PRJNA699078	60483	218	1.319527	2.87656886	Streptococcus urinalis	149016	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|1539866814\|emb\|LR134323.1\|	149016	g59534	i0	100	0.128440366972477	28	0	13	0	9	36	558634	558661	Streptococcus urinalis strain NCTC13766 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus urinalis
3735921	3735921	PRJNA699078_S_NODE_78343_length_190_cov_1.106383_g77394_i0	PRJNA699078	78343	190	1.106383	2.1021277	Clostridia	186801	Bacteria	Bacteria	311	2.44e-80	NTclustered	gi\|2619698994\|gb\|CP137821.1\|	29347	g77394	i0	96.296	403.021052631579	189	7	100	0	2	190	1915981	1916169	[Clostridium] scindens strain JCM10422 (TH-82)	blastn	76574	313	0.993610223642173	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoclostridium	[Clostridium] scindens
5786102	5786102	PRJNA699078_S_NODE_68525_length_204_cov_1.006452_g67576_i0	PRJNA699078	68525	204	1.006452	2.05316208	Sporosarcina ureae	1571	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1174585705\|gb\|CP015109.1\|	1571	g67576	i0	100	0.137254901960784	28	0	14	0	168	195	2317968	2317941	Sporosarcina ureae strain P17a chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina ureae
7562020	7562020	PRJNA699078_S_NODE_96566_length_169_cov_13.400000_g95617_i0	PRJNA699078	96566	169	13.4	22.646	root	1	Root_unresolved	Root_unresolved	313	5.859999999999999e-81	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g95617	i0	100	99.1183431952663	169	0	100	0	1	169	2463672	2463840	Staphylococcus aureus strain WH9628 chromosome	blastn	16751	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8334787	8334787	PRJNA699078_S_NODE_100627_length_167_cov_0.881356_g99678_i0	PRJNA699078	100627	167	0.881356	1.47186452	Paenibacillus sp. Cedars	1980674	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1394605008\|gb\|CP020866.1\|	1980674	g99678	i0	100	0.167664670658683	28	0	17	0	98	125	5761339	5761366	Paenibacillus sp. Cedars chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. Cedars
8335102	8335102	PRJNA699078_S_NODE_23207_length_352_cov_5.009901_g22258_i0	PRJNA699078	23207	352	5.009901	17.63485152	Clostridium sp. MD294	97138	Bacteria	Bacteria	540	5.82e-149	NTclustered	gi\|2254032980\|gb\|CP097810.1\|	97138	g22258	i0	94.602	493.326704545455	352	14	100	3	1	352	734066	734412	Clostridium sp. MD294 strain ASF356 chromosome, complete genome	blastn	173651	540	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. MD294
8335464	8335464	PRJNA699078_S_NODE_45467_length_255_cov_1.291262_g44518_i0	PRJNA699078	45467	255	1.291262	3.2927181	Oceanobacillus sp. FSL K6-3682	2921503	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2709943379\|gb\|CP150263.1\|	2921503	g44518	i0	100	0.109803921568627	28	0	11	0	130	157	2011122	2011149	Oceanobacillus sp. FSL K6-3682 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus sp. FSL K6-3682
12663589	12663589	PRJNA699078_S_NODE_11750_length_453_cov_2.655941_g10830_i0	PRJNA699078	11750	453	2.655941	12.03141273	Lachnospiraceae	186803	Bacteria	Bacteria	294	6.61e-75	NTclustered	gi\|1721134209\|emb\|LR699011.1\|	301301	g10830	i0	83.988	296.189845474614	331	28	75	12	24	351	27667	27975	Roseburia hominis isolate MGYG-HGUT-02517 genome assembly, chromosome: 1	blastn	134174	296	0.993243243243243	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia hominis
12663601	12663601	PRJNA699078_S_NODE_26390_length_333_cov_3.197183_g25441_i0	PRJNA699078	26390	333	3.197183	10.64661939	Lachnospiraceae	186803	Bacteria	Bacteria	363	1.2799999999999999e-95	NTclustered	gi\|2729058667\|emb\|OZ006967.1\|	3048880	g25441	i0	87.077	403.948948948949	325	36	97	6	4	325	643643	643322	MAG: Candidatus Scatomonas sp. isolate 6732_HOM_VAC_s127.ctg000167c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	134515	366	0.991803278688525	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Scatomonas	Candidatus Scatomonas sp.
13435662	13435662	PRJNA699078_S_NODE_18491_length_385_cov_1.982143_g17544_i0	PRJNA699078	18491	385	1.982143	7.63125055	Clostridium sp. MD294	97138	Bacteria	Bacteria	601	2.91e-167	NTclustered	gi\|2254032980\|gb\|CP097810.1\|	97138	g17544	i0	95.039	383.387012987013	383	17	99	2	3	385	962772	963152	Clostridium sp. MD294 strain ASF356 chromosome, complete genome	blastn	147604	601	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. MD294
13436592	13436592	PRJNA699078_S_NODE_82411_length_185_cov_1.147059_g81462_i0	PRJNA699078	82411	185	1.147059	2.12205915	Clostridium intestinale	36845	Bacteria	Bacteria	58.4	3.4e-4	NTclustered	gi\|1880427247\|gb\|CP059378.1\|	36845	g81462	i0	97.143	0.189189189189189	35	0	19	1	17	51	1931226	1931193	Clostridium intestinale strain Lx1 chromosome, complete genome	blastn	35	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
19035918	19035918	PRJNA699078_S_NODE_95395_length_171_cov_1.081967_g94446_i0	PRJNA699078	95395	171	1.081967	1.85016357	root	1	Root_unresolved	Root_unresolved	54.7	0.004	NTclustered	gi\|2579557060\|gb\|CP134474.1\|	1307	g94446	i0	100	1.69590643274854	29	0	17	0	141	169	810328	810356	Streptococcus suis strain PH2016-081 chromosome, complete genome	blastn	290	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
19808589	19808589	PRJNA699078_S_NODE_104516_length_164_cov_1.356522_g103567_i0	PRJNA699078	104516	164	1.356522	2.22469608	Vescimonas coprocola	2714355	Bacteria	Bacteria	265	1.6199999999999998e-66	NTclustered	gi\|2025053910\|dbj\|AP023418.1\|	2714355	g103567	i0	95.732	294.817073170732	164	7	100	0	1	164	257864	257701	Vescimonas coprocola MM50 DNA, complete genome	blastn	48350	265	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Vescimonas	Vescimonas coprocola
21084196	21084196	PRJNA699078_S_NODE_13857_length_427_cov_5.960317_g12922_i0	PRJNA699078	13857	427	5.960317	25.45055359	Clostridium sp. MD294	97138	Bacteria	Bacteria	667	0	NTclustered	gi\|2254032980\|gb\|CP097810.1\|	97138	g12922	i0	95.07	473.19906323185	426	17	99	2	1	426	734900	734479	Clostridium sp. MD294 strain ASF356 chromosome, complete genome	blastn	202056	667	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. MD294
23634598	23634598	PRJNA699078_S_NODE_102219_length_166_cov_0.888889_g101270_i0	PRJNA699078	102219	166	0.888889	1.47555574	Eubacterium ramulus	39490	Bacteria	Bacteria	200	4.69e-47	NTclustered	gi\|2852972075\|gb\|CP173382.1\|	39490	g101270	i0	89.375	13.644578313253	160	16	96	1	4	162	47518	47677	Eubacterium ramulus strain JCM 31335 chromosome, complete genome	blastn	2265	200	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium ramulus
24908109	24908109	PRJNA699078_S_NODE_12960_length_438_cov_2.172237_g12031_i0	PRJNA699078	12960	438	2.172237	9.51439806	Roseburia sp. 831b	1261635	Bacteria	Bacteria	569	9.449999999999999e-158	NTclustered	gi\|2667762819\|gb\|CP135162.1\|	1261635	g12031	i0	90.345	443.139269406393	435	41	99	1	1	434	237422	237856	Roseburia sp. 831b chromosome, complete genome	blastn	194095	569	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia sp. 831b
24908164	24908164	PRJNA699078_S_NODE_17480_length_393_cov_1.982558_g16533_i0	PRJNA699078	17480	393	1.982558	7.79145294	Hungatella hathewayi	154046	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2299353445\|gb\|CP102274.1\|	154046	g16533	i0	100	0.0712468193384224	28	0	7	0	278	305	708675	708702	Hungatella hathewayi strain DSM 13479 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Hungatella	Hungatella hathewayi
25410664	25410664	PRJNA699078_S_NODE_55740_length_228_cov_1.592179_g54791_i0	PRJNA699078	55740	228	1.592179	3.63016812	root	1	Root_unresolved	Root_unresolved	399	6.299999999999999e-107	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g54791	i0	98.246	127.947368421053	228	4	100	0	1	228	520	747	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	29172	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens

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