metadata: contig_metadata: 11 rows where bioproject = "PRJNA322517" and tax

11 rows where bioproject = "PRJNA322517" 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
389322	389322	PRJNA322517_P_NODE_5081_length_172_cov_5.000000_g5059_i0	PRJNA322517	5081	172	5	8.6	Dietzia kunjamensis	322509	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2732850265\|gb\|CP155441.1\|	322509	g5059	i0	100	3	172	0	100	0	1	172	34163	34334	Dietzia kunjamensis strain BIM B-2035 plasmid pDK2035-69, complete sequence	blastn	516	318	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia kunjamensis
1664011	1664011	PRJNA322517_P_NODE_4822_length_177_cov_2.726562_g4800_i0	PRJNA322517	4822	177	2.726562	4.82601474	Corynebacterium doosanense	1121358	Bacteria	Bacteria	178	2.36e-40	NTclustered	gi\|697777148\|gb\|CP006764.1\|	558173	g4800	i0	85.227	35.6666666666667	176	22	98	4	4	177	1308829	1308656	Corynebacterium doosanense CAU 212 = DSM 45436, complete genome	blastn	6313	178	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium doosanense
5492877	5492877	PRJNA322517_P_NODE_6225_length_161_cov_2.125000_g6203_i0	PRJNA322517	6225	161	2.125	3.42125	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g6203	i0	100	0.173913043478261	28	0	17	0	128	155	995425	995398	Streptomyces sp. cg36 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36
9317279	9317279	PRJNA322517_P_NODE_3648_length_210_cov_3.335404_g3626_i0	PRJNA322517	3648	210	3.335404	7.0043484	Janibacter cremeus	1285192	Bacteria	Bacteria	117	6.44e-22	NTclustered	gi\|2467977479\|gb\|CP115184.1\|	1285192	g3626	i0	90	0.428571428571429	90	9	43	0	1	90	557107	557018	Janibacter cremeus strain SCSIO 52865 chromosome, complete genome	blastn	90	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter cremeus
10592968	10592968	PRJNA322517_P_NODE_4009_length_198_cov_3.442953_g3987_i0	PRJNA322517	4009	198	3.442953	6.81704694	Janibacter sp. CX7	2963431	Bacteria	Bacteria	244	2.64e-60	NTclustered	gi\|2274439729\|gb\|CP101464.1\|	2963431	g3987	i0	88.889	8.22727272727273	198	22	100	0	1	198	677926	678123	Janibacter sp. CX7 chromosome, complete genome	blastn	1629	244	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter sp. CX7
10593009	10593009	PRJNA322517_P_NODE_5249_length_169_cov_2.083333_g5227_i0	PRJNA322517	5249	169	2.083333	3.52083277	Brevibacterium sp. CS2	2575923	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|1638089728\|gb\|CP040020.1\|	2575923	g5227	i0	99.408	1.3905325443787	169	1	100	0	1	169	378108	378276	Brevibacterium sp. CS2 chromosome, complete genome	blastn	235	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium sp. CS2
23341192	23341192	PRJNA322517_P_NODE_4319_length_188_cov_2.870504_g4297_i0	PRJNA322517	4319	188	2.870504	5.39654752	Janibacter limosus	53458	Bacteria	Bacteria	204	4.2e-48	NTclustered	gi\|1578802915\|gb\|CP036164.1\|	53458	g4297	i0	86.813	7.53191489361702	182	24	97	0	1	182	107777	107596	Janibacter limosus strain P3-3-X1 chromosome, complete genome	blastn	1416	204	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter limosus
24615401	24615401	PRJNA322517_P_NODE_4780_length_178_cov_2.193798_g4758_i0	PRJNA322517	4780	178	2.193798	3.90496044	Corynebacterium durum	61592	Bacteria	Bacteria	296	6.3e-76	NTclustered	gi\|2531279924\|gb\|CP047200.1\|	61592	g4758	i0	96.629	1	178	6	100	0	1	178	224718	224895	Corynebacterium durum strain DSM 45333 chromosome, complete genome	blastn	178	296	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium durum
27895759	27895759	PRJNA322517_P_NODE_4585_length_183_cov_1.007463_g4563_i0	PRJNA322517	4585	183	1.007463	1.84365729	Nesterenkonia cremea	1882340	Bacteria	Bacteria	132	5.11e-35	NR	WP_229658688.1	1882340	g4563	i0	98.3	0.983606557377049	60	1	98.4	0	181	2	156	215	WP_229658688.1 extracellular solute-binding protein [Nesterenkonia cremea]	diamond	180	132	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia cremea
28734145	28734145	PRJNA322517_P_NODE_3427_length_223_cov_1.172414_g3405_i0	PRJNA322517	3427	223	1.172414	2.61448322	Actinomycetota	201174	Bacteria	Bacteria	42.4	0.0404	NR	WP_344774255.1	993084	g3405	i0	39.1	1.26457399103139	46	27	61.9	1	32	169	447	491	WP_344774255.1 ArnT family glycosyltransferase [Gryllotalpicola kribbensis]	diamond	282	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Gryllotalpicola	Gryllotalpicola kribbensis
31971129	31971129	PRJNA322517_P_NODE_4958_length_175_cov_1.214286_g4936_i0	PRJNA322517	4958	175	1.214286	2.1250005	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	56.2	2.45e-7	NR	MDC1474477.1	2518612	g4936	i0	57.1	2.58857142857143	49	21	84	0	173	27	1	49	MDC1474477.1 hypothetical protein [Candidatus Nanopelagicales bacterium]	diamond	453	56.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales 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);;