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

10 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax_phylum = "Kiritimatiellota"

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_species
18787179	18787179	PRJNA951810_P_NODE_105915_length_289_cov_5.129630_g105571_i0	PRJNA951810	105915	289	5.12963	14.8246307	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	114	7.6e-30	NR	MBW7909587.1	2212473	g105571	i0	58.5	1.96193771626298	94	37	97.6	1	4	285	9	100	MBW7909587.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Kiritimatiellia bacterium]	diamond	567	114	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
26677180	26677180	PRJNA951810_P_NODE_186941_length_222_cov_6.664430_g186596_i0	PRJNA951810	186941	222	6.66443	14.7950346	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	67.4	1.25e-11	NR	WFB36875.1	3040511	g186596	i0	49.3	1.01351351351351	75	36	98.6	1	221	3	53	127	WFB36875.1 DUF4082 domain-containing protein [Kiritimatiellota bacterium B12222]	diamond	225	67.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota		Kiritimatiellota bacterium B12222
27310362	27310362	PRJNA951810_P_NODE_176603_length_236_cov_2.300613_g176258_i0	PRJNA951810	176603	236	2.300613	5.42944668	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	93.6	4.34e-20	NR	HPF98645.1	2212473	g176258	i0	52.4	4.16949152542373	82	35	99.2	1	3	236	208	289	HPF98645.1 glycosyltransferase family 4 protein [Kiritimatiellia bacterium]	diamond	984	93.6	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
27562585	27562585	PRJNA951810_P_NODE_196444_length_200_cov_7.181102_g196099_i0	PRJNA951810	196444	200	7.181102	14.362204	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.1	0.0148	NR	HRT04474.1	2212473	g196099	i0	39	0.885	59	33	88.5	1	11	187	163	218	HRT04474.1 50S ribosomal protein L2 [Kiritimatiellia bacterium]	diamond	177	43.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
28478467	28478467	PRJNA951810_P_NODE_148946_length_259_cov_1.478495_g148601_i0	PRJNA951810	148946	259	1.478495	3.82930205	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	103	1.26e-23	NR	MBQ3342078.1	2212473	g148601	i0	61.6	0.845559845559846	73	28	84.6	0	257	39	373	445	MBQ3342078.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	219	103	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
28952331	28952331	PRJNA951810_P_NODE_21108_length_436_cov_4.531680_g20770_i0	PRJNA951810	21108	436	4.53168	19.7581248	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	244	7.520000000000001e-79	NR	HNR94251.1	2212473	g20770	i0	79.3	1.9954128440367	145	30	99.8	0	2	436	41	185	HNR94251.1 NAD-dependent epimerase/dehydratase family protein [Kiritimatiellia bacterium]	diamond	870	244	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
29677934	29677934	PRJNA951810_P_NODE_177470_length_235_cov_2.438272_g177125_i0	PRJNA951810	177470	235	2.438272	5.7299392	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	104	5.28e-25	NR	HPF99733.1	2212473	g177125	i0	64.9	0.982978723404255	77	27	98.3	0	5	235	161	237	HPF99733.1 GDP-mannose 4,6-dehydratase [Kiritimatiellia bacterium]	diamond	231	104	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
30151856	30151856	PRJNA951810_P_NODE_33092_length_346_cov_5.600733_g32750_i0	PRJNA951810	33092	346	5.600733	19.37853618	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	96.3	1.29e-20	NR	MFA7160882.1	2212473	g32750	i0	67.6	0.589595375722543	68	16	59	1	344	141	219	280	MFA7160882.1 nucleotide sugar dehydrogenase [Kiritimatiellia bacterium]	diamond	204	96.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31099731	31099731	PRJNA951810_P_NODE_135415_length_269_cov_3.040816_g135070_i0	PRJNA951810	135415	269	3.040816	8.17979504	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	73.6	3.93e-13	NR	HMP00840.1	2212473	g135070	i0	53.7	0.747211895910781	67	31	74.7	0	67	267	12	78	HMP00840.1 tyrosine-type recombinase/integrase [Kiritimatiellia bacterium]	diamond	201	73.6	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
32586773	32586773	PRJNA951810_P_NODE_25679_length_396_cov_11.037152_g25337_i0	PRJNA951810	25679	396	11.037152	43.70712192	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	136	9.8e-37	NR	MCG2660197.1	2212473	g25337	i0	56.1	1.87878787878788	123	49	89.4	1	356	3	3	125	MCG2660197.1 SDR family oxidoreductase [Kiritimatiellia bacterium]	diamond	744	136	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium

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