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

19 rows where bioproject = "PRJNA1101048" and tax_phylum = "Actinomycetota"

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
1019771	1019771	PRJNA1101048_P_NODE_4361_length_302_cov_2.720524_g4305_i0	PRJNA1101048	4361	302	2.720524	8.21598248	Cutibacterium	1912216	Bacteria	Bacteria	525	1.3799999999999995e-144	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4305	i0	98.976	258.470198675497	293	3	97	0	2	294	55937	55645	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	78058	525	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3570375	3570375	PRJNA1101048_P_NODE_4723_length_293_cov_2.200000_g4667_i0	PRJNA1101048	4723	293	2.2	6.446	Cutibacterium	1912216	Bacteria	Bacteria	298	3.16e-76	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4667	i0	99.39	53.1638225255973	164	1	100	0	130	293	515893	515730	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15577	298	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9948021	9948021	PRJNA1101048_P_NODE_3168_length_340_cov_1.397004_g3112_i0	PRJNA1101048	3168	340	1.397004	4.7498136	Streptomyces	1883	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2173784915\|gb\|CP085300.1\|	2605730	g3112	i0	100	0.164705882352941	28	0	8	0	223	250	6500038	6500065	Streptomyces sp. BSE6.1 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. BSE6.1
9948024	9948024	PRJNA1101048_P_NODE_5608_length_275_cov_2.767327_g5552_i0	PRJNA1101048	5608	275	2.767327	7.61014925	Cutibacterium	1912216	Bacteria	Bacteria	466	7.62e-127	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5552	i0	98.855	243.043636363636	262	2	95	1	10	270	56848	57109	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	66837	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10414607	10414607	PRJNA1101048_P_NODE_7629_length_250_cov_0.881356_g7573_i0	PRJNA1101048	7629	250	0.881356	2.20339	Corynebacterium pseudokroppenstedtii	2804917	Bacteria	Bacteria	436	5.349999999999999e-118	NTclustered	gi\|2659438818\|gb\|CP137757.1\|	2804917	g7573	i0	99.582	6.276	239	1	96	0	1	239	780984	780746	Corynebacterium pseudokroppenstedtii strain P15_C1 chromosome, complete genome	blastn	1569	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudokroppenstedtii
13773210	13773210	PRJNA1101048_P_NODE_7451_length_251_cov_0.876404_g7395_i0	PRJNA1101048	7451	251	0.876404	2.19977404	Corynebacterium	1716	Bacteria	Bacteria	340	4.33e-89	NTclustered	gi\|1986028547\|gb\|CP069509.1\|	161879	g7395	i0	97.487	4	199	5	79	0	28	226	1378458	1378260	Corynebacterium kroppenstedtii strain FDAARGOS_1192 chromosome, complete genome	blastn	1004	340	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
16322324	16322324	PRJNA1101048_P_NODE_6373_length_262_cov_1.507937_g6317_i0	PRJNA1101048	6373	262	1.507937	3.95079494	Cutibacterium	1912216	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g6317	i0	100	52.1374045801527	259	0	99	0	1	259	1768822	1768564	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13660	479	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18062895	18062895	PRJNA1101048_P_NODE_5195_length_284_cov_1.194313_g5139_i0	PRJNA1101048	5195	284	1.194313	3.39184892	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	444	3.6999999999999986e-120	NTclustered	gi\|2694275225\|gb\|CP140010.1\|	1528099	g5139	i0	99.588	4.01056338028169	243	1	99	0	3	245	345818	346060	MAG: Lawsonella clevelandensis isolate TECA_312545_bc_10 chromosome	blastn	1139	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
18062903	18062903	PRJNA1101048_P_NODE_8115_length_248_cov_0.885714_g8059_i0	PRJNA1101048	8115	248	0.885714	2.19657072	Corynebacterium kroppenstedtii	161879	Bacteria	Bacteria	374	4.2099999999999995e-99	NTclustered	gi\|2809007534\|gb\|CP119163.1\|	2736648	g8059	i0	94.606	80.9193548387097	241	13	97	0	3	243	2337002	2337242	Corynebacterium kroppenstedtii subsp. demodicis strain Df-1 chromosome, complete genome	blastn	20068	374	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
26814602	26814602	PRJNA1101048_P_NODE_9101_length_243_cov_0.917647_g9045_i0	PRJNA1101048	9101	243	0.917647	2.22988221	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0352	NR	WP_399964477.1	3365722	g9045	i0	38.7	0.765432098765432	62	38	76.5	0	11	196	202	263	WP_399964477.1 polyprenyl synthetase family protein [Streptomyces sp. NPDC079020]	diamond	186	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC079020
27510150	27510150	PRJNA1101048_P_NODE_7323_length_251_cov_1.747191_g7267_i0	PRJNA1101048	7323	251	1.747191	4.38544941	Bifidobacteriaceae bacterium	2291324	Bacteria	Bacteria	66.6	4.92e-12	NR	MDO5764056.1	2291324	g7267	i0	90.6	0.382470119521912	32	3	38.2	0	249	154	40	71	MDO5764056.1 hypothetical protein [Bifidobacteriaceae bacterium]	diamond	96	66.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae		Bifidobacteriaceae bacterium
28109794	28109794	PRJNA1101048_P_NODE_3685_length_322_cov_1.393574_g3629_i0	PRJNA1101048	3685	322	1.393574	4.48730828	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	43.5	0.0473	NR	HEY4896767.1	2586742	g3629	i0	35.8	0.754658385093168	81	49	75.5	1	282	40	107	184	HEY4896767.1 M48 family metalloprotease [Solirubrobacteraceae bacterium]	diamond	243	43.5	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
28710015	28710015	PRJNA1101048_P_NODE_8607_length_245_cov_1.406977_g8551_i0	PRJNA1101048	8607	245	1.406977	3.44709365	Demequina capsici	3075620	Bacteria	Bacteria	43.5	0.0153	NR	WP_313541647.1	3075620	g8551	i0	31.2	1.88571428571429	77	52	93.1	1	14	241	56	132	WP_313541647.1 biotin transporter BioY [Demequina capsici]	diamond	462	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Demequinaceae	Demequina	Demequina capsici
28772886	28772886	PRJNA1101048_P_NODE_6927_length_253_cov_1.722222_g6871_i0	PRJNA1101048	6927	253	1.722222	4.35722166	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	43.1	0.0197	NR	MEI2785879.1	2518612	g6871	i0	52.5	0.474308300395257	40	15	47.4	1	25	144	136	171	MEI2785879.1 DUF222 domain-containing protein [Candidatus Nanopelagicales bacterium]	diamond	120	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
29688328	29688328	PRJNA1101048_P_NODE_7690_length_250_cov_0.881356_g7634_i0	PRJNA1101048	7690	250	0.881356	2.20339	Streptomyces macrosporus	44032	Bacteria	Bacteria	43.9	0.0159	NR	WP_344320102.1	44032	g7634	i0	43.8	1.164	48	23	55.2	3	73	210	216	261	WP_344320102.1 hypothetical protein [Streptomyces macrosporus]	diamond	291	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces macrosporus
30825892	30825892	PRJNA1101048_P_NODE_8734_length_245_cov_0.906977_g8678_i0	PRJNA1101048	8734	245	0.906977	2.22209365	Blastococcus colisei	1564162	Bacteria	Bacteria	41.2	0.0322	NR	WP_142023984.1	1564162	g8678	i0	41.3	0.771428571428571	63	31	73.5	4	32	211	7	66	WP_142023984.1 DUF2516 family protein [Blastococcus colisei]	diamond	189	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus colisei
31015500	31015500	PRJNA1101048_P_NODE_6995_length_253_cov_0.866667_g6939_i0	PRJNA1101048	6995	253	0.866667	2.19266751	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	44.3	0.0113	NR	MFN8130756.1	2586742	g6939	i0	35.4	1.73122529644269	48	30	56.9	1	156	13	61	107	MFN8130756.1 hypothetical protein [Solirubrobacteraceae bacterium]	diamond	438	44.3	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
31711184	31711184	PRJNA1101048_P_NODE_7877_length_249_cov_0.886364_g7821_i0	PRJNA1101048	7877	249	0.886364	2.20704636	Saccharopolyspora rosea	524884	Bacteria	Bacteria	43.1	0.0271	NR	WP_263250359.1	524884	g7821	i0	35.1	0.686746987951807	57	32	62.7	2	39	194	202	258	WP_263250359.1 DUF4328 domain-containing protein [Saccharopolyspora rosea]	diamond	171	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora rosea
32407280	32407280	PRJNA1101048_P_NODE_8459_length_246_cov_0.901734_g8403_i0	PRJNA1101048	8459	246	0.901734	2.21826564	Actinomycetes bacterium	1883427	Bacteria	Bacteria	42.7	0.0375	NR	MCL2339710.1	1883427	g8403	i0	36.9	0.792682926829268	65	30	65.9	3	38	199	361	425	MCL2339710.1 PH domain-containing protein [Actinomycetes bacterium]	diamond	195	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes 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);;