metadata: contig_metadata: 11 rows where bioproject = "PRJNA857857" and tax

11 rows where bioproject = "PRJNA857857" and tax_phylum = "Gemmatimonadota"

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
4673534	4673534	PRJNA857857_P_NODE_34464_length_260_cov_1.235294_g34015_i0	PRJNA857857	34464	260	1.235294	3.2117644	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	361	3.469999999999999e-95	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g34015	i0	91.892	224.926923076923	259	20	99	1	1	259	1903876	1904133	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	58481	361	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7222985	7222985	PRJNA857857_P_NODE_20506_length_345_cov_3.014706_g20057_i0	PRJNA857857	20506	345	3.014706	10.4007357	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	359	1.72e-94	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g20057	i0	91.353	386.211594202899	266	17	76	6	8	270	1904745	1904483	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	133243	359	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24187338	24187338	PRJNA857857_P_NODE_43179_length_247_cov_0.885057_g42730_i0	PRJNA857857	43179	247	0.885057	2.18609079	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	156	5.71e-43	NR	HKC47731.1	2448054	g42730	i0	97.6	4.95546558704453	82	2	99.6	0	1	246	432	513	HKC47731.1 iron ABC transporter permease [Gemmatimonadales bacterium]	diamond	1224	156	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26897058	26897058	PRJNA857857_P_NODE_49201_length_243_cov_0.905882_g48752_i0	PRJNA857857	49201	243	0.905882	2.20129326	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	87.8	5.89e-21	NR	HYR32143.1	2448054	g48752	i0	97.5	0.493827160493827	40	1	49.4	0	124	243	1	40	HYR32143.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	120	87.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26991587	26991587	PRJNA857857_P_NODE_28722_length_288_cov_1.744186_g28273_i0	PRJNA857857	28722	288	1.744186	5.02325568	Gemmatimonadetes bacterium SCN 7	1660163	Bacteria	Bacteria	44.7	0.0126	NR	ODT02342.1	1660163	g28273	i0	35.1	0.802083333333333	77	46	77.1	3	47	268	41	116	ODT02342.1 MAG: hypothetical protein ABS52_14075 [Gemmatimonadetes bacterium SCN 70-22]	diamond	231	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium SCN 70-22
28507887	28507887	PRJNA857857_P_NODE_21267_length_339_cov_1.447368_g20818_i0	PRJNA857857	21267	339	1.447368	4.90657752	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	113	3.33e-27	NR	HWA58712.1	2448054	g20818	i0	49.1	19.1769911504425	114	53	99.1	2	4	339	183	293	HWA58712.1 4-hydroxyphenylpyruvate dioxygenase [Gemmatimonadales bacterium]	diamond	6501	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29052893	29052893	PRJNA857857_P_NODE_48168_length_243_cov_0.905882_g47719_i0	PRJNA857857	48168	243	0.905882	2.20129326	FCB group	1783270	Bacteria	Bacteria	116	3.85e-29	NR	HEX3273210.1	2448054	g47719	i0	93.5	1.53086419753086	62	4	76.5	0	242	57	221	282	HEX3273210.1 ferritin-like domain-containing protein [Gemmatimonadales bacterium]	diamond	372	116	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29273588	29273588	PRJNA857857_P_NODE_13669_length_426_cov_1.320113_g13223_i0	PRJNA857857	13669	426	1.320113	5.62368138	Bacteria	2	Bacteria	Bacteria	58.5	6.15e-7	NR	MEO7520644.1	1962908	g13223	i0	35.9	1.23943661971831	92	54	62	2	162	425	14	104	MEO7520644.1 terminase family protein [Gemmatimonas sp.]	diamond	528	58.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
31572230	31572230	PRJNA857857_P_NODE_27096_length_298_cov_1.026667_g26647_i0	PRJNA857857	27096	298	1.026667	3.05946766	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	51.6	5.45e-5	NR	MCJ7630193.1	2910168	g26647	i0	29.6	1.6006711409396	81	57	81.5	0	295	53	77	157	MCJ7630193.1 PAS domain S-box protein [Longimicrobiales bacterium]	diamond	477	51.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32521483	32521483	PRJNA857857_P_NODE_33759_length_263_cov_1.621053_g33310_i0	PRJNA857857	33759	263	1.621053	4.26336939	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.5	7e-6	NR	MEJ2202921.1	2026742	g33310	i0	39.1	0.992395437262357	87	45	99.2	2	3	263	21	99	MEJ2202921.1 PD-(D/E)XK nuclease family protein [Gemmatimonadota bacterium]	diamond	261	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32773194	32773194	PRJNA857857_P_NODE_39860_length_249_cov_0.875000_g39411_i0	PRJNA857857	39860	249	0.875	2.17875	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	47	0.00107	NR	MXY96196.1	2026742	g39411	i0	34.1	1.73493975903614	85	49	96.4	3	248	9	163	245	MXY96196.1 class I SAM-dependent methyltransferase [Gemmatimonadota bacterium]	diamond	432	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;