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

15 rows where analysis = "blastn", bioproject = "PRJNA207719" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2917689	2917689	PRJNA207719_P_NODE_1263_length_158_cov_2.945736_g1243_i0	PRJNA207719	1263	158	2.945736	4.65426288	Streptococcus oralis	1303	Bacteria	Bacteria	274	2.56e-69	NTclustered	gi\|288522\|emb\|X68427.1\|	1303	g1243	i0	98.089	371.481012658228	157	3	99	0	1	157	1233	1389	S.oralis gene for 23S rRNA	blastn	58694	274	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3606522	3606522	PRJNA207719_P_NODE_503_length_290_cov_1.804598_g483_i0	PRJNA207719	503	290	1.804598	5.2333342	Chroococcidiopsis	54298	Bacteria	Bacteria	392	1.39e-104	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g483	i0	89.701	114.131034482759	301	20	100	1	1	290	1498	1198	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	33098	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
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
6744705	6744705	PRJNA207719_P_NODE_866_length_208_cov_1.508380_g846_i0	PRJNA207719	866	208	1.50838	3.1374304	Candidatus Syntrophocurvum alkaliphilum	2293317	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1782150439\|gb\|CP046457.1\|	2293317	g846	i0	100	0.139423076923077	29	0	14	0	156	184	1433593	1433565	Candidatus Syntrophocurvum alkaliphilum isolate B(2M) chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae	Candidatus Syntrophocurvum	Candidatus Syntrophocurvum alkaliphilum
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
8708727	8708727	PRJNA207719_P_NODE_907_length_201_cov_2.168605_g887_i0	PRJNA207719	907	201	2.168605	4.35889605	Staphylococcus	1279	Bacteria	Bacteria	364	1.98e-96	NTclustered	gi\|2851146212\|gb\|CP085027.1\|	1283	g887	i0	99.5	472.398009950249	200	1	99	0	2	201	730484	730285	Staphylococcus haemolyticus strain SLM-175 chromosome, complete genome	blastn	94952	364	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
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
9984129	9984129	PRJNA207719_P_NODE_728_length_233_cov_2.553922_g708_i0	PRJNA207719	728	233	2.553922	5.95063826	Staphylococcus	1279	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g708	i0	100	474.351931330472	233	0	100	0	1	233	772625	772393	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	110524	431	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
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);;