metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA816527" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA816527" 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
819415	819415	PRJNA816527_P_NODE_17381_length_250_cov_0.870056_g17331_i0	PRJNA816527	17381	250	0.870056	2.17514	Leifsonia xyli	1575	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|1029984024\|gb\|CP014761.1\|	1575	g17331	i0	86.111	50.816	252	31	100	4	1	250	3534480	3534231	Leifsonia xyli strain SE134 chromosome, complete genome	blastn	12704	268	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia xyli
2094958	2094958	PRJNA816527_P_NODE_16502_length_253_cov_2.233333_g16452_i0	PRJNA816527	16502	253	2.233333	5.65033249	Actinomyces radicidentis	111015	Bacteria	Bacteria	392	1.1899999999999997e-104	NTclustered	gi\|987450852\|gb\|CP014228.1\|	111015	g16452	i0	94.531	3.68379446640316	256	11	100	1	1	253	1232330	1232585	Actinomyces radicidentis strain CCUG 36733 chromosome, complete genome	blastn	932	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces radicidentis
3779829	3779829	PRJNA816527_P_NODE_14503_length_275_cov_2.089109_g14453_i0	PRJNA816527	14503	275	2.089109	5.74504975	Rhodococcus	1827	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g14453	i0	99.636	56.2909090909091	275	1	100	0	1	275	1752283	1752557	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	15480	508	0.990157480314961	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
3779868	3779868	PRJNA816527_P_NODE_20383_length_241_cov_1.559524_g20333_i0	PRJNA816527	20383	241	1.559524	3.75845284	Corynebacterium	1716	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|171191170\|gb\|EU373370.1\|	1717	g20333	i0	99.585	190.03734439834	241	1	100	0	1	241	1320	1080	Corynebacterium diphtheriae strain TPL03 16S ribosomal RNA gene, partial sequence	blastn	45799	440	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium diphtheriae
7197565	7197565	PRJNA816527_P_NODE_16606_length_252_cov_1.446927_g16556_i0	PRJNA816527	16606	252	1.446927	3.64625604	Leifsonia sp. WHRI 6310E	3162562	Bacteria	Bacteria	294	3.44e-75	NTclustered	gi\|2801868331\|gb\|CP168169.1\|	3162562	g16556	i0	87.698	99.7619047619048	252	31	100	0	1	252	2437065	2436814	Leifsonia sp. WHRI 6310E chromosome, complete genome	blastn	25140	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. WHRI 6310E
11023112	11023112	PRJNA816527_P_NODE_14129_length_279_cov_2.135922_g14079_i0	PRJNA816527	14129	279	2.135922	5.95922238	Leifsonia shinshuensis	150026	Bacteria	Bacteria	285	2.3299999999999997e-72	NTclustered	gi\|1890941476\|gb\|CP043641.1\|	150026	g14079	i0	85.816	9.2831541218638	282	25	100	5	1	279	3508873	3509142	Leifsonia shinshuensis strain INR9 chromosome, complete genome	blastn	2590	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
12298689	12298689	PRJNA816527_P_NODE_19990_length_242_cov_1.828402_g19940_i0	PRJNA816527	19990	242	1.828402	4.42473284	Microbacterium maritypicum	33918	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g19940	i0	95.775	16.595041322314	142	3	58	2	102	241	1598023	1598163	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	4016	226	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
15256038	15256038	PRJNA816527_P_NODE_7392_length_380_cov_2.524430_g7342_i0	PRJNA816527	7392	380	2.52443	9.592834	Corynebacterium	1716	Bacteria	Bacteria	697	0	NTclustered	gi\|2894611912\|gb\|PV018956.1\|	1720	g7342	i0	99.737	100	380	1	100	0	1	380	705	326	Corynebacterium sp. strain LMT-16 16S ribosomal RNA gene, partial sequence	blastn	38000	697	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp.
17397833	17397833	PRJNA816527_P_NODE_18954_length_245_cov_1.674419_g18904_i0	PRJNA816527	18954	245	1.674419	4.10232655	Citricoccus nitrophenolicus	863575	Bacteria	Bacteria	315	2.55e-81	NTclustered	gi\|2895617228\|gb\|CP063070.1\|	863575	g18904	i0	89.796	1	245	25	100	0	1	245	3109707	3109463	Citricoccus nitrophenolicus strain B1 chromosome, complete genome	blastn	245	315	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Citricoccus	Citricoccus nitrophenolicus
17397887	17397887	PRJNA816527_P_NODE_20794_length_228_cov_2.522581_g20744_i0	PRJNA816527	20794	228	2.522581	5.75148468	Micrococcus yunnanensis	566027	Bacteria	Bacteria	307	3.9300000000000005e-79	NTclustered	gi\|2506638323\|gb\|CP125290.1\|	566027	g20744	i0	91.15	49.7280701754386	226	20	99	0	1	226	800883	800658	Micrococcus yunnanensis strain TJPT4 chromosome, complete genome	blastn	11338	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus yunnanensis
19946065	19946065	PRJNA816527_P_NODE_19636_length_243_cov_2.652941_g19586_i0	PRJNA816527	19636	243	2.652941	6.44664663	Leifsonia shinshuensis	150026	Bacteria	Bacteria	272	1.5399999999999998e-68	NTclustered	gi\|1890941476\|gb\|CP043641.1\|	150026	g19586	i0	86.831	3.5843621399177	243	32	100	0	1	243	1328716	1328474	Leifsonia shinshuensis strain INR9 chromosome, complete genome	blastn	871	272	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
21221436	21221436	PRJNA816527_P_NODE_15797_length_261_cov_2.015957_g15747_i0	PRJNA816527	15797	261	2.0159570000000002	5.26164777	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g15747	i0	100	2	261	0	100	0	1	261	185126	184866	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	522	483	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
22496161	22496161	PRJNA816527_P_NODE_16598_length_252_cov_1.720670_g16548_i0	PRJNA816527	16598	252	1.72067	4.3360884	Nakamurella multipartita	53461	Bacteria	Bacteria	239	1.6300000000000002e-58	NTclustered	gi\|258553496\|gb\|CP001737.1\|	479431	g16548	i0	83.73	100.615079365079	252	41	100	0	1	252	4403800	4404051	Nakamurella multipartita DSM 44233 chromosome, complete genome	blastn	25355	239	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella multipartita
25045621	25045621	PRJNA816527_P_NODE_13060_length_290_cov_1.419355_g13010_i0	PRJNA816527	13060	290	1.419355	4.1161295	Leifsonia sp. ZF2019	2781978	Bacteria	Bacteria	320	6.67e-83	NTclustered	gi\|2093112753\|gb\|CP065037.1\|	2781978	g13010	i0	89.412	35.2034482758621	255	26	88	1	37	290	2185897	2185643	Leifsonia sp. ZF2019 chromosome, complete genome	blastn	10209	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. ZF2019
25454549	25454549	PRJNA816527_P_NODE_14840_length_272_cov_1.266332_g14790_i0	PRJNA816527	14840	272	1.266332	3.44442304	Leifsonia	110932	Bacteria	Bacteria	289	1.75e-73	NTclustered	gi\|1890941476\|gb\|CP043641.1\|	150026	g14790	i0	92.195	72.3125	205	15	75	1	1	204	1010396	1010600	Leifsonia shinshuensis strain INR9 chromosome, complete genome	blastn	19669	289	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis

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