metadata: contig_metadata: 30 rows where bioproject = "PRJNA575566" and tax

30 rows where bioproject = "PRJNA575566" 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
1136869	1136869	PRJNA575566_P_NODE_9401_length_341_cov_1.135714_g9204_i0	PRJNA575566	9401	341	1.135714	3.87278474	Rathayibacter	33886	Bacteria	Bacteria	592	1.54e-164	NTclustered	gi\|1026621770\|gb\|CP015515.1\|	33888	g9204	i0	97.947	182.005865102639	341	7	100	0	1	341	1189812	1189472	Rathayibacter tritici strain NCPPB 1953, complete genome	blastn	62064	592	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rathayibacter	Rathayibacter tritici
3110884	3110884	PRJNA575566_P_NODE_17003_length_256_cov_1.076923_g16806_i0	PRJNA575566	17003	256	1.076923	2.75692288	Antiquaquibacter oligotrophicus	2880260	Bacteria	Bacteria	457	4.22e-124	NTclustered	gi\|2119302123\|gb\|CP085036.1\|	2880260	g16806	i0	98.828	189.78515625	256	3	100	0	1	256	291846	292101	Antiquaquibacter oligotrophicus strain SG_E_30_P1 chromosome, complete genome	blastn	48585	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Antiquaquibacter	Antiquaquibacter oligotrophicus
8789488	8789488	PRJNA575566_P_NODE_11267_length_312_cov_1.079681_g11070_i0	PRJNA575566	11267	312	1.079681	3.36860472	Microbacterium	33882	Bacteria	Bacteria	549	8.489999999999997e-152	NTclustered	gi\|2499903749\|gb\|OQ918216.1\|	51671	g11070	i0	98.397	104.865384615385	312	5	100	0	1	312	6	317	Microbacterium sp. strain HTZ3 16S ribosomal RNA gene, partial sequence	blastn	32718	549	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
8789493	8789493	PRJNA575566_P_NODE_12047_length_302_cov_1.568465_g11850_i0	PRJNA575566	12047	302	1.568465	4.7367643	Cutibacterium	1912216	Bacteria	Bacteria	558	1.36e-154	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11850	i0	100	253.35761589404	302	0	100	0	1	302	55371	55672	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	76514	558	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8789495	8789495	PRJNA575566_P_NODE_12247_length_300_cov_0.987448_g12050_i0	PRJNA575566	12247	300	0.987448	2.962344	Micrococcaceae	1268	Bacteria	Bacteria	433	8.53e-117	NTclustered	gi\|1883577788\|gb\|CP059343.1\|	1272	g12050	i0	92.715	357.083333333333	302	19	100	3	1	300	1051879	1052179	Kocuria varians strain 80 chromosome, complete genome	blastn	107125	436	0.993119266055046	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria varians
10065160	10065160	PRJNA575566_P_NODE_11848_length_305_cov_1.004098_g11651_i0	PRJNA575566	11848	305	1.004098	3.0624989	Micrococcales	85006	Bacteria	Bacteria	488	1.83e-133	NTclustered	gi\|1778215143\|gb\|CP046175.1\|	2675754	g11651	i0	96	204.095081967213	300	12	98	0	1	300	1269788	1269489	Occultella kanbiaonis strain HY164 chromosome, complete genome	blastn	62249	488	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Ruaniaceae	Occultella	Occultella kanbiaonis
10764554	10764554	PRJNA575566_P_NODE_9469_length_339_cov_2.143885_g9272_i0	PRJNA575566	9469	339	2.143885	7.26777015	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	616	9.05e-172	NTclustered	gi\|2874253773\|emb\|OY969722.1\|	3039803	g9272	i0	99.41	244.646017699115	339	2	100	0	1	339	1178519	1178857	MAG: uncultured Actinomycetota bacterium isolate MFD10113.bin.2.32 genome assembly, chromosome: 1	blastn	82935	616	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
11340048	11340048	PRJNA575566_P_NODE_3629_length_546_cov_6.915464_g3433_i0	PRJNA575566	3629	546	6.915464	37.75843344	Micrococcus	1269	Bacteria	Bacteria	998	0	NTclustered	gi\|2274423316\|gb\|CP101465.1\|	1270	g3433	i0	99.634	366.001831501831	546	2	100	0	1	546	363129	362584	Micrococcus luteus strain DNA1 chromosome, complete genome	blastn	199837	998	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
12039150	12039150	PRJNA575566_P_NODE_22190_length_221_cov_0.950000_g21993_i0	PRJNA575566	22190	221	0.95	2.0995	Corynebacterium nuruki	1032851	Bacteria	Bacteria	381	2.2e-101	NTclustered	gi\|1721633248\|gb\|CP042429.1\|	863239	g21993	i0	99.057	305.253393665158	212	2	96	0	1	212	767557	767346	Corynebacterium nuruki S6-4 chromosome, complete genome	blastn	67461	381	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium nuruki
13890785	13890785	PRJNA575566_P_NODE_2651_length_636_cov_2.231304_g2461_i0	PRJNA575566	2651	636	2.231304	14.19109344	Cutibacterium	1912216	Bacteria	Bacteria	1103	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2461	i0	98.113	282.536163522013	636	7	100	2	1	636	56307	55677	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	179693	1103	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13890896	13890896	PRJNA575566_P_NODE_911_length_1048_cov_4.627153_g786_i0	PRJNA575566	911	1048	4.627153	48.49256344	Micrococcus	1269	Bacteria	Bacteria	1585	0	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g786	i0	99.54	206.409351145038	870	4	90	0	179	1048	1627334	1628203	Micrococcus luteus strain ML chromosome, complete genome	blastn	216317	1585	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
14588717	14588717	PRJNA575566_P_NODE_12612_length_296_cov_0.987234_g12415_i0	PRJNA575566	12612	296	0.987234	2.92221264	Brachybacterium sp. GU-2	3069708	Bacteria	Bacteria	433	8.4e-117	NTclustered	gi\|2583613703\|gb\|CP133037.2\|	3069708	g12415	i0	92.977	364.912162162162	299	17	100	4	1	296	715181	715478	Brachybacterium sp. GU-2 chromosome, complete genome	blastn	108014	433	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. GU-2
15164839	15164839	PRJNA575566_P_NODE_20792_length_229_cov_3.410714_g20595_i0	PRJNA575566	20792	229	3.410714	7.81053506	Micrococcus	1269	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g20595	i0	100	399.659388646288	229	0	100	0	1	229	348264	348492	Micrococcus luteus strain V017 chromosome, complete genome	blastn	91522	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15164898	15164898	PRJNA575566_P_NODE_28012_length_204_cov_0.895105_g27815_i0	PRJNA575566	28012	204	0.895105	1.8260142	Cutibacterium	1912216	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g27815	i0	100	82.4558823529412	204	0	100	0	1	204	2104204	2104407	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16821	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16439350	16439350	PRJNA575566_P_NODE_21633_length_224_cov_1.570552_g21436_i0	PRJNA575566	21633	224	1.570552	3.51803648	Corynebacterium	1716	Bacteria	Bacteria	409	1.03e-109	NTclustered	gi\|2550476051\|gb\|CP100377.1\|	38284	g21436	i0	99.554	377.491071428571	224	1	100	0	1	224	2470788	2471011	Corynebacterium accolens strain CA6 chromosome, complete genome	blastn	84558	409	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
17714601	17714601	PRJNA575566_P_NODE_15454_length_268_cov_1.289855_g15257_i0	PRJNA575566	15454	268	1.289855	3.4568114	Corynebacterium	1716	Bacteria	Bacteria	490	4.39e-134	NTclustered	gi\|2550482033\|gb\|CP100379.1\|	38284	g15257	i0	99.628	365.414179104478	269	0	100	1	1	268	2461290	2461558	Corynebacterium accolens strain CA4 chromosome	blastn	97931	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
18412147	18412147	PRJNA575566_P_NODE_3815_length_534_cov_2.188161_g3619_i0	PRJNA575566	3815	534	2.188161	11.68477974	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	876	0	NTclustered	gi\|2874253773\|emb\|OY969722.1\|	3039803	g3619	i0	96.269	190.936329588015	536	17	100	3	1	534	1177162	1177696	MAG: uncultured Actinomycetota bacterium isolate MFD10113.bin.2.32 genome assembly, chromosome: 1	blastn	101960	876	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
19686733	19686733	PRJNA575566_P_NODE_5956_length_428_cov_3.272480_g5759_i0	PRJNA575566	5956	428	3.27248	14.0062144	Micrococcus luteus	1270	Bacteria	Bacteria	758	0	NTclustered	gi\|2090302498\|gb\|CP082331.1\|	1270	g5759	i0	98.598	303.894859813084	428	6	100	0	1	428	371304	371731	Micrococcus luteus strain CW.Ay chromosome, complete genome	blastn	130067	758	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
20263203	20263203	PRJNA575566_P_NODE_20156_length_233_cov_2.691860_g19959_i0	PRJNA575566	20156	233	2.69186	6.2720338	Kocuria	57493	Bacteria	Bacteria	342	1.0999999999999999e-89	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g19959	i0	93.162	215.828326180258	234	14	100	2	1	233	898238	898470	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	50288	342	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
20962307	20962307	PRJNA575566_P_NODE_25597_length_207_cov_0.876712_g25400_i0	PRJNA575566	25597	207	0.876712	1.81479384	Streptomyces kanamyceticus	1967	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1751429806\|gb\|CP023699.1\|	1967	g25400	i0	92.308	0.188405797101449	39	3	19	0	158	196	1093710	1093748	Streptomyces kanamyceticus strain ATCC 12853 chromosome, complete genome	blastn	39	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces kanamyceticus
21538660	21538660	PRJNA575566_P_NODE_23157_length_214_cov_2.509804_g22960_i0	PRJNA575566	23157	214	2.509804	5.37098056	Corynebacterium	1716	Bacteria	Bacteria	396	7.559999999999996e-106	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g22960	i0	100	350.214953271028	214	0	100	0	1	214	2491501	2491288	Corynebacterium accolens strain CA3 chromosome	blastn	74946	396	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
21538703	21538703	PRJNA575566_P_NODE_27817_length_204_cov_0.895105_g27620_i0	PRJNA575566	27817	204	0.895105	1.8260142	Corynebacterium	1716	Bacteria	Bacteria	348	2.0300000000000002e-91	NTclustered	gi\|1061049\|emb\|X81904.1\|	1720	g27620	i0	98	98.2107843137255	200	4	98	0	1	200	251	52	Corynebacterium sp. 16S rRNA gene (CDC G5911)	blastn	20035	351	0.991452991452991	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp.
22813844	22813844	PRJNA575566_P_NODE_12438_length_297_cov_2.478814_g12241_i0	PRJNA575566	12438	297	2.478814	7.36207758	Micrococcaceae	1268	Bacteria	Bacteria	473	4.9699999999999996e-129	NTclustered	gi\|1883577788\|gb\|CP059343.1\|	1272	g12241	i0	95.593	350.390572390572	295	13	99	0	3	297	1051977	1052271	Kocuria varians strain 80 chromosome, complete genome	blastn	104066	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria varians
27585027	27585027	PRJNA575566_P_NODE_28404_length_203_cov_0.901408_g28207_i0	PRJNA575566	28404	203	0.901408	1.82985824	Cellulomonas sp. PSBB	40001	Bacteria	Bacteria	102	8.89e-27	NR	ASR55687.1	2003551	g28207	i0	62.7	0.990147783251232	67	25	99	0	3	203	22	88	ASR55687.1 hypothetical protein CBP52_11970 [Cellulomonas sp. PSBB021]	diamond	201	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas sp. PSBB021
28027180	28027180	PRJNA575566_P_NODE_3305_length_571_cov_0.821569_g3110_i0	PRJNA575566	3305	571	0.821569	4.69115899	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	46.6	0.0341	NR	HEX4539557.1	2201156	g3110	i0	32.9	0.893169877408056	170	71	74.1	8	517	95	79	234	HEX4539557.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	510	46.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
30630089	30630089	PRJNA575566_P_NODE_29053_length_202_cov_0.907801_g28856_i0	PRJNA575566	29053	202	0.907801	1.83375802	Micrococcales	85006	Bacteria	Bacteria	68.2	2.34e-11	NR	MDO5698836.1	1863	g28856	i0	44.1	9.34158415841584	68	35	96.5	1	199	5	122	189	MDO5698836.1 peptidoglycan-binding domain-containing protein [Dermatophilus congolensis]	diamond	1887	68.6	0.994169096209913	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Dermatophilus	Dermatophilus congolensis
30647987	30647987	PRJNA575566_P_NODE_13853_length_283_cov_0.792793_g13656_i0	PRJNA575566	13853	283	0.792793	2.24360419	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	43.9	0.0104	NR	HXA74293.1	2201156	g13656	i0	38.8	1.15547703180212	67	34	63.6	2	84	263	72	138	HXA74293.1 DUF501 domain-containing protein [Acidimicrobiales bacterium]	diamond	327	43.9	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
30995884	30995884	PRJNA575566_P_NODE_27034_length_205_cov_0.888889_g26837_i0	PRJNA575566	27034	205	0.888889	1.82222245	Mycobacteriales bacterium	1957017	Bacteria	Bacteria	47	6.9e-4	NR	HEX3811592.1	1957017	g26837	i0	41.4	0.848780487804878	58	32	84.9	2	203	30	80	135	HEX3811592.1 acetoin utilization protein AcuC [Mycobacteriales bacterium]	diamond	174	47	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales			Mycobacteriales bacterium
31786116	31786116	PRJNA575566_P_NODE_16777_length_257_cov_4.244898_g16580_i0	PRJNA575566	16777	257	4.244898	10.90938786	Parafrankia sp. EUN1f	102897	Bacteria	Bacteria	44.7	0.00851	NR	EFC82233.1	102897	g16580	i0	41.4	0.67704280155642	58	33	67.7	1	25	198	29	85	EFC82233.1 conserved hypothetical protein [Parafrankia sp. EUN1f]	diamond	174	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Parafrankia	Parafrankia sp. EUN1f
31976047	31976047	PRJNA575566_P_NODE_24318_length_209_cov_0.864865_g24121_i0	PRJNA575566	24318	209	0.864865	1.80756785	Actinomycetota bacterium	2900548	Bacteria	Bacteria	45.1	0.00336	NR	MEM9522269.1	2900548	g24121	i0	43.9	0.588516746411483	41	22	57.4	1	184	65	122	162	MEM9522269.1 mechanosensitive ion channel family protein [Actinomycetota bacterium]	diamond	123	45.1	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota 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);;