metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA534016" 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
507478	507478	PRJNA534016_P_NODE_13361_length_252_cov_2.804469_g13271_i0	PRJNA534016	13361	252	2.804469	7.06726188	Actinomyces	1654	Bacteria	Bacteria	160	4.89e-49	NR	WP_076131286.1	1655	g13271	i0	100	1.97619047619048	83	0	98.8	0	250	2	26	108	WP_076131286.1 NYN domain-containing protein [Actinomyces naeslundii]	diamond	498	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
26729179	26729179	PRJNA534016_P_NODE_15081_length_248_cov_0.880000_g14991_i0	PRJNA534016	15081	248	0.88	2.1824	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	43.5	0.0209	NR	MEZ5111511.1	1873462	g14991	i0	48.8	0.991935483870968	41	21	49.6	0	168	46	75	115	MEZ5111511.1 L,D-transpeptidase [Microbacteriaceae bacterium]	diamond	246	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
26793029	26793029	PRJNA534016_P_NODE_12341_length_261_cov_0.851064_g12251_i0	PRJNA534016	12341	261	0.851064	2.22127704	Nocardia lasii	1616107	Bacteria	Bacteria	42.7	0.0476	NR	WP_378607160.1	1616107	g12251	i0	36.4	0.758620689655172	66	41	75.9	1	1	198	60	124	WP_378607160.1 DAK2 domain-containing protein [Nocardia lasii]	diamond	198	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia lasii
26934491	26934491	PRJNA534016_P_NODE_12502_length_259_cov_2.387097_g12412_i0	PRJNA534016	12502	259	2.387097	6.18258123	root	1	Root_unresolved	Root_unresolved	43.1	0.0326	NR	WP_328611704.1	2975955	g12412	i0	42.9	2.29343629343629	42	24	48.6	0	7	132	273	314	WP_328611704.1 tachylectin-related carbohydrate-binding protein [Amycolatopsis sp. NBC_00345]	diamond	594	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. NBC_00345
27583206	27583206	PRJNA534016_P_NODE_10104_length_278_cov_1.502439_g10014_i0	PRJNA534016	10104	278	1.502439	4.17678042	Thermoleophilia bacterium	2026888	Bacteria	Bacteria	113	4.5400000000000005e-27	NR	MCB0878198.1	2026888	g10014	i0	63	0.992805755395683	92	34	99.3	0	277	2	172	263	MCB0878198.1 hypothetical protein [Thermoleophilia bacterium]	diamond	276	113	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia				Thermoleophilia bacterium
27913828	27913828	PRJNA534016_P_NODE_16465_length_245_cov_0.895349_g16375_i0	PRJNA534016	16465	245	0.895349	2.19360505	Micrococcus	1269	Bacteria	Bacteria	48.5	2.42e-4	NR	WP_235186525.1	1270	g16375	i0	48.4	5.31428571428571	62	32	75.9	0	58	243	132	193	WP_235186525.1 rhomboid family intramembrane serine protease, partial [Micrococcus luteus]	diamond	1302	48.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
27962180	27962180	PRJNA534016_P_NODE_15625_length_247_cov_0.885057_g15535_i0	PRJNA534016	15625	247	0.885057	2.18609079	Streptomyces brasiliscabiei	2736302	Bacteria	Bacteria	122	3.6e-34	NR	WP_336543724.1	2736302	g15535	i0	86.8	0.825910931174089	68	9	82.6	0	205	2	1	68	WP_336543724.1 hypothetical protein, partial [Streptomyces brasiliscabiei]	diamond	204	122	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces brasiliscabiei
27993885	27993885	PRJNA534016_P_NODE_15225_length_248_cov_0.880000_g15135_i0	PRJNA534016	15225	248	0.88	2.1824	Flaviflexus sp.	1969482	Bacteria	Bacteria	49.7	1.24e-4	NR	WP_371683592.1	1969482	g15135	i0	44	0.604838709677419	50	28	60.5	0	247	98	131	180	WP_371683592.1 dephospho-CoA kinase [Flaviflexus sp.]	diamond	150	49.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Flaviflexus	Flaviflexus sp.
28846092	28846092	PRJNA534016_P_NODE_14648_length_249_cov_0.875000_g14558_i0	PRJNA534016	14648	249	0.875	2.17875	Micrococcus luteus	1270	Bacteria	Bacteria	42.4	0.0411	NR	WP_010079823.1	1270	g14558	i0	48.3	2.09638554216867	58	30	69.9	0	8	181	100	157	WP_010079823.1 GntR family transcriptional regulator [Micrococcus luteus]	diamond	522	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
29618594	29618594	PRJNA534016_P_NODE_17450_length_243_cov_0.905882_g17360_i0	PRJNA534016	17450	243	0.905882	2.20129326	Mycobacteroides	670516	Bacteria	Bacteria	43.1	0.0255	NR	WP_076984139.1	36809	g17360	i0	37.5	3.83950617283951	64	40	79	0	9	200	235	298	WP_076984139.1 ParB/RepB/Spo0J family partition protein [Mycobacteroides abscessus]	diamond	933	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides abscessus
30882552	30882552	PRJNA534016_P_NODE_13474_length_252_cov_0.860335_g13384_i0	PRJNA534016	13474	252	0.860335	2.1680442	Streptomyces	1883	Bacteria	Bacteria	43.9	0.00609	NR	WP_406485910.1	1923	g13384	i0	48.4	2.21428571428571	31	16	36.9	0	139	231	70	100	WP_406485910.1 hypothetical protein [Streptomyces phaeochromogenes]	diamond	558	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces phaeochromogenes
30930922	30930922	PRJNA534016_P_NODE_14774_length_249_cov_0.875000_g14684_i0	PRJNA534016	14774	249	0.875	2.17875	Microlunatus sp.	39595	Bacteria	Bacteria	43.1	0.0275	NR	HEU5483734.1	39595	g14684	i0	43.1	0.867469879518072	72	41	86.7	0	27	242	175	246	HEU5483734.1 acetylxylan esterase [Microlunatus sp.]	diamond	216	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
31057605	31057605	PRJNA534016_P_NODE_18095_length_241_cov_1.833333_g18005_i0	PRJNA534016	18095	241	1.833333	4.41833253	unclassified Streptomyces	2593676	Bacteria	Bacteria	42.7	0.0359	NR	WP_412492569.1	2593676	g18005	i0	40	1.05809128630705	85	42	97.1	4	241	8	348	430	WP_412492569.1 MULTISPECIES: SigB/SigF/SigG family RNA polymerase sigma factor [unclassified Streptomyces]	diamond	255	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
31324981	31324981	PRJNA534016_P_NODE_15615_length_247_cov_0.885057_g15525_i0	PRJNA534016	15615	247	0.885057	2.18609079	Micrococcaceae	1268	Bacteria	Bacteria	52	2.06e-5	NR	WP_267895940.1	1646	g15525	i0	59.6	37.4574898785425	52	21	63.2	0	37	192	22	73	WP_267895940.1 translation initiation factor IF-3 [Renibacterium salmoninarum]	diamond	9252	52	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Renibacterium	Renibacterium salmoninarum
31419891	31419891	PRJNA534016_P_NODE_14596_length_249_cov_0.875000_g14506_i0	PRJNA534016	14596	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	59.7	3.25e-9	NR	MES8397350.1	1747	g14506	i0	47.9	7.26506024096386	73	31	80.7	3	231	31	42	113	MES8397350.1 hypothetical protein [Cutibacterium acnes]	diamond	1809	60.1	0.993344425956739	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32116008	32116008	PRJNA534016_P_NODE_8198_length_296_cov_1.914798_g8108_i0	PRJNA534016	8198	296	1.914798	5.66780208	root	1	Root_unresolved	Root_unresolved	75.9	9.54e-15	NR	WP_355353866.1	2593676	g8108	i0	87.8	0.831081081081081	41	5	41.6	0	1	123	128	168	WP_355353866.1 MULTISPECIES: peptidylprolyl isomerase [unclassified Streptomyces]	diamond	246	75.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
32291212	32291212	PRJNA534016_P_NODE_15719_length_247_cov_0.885057_g15629_i0	PRJNA534016	15719	247	0.885057	2.18609079	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	121	9.239999999999999e-30	NR	WP_394268295.1	1528099	g15629	i0	100	0.765182186234818	63	0	76.5	0	245	57	473	535	WP_394268295.1 hypothetical protein [Lawsonella clevelandensis]	diamond	189	121	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32369258	32369258	PRJNA534016_P_NODE_11619_length_266_cov_1.637306_g11529_i0	PRJNA534016	11619	266	1.637306	4.35523396	Actinomycetes	1760	Bacteria	Bacteria	52	2.26e-6	NR	WP_247049984.1	2932773	g11529	i0	43.5	9.05639097744361	69	30	67.7	1	249	70	5	73	WP_247049984.1 phosphopantetheine-binding protein [Amycolatopsis sp. WQ 127309]	diamond	2409	52	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. WQ 127309
32827444	32827444	PRJNA534016_P_NODE_12380_length_260_cov_2.048128_g12290_i0	PRJNA534016	12380	260	2.048128	5.3251328000000004	Leifsonia aquatica	144185	Bacteria	Bacteria	153	9e-44	NR	WP_155829066.1	144185	g12290	i0	93.8	0.934615384615385	81	5	93.5	0	17	259	1	81	WP_155829066.1 hypothetical protein [Leifsonia aquatica]	diamond	243	153	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia aquatica

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