metadata: contig_metadata: 13 rows where bioproject = "PRJNA773247", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA773247", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"

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
27568273	27568273	PRJNA773247_P_NODE_35744_length_234_cov_2.664596_g35660_i0	PRJNA773247	35744	234	2.664596	6.23515464	Pseudomonadati	3379134	Bacteria	Bacteria	100	1.34e-23	NR	KMQ49676.1	1008392	g35660	i0	61.1	4.48717948717949	72	28	92.3	0	1	216	112	183	KMQ49676.1 putative hemolysin [Chitinispirillum alkaliphilum]	diamond	1050	101	0.99009900990099	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae	Chitinispirillum	Chitinispirillum alkaliphilum
27717150	27717150	PRJNA773247_P_NODE_29544_length_254_cov_1.872928_g29460_i0	PRJNA773247	29544	254	1.872928	4.75723712	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	112	1.97e-29	NR	HNY31751.1	2725311	g29460	i0	88.5	0.720472440944882	61	7	72	0	183	1	1	61	HNY31751.1 hypothetical protein [Fibrobacteria bacterium]	diamond	183	112	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
29169265	29169265	PRJNA773247_P_NODE_12909_length_422_cov_14.452722_g12826_i0	PRJNA773247	12909	422	14.452722	60.99048684	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	49.7	8.97e-4	NR	MBK9580293.1	2052160	g12826	i0	55.8	0.305687203791469	43	17	30.6	1	91	219	1	41	MBK9580293.1 hypothetical protein [Fibrobacterota bacterium]	diamond	129	49.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29232416	29232416	PRJNA773247_P_NODE_6469_length_670_cov_80.268007_g6387_i0	PRJNA773247	6469	670	80.268007	537.7956469	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	196	3.2700000000000004e-58	NR	MBK9580285.1	2052160	g6387	i0	65.8	0.680597014925373	152	51	68.1	1	661	206	146	296	MBK9580285.1 hypothetical protein [Fibrobacterota bacterium]	diamond	456	196	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29705443	29705443	PRJNA773247_P_NODE_13910_length_402_cov_9.522796_g13826_i0	PRJNA773247	13910	402	9.522796	38.28163992	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	49.3	0.00101	NR	MBK9580293.1	2052160	g13826	i0	55.8	0.32089552238806	43	17	32.1	1	83	211	1	41	MBK9580293.1 hypothetical protein [Fibrobacterota bacterium]	diamond	129	49.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29705482	29705482	PRJNA773247_P_NODE_8830_length_540_cov_1.689507_g8747_i0	PRJNA773247	8830	540	1.689507	9.1233378	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	174	5.2e-51	NR	MBK9580292.1	2052160	g8747	i0	56.9	0.85	153	65	85	1	462	4	1	152	MBK9580292.1 hypothetical protein [Fibrobacterota bacterium]	diamond	459	174	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30369730	30369730	PRJNA773247_P_NODE_13852_length_403_cov_5.542424_g13768_i0	PRJNA773247	13852	403	5.542424	22.33596872	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	95.9	1.57e-22	NR	MBK9580313.1	2052160	g13768	i0	46.5	0.73697270471464	99	53	73.7	0	6	302	24	122	MBK9580313.1 DUF1064 domain-containing protein [Fibrobacterota bacterium]	diamond	297	95.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30811566	30811566	PRJNA773247_P_NODE_22014_length_302_cov_8.628821_g21930_i0	PRJNA773247	22014	302	8.628821	26.05903942	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	85.9	5.32e-17	NR	HNY31724.1	2725311	g21930	i0	48.4	1.82781456953642	93	48	92.4	0	9	287	340	432	HNY31724.1 hypothetical protein [Fibrobacteria bacterium]	diamond	552	85.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
31421690	31421690	PRJNA773247_P_NODE_34136_length_242_cov_3.857988_g34052_i0	PRJNA773247	34136	242	3.857988	9.33633096	FCB group	1783270	Bacteria	Bacteria	44.7	0.00177	NR	WP_407457157.1	35828	g34052	i0	39.7	1.7603305785124	73	44	90.5	0	8	226	24	96	WP_407457157.1 helix-turn-helix domain-containing protein, partial [Fibrobacter sp.]	diamond	426	44.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
31854904	31854904	PRJNA773247_P_NODE_20777_length_313_cov_7.708333_g20693_i0	PRJNA773247	20777	313	7.708333	24.12708229	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	123	6.08e-32	NR	MBK9580285.1	2052160	g20693	i0	67.4	0.910543130990415	95	31	91.1	0	300	16	53	147	MBK9580285.1 hypothetical protein [Fibrobacterota bacterium]	diamond	285	123	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
31896097	31896097	PRJNA773247_P_NODE_35237_length_239_cov_2.493976_g35153_i0	PRJNA773247	35237	239	2.493976	5.96060264	Bacteria	2	Bacteria	Bacteria	102	2.9099999999999996e-23	NR	MEK7391014.1	2052160	g35153	i0	65.3	2.83682008368201	75	26	94.1	0	233	9	447	521	MEK7391014.1 glycosyltransferase [Fibrobacterota bacterium]	diamond	678	102	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32298305	32298305	PRJNA773247_P_NODE_26779_length_269_cov_2.892857_g26695_i0	PRJNA773247	26779	269	2.892857	7.78178533	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	120	3.1999999999999996e-32	NR	HNY31751.1	2725311	g26695	i0	72.7	0.858736059479554	77	21	85.9	0	231	1	1	77	HNY31751.1 hypothetical protein [Fibrobacteria bacterium]	diamond	231	120	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
32424520	32424520	PRJNA773247_P_NODE_16839_length_356_cov_5.992933_g16755_i0	PRJNA773247	16839	356	5.992933	21.33484148	uncultured Fibrobacter sp.	261512	Bacteria	Bacteria	80.5	7.33e-15	NR	WP_295055254.1	261512	g16755	i0	46.2	0.893258426966292	106	55	89.3	1	23	340	29	132	WP_295055254.1 baseplate J/gp47 family protein [uncultured Fibrobacter sp.]	diamond	318	80.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	uncultured Fibrobacter 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);;