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

15 rows where bioproject = "PRJNA685060" and tax_clade = "FCB group"

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
13930041	13930041	PRJNA685060_P_NODE_6711_length_368_cov_1.044068_g6621_i0	PRJNA685060	6711	368	1.044068	3.84217024	Paludibacter	346096	Bacteria	Bacteria	158	7.2e-34	NTclustered	gi\|470487156\|ref\|NR_076804.1\|	185300	g6621	i0	84.906	7.28804347826087	159	20	43	4	211	367	869	713	Paludibacter propionicigenes strain WB4 23S ribosomal RNA gene, complete sequence	blastn	2682	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
15968840	15968840	PRJNA685060_P_NODE_15973_length_245_cov_0.895349_g15883_i0	PRJNA685060	15973	245	0.895349	2.19360505	Adhaeribacter swui	2086471	Bacteria	Bacteria	281	2.59e-71	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g15883	i0	87.449	1.00816326530612	247	27	100	4	1	245	1706545	1706301	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	247	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
19793103	19793103	PRJNA685060_P_NODE_15456_length_246_cov_0.890173_g15366_i0	PRJNA685060	15456	246	0.890173	2.18982558	Hymenobacter sublimis	2933777	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|2230260579\|gb\|CP095848.1\|	2933777	g15366	i0	89.431	4.45934959349593	246	26	100	0	1	246	3535683	3535928	Hymenobacter sublimis strain 5516 S-25 chromosome, complete genome	blastn	1097	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sublimis
21578255	21578255	PRJNA685060_P_NODE_15597_length_246_cov_0.890173_g15507_i0	PRJNA685060	15597	246	0.890173	2.18982558	Flavobacterium	237	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|1145600863\|gb\|KX832991.2\|	239	g15507	i0	98.374	99.5650406504065	246	4	100	0	1	246	492	737	Flavobacterium sp. strain 2PKS3051 16S ribosomal RNA gene, partial sequence	blastn	24493	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
23618995	23618995	PRJNA685060_P_NODE_13499_length_251_cov_0.865169_g13409_i0	PRJNA685060	13499	251	0.865169	2.17157419	Chryseobacterium shandongense	1493872	Bacteria	Bacteria	222	1.64e-53	NTclustered	gi\|1519499628\|gb\|CP033914.1\|	1493872	g13409	i0	84.322	2.8207171314741	236	28	91	6	23	251	1633660	1633427	Chryseobacterium shandongense strain G0239 chromosome, complete genome	blastn	708	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium shandongense
24128047	24128047	PRJNA685060_P_NODE_9339_length_310_cov_1.729958_g9249_i0	PRJNA685060	9339	310	1.729958	5.3628698	Haliscomenobacter	2349	Bacteria	Bacteria	379	1.17e-100	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g9249	i0	88.782	415.896774193548	312	31	100	4	1	310	345	654	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	128928	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
27366962	27366962	PRJNA685060_P_NODE_543_length_1223_cov_3.296522_g500_i0	PRJNA685060	543	1223	3.296522	40.31646406	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	49.3	0.0174	NR	MEE2753403.1	2053570	g500	i0	34.8	0.218315617334424	89	53	21.1	3	86	343	72	158	MEE2753403.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	267	49.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
27410111	27410111	PRJNA685060_P_NODE_5783_length_400_cov_0.941896_g5693_i0	PRJNA685060	5783	400	0.941896	3.767584	Bacteria	2	Bacteria	Bacteria	45.8	0.00421	NR	MBC7826799.1	1869212	g5693	i0	30.8	6.3825	91	47	56.3	2	83	307	15	105	MBC7826799.1 SET domain-containing protein-lysine N-methyltransferase [Chitinophagaceae bacterium]	diamond	2553	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27871833	27871833	PRJNA685060_P_NODE_13265_length_251_cov_1.730337_g13175_i0	PRJNA685060	13265	251	1.730337	4.34314587	Altibacter sp.	2024823	Bacteria	Bacteria	42.4	0.0438	NR	WP_290785504.1	2024823	g13175	i0	41.2	0.609561752988048	51	29	59.8	1	78	227	19	69	WP_290785504.1 IMPACT family protein [Altibacter sp.]	diamond	153	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Altibacter	Altibacter sp.
28483451	28483451	PRJNA685060_P_NODE_9306_length_311_cov_1.033613_g9216_i0	PRJNA685060	9306	311	1.033613	3.21453643	Pseudomonadati	3379134	Bacteria	Bacteria	99.8	1.86e-22	NR	BCX00657.1	1898104	g9216	i0	49.5	2.60450160771704	91	41	83	1	310	53	252	342	BCX00657.1 MAG: hypothetical protein KatS3mg041_0703 [Bacteroidota bacterium]	diamond	810	100	0.998	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28913577	28913577	PRJNA685060_P_NODE_15108_length_247_cov_0.885057_g15018_i0	PRJNA685060	15108	247	0.885057	2.18609079	Pedobacter aquatilis	351343	Bacteria	Bacteria	84	1.11e-16	NR	WP_316739711.1	351343	g15018	i0	87.8	0.497975708502024	41	5	49.8	0	3	125	456	496	WP_316739711.1 RagB/SusD family nutrient uptake outer membrane protein [Pedobacter aquatilis]	diamond	123	84	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter aquatilis
31030321	31030321	PRJNA685060_P_NODE_13655_length_250_cov_2.372881_g13565_i0	PRJNA685060	13655	250	2.372881	5.9322025	Chitinophagales bacterium	2448779	Bacteria	Bacteria	45.1	0.00484	NR	MFK7907468.1	2448779	g13565	i0	45.7	1.296	46	20	55.2	1	25	162	26	66	MFK7907468.1 calcium-binding EGF-like domain-containing protein [Chitinophagales bacterium]	diamond	324	45.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
31219303	31219303	PRJNA685060_P_NODE_17135_length_242_cov_0.911243_g17045_i0	PRJNA685060	17135	242	0.911243	2.20520806	Bacteroidales bacterium	2030927	Bacteria	Bacteria	57	3.22e-7	NR	HPT10631.1	2030927	g17045	i0	45	0.743801652892562	60	28	73.1	2	235	59	190	245	HPT10631.1 NAD-dependent epimerase/dehydratase family protein [Bacteroidales bacterium]	diamond	180	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32042135	32042135	PRJNA685060_P_NODE_8418_length_327_cov_2.641732_g8328_i0	PRJNA685060	8418	327	2.641732	8.63846364	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	44.3	0.0292	NR	HET9055784.1	1869212	g8328	i0	32.4	0.678899082568807	74	48	67	2	93	311	398	470	HET9055784.1 alpha-2-macroglobulin family protein [Chitinophagaceae bacterium]	diamond	222	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32674179	32674179	PRJNA685060_P_NODE_13360_length_251_cov_0.865169_g13270_i0	PRJNA685060	13360	251	0.865169	2.17157419	Bacteroidota bacterium	1898104	Bacteria	Bacteria	116	1.4599999999999999e-31	NR	MFN7821604.1	1898104	g13270	i0	74.7	0.99203187250996006	83	21	99.2	0	1	249	15	97	MFN7821604.1 F0F1 ATP synthase subunit A [Bacteroidota bacterium]	diamond	249	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota 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);;