metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1088503" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1088503" 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
4845579	4845579	PRJNA1088503_P_NODE_264_length_1352_cov_4.937264_g225_i0	PRJNA1088503	264	1352	4.937264	66.75180928	Cutibacterium	1912216	Bacteria	Bacteria	1533	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g225	i0	99.88	56.3247041420118	834	0	98	1	21	853	16115	15282	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	76151	1533	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4845582	4845582	PRJNA1088503_P_NODE_5864_length_325_cov_31827.635135_g5492_i0	PRJNA1088503	5864	325	31827.635135	103439.81418875	Micrococcus	1269	Bacteria	Bacteria	523	5.379999999999999e-144	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g5492	i0	100	355.8	283	0	87	0	37	319	348264	348546	Micrococcus luteus strain V017 chromosome, complete genome	blastn	115635	523	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
5297345	5297345	PRJNA1088503_P_NODE_945_length_908_cov_10573.125142_g832_i0	PRJNA1088503	945	908	10573.125142	96003.97628936	Cutibacterium acnes	1747	Bacteria	Bacteria	1574	0	NTclustered	gi\|2790107115\|gb\|CP166959.1\|	1747	g832	i0	99.652	1.89647577092511	861	3	95	0	15	875	1222469	1221609	Cutibacterium acnes strain CN6 chromosome, complete genome	blastn	1722	1574	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8670748	8670748	PRJNA1088503_P_NODE_1827_length_681_cov_13570.429448_g1621_i0	PRJNA1088503	1827	681	13570.429448	92414.62454088	Cutibacterium	1912216	Bacteria	Bacteria	1147	0	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g1621	i0	99.681	48.8766519823789	627	2	92	0	34	660	855089	854463	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	33285	1147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9122107	9122107	PRJNA1088503_P_NODE_1208_length_823_cov_13533.468514_g1067_i0	PRJNA1088503	1208	823	13533.468514	111380.44587022	Actinomyces massiliensis	461393	Bacteria	Bacteria	1441	0	NTclustered	gi\|2557556977\|gb\|CP128646.1\|	461393	g1067	i0	99.62	0.95868772782503	789	3	96	0	8	796	3307263	3308051	Actinomyces massiliensis strain F0489 chromosome, complete genome	blastn	789	1441	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces massiliensis
12496290	12496290	PRJNA1088503_P_NODE_170_length_1498_cov_147.707284_g141_i0	PRJNA1088503	170	1498	147.707284	2212.65511432	Cutibacterium	1912216	Bacteria	Bacteria	2700	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g141	i0	99.932	52.7389853137517	1465	1	98	0	22	1486	821484	822948	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	79003	2700	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12948220	12948220	PRJNA1088503_P_NODE_8911_length_218_cov_55405.296296_g8539_i0	PRJNA1088503	8911	218	55405.296296	120783.54592528	Mycobacterium tuberculosis	1773	Bacteria	Bacteria	60.2	1.15e-4	NTclustered	gi\|2126371852\|gb\|CP085615.1\|	1773	g8539	i0	94.872	4.86238532110092	39	1	17	1	181	218	4028500	4028462	Mycobacterium tuberculosis strain 253/2019 chromosome	blastn	1060	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
14223249	14223249	PRJNA1088503_P_NODE_3792_length_452_cov_11.432624_g3445_i0	PRJNA1088503	3792	452	11.432624	51.67546048	Cutibacterium acnes	1747	Bacteria	Bacteria	809	0	NTclustered	gi\|966533409\|gb\|CP012350.1\|	1747	g3445	i0	100	105.008849557522	438	0	97	0	1	438	612320	612757	Cutibacterium acnes strain PA_30_2_L1 chromosome, complete genome	blastn	47464	809	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15045202	15045202	PRJNA1088503_P_NODE_9332_length_208_cov_12.692737_g8960_i0	PRJNA1088503	9332	208	12.692737	26.40089296	Cutibacterium	1912216	Bacteria	Bacteria	331	2.0900000000000002e-86	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8960	i0	99.454	217	183	0	88	1	18	200	57462	57281	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	45136	331	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15497176	15497176	PRJNA1088503_P_NODE_8773_length_222_cov_47520.994819_g8401_i0	PRJNA1088503	8773	222	47520.994819	105496.60849818	Pseudarthrobacter defluvii	410837	Bacteria	Bacteria	145	3.16e-30	NTclustered	gi\|2522919821\|gb\|CP066362.1\|	410837	g8401	i0	93.75	0.432432432432432	96	6	43	0	94	189	3348046	3348141	Pseudarthrobacter defluvii strain E5 chromosome, complete genome	blastn	96	145	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter defluvii
19320284	19320284	PRJNA1088503_P_NODE_8816_length_221_cov_47740.984375_g8444_i0	PRJNA1088503	8816	221	47740.984375	105507.57546875	Arsenicicoccus cauae	2663847	Bacteria	Bacteria	243	1.08e-59	NTclustered	gi\|2831290308\|gb\|CP171001.1\|	2663847	g8444	i0	98.54	1.00452488687783	137	2	62	0	70	206	3045002	3044866	Arsenicicoccus cauae strain WGS1510 chromosome, complete genome	blastn	222	243	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Arsenicicoccus	Arsenicicoccus cauae
20143885	20143885	PRJNA1088503_P_NODE_6896_length_283_cov_41935.996063_g6524_i0	PRJNA1088503	6896	283	41935.996063	118678.86885829	Cutibacterium	1912216	Bacteria	Bacteria	339	1.79e-88	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g6524	i0	100	32.9787985865724	183	0	65	0	34	216	1833764	1833582	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9333	339	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22694376	22694376	PRJNA1088503_P_NODE_7678_length_256_cov_46936.687225_g7306_i0	PRJNA1088503	7678	256	46936.687225	120157.919296	Cutibacterium	1912216	Bacteria	Bacteria	414	2.58e-111	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7306	i0	99.134	154.62109375	231	1	90	1	26	256	53362	53591	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	39583	414	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23969892	23969892	PRJNA1088503_P_NODE_7759_length_253_cov_48488.665179_g7387_i0	PRJNA1088503	7759	253	48488.665179	122676.32290287	Micrococcus	1269	Bacteria	Bacteria	405	1.53e-108	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g7387	i0	100	82.1778656126482	219	0	87	0	35	253	759580	759798	Micrococcus luteus strain V017 chromosome, complete genome	blastn	20791	405	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25243833	25243833	PRJNA1088503_P_NODE_11320_length_159_cov_1.184615_g10948_i0	PRJNA1088503	11320	159	1.184615	1.88353785	Cutibacterium	1912216	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10948	i0	100	103.433962264151	159	0	100	0	1	159	1945661	1945503	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16446	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25243837	25243837	PRJNA1088503_P_NODE_5760_length_330_cov_35453.634551_g5388_i0	PRJNA1088503	5760	330	35453.634551	116996.9940183	Cutibacterium	1912216	Bacteria	Bacteria	555	1.9399999999999994e-153	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5388	i0	100	47.1484848484848	300	0	91	0	8	307	565754	566053	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15559	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25243839	25243839	PRJNA1088503_P_NODE_6740_length_289_cov_40616.788462_g6368_i0	PRJNA1088503	6740	289	40616.788462	117382.51865518	Cutibacterium	1912216	Bacteria	Bacteria	473	4.819999999999999e-129	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g6368	i0	99.615	251.996539792388	260	0	90	1	1	259	56873	56614	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	72827	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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