metadata: contig_metadata: 5 rows where bioproject = "PRJNA763243", tax_kingdom = "Thermotogati" and tax

5 rows where bioproject = "PRJNA763243", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"

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
2019163	2019163	PRJNA763243_P_NODE_32242_length_300_cov_1.854626_g31896_i0	PRJNA763243	32242	300	1.854626	5.563878	Cloacibacillus porcorum	1197717	Bacteria	Bacteria	379	1.13e-100	NTclustered	gi\|1050315908\|gb\|CP016757.1\|	1197717	g31896	i0	90.033	533.17	301	19	99	9	1	297	637695	637402	Cloacibacillus porcorum strain CL-84 chromosome, complete genome	blastn	159951	379	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus porcorum
5847073	5847073	PRJNA763243_P_NODE_49765_length_255_cov_1.137363_g49419_i0	PRJNA763243	49765	255	1.137363	2.90027565	Synergistaceae bacterium	2053624	Bacteria	Bacteria	279	9.76e-71	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g49419	i0	86.822	190.372549019608	258	25	99	6	1	252	325131	325385	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	48545	279	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
7583282	7583282	PRJNA763243_P_NODE_46066_length_262_cov_6.079365_g45720_i0	PRJNA763243	46066	262	6.079365	15.9279363	Thermanaerovibrio	81461	Bacteria	Bacteria	481	2.57e-131	NTclustered	gi\|470485441\|ref\|NR_076701.1\|	81462	g45720	i0	100	351.534351145038	260	0	99	0	3	262	1244	1503	Thermanaerovibrio acidaminovorans strain Su883 23S ribosomal RNA gene, complete sequence	blastn	92102	481	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
9672439	9672439	PRJNA763243_P_NODE_70228_length_219_cov_7.630137_g69882_i0	PRJNA763243	70228	219	7.630137	16.71000003	Synergistales bacterium	2268201	Bacteria	Bacteria	137	5.200000000000001e-28	NTclustered	gi\|2621703689\|emb\|OY762654.1\|	2268201	g69882	i0	78.636	85.9406392694064	220	38	99	9	4	219	237529	237315	MAG: Synergistales bacterium isolate e2a2af2a-30b9-47e3-8e03-f1be080e1666 genome assembly, chromosome: 1	blastn	18821	137	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
24969419	24969419	PRJNA763243_P_NODE_20100_length_353_cov_1.078571_g19754_i0	PRJNA763243	20100	353	1.078571	3.80735563	Synergistaceae bacterium	2053624	Bacteria	Bacteria	385	2.8999999999999995e-102	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g19754	i0	87.353	116.28895184136	340	37	95	5	1	337	325795	326131	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	41050	385	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;