metadata: contig_metadata: 28 rows where bioproject = "PRJNA986481", tax_clade = "FCB group" and tax

28 rows where bioproject = "PRJNA986481", tax_clade = "FCB group" 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
974027	974027	PRJNA986481_P_NODE_7461_length_594_cov_1.866055_g6963_i0	PRJNA986481	7461	594	1.866055	11.0843667	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	462	2.29e-125	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g6963	i0	82.927	11.8888888888889	533	72	88	17	44	568	1509547	1510068	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	7062	462	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
2248470	2248470	PRJNA986481_P_NODE_1722_length_1073_cov_6.793945_g1459_i0	PRJNA986481	1722	1073	6.793945	72.89902985	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	585	1.87e-206	NR	HET8771291.1	2026741	g1459	i0	98	0.835973904939422	299	6	83.6	0	172	1068	1	299	HET8771291.1 peptide MFS transporter [Gemmatimonadaceae bacterium]	diamond	897	585	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
3524313	3524313	PRJNA986481_P_NODE_4683_length_725_cov_7.548817_g4262_i0	PRJNA986481	4683	725	7.548817	54.72892325	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	263	5.35e-85	NR	HET8770835.1	2026741	g4262	i0	100	0.604137931034483	146	0	60.4	0	459	22	1	146	HET8770835.1 TerC family protein [Gemmatimonadaceae bacterium]	diamond	438	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
4801650	4801650	PRJNA986481_P_NODE_47904_length_254_cov_2.868293_g47379_i0	PRJNA986481	47904	254	2.868293	7.28546422	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	58.4	4.96e-4	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g47379	i0	92.683	0.161417322834646	41	1	16	2	215	254	536403	536364	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	41	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6076432	6076432	PRJNA986481_P_NODE_1285_length_1181_cov_5.115724_g1058_i0	PRJNA986481	1285	1181	5.115724	60.41670044	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	287	1.13e-91	NR	HET8772034.1	2026741	g1058	i0	100	0.398814563928874	157	0	39.9	0	1161	691	133	289	HET8772034.1 SPFH domain-containing protein [Gemmatimonadaceae bacterium]	diamond	471	287	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
7351299	7351299	PRJNA986481_P_NODE_31506_length_291_cov_1.838843_g30981_i0	PRJNA986481	31506	291	1.838843	5.35103313	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	192	3.009999999999999e-55	NR	HET8770394.1	2026741	g30981	i0	100	0.989690721649485	96	0	99	0	290	3	541	636	HET8770394.1 cyanophycin synthetase [Gemmatimonadaceae bacterium]	diamond	288	192	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
12452624	12452624	PRJNA986481_P_NODE_24230_length_333_cov_2.077465_g23705_i0	PRJNA986481	24230	333	2.077465	6.91795845	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	150	8.27e-40	NR	RMH73596.1	2026742	g23705	i0	60.4	1	111	43	100	1	1	333	324	433	RMH73596.1 MAG: hypothetical protein D6675_02145, partial [Gemmatimonadota bacterium]	diamond	333	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
12751215	12751215	PRJNA986481_P_NODE_1010_length_1296_cov_5.210104_g815_i0	PRJNA986481	1010	1296	5.210104	67.52294784	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	431	2.5399999999999992e-145	NR	HET8769643.1	2026741	g815	i0	100	0.513888888888889	222	0	51.4	0	614	1279	1	222	HET8769643.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	666	431	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
14025946	14025946	PRJNA986481_P_NODE_27971_length_310_cov_1.927203_g27446_i0	PRJNA986481	27971	310	1.927203	5.9743293	Pseudomonadati	3379134	Bacteria	Bacteria	309	1.5600000000000002e-79	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g27446	i0	89.958	163.029032258065	239	24	77	0	39	277	1047643	1047405	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	50539	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
16276309	16276309	PRJNA986481_P_NODE_2613_length_916_cov_2.988466_g2282_i0	PRJNA986481	2613	916	2.988466	27.37434856	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	565	2.1499999999999998e-195	NR	HET8770533.1	2026741	g2282	i0	99.3	0.920305676855895	281	2	92	0	897	55	493	773	HET8770533.1 primosomal protein N' [Gemmatimonadaceae bacterium]	diamond	843	565	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
17551499	17551499	PRJNA986481_P_NODE_38694_length_265_cov_1.898148_g38169_i0	PRJNA986481	38694	265	1.898148	5.0300922	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	278	3.67e-70	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g38169	i0	89.498	28.6490566037736	219	23	83	0	19	237	925290	925072	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	7592	278	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
17551736	17551736	PRJNA986481_P_NODE_5314_length_689_cov_4.935937_g4876_i0	PRJNA986481	5314	689	4.935937	34.00860593	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	443	3.069999999999999e-151	NR	HET8771038.1	2026741	g4876	i0	100	0.966618287373004	222	0	96.7	0	22	687	290	511	HET8771038.1 sodium:solute symporter family protein [Gemmatimonadaceae bacterium]	diamond	666	443	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
22650290	22650290	PRJNA986481_P_NODE_13698_length_443_cov_2.007614_g13174_i0	PRJNA986481	13698	443	2.007614	8.89373002	Pseudomonadati	3379134	Bacteria	Bacteria	122	2.6799999999999996e-31	NR	HEX2219116.1	2448054	g13174	i0	69.8	7.49661399548533	86	26	58.2	0	442	185	140	225	HEX2219116.1 type 1 glutamine amidotransferase domain-containing protein [Gemmatimonadales bacterium]	diamond	3321	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26773217	26773217	PRJNA986481_P_NODE_1821_length_1055_cov_2.725646_g1547_i0	PRJNA986481	1821	1055	2.725646	28.7555653	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57.4	3.37e-5	NR	HSM08200.1	2026742	g1547	i0	30.3	3.35545023696682	175	102	49.5	6	26	547	24	179	HSM08200.1 regulatory iron-sulfur-containing complex subunit RicT [Gemmatimonadota bacterium]	diamond	3540	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27405863	27405863	PRJNA986481_P_NODE_15083_length_422_cov_2.815013_g14558_i0	PRJNA986481	15083	422	2.815013	11.87935486	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	271	1.16e-83	NR	HET8769788.1	2026741	g14558	i0	100	0.959715639810427	135	0	96	0	6	410	54	188	HET8769788.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium]	diamond	405	271	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27658472	27658472	PRJNA986481_P_NODE_5204_length_695_cov_2.818885_g4770_i0	PRJNA986481	5204	695	2.818885	19.59125075	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	44.3	0.0451	NR	MEE2993648.1	2026742	g4770	i0	32.3	0.280575539568345	65	44	28.1	0	668	474	42	106	MEE2993648.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	195	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27696107	27696107	PRJNA986481_P_NODE_2384_length_949_cov_1.985556_g2066_i0	PRJNA986481	2384	949	1.985556	18.84292644	Bacteria	2	Bacteria	Bacteria	60.8	3.02e-6	NR	MFO7587283.1	2026742	g2066	i0	34.9	1.40674394099052	109	61	34.5	1	566	240	307	405	MFO7587283.1 trypsin-like peptidase domain-containing protein [Gemmatimonadota bacterium]	diamond	1335	60.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28263949	28263949	PRJNA986481_P_NODE_57006_length_244_cov_2.410256_g56481_i0	PRJNA986481	57006	244	2.410256	5.88102464	FCB group	1783270	Bacteria	Bacteria	101	4.0699999999999996e-23	NR	HEX4935280.1	2026741	g56481	i0	61.3	8.64344262295082	80	29	98.4	1	244	5	329	406	HEX4935280.1 aminomethyltransferase family protein [Gemmatimonadaceae bacterium]	diamond	2109	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28447778	28447778	PRJNA986481_P_NODE_2546_length_924_cov_5.723429_g2218_i0	PRJNA986481	2546	924	5.723429	52.88448396	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	599	1.9299999999999996e-208	NR	HET8769962.1	2026741	g2218	i0	99	0.970779220779221	299	3	97.1	0	20	916	500	798	HET8769962.1 TonB-dependent receptor [Gemmatimonadaceae bacterium]	diamond	897	599	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29741865	29741865	PRJNA986481_P_NODE_11290_length_488_cov_2.332574_g10767_i0	PRJNA986481	11290	488	2.332574	11.38296112	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	234	8.049999999999999e-72	NR	HET8770858.1	2026741	g10767	i0	88.7	0.817622950819672	133	15	81.8	0	78	476	1	133	HET8770858.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	399	234	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29805260	29805260	PRJNA986481_P_NODE_57871_length_243_cov_2.711340_g57346_i0	PRJNA986481	57871	243	2.71134	6.5885562	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	104	5.91e-24	NR	HET8769788.1	2026741	g57346	i0	98.1	0.654320987654321	53	1	65.4	0	85	243	1	53	HET8769788.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium]	diamond	159	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30026532	30026532	PRJNA986481_P_NODE_36351_length_270_cov_2.683258_g35826_i0	PRJNA986481	36351	270	2.683258	7.2447966	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	163	1.53e-44	NR	HET8771594.1	2026741	g35826	i0	95.2	0.933333333333333	84	4	93.3	0	270	19	11	94	HET8771594.1 M14 family metallopeptidase [Gemmatimonadaceae bacterium]	diamond	252	163	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30215847	30215847	PRJNA986481_P_NODE_8772_length_550_cov_1.762475_g8260_i0	PRJNA986481	8772	550	1.762475	9.6936125	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	65.5	9.27e-9	NR	MBM3907237.1	2026742	g8260	i0	49.2	0.643636363636364	59	30	32.2	0	3	179	485	543	MBM3907237.1 NAD-dependent malic enzyme [Gemmatimonadota bacterium]	diamond	354	65.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30437402	30437402	PRJNA986481_P_NODE_13653_length_444_cov_1.336709_g13129_i0	PRJNA986481	13653	444	1.336709	5.93498796	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	179	1.2e-50	NR	MDR0787118.1	2026742	g13129	i0	58.3	0.939189189189189	139	58	93.9	0	3	419	316	454	MDR0787118.1 polysaccharide deacetylase family protein [Gemmatimonadota bacterium]	diamond	417	179	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30721413	30721413	PRJNA986481_P_NODE_60974_length_238_cov_2.211640_g60449_i0	PRJNA986481	60974	238	2.21164	5.2637032	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	77	1.3e-15	NR	NNF38801.1	2026742	g60449	i0	50.7	7.46218487394958	75	33	94.5	2	3	227	55	125	NNF38801.1 NAD(P)-binding protein [Gemmatimonadota bacterium]	diamond	1776	77	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31005835	31005835	PRJNA986481_P_NODE_13974_length_438_cov_6.784062_g13450_i0	PRJNA986481	13974	438	6.784062	29.71419156	Longimicrobium sp.	2029185	Bacteria	Bacteria	80.5	2.36e-15	NR	HEX2080112.1	2029185	g13450	i0	40	0.753424657534247	110	62	74	2	2	325	101	208	HEX2080112.1 hypothetical protein [Longimicrobium sp.]	diamond	330	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31827830	31827830	PRJNA986481_P_NODE_14517_length_430_cov_5.950131_g13992_i0	PRJNA986481	14517	430	5.950131	25.5855633	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	254	3.36e-78	NR	HET8771312.1	2026741	g13992	i0	93.2	0.927906976744186	133	6	90.7	1	408	19	286	418	HET8771312.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	399	254	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31827840	31827840	PRJNA986481_P_NODE_28777_length_305_cov_8.117188_g28252_i0	PRJNA986481	28777	305	8.117188	24.7574234	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	170	1.1699999999999999e-46	NR	HET8771344.1	2026741	g28252	i0	98.8	0.836065573770492	85	1	83.6	0	17	271	1421	1505	HET8771344.1 translocation/assembly module TamB domain-containing protein [Gemmatimonadaceae bacterium]	diamond	255	170	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;