metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_kingdom = "Methanobacteriati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26907770	26907770	PRJEB83711_P_NODE_68222_length_247_cov_1.522989_g67956_i0	PRJEB83711	68222	247	1.522989	3.76178283	Natronoarchaeum rubrum	755311	Archaea	Archaea	43.5	0.0197	NR	WP_256391750.1	755311	g67956	i0	37.5	0.97165991902834	80	39	88.7	3	18	236	59	134	WP_256391750.1 ATP-binding protein [Natronoarchaeum rubrum]	diamond	240	43.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Natronoarchaeum	Natronoarchaeum rubrum
27097493	27097493	PRJEB83711_P_NODE_62062_length_251_cov_0.876404_g61796_i0	PRJEB83711	62062	251	0.876404	2.19977404	Methanobrevibacter sp.	66852	Archaea	Archaea	87.8	1.68e-19	NR	MBO7212442.1	66852	g61796	i0	67.3	0.621513944223108	52	17	62.2	0	1	156	130	181	MBO7212442.1 hypothetical protein [Methanobrevibacter sp.]	diamond	156	87.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27184862	27184862	PRJEB83711_P_NODE_66862_length_248_cov_0.891429_g66596_i0	PRJEB83711	66862	248	0.891429	2.21074392	Methanobrevibacter	2172	Archaea	Archaea	154	1.33e-42	NR	WP_330027063.1	66852	g66596	i0	85.2	1.95967741935484	81	12	98	0	248	6	305	385	WP_330027063.1 glutamate--tRNA ligase, partial [Methanobrevibacter sp.]	diamond	486	154	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27382129	27382129	PRJEB83711_P_NODE_54163_length_259_cov_1.322581_g53897_i0	PRJEB83711	54163	259	1.322581	3.42548479	Methanobrevibacter sp.	66852	Archaea	Archaea	108	4.45e-27	NR	WP_330009041.1	66852	g53897	i0	54.7	0.996138996138996	86	39	99.6	0	259	2	81	166	WP_330009041.1 AraC family transcriptional regulator [Methanobrevibacter sp.]	diamond	258	108	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27634733	27634733	PRJEB83711_P_NODE_42004_length_284_cov_1.473934_g41738_i0	PRJEB83711	42004	284	1.473934	4.18597256	Halococcus dombrowskii	179637	Archaea	Archaea	155	2.16e-41	NR	WP_244706568.1	179637	g41738	i0	76.6	0.992957746478873	94	22	99.3	0	282	1	1231	1324	WP_244706568.1 hypothetical protein [Halococcus dombrowskii]	diamond	282	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus dombrowskii
27950413	27950413	PRJEB83711_P_NODE_77085_length_243_cov_0.917647_g76819_i0	PRJEB83711	77085	243	0.917647	2.22988221	Halosimplex carlsbadense	171164	Archaea	Archaea	94.4	9.62e-21	NR	WP_006881789.1	171164	g76819	i0	58	2	81	34	100	0	1	243	88	168	WP_006881789.1 aminopeptidase [Halosimplex carlsbadense]	diamond	486	94.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halosimplex	Halosimplex carlsbadense
27981980	27981980	PRJEB83711_P_NODE_71465_length_246_cov_0.901734_g71199_i0	PRJEB83711	71465	246	0.901734	2.21826564	Methanobrevibacter sp. UBA412	1915486	Archaea	Archaea	129	6.030000000000001e-36	NR	WP_413829086.1	1915486	g71199	i0	70.4	1.97560975609756	81	24	98.8	0	1	243	41	121	WP_413829086.1 response regulator [Methanobrevibacter sp. UBA412]	diamond	486	129	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. UBA412
29908138	29908138	PRJEB83711_P_NODE_44631_length_278_cov_1.502439_g44365_i0	PRJEB83711	44631	278	1.502439	4.17678042	Natronomonas sp. LN261	2750669	Archaea	Archaea	116	1.6699999999999999e-31	NR	WP_181693274.1	2750669	g44365	i0	94.9	0.636690647482014	59	3	63.7	0	2	178	55	113	WP_181693274.1 hypothetical protein [Natronomonas sp. LN261]	diamond	177	116	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
31646027	31646027	PRJEB83711_P_NODE_58597_length_253_cov_0.866667_g58331_i0	PRJEB83711	58597	253	0.866667	2.19266751	Methanobrevibacter sp.	66852	Archaea	Archaea	132	3.4199999999999992e-34	NR	MBO7212323.1	66852	g58331	i0	64.4	1.06719367588933	90	25	98.4	1	251	3	402	491	MBO7212323.1 peptidoglycan-binding protein [Methanobrevibacter sp.]	diamond	270	132	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31899266	31899266	PRJEB83711_P_NODE_78197_length_242_cov_0.988166_g77931_i0	PRJEB83711	78197	242	0.988166	2.39136172	Thermoplasmata archaeon	1906666	Archaea	Archaea	42.7	0.0275	NR	MDH4123785.1	1906666	g77931	i0	40.5	0.45867768595041303	37	22	45.9	0	187	77	46	82	MDH4123785.1 phosphoesterase [Thermoplasmata archaeon]	diamond	111	42.7	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32342465	32342465	PRJEB83711_P_NODE_60119_length_252_cov_0.871508_g59853_i0	PRJEB83711	60119	252	0.871508	2.19620016	Methanobrevibacter sp.	66852	Archaea	Archaea	151	8.459999999999998e-42	NR	MBR2558764.1	66852	g59853	i0	92.8	1.97619047619048	83	6	98.8	0	2	250	260	342	MBR2558764.1 lysine--tRNA ligase [Methanobrevibacter sp.]	diamond	498	151	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32595300	32595300	PRJEB83711_P_NODE_76840_length_243_cov_0.917647_g76574_i0	PRJEB83711	76840	243	0.917647	2.22988221	Methanosarcina sp. UBA5	1915593	Archaea	Archaea	48.9	5.57e-5	NR	WP_292387852.1	1915593	g76574	i0	88	0.308641975308642	25	3	30.9	0	87	161	98	122	WP_292387852.1 DDE-type integrase/transposase/recombinase, partial [Methanosarcina sp. UBA5]	diamond	75	48.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp. UBA5

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