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

7 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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
1599400	1599400	PRJNA1198392_P_NODE_5522_length_341_cov_1.723881_g5381_i0	PRJNA1198392	5522	341	1.723881	5.87843421	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	508	1.59e-139	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g5381	i0	93.567	110.202346041056	342	20	100	2	1	341	4355647	4355987	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	37579	508	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1599461	1599461	PRJNA1198392_P_NODE_9002_length_287_cov_1.350467_g8861_i0	PRJNA1198392	9002	287	1.350467	3.87584029	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	464	2.8799999999999993e-126	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g8861	i0	95.848	176.574912891986	289	8	100	3	1	287	4575094	4575380	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	50677	464	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
2875280	2875280	PRJNA1198392_P_NODE_13923_length_262_cov_1.629630_g13782_i0	PRJNA1198392	13923	262	1.62963	4.2696306	Paludibaculum fermentans	1473598	Bacteria	Bacteria	292	1.2899999999999999e-74	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g13782	i0	87.072	142.675572519084	263	29	99	5	2	262	4786067	4786326	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	37381	292	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
7421708	7421708	PRJNA1198392_P_NODE_8686_length_288_cov_1.790698_g8545_i0	PRJNA1198392	8686	288	1.790698	5.15721024	Bacteria	2	Bacteria	Bacteria	418	2.28e-112	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8545	i0	93.056	118.381944444444	288	17	100	3	1	288	3298965	3298681	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	34094	418	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9252464	9252464	PRJNA1198392_P_NODE_15448_length_252_cov_1.720670_g15307_i0	PRJNA1198392	15448	252	1.72067	4.3360884	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	420	5.44e-113	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g15307	i0	97.177	98.8690476190476	248	7	98	0	5	252	3918452	3918205	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	24915	420	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12522427	12522427	PRJNA1198392_P_NODE_15670_length_251_cov_1.432584_g15529_i0	PRJNA1198392	15670	251	1.432584	3.59578584	Geothrix	44675	Bacteria	Bacteria	76.8	1.35e-9	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g15529	i0	88.889	1.01593625498008	63	6	25	1	190	251	3112970	3113032	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	255	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
20725951	20725951	PRJNA1198392_P_NODE_18357_length_246_cov_1.780347_g18216_i0	PRJNA1198392	18357	246	1.780347	4.37965362	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g18216	i0	100	101.69512195122	246	0	100	0	1	246	4356430	4356675	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	25017	455	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);;