metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
674768	674768	PRJNA694770_P_NODE_53881_length_288_cov_1.790698_g53587_i0	PRJNA694770	53881	288	1.790698	5.15721024	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	58.4	5.73e-4	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g53587	i0	100	0.604166666666667	31	0	11	0	179	209	1212510	1212540	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	174	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
675481	675481	PRJNA694770_P_NODE_78681_length_251_cov_0.865169_g78387_i0	PRJNA694770	78681	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	372	1.54e-98	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g78387	i0	93.927	78.199203187251	247	13	98	2	1	246	4233436	4233681	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	19628	372	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1951879	1951879	PRJNA694770_P_NODE_94402_length_243_cov_4.047059_g94108_i0	PRJNA694770	94402	243	4.047059	9.83435337	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	180	9.63e-41	NTclustered	gi\|2621701942\|emb\|OY761158.1\|	2651171	g94108	i0	83.085	30.0781893004115	201	30	82	4	45	243	3193312	3193510	MAG: Thermoanaerobaculia bacterium isolate 1b26a83f-5f0d-4c2c-8de2-47f95369405e genome assembly, chromosome: 1	blastn	7309	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
14704234	14704234	PRJNA694770_P_NODE_71252_length_262_cov_1.306878_g70958_i0	PRJNA694770	71252	262	1.306878	3.42402036	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	99	3.03e-16	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g70958	i0	79.195	0.568702290076336	149	25	56	5	34	179	4179161	4179306	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	149	99	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24900129	24900129	PRJNA694770_P_NODE_18340_length_441_cov_1.255435_g18046_i0	PRJNA694770	18340	441	1.255435	5.53646835	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	161	6.789999999999998e-35	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g18046	i0	82.873	7.45124716553288	181	29	41	2	4	183	1859804	1859625	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	3286	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
25407675	25407675	PRJNA694770_P_NODE_77860_length_251_cov_1.292135_g77566_i0	PRJNA694770	77860	251	1.292135	3.24325885	Bacteria	2	Bacteria	Bacteria	87.9	6.24e-13	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g77566	i0	77.358	2.69322709163347	159	28	62	5	4	158	1224287	1224441	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	676	87.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota 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);;