metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA864829" 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
2512379	2512379	PRJNA864829_S_NODE_1522_length_409_cov_3.288889_g1436_i0	PRJNA864829	1522	409	3.288889	13.45155601	Bacteria	2	Bacteria	Bacteria	189	2.8699999999999998e-43	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g1436	i0	76.238	69.520782396088	404	69	95	23	21	409	595944	595553	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	28434	189	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
3397997	3397997	PRJNA864829_S_NODE_12483_length_181_cov_1.712121_g12397_i0	PRJNA864829	12483	181	1.712121	3.09893901	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	169	1.4599999999999998e-37	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g12397	i0	87.248	48.1381215469613	149	17	82	2	9	156	2261845	2261698	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	8713	169	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
9775306	9775306	PRJNA864829_S_NODE_3828_length_290_cov_2.929461_g3742_i0	PRJNA864829	3828	290	2.929461	8.4954369	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	241	5.340000000000001e-59	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g3742	i0	82.253	105.955172413793	293	38	99	11	5	290	2262509	2262794	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	30727	241	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
11051007	11051007	PRJNA864829_S_NODE_1889_length_374_cov_2.756923_g1803_i0	PRJNA864829	1889	374	2.756923	10.31089202	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	195	5.59e-45	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g1803	i0	76.684	63.7941176470588	386	69	100	16	1	374	2070086	2070462	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	23859	195	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
11051036	11051036	PRJNA864829_S_NODE_6389_length_241_cov_1.276042_g6303_i0	PRJNA864829	6389	241	1.276042	3.07526122	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	248	2.58e-61	NTclustered	gi\|2874253748\|emb\|OY969622.1\|	2803731	g6303	i0	88.406	114.344398340249	207	23	86	1	35	241	373410	373615	MAG: Candidatus Babeliales bacterium isolate MFD04434.bin.c.2 genome assembly, chromosome: 1	blastn	27557	248	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
13600969	13600969	PRJNA864829_S_NODE_3331_length_305_cov_1.710938_g3245_i0	PRJNA864829	3331	305	1.710938	5.2183609	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	239	2.03e-58	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g3245	i0	81.544	428.701639344262	298	48	97	6	2	298	160528	160819	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	130754	239	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
17425453	17425453	PRJNA864829_S_NODE_1714_length_389_cov_47.250000_g1628_i0	PRJNA864829	1714	389	47.25	183.8025	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	296	1.56e-75	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g1628	i0	85.971	486.706940874036	278	37	71	2	112	389	3394159	3394434	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	189329	296	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;