metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA207719" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA207719" 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
3606524	3606524	PRJNA207719_P_NODE_783_length_221_cov_3.953125_g763_i0	PRJNA207719	783	221	3.953125	8.73640625	Cutibacterium	1912216	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g763	i0	100	280.972850678733	221	0	100	0	1	221	56580	56800	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	62095	409	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7433938	7433938	PRJNA207719_P_NODE_506_length_289_cov_4.584615_g486_i0	PRJNA207719	506	289	4.584615	13.24953735	Corynebacterium	1716	Bacteria	Bacteria	529	1.01e-145	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g486	i0	99.654	368	289	1	100	0	1	289	1254354	1254642	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	106352	529	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
8020473	8020473	PRJNA207719_P_NODE_27_length_1139_cov_10.373874_g24_i0	PRJNA207719	27	1139	10.373874	118.15842486	Rhodococcoides fascians	1828	Bacteria	Bacteria	1502	0	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g24	i0	90.714	386.642669007902	1120	95	98	7	1	1116	1711414	1710300	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	440386	1502	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
8708724	8708724	PRJNA207719_P_NODE_1127_length_174_cov_3.006897_g1107_i0	PRJNA207719	1127	174	3.006897	5.23200078	Streptosporangiales	85012	Bacteria	Bacteria	305	1.02e-78	NTclustered	gi\|6694271\|gb\|AF192149.1\|AF192149	46179	g1107	i0	98.276	237.885057471264	174	3	100	0	1	174	1127	954	Nonomuraea roseola 23S ribosomal RNA, partial sequence	blastn	41392	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea roseola
8708726	8708726	PRJNA207719_P_NODE_507_length_289_cov_3.200000_g487_i0	PRJNA207719	507	289	3.2	9.248	Mycolicibacterium	1866885	Bacteria	Bacteria	244	4.11e-60	NTclustered	gi\|2076782997\|gb\|CP080333.1\|	370524	g487	i0	94.375	230.553633217993	160	7	92	2	13	171	4496309	4496467	Mycolicibacterium pallens strain JCM 16370 chromosome, complete genome	blastn	66630	244	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium pallens
9295145	9295145	PRJNA207719_P_NODE_228_length_451_cov_7.703791_g208_i0	PRJNA207719	228	451	7.703791	34.74409741	Corynebacterium hesseae	2913502	Bacteria	Bacteria	372	2.95e-98	NTclustered	gi\|2704699628\|gb\|CP137211.1\|	2913502	g208	i0	93.254	374.784922394679	252	17	98	0	200	451	820450	820701	Corynebacterium hesseae strain 10VPs_Sm8 chromosome, complete genome	blastn	169028	372	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hesseae
16944350	16944350	PRJNA207719_P_NODE_474_length_303_cov_4.171533_g454_i0	PRJNA207719	474	303	4.171533	12.63974499	Micrococcus luteus	1270	Bacteria	Bacteria	477	3.9299999999999986e-130	NTclustered	gi\|2274423316\|gb\|CP101465.1\|	1270	g454	i0	95.05	261.316831683168	303	15	100	0	1	303	362739	363041	Micrococcus luteus strain DNA1 chromosome, complete genome	blastn	79179	477	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17633647	17633647	PRJNA207719_P_NODE_294_length_390_cov_3.653740_g274_i0	PRJNA207719	294	390	3.65374	14.249586	Cutibacterium	1912216	Bacteria	Bacteria	715	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g274	i0	99.744	286.641025641026	390	1	100	0	1	390	57222	56833	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	111790	715	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18907493	18907493	PRJNA207719_P_NODE_835_length_213_cov_6.918478_g815_i0	PRJNA207719	835	213	6.918478	14.73635814	Cutibacterium	1912216	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g815	i0	100	260.201877934272	213	0	100	0	1	213	55814	55602	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	55423	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20182081	20182081	PRJNA207719_P_NODE_236_length_446_cov_2.395683_g216_i0	PRJNA207719	236	446	2.395683	10.68474618	Cutibacterium	1912216	Bacteria	Bacteria	675	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g216	i0	92.873	301.903587443946	463	16	100	2	1	446	56006	56468	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	134649	675	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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