metadata: contig_metadata: 10 rows where bioproject = "PRJNA1020641" and tax

10 rows where bioproject = "PRJNA1020641" 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
1002995	1002995	PRJNA1020641_P_NODE_3901_length_309_cov_0.944915_g3858_i0	PRJNA1020641	3901	309	0.944915	2.91978735	Rhodococcus	1827	Bacteria	Bacteria	477	4.0199999999999996e-130	NTclustered	gi\|2921205402\|gb\|CP134707.1\|	37919	g3858	i0	94.516	404.333333333333	310	16	100	1	1	309	2199209	2199518	Rhodococcus opacus strain DSM 43205 chromosome, complete genome	blastn	124939	477	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
2278068	2278068	PRJNA1020641_P_NODE_2582_length_380_cov_1.504886_g2539_i0	PRJNA1020641	2582	380	1.504886	5.7185668	Cutibacterium	1912216	Bacteria	Bacteria	702	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2539	i0	100	247.776315789474	380	0	100	0	1	380	55417	55796	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	94155	702	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11206244	11206244	PRJNA1020641_P_NODE_4669_length_278_cov_1.468293_g4626_i0	PRJNA1020641	4669	278	1.468293	4.08185454	Actinomycetes	1760	Bacteria	Bacteria	425	1.31e-114	NTclustered	gi\|1345633730\|emb\|LT985188.1\|	75385	g4626	i0	94.245	312.053956834532	278	16	100	0	1	278	1730498	1730221	Micropruina glycogenica isolate 1 genome assembly, chromosome: 1	blastn	86751	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Micropruina	Micropruina glycogenica
15463311	15463311	PRJNA1020641_P_NODE_7133_length_243_cov_0.870588_g7090_i0	PRJNA1020641	7133	243	0.870588	2.11552884	Pedococcus sp. KACC 23699	3149228	Bacteria	Bacteria	124	4.579999999999999e-24	NTclustered	gi\|2739524205\|gb\|CP157483.1\|	3149228	g7090	i0	96.053	26.7448559670782	76	3	31	0	103	178	3703373	3703298	Pedococcus sp. KACC 23699 chromosome, complete genome	blastn	6499	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Pedococcus	Pedococcus sp. KACC 23699
18854652	18854652	PRJNA1020641_P_NODE_2415_length_393_cov_1.212500_g2372_i0	PRJNA1020641	2415	393	1.2125	4.765125	Corynebacterium	1716	Bacteria	Bacteria	669	0	NTclustered	gi\|1899780227\|gb\|CP061031.1\|	2735136	g2372	i0	97.692	285.681933842239	390	8	100	1	1	390	710642	711030	Corynebacterium wankanglinii strain zg-913 chromosome, complete genome	blastn	112273	675	0.991111111111111	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium wankanglinii
20561727	20561727	PRJNA1020641_P_NODE_4137_length_299_cov_0.871681_g4094_i0	PRJNA1020641	4137	299	0.871681	2.60632619	Pseudonocardia sp. EC080625-04	1096868	Bacteria	Bacteria	514	2.95e-141	NTclustered	gi\|928461215\|gb\|CP010989.1\|	1096868	g4094	i0	97.659	371.080267558528	299	7	100	0	1	299	2981890	2981592	Pseudonocardia sp. EC080625-04, complete genome	blastn	110953	514	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp. EC080625-04
26717932	26717932	PRJNA1020641_P_NODE_5861_length_250_cov_0.870056_g5818_i0	PRJNA1020641	5861	250	0.870056	2.17514	Nocardioides sp. DS6	3231482	Bacteria	Bacteria	40.8	0.0415	NR	WP_367991583.1	3231482	g5818	i0	33.3	0.828	69	46	82.8	0	240	34	16	84	WP_367991583.1 hypothetical protein [Nocardioides sp. DS6]	diamond	207	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides eburneus
28551002	28551002	PRJNA1020641_P_NODE_6907_length_244_cov_0.900585_g6864_i0	PRJNA1020641	6907	244	0.900585	2.1974274	Olsenella uli	133926	Bacteria	Bacteria	61.2	3.83e-9	NR	WP_347711276.1	133926	g6864	i0	65.8	1.94262295081967	38	13	46.7	0	114	1	4	41	WP_347711276.1 sister chromatid cohesion protein PDS5 [Olsenella uli]	diamond	474	61.2	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Olsenella	Olsenella uli
30563922	30563922	PRJNA1020641_P_NODE_6193_length_248_cov_0.880000_g6150_i0	PRJNA1020641	6193	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	42.7	0.0379	NR	WP_369069502.1	2044856	g6150	i0	43.6	1.27016129032258	55	28	62.9	1	5	160	95	149	WP_369069502.1 acyl-CoA dehydrogenase [Kineococcus terrestris]	diamond	315	43.1	0.990719257540603	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kineosporiales	Kineosporiaceae	Kineococcus	Kineococcus terrestris
31868019	31868019	PRJNA1020641_P_NODE_4637_length_280_cov_1.000000_g4594_i0	PRJNA1020641	4637	280	1	2.8	Kitasatospora phosalacinea	2065	Bacteria	Bacteria	43.5	0.0299	NR	WP_376055136.1	2065	g4594	i0	38.9	0.578571428571429	54	32	57.9	1	254	93	29	81	WP_376055136.1 amidohydrolase [Kitasatospora phosalacinea]	diamond	162	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora phosalacinea

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