metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6557446	6557446	PRJNA1063685_S_NODE_29166_length_435_cov_2.870166_g28624_i0	PRJNA1063685	29166	435	2.870166	12.4852221	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	224	8.41e-54	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g28624	i0	84.127	19.5770114942529	252	18	57	12	57	306	1254156	1254387	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	8516	224	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
7832521	7832521	PRJNA1063685_S_NODE_80967_length_197_cov_5.516129_g80424_i0	PRJNA1063685	80967	197	5.516129	10.86677413	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	268	1.5599999999999998e-67	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g80424	i0	94.286	78.7715736040609	175	10	89	0	23	197	668342	668168	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	15518	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
8665177	8665177	PRJNA1063685_S_NODE_40947_length_363_cov_5.872414_g40404_i0	PRJNA1063685	40947	363	5.872414	21.31686282	Pseudomonadati	3379134	Bacteria	Bacteria	134	1.2e-26	NTclustered	gi\|2874253778\|emb\|OY969762.1\|	2052149	g40404	i0	81.657	80.168044077135	169	24	46	5	180	346	2992860	2992697	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.c.1 genome assembly, chromosome: 1	blastn	29101	134	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
10382783	10382783	PRJNA1063685_S_NODE_27829_length_445_cov_2.572581_g27288_i0	PRJNA1063685	27829	445	2.572581	11.44798545	Candidatus Peribacter riflensis	1735162	Bacteria	Bacteria	67.6	1.54e-6	NTclustered	gi\|946529367\|gb\|CP013062.1\|	1735162	g27288	i0	100	28.9932584269663	36	0	8	0	388	423	1197819	1197784	MAG: Candidatus Peribacter riflensis, complete genome	blastn	12902	67.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacter	Candidatus Peribacter riflensis
10383054	10383054	PRJNA1063685_S_NODE_60789_length_277_cov_3.019608_g60246_i0	PRJNA1063685	60789	277	3.019608	8.36431416	uncultured Parcubacteria group bacterium	221218	Bacteria	Bacteria	359	1.34e-94	NTclustered	gi\|83834994\|gb\|DQ330677.1\|	221218	g60246	i0	96.364	89.3537906137184	220	5	79	3	35	254	844	628	Uncultured candidate division OD1 bacterium clone 01N1Y32 16S ribosomal RNA gene, partial sequence	blastn	24751	359	1	Bacteria	Bacteria candidate phyla						uncultured Parcubacteria group bacterium
18031552	18031552	PRJNA1063685_S_NODE_72155_length_245_cov_6.011628_g71612_i0	PRJNA1063685	72155	245	6.011628	14.7284886	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	329	9.12e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g71612	i0	93.636	227.265306122449	220	14	90	0	23	242	219894	220113	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	55680	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
21856332	21856332	PRJNA1063685_S_NODE_25578_length_461_cov_12.569588_g25038_i0	PRJNA1063685	25578	461	12.569588	57.94580068	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	582	1.28e-161	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g25038	i0	90.972	102.119305856833	432	39	94	0	30	461	884054	883623	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	47077	582	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22689047	22689047	PRJNA1063685_S_NODE_9458_length_637_cov_9.900709_g8947_i0	PRJNA1063685	9458	637	9.900709	63.06751633	Bacteria	2	Bacteria	Bacteria	996	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g8947	i0	95.935	150.511773940345	615	24	96	1	24	637	696743	697357	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	95876	1002	0.994011976047904	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis

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