metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax_phylum = "Thermotogota"

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
27116094	27116094	PRJNA758770_S_NODE_24302_length_252_cov_0.871508_g24176_i0	PRJNA758770	24302	252	0.871508	2.19620016	Defluviitoga sp.	2969823	Bacteria	Bacteria	99.8	1.92e-22	NR	HOB16703.1	2969823	g24176	i0	96.2	0.630952380952381	53	2	63.1	0	92	250	1	53	HOB16703.1 extracellular solute-binding protein [Defluviitoga sp.]	diamond	159	99.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga sp.
28221503	28221503	PRJNA758770_S_NODE_23446_length_253_cov_0.866667_g23320_i0	PRJNA758770	23446	253	0.866667	2.19266751	Petrotoga sp. 9PWA.NaAc.5.4	1434328	Bacteria	Bacteria	95.5	2.6500000000000003e-21	NR	WP_255398011.1	1434328	g23320	i0	82.5	1.35177865612648	57	10	67.6	0	253	83	174	230	WP_255398011.1 IS3 family transposase [Petrotoga sp. 9PWA.NaAc.5.4]	diamond	342	95.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp. 9PWA.NaAc.5.4
28505850	28505850	PRJNA758770_S_NODE_30307_length_245_cov_0.906977_g30181_i0	PRJNA758770	30307	245	0.906977	2.22209365	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	148	2.06e-39	NR	HOL87040.1	1006576	g30181	i0	98.8	0.991836734693878	81	1	99.2	0	2	244	420	500	HOL87040.1 tape measure protein [Defluviitoga tunisiensis]	diamond	243	148	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
29358438	29358438	PRJNA758770_S_NODE_32689_length_242_cov_0.923077_g32563_i0	PRJNA758770	32689	242	0.923077	2.23384634	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	54.7	2.14e-6	NR	HPP11068.1	1006576	g32563	i0	96	0.309917355371901	25	1	31	0	168	242	1	25	HPP11068.1 ParB/RepB/Spo0J family partition protein [Defluviitoga tunisiensis]	diamond	75	54.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
29579094	29579094	PRJNA758770_S_NODE_23670_length_253_cov_0.866667_g23544_i0	PRJNA758770	23670	253	0.866667	2.19266751	Fervidobacterium sp.	1871331	Bacteria	Bacteria	127	1.3399999999999998e-32	NR	HUM45018.1	1871331	g23544	i0	100	0.699604743083004	59	0	70	0	3	179	374	432	HUM45018.1 IS1634 family transposase [Fervidobacterium sp.]	diamond	177	127	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
29958278	29958278	PRJNA758770_S_NODE_25151_length_251_cov_0.876404_g25025_i0	PRJNA758770	25151	251	0.876404	2.19977404	Fervidobacterium sp.	1871331	Bacteria	Bacteria	154	1.17e-42	NR	HUM44799.1	1871331	g25025	i0	94	0.99203187250996006	83	5	99.2	0	3	251	96	178	HUM44799.1 hypothetical protein [Fervidobacterium sp.]	diamond	249	154	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
30653237	30653237	PRJNA758770_S_NODE_29613_length_246_cov_0.867052_g29487_i0	PRJNA758770	29613	246	0.867052	2.13294792	Fervidobacterium sp.	1871331	Bacteria	Bacteria	56.6	2.42e-8	NR	HQE50075.1	1871331	g29487	i0	68.8	0.390243902439024	32	10	39	0	2	97	52	83	HQE50075.1 hypothetical protein [Fervidobacterium sp.]	diamond	96	56.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
30811365	30811365	PRJNA758770_S_NODE_20654_length_267_cov_1.206186_g20528_i0	PRJNA758770	20654	267	1.206186	3.22051662	Fervidobacterium sp.	1871331	Bacteria	Bacteria	127	3.54e-32	NR	HUM44711.1	1871331	g20528	i0	69.7	1	89	26	98.9	1	264	1	376	464	HUM44711.1 hypothetical protein [Fervidobacterium sp.]	diamond	267	127	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.

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);;