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

15 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Acidobacteriota"

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
15752682	15752682	PRJNA488043_P_NODE_8313_length_401_cov_2.075269_g6112_i0	PRJNA488043	8313	401	2.075269	8.32182869	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	116	6.35e-28	NR	MBA3271906.1	1978231	g6112	i0	67.4	1.93017456359102	86	24	61.3	1	154	399	1	86	MBA3271906.1 RtcB family protein [Acidobacteriota bacterium]	diamond	774	116	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24675897	24675897	PRJNA488043_P_NODE_21520_length_158_cov_2.255814_g19278_i0	PRJNA488043	21520	158	2.255814	3.56418612	Pseudomonadati	3379134	Bacteria	Bacteria	111	1.81e-27	NR	NLH10748.1	2073116	g19278	i0	100	2.9620253164557	52	0	98.7	0	1	156	106	157	NLH10748.1 terminase large subunit [Holophagae bacterium]	diamond	468	111	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae				Holophagae bacterium
26949670	26949670	PRJNA488043_P_NODE_21402_length_159_cov_2.146154_g19160_i0	PRJNA488043	21402	159	2.146154	3.41238486	Terriglobales bacterium	2282142	Bacteria	Bacteria	79.3	1.47e-15	NR	HKS72389.1	2282142	g19160	i0	71.7	1	53	15	100	0	1	159	50	102	HKS72389.1 hypothetical protein [Terriglobales bacterium]	diamond	159	79.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27187044	27187044	PRJNA488043_P_NODE_10242_length_332_cov_2.432343_g8001_i0	PRJNA488043	10242	332	2.432343	8.07537876	Pseudomonadati	3379134	Bacteria	Bacteria	59.3	2.73e-8	NR	MDM7995639.1	1978231	g8001	i0	42.6	1.12048192771084	61	35	55.1	0	190	8	1	61	MDM7995639.1 GNAT family protein [Acidobacteriota bacterium]	diamond	372	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27803019	27803019	PRJNA488043_P_NODE_16164_length_212_cov_1.868852_g13922_i0	PRJNA488043	16164	212	1.868852	3.96196624	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	135	8.74e-39	NR	NLH78671.1	1978231	g13922	i0	95.7	0.990566037735849	70	3	99.1	0	212	3	77	146	NLH78671.1 hypothetical protein [Acidobacteriota bacterium]	diamond	210	135	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28276337	28276337	PRJNA488043_P_NODE_16386_length_209_cov_2.661111_g14144_i0	PRJNA488043	16386	209	2.661111	5.56172199	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	97.1	1.1399999999999999e-24	NR	HOK48163.1	2212468	g14144	i0	93.9	0.703349282296651	49	3	70.3	0	63	209	1	49	HOK48163.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	147	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28434384	28434384	PRJNA488043_P_NODE_15666_length_218_cov_2.502646_g13424_i0	PRJNA488043	15666	218	2.502646	5.45576828	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	104	1.14e-27	NR	HOK48163.1	2212468	g13424	i0	96.2	0.715596330275229	52	2	71.6	0	156	1	1	52	HOK48163.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	156	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28434390	28434390	PRJNA488043_P_NODE_21046_length_162_cov_2.187970_g18804_i0	PRJNA488043	21046	162	2.18797	3.5445114	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	40.4	0.032	NR	HKG81051.1	2283092	g18804	i0	38.9	0.666666666666667	36	22	66.7	0	145	38	57	92	HKG81051.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	108	40.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29334484	29334484	PRJNA488043_P_NODE_9989_length_340_cov_2.295820_g7749_i0	PRJNA488043	9989	340	2.29582	7.805788	Pseudomonadati	3379134	Bacteria	Bacteria	59.3	3e-8	NR	MDM7995639.1	1978231	g7749	i0	42.6	1.09411764705882	61	35	53.8	0	190	8	1	61	MDM7995639.1 GNAT family protein [Acidobacteriota bacterium]	diamond	372	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29381581	29381581	PRJNA488043_P_NODE_21909_length_155_cov_1.968254_g19667_i0	PRJNA488043	21909	155	1.968254	3.0507937	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	80.5	3.99e-16	NR	MEY4636517.1	1978231	g19667	i0	76.5	0.987096774193548	51	12	98.7	0	154	2	290	340	MEY4636517.1 hypothetical protein [Acidobacteriota bacterium]	diamond	153	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29476003	29476003	PRJNA488043_P_NODE_6450_length_498_cov_2.264392_g4390_i0	PRJNA488043	6450	498	2.264392	11.27667216	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	142	1.4799999999999999e-40	NR	MBF84493.1	1978231	g4390	i0	54.6	0.650602409638554	108	49	65.1	0	146	469	1	108	MBF84493.1 hypothetical protein [Acidobacteriota bacterium]	diamond	324	142	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30392748	30392748	PRJNA488043_P_NODE_6513_length_495_cov_2.259657_g4447_i0	PRJNA488043	6513	495	2.259657	11.18530215	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	68.9	1.82e-10	NR	HOQ61813.1	2910147	g4447	i0	42.9	0.721212121212121	119	65	72.1	2	130	486	29	144	HOQ61813.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	357	68.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31276901	31276901	PRJNA488043_P_NODE_5735_length_542_cov_2.210526_g3748_i0	PRJNA488043	5735	542	2.210526	11.98105092	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	148	1.37e-37	NR	HEY2091234.1	2651171	g3748	i0	42.6	3.08856088560886	188	99	99.6	3	3	542	252	438	HEY2091234.1 replicative DNA helicase [Thermoanaerobaculia bacterium]	diamond	1674	148	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
31372106	31372106	PRJNA488043_P_NODE_12256_length_277_cov_2.197581_g10015_i0	PRJNA488043	12256	277	2.197581	6.08729937	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	101	1.52e-22	NR	HKS24683.1	2651171	g10015	i0	48.9	1.90613718411552	92	47	99.6	0	2	277	244	335	HKS24683.1 replicative DNA helicase [Thermoanaerobaculia bacterium]	diamond	528	101	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
32162929	32162929	PRJNA488043_P_NODE_10618_length_320_cov_2.182131_g8377_i0	PRJNA488043	10618	320	2.182131	6.9828192	Terracidiphilus sp.	1964191	Bacteria	Bacteria	47.4	0.00119	NR	HLY40469.1	1964191	g8377	i0	43.5	0.58125	62	31	54.4	1	36	209	121	182	HLY40469.1 hypothetical protein [Terracidiphilus sp.]	diamond	186	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus 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);;