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

15 rows where bioproject = "PRJNA1002816" 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
152758	152758	PRJNA1002816_P_NODE_10921_length_337_cov_0.882576_g10761_i0	PRJNA1002816	10921	337	0.882576	2.97428112	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	514	3.37e-141	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g10761	i0	94.118	310.727002967359	340	17	100	2	1	337	361028	360689	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	104715	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
6531049	6531049	PRJNA1002816_P_NODE_17886_length_250_cov_0.870056_g17726_i0	PRJNA1002816	17886	250	0.870056	2.17514	uncultured Macellibacteroides sp.	1243007	Bacteria	Bacteria	176	1.2899999999999999e-39	NTclustered	gi\|2621704019\|emb\|OY762974.1\|	1243007	g17726	i0	79.675	1.92	246	48	98	2	4	248	1595622	1595378	MAG: uncultured Macellibacteroides sp. isolate 8f74f0af-0976-4f32-9dab-69c3ce622fc1 genome assembly, chromosome: 1	blastn	480	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Macellibacteroides	uncultured Macellibacteroides sp.
18852621	18852621	PRJNA1002816_P_NODE_7595_length_410_cov_1.370920_g7435_i0	PRJNA1002816	7595	410	1.37092	5.620772	Aquirufa	2676247	Bacteria	Bacteria	532	1.15e-146	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g7435	i0	91.371	435.639024390244	394	26	96	6	19	410	360118	359731	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	178612	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
21829561	21829561	PRJNA1002816_P_NODE_10698_length_341_cov_0.985075_g10538_i0	PRJNA1002816	10698	341	0.985075	3.35910575	Bacteria	2	Bacteria	Bacteria	199	3.57e-59	NR	MBN2729061.1	2030927	g10538	i0	82.3	24.7741935483871	113	20	99.4	0	339	1	303	415	MBN2729061.1 NADP-dependent malic enzyme [Bacteroidales bacterium]	diamond	8448	199	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
24378886	24378886	PRJNA1002816_P_NODE_18940_length_247_cov_0.885057_g18780_i0	PRJNA1002816	18940	247	0.885057	2.18609079	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g18780	i0	92.544	362.481781376518	228	15	92	2	21	247	3670	3444	Dyadobacter pollutisoli strain U1 chromosome	blastn	89533	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
24378957	24378957	PRJNA1002816_P_NODE_3520_length_606_cov_1.994371_g3362_i0	PRJNA1002816	3520	606	1.994371	12.08588826	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	920	0	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g3362	i0	94.108	281.42904290429	611	26	100	10	1	606	339346	338741	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	170546	920	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
27065937	27065937	PRJNA1002816_P_NODE_16322_length_265_cov_1.005208_g16162_i0	PRJNA1002816	16322	265	1.005208	2.6638012	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	61.6	3.35e-10	NR	MFM7855049.1	2026740	g16162	i0	87.9	0.373584905660377	33	4	37.4	0	189	91	31	63	MFM7855049.1 epiplasmin family protein [Flammeovirgaceae bacterium]	diamond	99	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
27571578	27571578	PRJNA1002816_P_NODE_20124_length_243_cov_0.905882_g19964_i0	PRJNA1002816	20124	243	0.905882	2.20129326	Tidjanibacter sp.	1929085	Bacteria	Bacteria	43.5	0.0194	NR	MBR4850700.1	1929085	g19964	i0	32.7	0.679012345679012	55	37	67.9	0	193	29	406	460	MBR4850700.1 C10 family peptidase [Tidjanibacter sp.]	diamond	165	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Tidjanibacter	Tidjanibacter sp.
27785385	27785385	PRJNA1002816_P_NODE_14564_length_286_cov_1.117371_g14404_i0	PRJNA1002816	14564	286	1.117371	3.19568106	Bacteria	2	Bacteria	Bacteria	102	1.48e-23	NR	MDP4205870.1	1898104	g14404	i0	51.6	2.96853146853147	95	46	99.7	0	286	2	76	170	MDP4205870.1 ADP-forming succinate--CoA ligase subunit beta [Bacteroidota bacterium]	diamond	849	103	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29395463	29395463	PRJNA1002816_P_NODE_18209_length_249_cov_0.875000_g18049_i0	PRJNA1002816	18209	249	0.875	2.17875	FCB group	1783270	Bacteria	Bacteria	129	1.47e-32	NR	WP_091510171.1	998	g18049	i0	78.2	29.2771084337349	78	17	94	0	234	1	596	673	WP_091510171.1 aminomethyl-transferring glycine dehydrogenase [Flexibacter flexilis]	diamond	7290	130	0.992307692307692	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flexibacteraceae	Flexibacter	Flexibacter flexilis
30160591	30160591	PRJNA1002816_P_NODE_19452_length_245_cov_0.895349_g19292_i0	PRJNA1002816	19452	245	0.895349	2.19360505	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42.7	0.0273	NR	MEE0429485.1	2030927	g19292	i0	41.7	0.587755102040816	48	28	58.8	0	145	2	30	77	MEE0429485.1 lysophospholipid acyltransferase family protein [Bacteroidales bacterium]	diamond	144	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31424840	31424840	PRJNA1002816_P_NODE_15756_length_272_cov_0.914573_g15596_i0	PRJNA1002816	15756	272	0.914573	2.48763856	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	167	1.09e-51	NR	MDD2984732.1	2026728	g15596	i0	94.9	0.871323529411765	79	4	87.1	0	3	239	1	79	MDD2984732.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	237	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
32405691	32405691	PRJNA1002816_P_NODE_14179_length_290_cov_1.336406_g14019_i0	PRJNA1002816	14179	290	1.336406	3.8755774	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	172	6.79e-52	NR	MDD2984733.1	2026728	g14019	i0	93.8	0.993103448275862	96	5	99.3	1	2	289	89	183	MDD2984733.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	288	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
32626685	32626685	PRJNA1002816_P_NODE_19420_length_245_cov_1.093023_g19260_i0	PRJNA1002816	19420	245	1.093023	2.67790635	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.028	NR	RLD79385.1	1898104	g19260	i0	34.8	0.808163265306122	66	40	80.8	1	243	46	552	614	RLD79385.1 MAG: RNA-binding transcriptional accessory protein [Bacteroidota bacterium]	diamond	198	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32689658	32689658	PRJNA1002816_P_NODE_18740_length_247_cov_1.701149_g18580_i0	PRJNA1002816	18740	247	1.701149	4.20183803	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	80.9	3.63e-16	NR	HON18569.1	2053305	g18580	i0	46.9	1.54251012145749	64	34	77.7	0	194	3	1	64	HON18569.1 purine-nucleoside phosphorylase [Salinivirgaceae bacterium]	diamond	381	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae 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);;