metadata: contig_metadata: 19 rows where bioproject = "PRJNA1263632" and tax

19 rows where bioproject = "PRJNA1263632" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
363766	363766	PRJNA1263632_P_NODE_7161_length_247_cov_0.885057_g7143_i0	PRJNA1263632	7161	247	0.885057	2.18609079	Clostridia bacterium	2044939	Bacteria	Bacteria	81.6	1.72e-18	NR	MEG1510266.1	2044939	g7143	i0	78.7	5.19838056680162	47	10	57.1	0	178	38	3	49	MEG1510266.1 zinc-ribbon domain-containing protein [Clostridia bacterium]	diamond	1284	81.6	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
3604489	3604489	PRJNA1263632_P_NODE_8563_length_233_cov_2.956250_g8545_i0	PRJNA1263632	8563	233	2.95625	6.8880625	Streptomyces	1883	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2070205667\|gb\|CP079114.1\|	2855836	g8545	i0	100	0.240343347639485	28	0	12	0	84	111	3126113	3126086	Streptomyces sp. WY228 chromosome	blastn	56	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. WY228
4882020	4882020	PRJNA1263632_P_NODE_2404_length_391_cov_2.959119_g2386_i0	PRJNA1263632	2404	391	2.959119	11.57015529	Listeria	1637	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2611946659\|gb\|CP137276.1\|	1639	g2386	i0	96.875	8.82097186700767	32	0	8	1	81	112	2548517	2548487	Listeria monocytogenes strain FV3 chromosome, complete genome	blastn	3449	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
11257317	11257317	PRJNA1263632_P_NODE_3189_length_343_cov_3.262963_g3171_i0	PRJNA1263632	3189	343	3.262963	11.19196309	root	1	Root_unresolved	Root_unresolved	628	1.1799999999999997e-175	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g3171	i0	99.708	98.8250728862974	343	1	100	0	1	343	2463318	2463660	Staphylococcus aureus strain WH9628 chromosome	blastn	33897	628	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16941078	16941078	PRJNA1263632_P_NODE_8334_length_241_cov_0.916667_g8316_i0	PRJNA1263632	8334	241	0.916667	2.20916747	Mycoplasmopsis adleri	51362	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2860284679\|gb\|CP174162.1\|	51362	g8316	i0	81.69	0.294605809128631	71	7	28	5	142	208	1102201	1102133	Mycoplasmopsis adleri strain G145 chromosome, complete genome	blastn	71	54.7	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis adleri
18905476	18905476	PRJNA1263632_P_NODE_8355_length_241_cov_0.916667_g8337_i0	PRJNA1263632	8355	241	0.916667	2.20916747	Cutibacterium	1912216	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8337	i0	100	56.551867219917	241	0	100	0	1	241	1299535	1299295	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13629	446	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22040458	22040458	PRJNA1263632_P_NODE_6998_length_248_cov_0.880000_g6980_i0	PRJNA1263632	6998	248	0.88	2.1824	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g6980	i0	100	0.112903225806452	28	0	11	0	182	209	3228849	3228822	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
24006006	24006006	PRJNA1263632_P_NODE_6799_length_249_cov_0.875000_g6781_i0	PRJNA1263632	6799	249	0.875	2.17875	Staphylococcus	1279	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g6781	i0	99.598	97.8473895582329	249	1	100	0	1	249	60603	60355	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	24364	455	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
27326807	27326807	PRJNA1263632_P_NODE_1583_length_476_cov_1.751861_g1565_i0	PRJNA1263632	1583	476	1.751861	8.33885836	Clostridia bacterium	2044939	Bacteria	Bacteria	191	5.4599999999999995e-56	NR	MBP3800546.1	2044939	g1565	i0	62.8	0.913865546218487	145	54	91.4	0	436	2	125	269	MBP3800546.1 50S ribosomal protein L3 [Clostridia bacterium]	diamond	435	191	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
27755369	27755369	PRJNA1263632_P_NODE_4904_length_285_cov_1.070755_g4886_i0	PRJNA1263632	4904	285	1.070755	3.05165175	Bacteria	2	Bacteria	Bacteria	53.5	9.16e-6	NR	NLP48504.1	1898207	g4886	i0	44.7	2.55789473684211	85	39	89.5	4	284	30	267	343	NLP48504.1 phosphonopyruvate decarboxylase [Clostridiales bacterium]	diamond	729	53.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
29473576	29473576	PRJNA1263632_P_NODE_6670_length_250_cov_0.870056_g6652_i0	PRJNA1263632	6670	250	0.870056	2.17514	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	44.7	0.00627	NR	MDQ6771743.1	2052315	g6652	i0	43.1	0.78	65	37	78	0	230	36	114	178	MDQ6771743.1 helix-turn-helix domain-containing protein [Candidatus Dormiibacterota bacterium]	diamond	195	44.7	1	Bacteria		Bacillati	Candidatus Dormiibacterota					Candidatus Dormiibacterota bacterium
29505308	29505308	PRJNA1263632_P_NODE_2150_length_414_cov_2.475073_g2132_i0	PRJNA1263632	2150	414	2.475073	10.24680222	Nostoc sp. DedQUE01	3075387	Bacteria	Bacteria	89.4	1.84e-19	NR	MFN6501164.1	3075387	g2132	i0	34.6	2.92753623188406	136	86	97.8	2	405	1	5	138	MFN6501164.1 TerB family tellurite resistance protein [Nostoc sp. DedQUE01]	diamond	1212	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. DedQUE01
30990316	30990316	PRJNA1263632_P_NODE_2994_length_354_cov_1.206406_g2976_i0	PRJNA1263632	2994	354	1.206406	4.27067724	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	186	5.109999999999999e-56	NR	MBX9694561.1	2847862	g2976	i0	77.1	1	118	26	99.2	1	2	352	72	189	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	354	186	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31134072	31134072	PRJNA1263632_P_NODE_2915_length_358_cov_1.621053_g2897_i0	PRJNA1263632	2915	358	1.621053	5.80336974	root	1	Root_unresolved	Root_unresolved	109	8.88e-28	NR	MEZ4515128.1	2026724	g2897	i0	45.6	2.93296089385475	114	61	94.7	1	339	1	6	119	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	1050	109	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31134073	31134073	PRJNA1263632_P_NODE_6955_length_248_cov_0.880000_g6937_i0	PRJNA1263632	6955	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	43.5	0.0219	NR	MCP4541251.1	2026724	g6937	i0	44.9	1.42741935483871	49	26	59.3	1	3	149	416	463	MCP4541251.1 DUF11 domain-containing protein [Chloroflexota bacterium]	diamond	354	43.9	0.990888382687927	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31210844	31210844	PRJNA1263632_P_NODE_7375_length_246_cov_0.890173_g7357_i0	PRJNA1263632	7375	246	0.890173	2.18982558	Clostridium botulinum	1491	Bacteria	Bacteria	47.4	8.34e-4	NR	NFE93591.1	1491	g7357	i0	36.3	1.95121951219512	80	48	95.1	2	5	238	40	118	NFE93591.1 hypothetical protein [Clostridium botulinum]	diamond	480	47.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
31717394	31717394	PRJNA1263632_P_NODE_8257_length_242_cov_0.911243_g8239_i0	PRJNA1263632	8257	242	0.911243	2.20520806	Microcoleus sp. FACHB-53	2692823	Bacteria	Bacteria	73.2	3.1e-13	NR	MBD2014905.1	2692823	g8239	i0	47.1	1.74793388429752	70	37	86.8	0	2	211	188	257	MBD2014905.1 TauD/TfdA family dioxygenase [Microcoleus sp. FACHB-53]	diamond	423	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-53
32033797	32033797	PRJNA1263632_P_NODE_6398_length_251_cov_0.865169_g6380_i0	PRJNA1263632	6398	251	0.865169	2.17157419	Chloroflexales bacterium	2725990	Bacteria	Bacteria	75.5	1.2e-13	NR	MCG8349124.1	2725990	g6380	i0	48.2	0.99203187250996006	83	39	99.2	1	3	251	483	561	MCG8349124.1 choline/carnitine O-acyltransferase [Chloroflexales bacterium]	diamond	249	75.5	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales			Chloroflexales bacterium
32666014	32666014	PRJNA1263632_P_NODE_2260_length_404_cov_1.740181_g2242_i0	PRJNA1263632	2260	404	1.740181	7.03033124	Clostridia bacterium	2044939	Bacteria	Bacteria	145	4.96e-39	NR	MBP3800546.1	2044939	g2242	i0	59.8	0.905940594059406	122	49	90.6	0	3	368	282	403	MBP3800546.1 50S ribosomal protein L3 [Clostridia bacterium]	diamond	366	145	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium

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