metadata: contig_metadata: 15 rows where bioproject = "PRJDB9741" and tax

15 rows where bioproject = "PRJDB9741" 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
2560832	2560832	PRJDB9741_P_NODE_36743_length_162_cov_2.504425_g36426_i0	PRJDB9741	36743	162	2.504425	4.0571685	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	156	9.99e-34	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36426	i0	84.337	64.1358024691358	166	19	99	6	2	162	3042320	3042483	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	10390	156	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
3532451	3532451	PRJDB9741_P_NODE_20523_length_177_cov_1.445312_g20206_i0	PRJDB9741	20523	177	1.445312	2.55820224	Gemmatirosa	1706036	Bacteria	Bacteria	272	1.0499999999999998e-68	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g20206	i0	94.413	10.2372881355932	179	6	100	4	1	177	421805	421629	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1812	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6084965	6084965	PRJDB9741_P_NODE_30945_length_165_cov_1.758621_g30628_i0	PRJDB9741	30945	165	1.758621	2.90172465	Gemmatirosa	1706036	Bacteria	Bacteria	279	5.81e-71	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g30628	i0	97.546	169.939393939394	163	4	99	0	3	165	423137	423299	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	28040	279	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10213729	10213729	PRJDB9741_P_NODE_30669_length_165_cov_3.560345_g30352_i0	PRJDB9741	30669	165	3.560345	5.87456925	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	267	4.53e-67	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g30352	i0	95.758	9.33939393939394	165	7	100	0	1	165	421743	421907	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1541	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12764552	12764552	PRJDB9741_P_NODE_37311_length_162_cov_1.451327_g36994_i0	PRJDB9741	37311	162	1.451327	2.35114974	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	228	2.0899999999999995e-55	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g36994	i0	92.025	213.086419753086	163	11	100	2	1	162	1902932	1903093	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	34520	228	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14039153	14039153	PRJDB9741_P_NODE_7112_length_235_cov_1.774194_g6795_i0	PRJDB9741	7112	235	1.774194	4.1693559	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	296	8.81e-76	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g6795	i0	89.362	41.9659574468085	235	25	100	0	1	235	3042850	3043084	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	9862	296	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16587950	16587950	PRJDB9741_P_NODE_7694_length_226_cov_3.000000_g7377_i0	PRJDB9741	7694	226	3	6.78	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	385	1.75e-102	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g7377	i0	97.368	14.7079646017699	228	2	100	4	1	226	1102886	1102661	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	3324	385	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
17862915	17862915	PRJDB9741_P_NODE_8555_length_216_cov_1.221557_g8238_i0	PRJDB9741	8555	216	1.221557	2.63856312	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	294	2.87e-75	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g8238	i0	95.652	48.9768518518519	184	7	85	1	32	215	801715	801897	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	10579	294	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19136317	19136317	PRJDB9741_P_NODE_13416_length_189_cov_2.378571_g13099_i0	PRJDB9741	13416	189	2.378571	4.49549919	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g13099	i0	99.471	422.47619047619	189	1	100	0	1	189	171714	171902	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	79848	344	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20411602	20411602	PRJDB9741_P_NODE_33457_length_164_cov_1.321739_g33140_i0	PRJDB9741	33457	164	1.321739	2.16765196	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	213	5.94e-51	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g33140	i0	91.083	84.6524390243902	157	14	96	0	1	157	746431	746587	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	13883	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20411634	20411634	PRJDB9741_P_NODE_3697_length_347_cov_2.590604_g3381_i0	PRJDB9741	3697	347	2.590604	8.98939588	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	409	1.69e-109	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g3381	i0	89.506	96.6974063400576	324	33	93	1	25	347	421037	421360	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	33554	409	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28132169	28132169	PRJDB9741_P_NODE_25185_length_170_cov_1.421488_g24868_i0	PRJDB9741	25185	170	1.421488	2.4165296	Pseudomonadati	3379134	Bacteria	Bacteria	86.7	3.56e-18	NR	HEU4699496.1	2448054	g24868	i0	67.9	7.58823529411765	56	18	98.8	0	2	169	368	423	HEU4699496.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Gemmatimonadales bacterium]	diamond	1290	86.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31201134	31201134	PRJDB9741_P_NODE_20395_length_177_cov_1.593750_g20078_i0	PRJDB9741	20395	177	1.59375	2.8209375	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	72	7.12e-13	NR	HUF75775.1	2910168	g20078	i0	63.8	0.983050847457627	58	21	98.3	0	175	2	245	302	HUF75775.1 adenylate/guanylate cyclase domain-containing protein [Longimicrobiales bacterium]	diamond	174	72	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31675880	31675880	PRJDB9741_P_NODE_23097_length_173_cov_1.370968_g22780_i0	PRJDB9741	23097	173	1.370968	2.37177464	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	98.6	8.82e-24	NR	HUP89793.1	2910168	g22780	i0	85.5	0.953757225433526	55	8	95.4	0	1	165	27	81	HUP89793.1 succinate dehydrogenase cytochrome b subunit [Longimicrobiales bacterium]	diamond	165	98.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
31865566	31865566	PRJDB9741_P_NODE_26177_length_168_cov_2.277311_g25860_i0	PRJDB9741	26177	168	2.277311	3.82588248	Gemmatirosa sp.	2510638	Bacteria	Bacteria	65.1	2.32e-11	NR	HZF67424.1	2510638	g25860	i0	82.1	0.696428571428571	39	7	69.6	0	117	1	1	39	HZF67424.1 hypothetical protein [Gemmatirosa sp.]	diamond	117	65.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa 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);;