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

6 rows where analysis = "blastn", bioproject = "PRJNA674308" 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_species
5748043	5748043	PRJNA674308_P_NODE_10905_length_289_cov_2.395833_g10670_i0	PRJNA674308	10905	289	2.395833	6.92395737	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	257	5.28e-64	NTclustered	gi\|2621701942\|emb\|OY761158.1\|	2651171	g10670	i0	84.249	120.332179930796	273	34	92	9	23	288	3583794	3583524	MAG: Thermoanaerobaculia bacterium isolate 1b26a83f-5f0d-4c2c-8de2-47f95369405e genome assembly, chromosome: 1	blastn	34776	257	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia bacterium
7023223	7023223	PRJNA674308_P_NODE_10346_length_296_cov_9.817814_g10111_i0	PRJNA674308	10346	296	9.817814	29.06072944	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	326	1.47e-84	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g10111	i0	86.486	177.682432432432	296	40	100	0	1	296	3559312	3559017	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	52594	326	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
14673769	14673769	PRJNA674308_P_NODE_32012_length_179_cov_1.200000_g31777_i0	PRJNA674308	32012	179	1.2	2.148	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|31789410\|gb\|AY281354.1\|	171953	g31777	i0	97.778	103.759776536313	180	2	100	2	1	179	38929	39107	Uncultured Acidobacteria bacterium clone 38c7 genomic sequence	blastn	18573	309	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
17222646	17222646	PRJNA674308_P_NODE_11374_length_283_cov_1.641026_g11139_i0	PRJNA674308	11374	283	1.641026	4.64410358	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	418	2.2399999999999995e-112	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g11139	i0	93.333	157.501766784452	285	16	100	3	1	283	3299147	3299430	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	44573	418	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
21047259	21047259	PRJNA674308_P_NODE_31777_length_179_cov_2.676923_g31542_i0	PRJNA674308	31777	179	2.676923	4.79169217	Bryobacterales bacterium	2026791	Bacteria	Bacteria	202	1.42e-47	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g31542	i0	87.151	24.7709497206704	179	21	99	2	2	179	6659353	6659530	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	4434	202	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
24870770	24870770	PRJNA674308_P_NODE_15040_length_249_cov_1.535000_g14805_i0	PRJNA674308	15040	249	1.535	3.82215	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g14805	i0	91.968	170.574297188755	249	20	100	0	1	249	3558155	3558403	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	42473	350	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae 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);;