metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA975724" 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
946491	946491	PRJNA975724_S_NODE_53921_length_290_cov_0.990783_g53740_i0	PRJNA975724	53921	290	0.990783	2.8732707	Hathewaya histolytica	1498	Bacteria	Bacteria	274	5.26e-69	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g53740	i0	84.266	15.551724137931	286	39	98	6	8	290	1464656	1464938	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	4510	274	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
2542538	2542538	PRJNA975724_S_NODE_8482_length_466_cov_9.992366_g8301_i0	PRJNA975724	8482	466	9.992366	46.56442556	Bacillales	1385	Bacteria	Bacteria	856	0	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g8301	i0	99.785	126.064377682403	466	1	100	0	1	466	931	466	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	58746	861	0.994192799070848	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4774489	4774489	PRJNA975724_S_NODE_42484_length_314_cov_1.265560_g42303_i0	PRJNA975724	42484	314	1.26556	3.9738584	Clostridium sporogenes	1509	Bacteria	Bacteria	370	7.14e-98	NTclustered	gi\|2094037488\|gb\|CP082942.1\|	1509	g42303	i0	88.779	5.87579617834395	303	32	96	2	4	305	2610867	2611168	Clostridium sporogenes strain FDAARGOS_1471 chromosome	blastn	1845	370	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sporogenes
4775779	4775779	PRJNA975724_S_NODE_91764_length_241_cov_0.904762_g91583_i0	PRJNA975724	91764	241	0.904762	2.18047642	Staphylospora marina	2490858	Bacteria	Bacteria	130	9.74e-26	NTclustered	gi\|1526221674\|gb\|CP034118.1\|	2490858	g91583	i0	85.156	114.095435684647	128	18	53	1	3	129	46642	46769	Staphylospora marina strain SCSIO 07575 chromosome, complete genome	blastn	27497	130	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Staphylospora	Staphylospora marina
6048742	6048742	PRJNA975724_S_NODE_18205_length_395_cov_2.332298_g18024_i0	PRJNA975724	18205	395	2.332298	9.2125771	Terrisporobacter petrolearius	1460447	Bacteria	Bacteria	60.2	2.26e-4	NTclustered	gi\|2591954491\|gb\|CP102984.1\|	1460447	g18024	i0	94.737	0.248101265822785	38	2	10	0	54	91	2251502	2251539	Terrisporobacter petrolearius strain JCM 19845 chromosome, complete genome	blastn	98	60.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Terrisporobacter	Terrisporobacter petrolearius
6049742	6049742	PRJNA975724_S_NODE_56145_length_285_cov_4.872642_g55964_i0	PRJNA975724	56145	285	4.872642	13.8870297	Hathewaya histolytica	1498	Bacteria	Bacteria	311	3.9300000000000005e-80	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g55964	i0	90.336	1.48771929824561	238	21	84	2	4	240	1303583	1303819	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	424	311	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
8600338	8600338	PRJNA975724_S_NODE_88907_length_243_cov_0.905882_g88726_i0	PRJNA975724	88907	243	0.905882	2.20129326	Hathewaya histolytica	1498	Bacteria	Bacteria	231	2.6199999999999997e-56	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g88726	i0	98.473	1.03292181069959	131	2	100	0	1	131	1442215	1442085	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	251	231	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
8919723	8919723	PRJNA975724_S_NODE_92267_length_237_cov_4.347561_g92086_i0	PRJNA975724	92267	237	4.347561	10.30371957	root	1	Root_unresolved	Root_unresolved	52.8	0.021	NTclustered	gi\|1783154430\|gb\|CP040340.1\|	1396	g92086	i0	100	0.751054852320675	28	0	12	0	142	169	4028259	4028286	Bacillus cereus strain DLOU-Tangshan chromosome, complete genome	blastn	178	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
9875725	9875725	PRJNA975724_S_NODE_9948_length_451_cov_1.476190_g9767_i0	PRJNA975724	9948	451	1.47619	6.6576169	[Clostridium] piliforme	1524	Bacteria	Bacteria	444	6.17e-120	NTclustered	gi\|86129723\|gb\|DQ352808.1\|	1524	g9767	i0	85.185	333.456762749446	432	64	96	0	1	432	3361	2930	Clostridium piliforme isolate CRL-K 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	150389	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Tyzzerella	[Clostridium] piliforme
11149774	11149774	PRJNA975724_S_NODE_42849_length_313_cov_1.512500_g42668_i0	PRJNA975724	42849	313	1.5125	4.734125	Hathewaya histolytica	1498	Bacteria	Bacteria	568	2.3499999999999998e-157	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g42668	i0	99.361	1	313	2	100	0	1	313	1481794	1481482	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	313	568	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
12746042	12746042	PRJNA975724_S_NODE_66570_length_268_cov_1.184615_g66389_i0	PRJNA975724	66570	268	1.184615	3.1747682	Bacteria	2	Bacteria	Bacteria	58.4	5.27e-4	NTclustered	gi\|1250077806\|gb\|CP023643.1\|	2756	g66389	i0	97.143	19.6679104477612	35	0	13	1	1	34	1653257	1653223	Brochothrix thermosphacta strain BII chromosome, complete genome	blastn	5271	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Brochothrix	Brochothrix thermosphacta
13700362	13700362	PRJNA975724_S_NODE_62811_length_274_cov_1.283582_g62630_i0	PRJNA975724	62811	274	1.283582	3.51701468	Eisenbergiella porci	2652274	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2777680868\|dbj\|AP031441.1\|	2652274	g62630	i0	100	0.102189781021898	28	0	10	0	186	213	5444665	5444692	Eisenbergiella porci k07-0079-E9-1 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Eisenbergiella	Eisenbergiella porci
13701016	13701016	PRJNA975724_S_NODE_86391_length_245_cov_0.895349_g86210_i0	PRJNA975724	86391	245	0.895349	2.19360505	[Clostridium] piliforme	1524	Bacteria	Bacteria	261	3.38e-65	NTclustered	gi\|86129724\|gb\|DQ352809.1\|	1524	g86210	i0	88	507.395918367347	225	21	91	6	24	245	3815	4036	Clostridium piliforme isolate 11KD 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	124312	261	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Tyzzerella	[Clostridium] piliforme
15294748	15294748	PRJNA975724_S_NODE_38972_length_322_cov_2.096386_g38791_i0	PRJNA975724	38972	322	2.096386	6.75036292	Paenibacillus	44249	Bacteria	Bacteria	78.7	4.99e-10	NTclustered	gi\|1769907722\|gb\|CP045295.1\|	562959	g38791	i0	90.164	0.698757763975155	61	4	19	2	160	219	2284273	2284214	Paenibacillus cellulositrophicus strain KACC 16577 chromosome, complete genome	blastn	225	78.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus cellulositrophicus
16248326	16248326	PRJNA975724_S_NODE_14833_length_414_cov_2.281525_g14652_i0	PRJNA975724	14833	414	2.281525	9.4455135	Weissella confusa	1583	Bacteria	Bacteria	167	1.36e-36	NTclustered	gi\|2472950818\|gb\|CP120516.1\|	1583	g14652	i0	75.26	64.7270531400966	384	77	89	15	46	414	1399671	1400051	Weissella confusa strain CYLB30 chromosome, complete genome	blastn	26797	167	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa
17523452	17523452	PRJNA975724_S_NODE_13734_length_421_cov_1.795977_g13553_i0	PRJNA975724	13734	421	1.795977	7.56106317	Hathewaya histolytica	1498	Bacteria	Bacteria	292	2.1899999999999993e-74	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g13553	i0	87.402	1.18527315914489	254	32	60	0	166	419	2724606	2724859	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	499	292	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
18798056	18798056	PRJNA975724_S_NODE_4415_length_537_cov_6.157328_g4236_i0	PRJNA975724	4415	537	6.157328	33.06485136	Anaerotignum propionicum	28446	Bacteria	Bacteria	492	2.62e-134	NTclustered	gi\|995953349\|gb\|CP014223.1\|	991789	g4236	i0	83.946	286.510242085661	517	79	96	4	1	514	379007	378492	Anaerotignum propionicum DSM 1682, complete genome	blastn	153856	492	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Anaerotignaceae	Anaerotignum	Anaerotignum propionicum
18798111	18798111	PRJNA975724_S_NODE_46595_length_304_cov_2.385281_g46414_i0	PRJNA975724	46595	304	2.385281	7.25125424	Hathewaya histolytica	1498	Bacteria	Bacteria	512	1.08e-140	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g46414	i0	97.039	1	304	9	100	0	1	304	1457132	1457435	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	304	512	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
18798416	18798416	PRJNA975724_S_NODE_58615_length_281_cov_1.480769_g58434_i0	PRJNA975724	58615	281	1.480769	4.16096089	Pullulanibacillus sp. KACC 23026	3028315	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2452489439\|gb\|CP119107.1\|	3028315	g58434	i0	94.444	0.626334519572954	36	2	13	0	166	201	1581142	1581107	Pullulanibacillus sp. KACC 23026 chromosome, complete genome	blastn	176	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Sporolactobacillaceae	Pullulanibacillus	Pullulanibacillus sp. KACC 23026
20072282	20072282	PRJNA975724_S_NODE_21796_length_378_cov_2.911475_g21615_i0	PRJNA975724	21796	378	2.911475	11.0053755	Anaerotignum sp. MB30-C6	3070814	Bacteria	Bacteria	518	2.95e-142	NTclustered	gi\|2569599646\|gb\|CP133078.1\|	3070814	g21615	i0	91.711	799.846560846561	374	29	99	1	3	376	611717	612088	Anaerotignum sp. MB30-C6 chromosome, complete genome	blastn	302342	518	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Anaerotignaceae	Anaerotignum	Anaerotignum sp. MB30-C6
22944557	22944557	PRJNA975724_S_NODE_81518_length_249_cov_0.863636_g81337_i0	PRJNA975724	81518	249	0.863636	2.15045364	root	1	Root_unresolved	Root_unresolved	399	6.989999999999999e-107	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g81337	i0	98.667	88.5542168674699	225	3	90	0	1	225	894153	894377	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	22050	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
24218491	24218491	PRJNA975724_S_NODE_47759_length_302_cov_1.222707_g47578_i0	PRJNA975724	47759	302	1.222707	3.69257514	Metabacillus	2675233	Bacteria	Bacteria	60.2	1.68e-4	NTclustered	gi\|1891105402\|gb\|CP055263.1\|	2745198	g47578	i0	100	0.211920529801325	32	0	11	0	176	207	2773607	2773576	Metabacillus sp. KUDC1714 chromosome, complete genome	blastn	64	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus elymi
25493357	25493357	PRJNA975724_S_NODE_78980_length_251_cov_0.865169_g78799_i0	PRJNA975724	78980	251	0.865169	2.17157419	Bacillati	1783272	Bacteria	Bacteria	412	9.06e-111	NTclustered	gi\|2007734766\|gb\|CP071738.1\|	1421	g78799	i0	99.558	905.107569721116	226	1	90	0	26	251	12309	12534	Lysinibacillus sphaericus strain BS-pTAND672-2 chromosome	blastn	227182	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sphaericus

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