metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Nitrospirota"

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
26696386	26696386	PRJNA488043_P_NODE_15401_length_222_cov_2.031088_g13159_i0	PRJNA488043	15401	222	2.031088	4.50901536	Nitrospira sp.	70125	Bacteria	Bacteria	76.3	1.34e-14	NR	MBK7421585.1	70125	g13159	i0	100	1.44594594594595	36	0	48.6	0	115	222	1	36	MBK7421585.1 hypothetical protein [Nitrospira sp.]	diamond	321	76.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26791593	26791593	PRJNA488043_P_NODE_13721_length_248_cov_2.319635_g11479_i0	PRJNA488043	13721	248	2.319635	5.7526948	Nitrospira sp.	70125	Bacteria	Bacteria	96.7	1.94e-21	NR	HMV57845.1	70125	g11479	i0	57.3	0.991935483870968	82	35	99.2	0	2	247	71	152	HMV57845.1 Clp protease ClpP [Nitrospira sp.]	diamond	246	96.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26823328	26823328	PRJNA488043_P_NODE_7461_length_442_cov_2.944310_g5312_i0	PRJNA488043	7461	442	2.94431	13.0138502	Nitrospira sp.	70125	Bacteria	Bacteria	229	8.77e-70	NR	HMV57842.1	70125	g5312	i0	72.1	0.997737556561086	147	41	99.8	0	441	1	103	249	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	441	229	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26934169	26934169	PRJNA488043_P_NODE_21122_length_161_cov_2.515152_g18880_i0	PRJNA488043	21122	161	2.515152	4.04939472	Pseudomonadati	3379134	Bacteria	Bacteria	60.5	6.62e-9	NR	HMV57851.1	70125	g18880	i0	51.9	1.93788819875776	52	25	96.9	0	158	3	118	169	HMV57851.1 DUF1834 family protein [Nitrospira sp.]	diamond	312	60.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27424213	27424213	PRJNA488043_P_NODE_18803_length_184_cov_1.709677_g16561_i0	PRJNA488043	18803	184	1.709677	3.14580568	Nitrospira sp.	70125	Bacteria	Bacteria	125	1.6599999999999998e-31	NR	MBK8380046.1	70125	g16561	i0	100	0.978260869565217	60	0	97.8	0	182	3	650	709	MBK8380046.1 hypothetical protein [Nitrospira sp.]	diamond	180	125	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27550166	27550166	PRJNA488043_P_NODE_6144_length_516_cov_4.351129_g4116_i0	PRJNA488043	6144	516	4.351129	22.45182564	Nitrospira sp.	70125	Bacteria	Bacteria	107	1.8399999999999998e-23	NR	HMV57842.1	70125	g4116	i0	63.9	0.418604651162791	72	26	41.9	0	296	511	7	78	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	216	107	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27834348	27834348	PRJNA488043_P_NODE_10784_length_315_cov_2.241259_g8543_i0	PRJNA488043	10784	315	2.241259	7.05996585	Nitrospira sp.	70125	Bacteria	Bacteria	63.2	4.6e-9	NR	HMV57846.1	70125	g8543	i0	37.1	0.923809523809524	97	59	92.4	1	4	294	174	268	HMV57846.1 hypothetical protein [Nitrospira sp.]	diamond	291	63.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28150332	28150332	PRJNA488043_P_NODE_13145_length_258_cov_2.716157_g10904_i0	PRJNA488043	13145	258	2.716157	7.00768506	Nitrospira sp.	70125	Bacteria	Bacteria	88.2	2.63e-20	NR	HMV57844.1	70125	g10904	i0	69.4	0.720930232558139	62	19	72.1	0	3	188	52	113	HMV57844.1 hypothetical protein [Nitrospira sp.]	diamond	186	88.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30013257	30013257	PRJNA488043_P_NODE_1011_length_1800_cov_2.656691_g352_i0	PRJNA488043	1011	1800	2.656691	47.820438	Nitrospira sp.	70125	Bacteria	Bacteria	314	2.9399999999999986e-96	NR	HMV57842.1	70125	g352	i0	79	0.31	186	37	30.7	1	1	552	331	516	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	558	314	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30060625	30060625	PRJNA488043_P_NODE_14631_length_233_cov_2.441176_g12389_i0	PRJNA488043	14631	233	2.441176	5.68794008	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	2.09e-10	NR	HND02873.1	70125	g12389	i0	43.7	1.89270386266094	71	40	91.4	0	231	19	94	164	HND02873.1 hypothetical protein [Nitrospira sp.]	diamond	441	63.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30297989	30297989	PRJNA488043_P_NODE_4172_length_681_cov_3.142638_g2423_i0	PRJNA488043	4172	681	3.142638	21.40136478	Nitrospira sp.	70125	Bacteria	Bacteria	82	4.82e-15	NR	HNN43760.1	70125	g2423	i0	41	0.92511013215859	105	60	46.3	1	384	70	27	129	HNN43760.1 replication protein P [Nitrospira sp.]	diamond	630	82	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31276890	31276890	PRJNA488043_P_NODE_10255_length_332_cov_2.155116_g8014_i0	PRJNA488043	10255	332	2.155116	7.15498512	Nitrospira sp.	70125	Bacteria	Bacteria	62.4	1.03e-8	NR	HMV57846.1	70125	g8014	i0	37.1	0.876506024096386	97	59	87.7	1	4	294	174	268	HMV57846.1 hypothetical protein [Nitrospira sp.]	diamond	291	62.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31846274	31846274	PRJNA488043_P_NODE_8237_length_404_cov_2.157333_g6039_i0	PRJNA488043	8237	404	2.157333	8.71562532	Nitrospira sp.	70125	Bacteria	Bacteria	241	1.2299999999999999e-74	NR	HMV57842.1	70125	g6039	i0	82.8	0.995049504950495	134	23	99.5	0	404	3	331	464	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	402	241	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32321300	32321300	PRJNA488043_P_NODE_7299_length_450_cov_2.263658_g5158_i0	PRJNA488043	7299	450	2.263658	10.186461	Nitrospira sp.	70125	Bacteria	Bacteria	281	6.18e-90	NR	HMV57842.1	70125	g5158	i0	81.9	0.993333333333333	149	27	99.3	0	447	1	271	419	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	447	281	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32731585	32731585	PRJNA488043_P_NODE_16520_length_208_cov_1.608939_g14278_i0	PRJNA488043	16520	208	1.608939	3.34659312	Nitrospira sp.	70125	Bacteria	Bacteria	75.5	1.76e-15	NR	MBK7421579.1	70125	g14278	i0	100	0.548076923076923	38	0	54.8	0	207	94	91	128	MBK7421579.1 hypothetical protein [Nitrospira sp.]	diamond	114	75.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32857414	32857414	PRJNA488043_P_NODE_1020_length_1774_cov_2.721490_g352_i1	PRJNA488043	1020	1774	2.72149	48.2792326	Nitrospira sp.	70125	Bacteria	Bacteria	314	2.279999999999999e-96	NR	HMV57842.1	70125	g352	i1	79	0.788049605411499	186	37	31.1	1	1	552	331	516	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	1398	314	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira 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);;