metadata: contig_metadata: 7 rows where bioproject = "PRJNA407368", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA407368", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"

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_species
15717686	15717686	PRJNA407368_S_NODE_10193_length_154_cov_2.856000_g10091_i0	PRJNA407368	10193	154	2.856	4.39824	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	75.5	1.09e-15	NR	MDD2565942.1	2044595	g10091	i0	87.2	0.915584415584416	47	6	91.6	0	142	2	1	47	MDD2565942.1 30S ribosomal protein S12 [Candidatus Altimarinota bacterium]	diamond	141	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
22091622	22091622	PRJNA407368_S_NODE_7038_length_197_cov_8.744048_g6936_i0	PRJNA407368	7038	197	8.744048	17.22577456	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	82.4	2.18e-11	NTclustered	gi\|2621704339\|emb\|OY760935.1\|	2044595	g6936	i0	78.082	7.99492385786802	146	21	71	9	58	197	1137364	1137224	MAG: Candidatus Gracilibacteria bacterium isolate 3c0776cb-dd52-49a3-965b-30fb91b92491 genome assembly, chromosome: 1	blastn	1575	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
26663633	26663633	PRJNA407368_S_NODE_10421_length_152_cov_2.902439_g10319_i0	PRJNA407368	10421	152	2.902439	4.41170728	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	60.5	5.93e-9	NR	MDD2745034.1	2044595	g10319	i0	66	0.927631578947368	47	16	92.8	0	149	9	471	517	MDD2745034.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium]	diamond	141	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
26885819	26885819	PRJNA407368_S_NODE_5821_length_224_cov_4.846154_g5719_i0	PRJNA407368	5821	224	4.846154	10.85538496	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	80.9	9.37e-17	NR	MDD5770332.1	2044595	g5719	i0	60.3	0.84375	63	25	84.4	0	219	31	140	202	MDD5770332.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	189	80.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28780617	28780617	PRJNA407368_S_NODE_827_length_715_cov_4.215743_g761_i0	PRJNA407368	827	715	4.215743	30.14256245	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	107	1.03e-23	NR	MBP9811851.1	2044595	g761	i0	94.8	0.243356643356643	58	3	24.3	0	176	3	27	84	MBP9811851.1 acyl-CoA desaturase [Candidatus Altimarinota bacterium]	diamond	174	107	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29443599	29443599	PRJNA407368_S_NODE_4650_length_262_cov_12.000000_g4548_i0	PRJNA407368	4650	262	12	31.44	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	157	1.94e-42	NR	MBP9812482.1	2044595	g4548	i0	98.8	0.938931297709924	82	1	93.9	0	247	2	524	605	MBP9812482.1 translation initiation factor IF-2 [Candidatus Altimarinota bacterium]	diamond	246	157	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29980716	29980716	PRJNA407368_S_NODE_5291_length_239_cov_2.871429_g5189_i0	PRJNA407368	5291	239	2.871429	6.86271531	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	169	7.74e-50	NR	MBP9811851.1	2044595	g5189	i0	97.5	0.99163179916318	79	2	99.2	0	3	239	77	155	MBP9811851.1 acyl-CoA desaturase [Candidatus Altimarinota bacterium]	diamond	237	169	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;