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

15 rows where analysis = "blastn", bioproject = "PRJNA631796" 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
3154304	3154304	PRJNA631796_P_NODE_9643_length_221_cov_3.375000_g9365_i0	PRJNA631796	9643	221	3.375	7.45875	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	298	2.28e-76	NTclustered	gi\|2874253748\|emb\|OY969622.1\|	2803731	g9365	i0	91.364	111.809954751131	220	15	99	4	4	221	373402	373619	MAG: Candidatus Babeliales bacterium isolate MFD04434.bin.c.2 genome assembly, chromosome: 1	blastn	24710	298	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
3703729	3703729	PRJNA631796_S_NODE_69683_length_217_cov_1.429487_g69516_i0	PRJNA631796	69683	217	1.429487	3.10198679	Bacteria	2	Bacteria	Bacteria	183	6.51e-42	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g69516	i0	83.251	175.396313364055	203	31	93	3	16	217	175652	175452	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	38061	183	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
4431075	4431075	PRJNA631796_P_NODE_11664_length_206_cov_2.206897_g11386_i0	PRJNA631796	11664	206	2.206897	4.54620782	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g11386	i0	100	39.4854368932039	206	0	100	0	1	206	294092	294297	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	8134	381	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
8256571	8256571	PRJNA631796_P_NODE_5967_length_282_cov_1.067873_g5689_i0	PRJNA631796	5967	282	1.067873	3.01140186	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	246	1.11e-60	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g5689	i0	83.394	77.9255319148936	277	35	96	11	11	282	125242	125512	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	21975	246	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
8804975	8804975	PRJNA631796_P_NODE_4107_length_344_cov_2.724382_g3829_i0	PRJNA631796	4107	344	2.724382	9.37187408	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	564	3.379999999999999e-156	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g3829	i0	96.243	186.325581395349	346	9	100	4	1	344	80124	80467	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	64096	564	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
10807591	10807591	PRJNA631796_P_NODE_2949_length_410_cov_1.693410_g2672_i0	PRJNA631796	2949	410	1.69341	6.942981	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	597	4.029999999999999e-166	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g2672	i0	93.366	71.280487804878	407	22	99	5	1	404	906293	906697	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	29225	597	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
14632287	14632287	PRJNA631796_P_NODE_10532_length_213_cov_1.368421_g10254_i0	PRJNA631796	10532	213	1.368421	2.91473673	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	387	4.52e-103	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g10254	i0	99.528	4.13615023474178	212	1	99	0	1	212	165803	166014	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	881	387	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
15906271	15906271	PRJNA631796_S_NODE_132953_length_197_cov_2.154412_g132786_i0	PRJNA631796	132953	197	2.154412	4.24419164	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	99	2.16e-16	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g132786	i0	76.44	31.989847715736	191	39	96	6	1	189	2239676	2239490	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	6302	99	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
17181378	17181378	PRJNA631796_P_NODE_3694_length_363_cov_3.245033_g3416_i0	PRJNA631796	3694	363	3.245033	11.77946979	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	669	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g3416	i0	100	0.997245179063361	362	0	99	0	2	363	845288	844927	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	362	669	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
18455521	18455521	PRJNA631796_S_NODE_19195_length_268_cov_3.342995_g19028_i0	PRJNA631796	19195	268	3.342995	8.9592266	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	233	8.16e-57	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g19028	i0	85.463	8.62313432835821	227	29	84	4	17	241	813885	813661	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	2311	233	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
19730017	19730017	PRJNA631796_P_NODE_5336_length_298_cov_2.502110_g5058_i0	PRJNA631796	5336	298	2.50211	7.4562878	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	309	1.49e-79	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g5058	i0	85.43	233.671140939597	302	38	100	6	1	298	125375	125674	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	69634	309	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
21005777	21005777	PRJNA631796_P_NODE_13477_length_197_cov_2.132353_g13199_i0	PRJNA631796	13477	197	2.132353	4.20073541	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	331	1.96e-86	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g13199	i0	96.954	253.58883248731	197	6	100	0	1	197	176786	176982	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	49957	331	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
21553979	21553979	PRJNA631796_P_NODE_7657_length_245_cov_2.434783_g7379_i0	PRJNA631796	7657	245	2.434783	5.96521835	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g7379	i0	99.592	171.90612244898	245	1	100	0	1	245	152085	151841	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	42117	448	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
22829476	22829476	PRJNA631796_P_NODE_6698_length_264_cov_1.275862_g6420_i0	PRJNA631796	6698	264	1.275862	3.36827568	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g6420	i0	100	197.69696969697	264	0	100	0	1	264	152302	152039	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	52192	488	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
23555929	23555929	PRJNA631796_P_NODE_11459_length_207_cov_1.410959_g11181_i0	PRJNA631796	11459	207	1.410959	2.92068513	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	340	3.4499999999999995e-89	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g11181	i0	96.585	23.3671497584541	205	7	99	0	3	207	890553	890757	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	4837	340	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871

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