metadata: contig_metadata: 12 rows where bioproject = "PRJNA564013" and tax

12 rows where bioproject = "PRJNA564013" and tax_phylum = "Balneolota"

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
1823728	1823728	PRJNA564013_P_NODE_173622_length_330_cov_10.724907_g170772_i0	PRJNA564013	173622	330	10.724907	35.3921931	Fodinibius	1397106	Bacteria	Bacteria	115	7.09e-28	NR	WP_148899923.1	860790	g170772	i0	75	4.32727272727273	68	17	61.8	0	260	57	328	395	WP_148899923.1 elongation factor Tu [Fodinibius salinus]	diamond	1428	116	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salinus
15159642	15159642	PRJNA564013_P_NODE_142612_length_358_cov_10.639731_g139763_i0	PRJNA564013	142612	358	10.639731	38.09023698	Fodinibius saliphilus	1920650	Bacteria	Bacteria	191	2.38e-58	NR	WP_138431657.1	1920650	g139763	i0	87.4	0.930167597765363	111	14	93	0	338	6	24	134	WP_138431657.1 ZIP family metal transporter [Fodinibius saliphilus]	diamond	333	191	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius saliphilus
22226227	22226227	PRJNA564013_P_NODE_219498_length_288_cov_2.651982_g216647_i0	PRJNA564013	219498	288	2.651982	7.63770816	Balneolaceae bacterium	2053516	Bacteria	Bacteria	111	4.33e-20	NTclustered	gi\|2021937725\|gb\|CP051242.1\|	2053516	g216647	i0	81.752	1.66666666666667	137	21	47	4	34	168	1494137	1494271	MAG: Balneolaceae bacterium isolate ih13 chromosome	blastn	480	111	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
26667454	26667454	PRJNA564013_P_NODE_119621_length_383_cov_5.673913_g116777_i0	PRJNA564013	119621	383	5.673913	21.73108679	Balneolaceae bacterium	2053516	Bacteria	Bacteria	52.4	6.69e-5	NR	MDZ7720220.1	2053516	g116777	i0	68.4	1.04177545691906	38	12	29.8	0	322	209	337	374	MDZ7720220.1 Gfo/Idh/MocA family oxidoreductase [Balneolaceae bacterium]	diamond	399	52.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
26712970	26712970	PRJNA564013_P_NODE_317341_length_215_cov_1.896104_g314489_i0	PRJNA564013	317341	215	1.896104	4.0766236	Fodinibius	1397106	Bacteria	Bacteria	84.7	1.43e-17	NR	WP_165267597.1	1736908	g314489	i0	80	1.88372093023256	45	9	62.8	0	213	79	265	309	WP_165267597.1 PIG-L family deacetylase [Fodinibius halophilus]	diamond	405	84.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius halophilus
26903357	26903357	PRJNA564013_P_NODE_56341_length_531_cov_11.810638_g53563_i0	PRJNA564013	56341	531	11.810638	62.71448778	Fodinibius	1397106	Bacteria	Bacteria	202	9.98e-63	NR	WP_322574197.1	1872440	g53563	i0	64.7	3.45762711864407	153	52	86.4	1	53	511	1	151	WP_322574197.1 SCO family protein [Fodinibius sp.]	diamond	1836	202	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
27490143	27490143	PRJNA564013_P_NODE_330163_length_208_cov_4.122449_g327311_i0	PRJNA564013	330163	208	4.122449	8.57469392	Aliifodinibius salipaludis	2032627	Bacteria	Bacteria	117	4.12e-29	NR	WP_095607064.1	2032627	g327311	i0	96.7	0.879807692307692	61	2	88	0	3	185	236	296	WP_095607064.1 class II fumarate hydratase [Aliifodinibius salipaludis]	diamond	183	117	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salipaludis
27788106	27788106	PRJNA564013_P_NODE_150344_length_351_cov_5.972414_g147495_i0	PRJNA564013	150344	351	5.972414	20.96317314	Fodinibius	1397106	Bacteria	Bacteria	105	2.94e-26	NR	WP_148899413.1	860790	g147495	i0	65.8	2.02564102564103	79	27	67.5	0	339	103	82	160	WP_148899413.1 hypothetical protein [Fodinibius salinus]	diamond	711	105	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salinus
28690059	28690059	PRJNA564013_P_NODE_120407_length_382_cov_6.595016_g117563_i0	PRJNA564013	120407	382	6.595016	25.19296112	Aliifodinibius salipaludis	2032627	Bacteria	Bacteria	205	1.64e-61	NR	WP_095607289.1	2032627	g117563	i0	96.1	0.808900523560209	103	4	80.9	0	326	18	225	327	WP_095607289.1 sugar porter family MFS transporter [Aliifodinibius salipaludis]	diamond	309	205	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salipaludis
29353052	29353052	PRJNA564013_P_NODE_70489_length_481_cov_3.792857_g67677_i0	PRJNA564013	70489	481	3.792857	18.24364217	Gracilimonas sp.	1974203	Bacteria	Bacteria	48.9	6.27e-4	NR	WP_395080306.1	1974203	g67677	i0	62.2	0.230769230769231	37	14	23.1	0	371	481	1	37	WP_395080306.1 recombination protein NinG [Gracilimonas sp.]	diamond	111	48.9	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sp.
30616231	30616231	PRJNA564013_P_NODE_100793_length_408_cov_47.815562_g97959_i0	PRJNA564013	100793	408	47.815562	195.08749296	Balneolaceae bacterium	2053516	Bacteria	Bacteria	213	2.29e-65	NR	HKK47297.1	2053516	g97959	i0	82.1	0.904411764705882	123	22	90.4	0	18	386	252	374	HKK47297.1 aspartate aminotransferase family protein [Balneolaceae bacterium]	diamond	369	213	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
31673216	31673216	PRJNA564013_P_NODE_314977_length_216_cov_3.812903_g312125_i0	PRJNA564013	314977	216	3.812903	8.23587048	Fodinibius	1397106	Bacteria	Bacteria	96.3	4.86e-22	NR	MDZ7681874.1	1872440	g312125	i0	92.2	2.125	51	4	70.8	0	208	56	152	202	MDZ7681874.1 ATP phosphoribosyltransferase [Fodinibius sp.]	diamond	459	96.3	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius 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);;