metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA631796" 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
6255670	6255670	PRJNA631796_P_NODE_11685_length_206_cov_1.765517_g11407_i0	PRJNA631796	11685	206	1.765517	3.63696502	FCB group	1783270	Bacteria	Bacteria	136	3.83e-40	NR	MFM9500543.1	33899	g11407	i0	100	1.98058252427184	68	0	99	0	1	204	6	73	MFM9500543.1 magnesium-translocating P-type ATPase [Streptomyces galilaeus]	diamond	408	136	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces galilaeus
27662271	27662271	PRJNA631796_P_NODE_12344_length_204_cov_0.895105_g12066_i0	PRJNA631796	12344	204	0.895105	1.8260142	Rothia	32207	Bacteria	Bacteria	140	1.01e-40	NR	WP_151146219.1	169480	g12066	i0	100	2	68	0	100	0	204	1	54	121	WP_151146219.1 tetratricopeptide repeat protein [Rothia amarae]	diamond	408	140	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
27838843	27838843	PRJNA631796_S_NODE_133444_length_194_cov_2.421053_g133277_i0	PRJNA631796	133444	194	2.421053	4.69684282	Cutibacterium acnes	1747	Bacteria	Bacteria	50.4	5.36e-6	NR	MCQ8208689.1	1734925	g133277	i0	100	0.34020618556701	22	0	34	0	3	68	1	22	MCQ8208689.1 hypothetical protein [Cutibacterium acnes subsp. acnes]	diamond	66	50.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
28565208	28565208	PRJNA631796_P_NODE_12287_length_204_cov_0.895105_g12009_i0	PRJNA631796	12287	204	0.895105	1.8260142	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	123	1.08e-30	NR	WP_306558879.1	1528099	g12009	i0	100	0.985294117647059	67	0	98.5	0	203	3	42	108	WP_306558879.1 HAD-IC family P-type ATPase [Lawsonella clevelandensis]	diamond	201	123	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
29493411	29493411	PRJNA631796_P_NODE_5030_length_308_cov_2.372470_g4752_i0	PRJNA631796	5030	308	2.37247	7.3072076	FCB group	1783270	Bacteria	Bacteria	124	1.5e-31	NR	WP_091275453.1	686309	g4752	i0	65	17.6493506493506	100	35	97.4	0	306	7	277	376	WP_091275453.1 S8 family peptidase [Micromonospora haikouensis]	diamond	5436	125	0.992	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora haikouensis
29543872	29543872	PRJNA631796_P_NODE_5770_length_287_cov_1.119469_g5492_i0	PRJNA631796	5770	287	1.119469	3.21287603	Pseudonocardiaceae bacterium	1873463	Bacteria	Bacteria	43.1	0.0431	NR	HEY1572059.1	1873463	g5492	i0	30.2	0.898954703832753	86	56	87.8	2	271	20	212	295	HEY1572059.1 SpoIIE family protein phosphatase [Pseudonocardiaceae bacterium]	diamond	258	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae		Pseudonocardiaceae bacterium
29809048	29809048	PRJNA631796_P_NODE_12131_length_205_cov_0.888889_g11853_i0	PRJNA631796	12131	205	0.888889	1.82222245	Bacteria	2	Bacteria	Bacteria	90.5	9.84e-21	NR	HYY79178.1	1883427	g11853	i0	58.2	5.86829268292683	67	28	98	0	203	3	67	133	HYY79178.1 type 1 glutamine amidotransferase domain-containing protein [Actinomycetes bacterium]	diamond	1203	90.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
30965773	30965773	PRJNA631796_P_NODE_11214_length_208_cov_1.741497_g10936_i0	PRJNA631796	11214	208	1.741497	3.62231376	Glycomyces arizonensis	256035	Bacteria	Bacteria	81.3	6.18e-16	NR	WP_051393720.1	256035	g10936	i0	63.2	6.90865384615385	68	22	98.1	1	208	5	210	274	WP_051393720.1 S8 family serine peptidase [Glycomyces arizonensis]	diamond	1437	81.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Glycomycetales	Glycomycetaceae	Glycomyces	Glycomyces arizonensis
32040823	32040823	PRJNA631796_P_NODE_12898_length_202_cov_0.907801_g12620_i0	PRJNA631796	12898	202	0.907801	1.83375802	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	87.8	2.3e-18	NR	WP_170957296.1	1274	g12620	i0	100	0.698019801980198	47	0	69.8	0	141	1	1	47	WP_170957296.1 hypothetical protein [Dermacoccus nishinomiyaensis]	diamond	141	87.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
32211628	32211628	PRJNA631796_P_NODE_6338_length_272_cov_2.123223_g6060_i0	PRJNA631796	6338	272	2.123223	5.77516656	Actinomycetes	1760	Bacteria	Bacteria	119	3.34e-29	NR	WP_091678716.1	490629	g6060	i0	71.1	13.8970588235294	90	26	99.3	0	1	270	288	377	WP_091678716.1 S8 family serine peptidase [Amycolatopsis marina]	diamond	3780	119	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis marina
32547269	32547269	PRJNA631796_P_NODE_9139_length_227_cov_1.156627_g8861_i0	PRJNA631796	9139	227	1.156627	2.62554329	Aeromicrobium stalagmiti	2738988	Bacteria	Bacteria	139	9.03e-39	NR	WP_173492924.1	2738988	g8861	i0	100	0.991189427312775	75	0	99.1	0	3	227	121	195	WP_173492924.1 hypothetical protein, partial [Aeromicrobium stalagmiti]	diamond	225	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium stalagmiti

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