metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB80557" 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
16299229	16299229	PRJEB80557_S_NODE_25093_length_192_cov_1.615385_g24697_i0	PRJEB80557	25093	192	1.615385	3.1015392	Bacteria	2	Bacteria	Bacteria	113	5.01e-31	NR	MDK2812087.1	2053592	g24697	i0	96.5	1.78125	57	2	89.1	0	22	192	1	57	MDK2812087.1 UDP-glucose 4-epimerase [Petrotoga sp.]	diamond	342	113	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp.
26717265	26717265	PRJEB80557_S_NODE_22441_length_201_cov_2.532895_g22045_i0	PRJEB80557	22441	201	2.532895	5.09111895	Fervidobacterium sp.	1871331	Bacteria	Bacteria	102	5.4499999999999996e-24	NR	MFN3692050.1	1871331	g22045	i0	82.5	0.940298507462687	63	11	94	0	13	201	81	143	MFN3692050.1 hypothetical protein [Fervidobacterium sp.]	diamond	189	102	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
27539903	27539903	PRJEB80557_S_NODE_31484_length_173_cov_1.233871_g31088_i0	PRJEB80557	31484	173	1.233871	2.13459683	Marinitoga litoralis	570855	Bacteria	Bacteria	59.3	1.98e-8	NR	WP_205099561.1	570855	g31088	i0	58	7.04046242774566	50	21	86.7	0	151	2	73	122	WP_205099561.1 ABC transporter ATP-binding protein [Marinitoga litoralis]	diamond	1218	59.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga litoralis
27761137	27761137	PRJEB80557_S_NODE_22924_length_199_cov_2.860000_g22528_i0	PRJEB80557	22924	199	2.86	5.6914	Pseudothermotoga lettingae	177758	Bacteria	Bacteria	44.3	0.00169	NR	KUK20993.1	177758	g22528	i0	65.7	0.527638190954774	35	12	52.8	0	106	2	5	39	KUK20993.1 MAG: Paclitaxel/taxanoid biosynthesis susceptibility protein TS1 [Pseudothermotoga lettingae]	diamond	105	44.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga lettingae
28834319	28834319	PRJEB80557_S_NODE_11748_length_269_cov_1.540909_g11352_i0	PRJEB80557	11748	269	1.540909	4.14504521	Thermosipho sp. (in: thermotogales)	1968895	Bacteria	Bacteria	45.4	0.00188	NR	MBO8161161.1	1968895	g11352	i0	48.7	0.434944237918216	39	20	43.5	0	152	268	1	39	MBO8161161.1 LysM peptidoglycan-binding domain-containing protein [Thermosipho sp. (in: thermotogales)]	diamond	117	45.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
28953592	28953592	PRJEB80557_S_NODE_4708_length_393_cov_2.456395_g4312_i0	PRJEB80557	4708	393	2.456395	9.65363235	Bacteria	2	Bacteria	Bacteria	142	9.48e-37	NR	WP_121957787.1	1434328	g4312	i0	54.9	2.7175572519084	113	50	86.3	1	341	3	428	539	WP_121957787.1 amylo-alpha-1,6-glucosidase [Petrotoga sp. 9PWA.NaAc.5.4]	diamond	1068	143	0.993006993006993	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga sp. 9PWA.NaAc.5.4
30027098	30027098	PRJEB80557_S_NODE_9971_length_289_cov_1.941667_g9575_i0	PRJEB80557	9971	289	1.941667	5.61141763	Bacteria	2	Bacteria	Bacteria	107	2.45e-25	NR	WP_103875928.1	28236	g9575	i0	57	5.26297577854671	86	37	89.3	0	8	265	305	390	WP_103875928.1 MULTISPECIES: glycosyltransferase [Petrotoga]	diamond	1521	107	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga
30500920	30500920	PRJEB80557_S_NODE_28053_length_182_cov_2.323308_g27657_i0	PRJEB80557	28053	182	2.323308	4.22842056	Thermosipho	2420	Bacteria	Bacteria	83.6	4.88e-17	NR	WP_126994205.1	380685	g27657	i0	75	1.76373626373626	52	13	85.7	0	23	178	213	264	WP_126994205.1 glycosyltransferase family 4 protein [Thermosipho globiformans]	diamond	321	84.3	0.991696322657177	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho globiformans
31709381	31709381	PRJEB80557_S_NODE_8217_length_314_cov_2.343396_g7821_i0	PRJEB80557	8217	314	2.343396	7.35826344	Thermosipho sp. (in: thermotogales)	1968895	Bacteria	Bacteria	74.7	2.08e-14	NR	MBO8160634.1	1968895	g7821	i0	46.8	0.592356687898089	62	33	59.2	0	1	186	82	143	MBO8160634.1 hypothetical protein [Thermosipho sp. (in: thermotogales)]	diamond	186	74.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
32468930	32468930	PRJEB80557_S_NODE_2959_length_468_cov_2.718377_g2565_i0	PRJEB80557	2959	468	2.718377	12.72200436	Thermotoga petrophila	93929	Bacteria	Bacteria	160	2.98e-44	NR	WP_334100517.1	93929	g2565	i0	54.4	2.88461538461538	149	66	94.9	2	11	454	64	211	WP_334100517.1 glycosyltransferase family 4 protein [Thermotoga petrophila]	diamond	1350	160	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga petrophila

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