metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA421571" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA421571" 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
424251	424251	PRJNA421571_P_NODE_87401_length_260_cov_1.588235_g84852_i0	PRJNA421571	87401	260	1.588235	4.129411	Ruminococcus sp. JL13D9	3233381	Bacteria	Bacteria	60.2	1.42e-4	NTclustered	gi\|2866352932\|gb\|CP162392.1\|	3233381	g84852	i0	92.857	0.161538461538462	42	2	16	1	27	67	517889	517930	Ruminococcus sp. JL13D9 chromosome, complete genome	blastn	42	60.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. JL13D9
1086168	1086168	PRJNA421571_P_NODE_81301_length_274_cov_1.144279_g78752_i0	PRJNA421571	81301	274	1.144279	3.13532446	Paenibacillus	44249	Bacteria	Bacteria	171	6.66e-38	NTclustered	gi\|2586999634\|gb\|CP130318.1\|	2918900	g78752	i0	81.106	5.48905109489051	217	37	78	3	19	233	5120697	5120911	Paenibacillus aurantius strain MBLB1776 chromosome, complete genome	blastn	1504	171	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus aurantius
4913997	4913997	PRJNA421571_P_NODE_53664_length_369_cov_1.560811_g51115_i0	PRJNA421571	53664	369	1.560811	5.75939259	Bacillus	1386	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|958622171\|gb\|CP013274.1\|	1428	g51115	i0	96.774	1.15989159891599	31	1	8	0	8	38	182836	182806	Bacillus thuringiensis strain CTC chromosome, complete genome	blastn	428	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
6189291	6189291	PRJNA421571_P_NODE_84885_length_266_cov_0.797927_g82336_i0	PRJNA421571	84885	266	0.797927	2.12248582	Paenibacillus	44249	Bacteria	Bacteria	58.4	5.23e-4	NTclustered	gi\|2710138553\|gb\|CP150299.1\|	2921379	g82336	i0	86.538	1.15037593984962	52	7	20	0	129	180	2334975	2334924	Paenibacillus sp. FSL H8-0175 chromosome, complete genome	blastn	306	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H8-0175
8077639	8077639	PRJNA421571_P_NODE_89907_length_254_cov_2.132597_g87358_i0	PRJNA421571	89907	254	2.132597	5.41679638	Erysipelothrix sp. P66	3141531	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2724004414\|gb\|CP152290.1\|	3141531	g87358	i0	100	0.110236220472441	28	0	11	0	149	176	1518444	1518471	Erysipelothrix sp. P66 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix sp. P66
9352479	9352479	PRJNA421571_P_NODE_94728_length_249_cov_0.875000_g92179_i0	PRJNA421571	94728	249	0.875	2.17875	Planococcus shenhongbingii	3058398	Bacteria	Bacteria	58.4	4.84e-4	NTclustered	gi\|2533122678\|gb\|CP129235.1\|	3058398	g92179	i0	97.059	0.136546184738956	34	1	14	0	34	67	3348231	3348198	Planococcus shenhongbingii strain N016 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus shenhongbingii
10627422	10627422	PRJNA421571_P_NODE_60629_length_337_cov_1.325758_g58080_i0	PRJNA421571	60629	337	1.325758	4.46780446	Tissierella carlieri	689904	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2844308018\|gb\|CP172320.1\|	689904	g58080	i0	100	0.0890207715133531	30	0	9	0	281	310	1302717	1302746	Tissierella carlieri strain WGS1355 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Tissierella	Tissierella carlieri
10628278	10628278	PRJNA421571_P_NODE_94849_length_249_cov_0.875000_g92300_i0	PRJNA421571	94849	249	0.875	2.17875	Streptococcus mitis	28037	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2886510793\|emb\|OZ217345.1\|	28037	g92300	i0	94.118	0.136546184738956	34	2	14	0	128	161	1545874	1545907	Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1	blastn	34	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
11289440	11289440	PRJNA421571_P_NODE_77409_length_283_cov_1.466667_g74860_i0	PRJNA421571	77409	283	1.466667	4.15066761	Bacteria	2	Bacteria	Bacteria	60.2	1.56e-4	NTclustered	gi\|2323120186\|gb\|CP109635.1\|	1363	g74860	i0	100	4.00353356890459	32	0	11	0	168	199	1731587	1731618	Lactococcus garvieae strain Alexii-11_2 chromosome, complete genome	blastn	1133	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus garvieae
11900642	11900642	PRJNA421571_P_NODE_100750_length_245_cov_0.895349_g98201_i0	PRJNA421571	100750	245	0.895349	2.19360505	Veillonella parvula	29466	Bacteria	Bacteria	368	1.93e-97	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g98201	i0	100	99.4857142857143	199	0	100	0	47	245	1744782	1744980	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	24374	368	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
13177112	13177112	PRJNA421571_P_NODE_54631_length_364_cov_1.463918_g52082_i0	PRJNA421571	54631	364	1.463918	5.32866152	Megamonas hypermegale	158847	Bacteria	Bacteria	60.2	2.06e-4	NTclustered	gi\|2729058674\|emb\|OZ006974.1\|	158847	g52082	i0	92.857	0.115384615384615	42	1	11	2	174	213	1999902	1999943	MAG: Megamonas hypermegale isolate 6755_HET_CTRL_s80.ctg000101c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	42	60.2	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Megamonas	Megamonas hypermegale
13178113	13178113	PRJNA421571_P_NODE_93571_length_250_cov_0.870056_g91022_i0	PRJNA421571	93571	250	0.870056	2.17514	Streptococcus mitis	28037	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|927035354\|gb\|CP012646.1\|	28037	g91022	i0	99.2	100	250	2	100	0	1	250	25695	25944	Streptococcus mitis strain KCOM 1350 (= ChDC B183), complete genome	blastn	25000	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
13839599	13839599	PRJNA421571_P_NODE_72231_length_297_cov_1.031250_g69682_i0	PRJNA421571	72231	297	1.03125	3.0628125	Bacillus	1386	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2193772129\|gb\|CP076173.1\|	1392	g69682	i0	94.595	13.1346801346801	37	0	12	1	118	152	4514987	4514951	Bacillus anthracis strain A178 chromosome, complete genome	blastn	3901	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
14452979	14452979	PRJNA421571_P_NODE_80752_length_275_cov_1.396040_g78203_i0	PRJNA421571	80752	275	1.39604	3.83911	Salisediminibacterium selenitireducens	85683	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|297140795\|gb\|CP001791.1\|	439292	g78203	i0	100	0.101818181818182	28	0	10	0	99	126	1553007	1552980	[Bacillus] selenitireducens MLS10 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salisediminibacterium	Salisediminibacterium selenitireducens
15724510	15724510	PRJNA421571_P_NODE_102753_length_243_cov_2.688235_g100204_i0	PRJNA421571	102753	243	2.688235	6.53241105	Brochothrix thermosphacta	2756	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1250077806\|gb\|CP023643.1\|	2756	g100204	i0	100	556.004115226337	243	0	100	0	1	243	721932	722174	Brochothrix thermosphacta strain BII chromosome, complete genome	blastn	135109	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Brochothrix	Brochothrix thermosphacta
17001839	17001839	PRJNA421571_P_NODE_97474_length_247_cov_1.316092_g94925_i0	PRJNA421571	97474	247	1.316092	3.25074724	Vagococcus fluvialis	2738	Bacteria	Bacteria	60.2	1.33e-4	NTclustered	gi\|2124551616\|gb\|CP081461.1\|	2738	g94925	i0	97.143	1.23481781376518	35	1	14	0	172	206	876923	876957	Vagococcus fluvialis strain 36B2 chromosome, complete genome	blastn	305	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus fluvialis
18276179	18276179	PRJNA421571_P_NODE_99895_length_246_cov_0.878613_g97346_i0	PRJNA421571	99895	246	0.878613	2.16138798	Mesobacillus foraminis	279826	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|1494009830\|gb\|CP033044.1\|	279826	g97346	i0	99.187	1133.92682926829	246	2	100	0	1	246	1296231	1296476	Mesobacillus foraminis strain Bac44 chromosome, complete genome	blastn	278946	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus foraminis
20825294	20825294	PRJNA421571_P_NODE_61197_length_335_cov_1.122137_g58648_i0	PRJNA421571	61197	335	1.122137	3.7591589500000002	Butyrivibrio fibrisolvens	831	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2697376818\|gb\|CP146963.1\|	831	g58648	i0	100	0.0835820895522388	28	0	8	0	284	311	2137813	2137786	Butyrivibrio fibrisolvens strain D1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Butyrivibrio	Butyrivibrio fibrisolvens

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