metadata: contig_metadata: 12 rows where bioproject = "PRJNA1120060" and tax

12 rows where bioproject = "PRJNA1120060" 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
9202186	9202186	PRJNA1120060_P_NODE_986568_length_312_cov_2.707113_g968639_i0	PRJNA1120060	986568	312	2.707113	8.44619256	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g968639	i0	100	0.0897435897435897	28	0	9	0	96	123	191355	191382	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
19380764	19380764	PRJNA1120060_P_NODE_2706556_length_248_cov_2.234286_g2688473_i0	PRJNA1120060	2706556	248	2.234286	5.54102928	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	104	6.11e-18	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g2688473	i0	88.372	0.346774193548387	86	10	35	0	143	228	1225841	1225756	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	86	104	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
27764832	27764832	PRJNA1120060_P_NODE_3437424_length_212_cov_6.748201_g3419299_i0	PRJNA1120060	3437424	212	6.748201	14.30618612	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	42	0.047	NR	MCB9497172.1	2725311	g3419299	i0	30.1	1.03301886792453	73	45	94.8	2	208	8	489	561	MCB9497172.1 endo-1,4-beta-xylanase [Fibrobacteria bacterium]	diamond	219	42	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
27984483	27984483	PRJNA1120060_P_NODE_1744545_length_283_cov_1.957143_g1726537_i0	PRJNA1120060	1744545	283	1.957143	5.53871469	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	48.1	7.91e-4	NR	MDB5050490.1	2052160	g1726537	i0	41.3	0.667844522968198	63	36	66.8	1	226	38	14	75	MDB5050490.1 Ig domain protein group 1 domain protein [Fibrobacterota bacterium]	diamond	189	48.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29184534	29184534	PRJNA1120060_P_NODE_1757089_length_282_cov_4.679426_g1739078_i0	PRJNA1120060	1757089	282	4.679426	13.19598132	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	43.5	0.0314	NR	HSQ42780.1	2652288	g1739078	i0	32.4	0.787234042553192	74	43	71.3	2	240	40	5	78	HSQ42780.1 hypothetical protein [Fibrobacteraceae bacterium]	diamond	222	43.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae		Fibrobacteraceae bacterium
29720729	29720729	PRJNA1120060_P_NODE_1553630_length_291_cov_1.697248_g1535639_i0	PRJNA1120060	1553630	291	1.697248	4.93899168	Fibrobacter succinogenes	833	Bacteria	Bacteria	40.8	0.0466	NR	WP_205428155.1	833	g1535639	i0	35.8	0.54639175257732	53	30	50.5	2	133	279	19	71	WP_205428155.1 hypothetical protein, partial [Fibrobacter succinogenes]	diamond	159	40.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
29880269	29880269	PRJNA1120060_P_NODE_3369611_length_219_cov_5.671233_g3351493_i0	PRJNA1120060	3369611	219	5.671233	12.42000027	Fibrobacter sp.	35828	Bacteria	Bacteria	42.7	0.0274	NR	NLG39608.1	35828	g3351493	i0	36.7	0.671232876712329	49	27	67.1	1	157	11	546	590	NLG39608.1 hypothetical protein [Fibrobacter sp.]	diamond	147	42.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
30291259	30291259	PRJNA1120060_P_NODE_3551312_length_202_cov_7.968992_g3533185_i0	PRJNA1120060	3551312	202	7.968992	16.09736384	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	41.6	0.0296	NR	HAJ80152.1	2052160	g3533185	i0	40.5	0.623762376237624	42	25	62.4	0	30	155	97	138	HAJ80152.1 hypothetical protein [Fibrobacterota bacterium]	diamond	126	41.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
31048091	31048091	PRJNA1120060_P_NODE_1448935_length_296_cov_1.049327_g1430951_i0	PRJNA1120060	1448935	296	1.049327	3.10600792	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	47.4	0.00153	NR	MBN1981350.1	2663014	g1430951	i0	33.7	0.902027027027027	89	53	84.1	1	256	8	11	99	MBN1981350.1 hypothetical protein [Chitinivibrionales bacterium]	diamond	267	47.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
31428782	31428782	PRJNA1120060_P_NODE_872556_length_313_cov_2.345833_g854632_i0	PRJNA1120060	872556	313	2.345833	7.34245729	Fibrobacteres bacterium CG2_3	1805149	Bacteria	Bacteria	46.6	0.00371	NR	OIP51258.1	1805149	g854632	i0	46.2	0.373801916932907	39	21	37.4	0	200	84	561	599	OIP51258.1 MAG: hypothetical protein AUK31_04450 [Fibrobacteres bacterium CG2_30_45_31]	diamond	117	46.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacteres bacterium CG2_30_45_31
31680004	31680004	PRJNA1120060_P_NODE_1307957_length_306_cov_2.021459_g1290005_i0	PRJNA1120060	1307957	306	2.021459	6.18566454	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	43.9	0.0295	NR	MDD5673408.1	2663014	g1290005	i0	35.9	0.627450980392157	64	33	57.8	3	67	243	48	108	MDD5673408.1 glycosyltransferase family 87 protein [Chitinivibrionales bacterium]	diamond	192	43.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
32503335	32503335	PRJNA1120060_P_NODE_1882559_length_277_cov_3.294118_g1864540_i0	PRJNA1120060	1882559	277	3.294118	9.12470686	Fibrobacterales bacterium	2478481	Bacteria	Bacteria	43.5	0.0269	NR	GHV13833.1	2478481	g1864540	i0	40	0.487364620938628	45	27	48.7	0	273	139	191	235	GHV13833.1 hypothetical protein AGMMS49938_08970 [Fibrobacterales bacterium]	diamond	135	43.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales			Fibrobacterales 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);;