metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

24 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
1401397	1401397	PRJEB64798_P_NODE_136062_length_195_cov_6.657534_g134296_i0	PRJEB64798	136062	195	6.657534	12.9821913	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	327	2.5e-85	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g134296	i0	97.409	87.9128205128205	193	4	98	1	1	192	1596482	1596290	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	17143	327	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
1401725	1401725	PRJEB64798_P_NODE_157422_length_184_cov_25.059259_g155656_i0	PRJEB64798	157422	184	25.059259	46.10903656	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	228	2.4299999999999996e-55	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g155656	i0	92.5	1.3695652173913	160	11	87	1	21	180	2981916	2981758	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	252	228	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
3952549	3952549	PRJEB64798_P_NODE_10764_length_609_cov_31.755357_g1104_i2	PRJEB64798	10764	609	31.755357	193.39012413	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	658	0	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g1104	i2	86.978	377.129720853859	599	61	97	14	1	591	2061220	2061809	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	229672	658	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
5232155	5232155	PRJEB64798_P_NODE_79305_length_216_cov_2.281437_g77539_i0	PRJEB64798	79305	216	2.281437	4.92790392	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	176	1.08e-39	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g77539	i0	88.079	330.236111111111	151	15	69	2	32	181	1595708	1595560	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	71331	176	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
6506918	6506918	PRJEB64798_P_NODE_31586_length_350_cov_8.704319_g29829_i0	PRJEB64798	31586	350	8.704319	30.4651165	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	363	1.3399999999999999e-95	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g29829	i0	85.797	80.6714285714286	345	45	98	4	1	344	2982413	2982072	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	28235	363	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
6507426	6507426	PRJEB64798_P_NODE_56946_length_258_cov_7.923445_g55181_i0	PRJEB64798	56946	258	7.923445	20.4424881	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	396	9.419999999999995e-106	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g55181	i0	94.862	133.693798449612	253	13	98	0	2	254	2061744	2061492	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	34493	396	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
7781436	7781436	PRJEB64798_P_NODE_4787_length_884_cov_182.886228_g1104_i1	PRJEB64798	4787	884	182.886228	1616.71425552	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	992	0	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g1104	i1	87.543	178.951357466063	875	88	98	17	19	884	2982570	2981708	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	158193	992	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
12880145	12880145	PRJEB64798_P_NODE_114571_length_209_cov_3.487500_g112805_i0	PRJEB64798	114571	209	3.4875	7.288875	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	202	1.7199999999999998e-47	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g112805	i0	84.951	215.358851674641	206	24	98	7	6	209	2981925	2981725	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	45010	202	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
12880292	12880292	PRJEB64798_P_NODE_123871_length_203_cov_5.000000_g122105_i0	PRJEB64798	123871	203	5	10.15	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	257	3.49e-64	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g122105	i0	92.265	221.758620689655	181	14	91	0	10	190	2062584	2062764	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	45017	257	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
14156073	14156073	PRJEB64798_P_NODE_187052_length_171_cov_7.622951_g185286_i0	PRJEB64798	187052	171	7.622951	13.03524621	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	237	3.68e-58	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g185286	i0	91.813	8.29824561403509	171	12	99	2	2	171	2061513	2061344	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	1419	237	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
14156497	14156497	PRJEB64798_P_NODE_215412_length_163_cov_4.157895_g213646_i0	PRJEB64798	215412	163	4.157895	6.77736885	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	185	1.28e-42	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g213646	i0	87.975	0.969325153374233	158	17	96	2	1	157	2061503	2061347	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	158	185	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
14156825	14156825	PRJEB64798_P_NODE_240212_length_155_cov_3.424528_g238446_i0	PRJEB64798	240212	155	3.424528	5.3080184	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	147	5.679999999999999e-31	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g238446	i0	88.618	6.25806451612903	123	11	79	3	3	124	1595675	1595555	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	970	147	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
15431100	15431100	PRJEB64798_P_NODE_29173_length_364_cov_9.853968_g27417_i0	PRJEB64798	29173	364	9.853968	35.86844352	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	492	1.72e-134	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g27417	i0	91.436	83.1510989010989	362	26	99	5	2	360	2981093	2980734	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	30267	492	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
19254244	19254244	PRJEB64798_P_NODE_27796_length_373_cov_9.577160_g26041_i0	PRJEB64798	27796	373	9.57716	35.7228068	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	394	5.12e-105	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g26041	i0	88.253	205.887399463807	332	35	88	4	39	368	1595536	1595865	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	76796	394	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
20119712	20119712	PRJEB64798_P_NODE_203556_length_166_cov_5.991453_g201790_i0	PRJEB64798	203556	166	5.991453	9.94581198	Fibrobacter	832	Bacteria	Bacteria	80.5	6.38e-11	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g201790	i0	83.146	5.89759036144578	89	14	54	1	1	89	1652	1565	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	979	80.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
20527513	20527513	PRJEB64798_P_NODE_116537_length_208_cov_4.861635_g114771_i0	PRJEB64798	116537	208	4.861635	10.1122008	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	209	1.02e-49	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g114771	i0	85.572	141.0625	201	27	96	2	9	208	1594879	1595078	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	29341	209	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
20528047	20528047	PRJEB64798_P_NODE_15037_length_514_cov_7.806452_g13359_i0	PRJEB64798	15037	514	7.806452	40.12516328	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	523	8.869999999999998e-144	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g13359	i0	84.99	229.196498054475	513	64	98	12	3	508	1594451	1593945	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	117807	523	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
20529953	20529953	PRJEB64798_P_NODE_46417_length_288_cov_6.037657_g44652_i0	PRJEB64798	46417	288	6.037657	17.38845216	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	283	8.679999999999999e-72	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g44652	i0	84.642	1.01736111111111	293	36	99	8	2	288	1595380	1595669	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	293	283	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
21803683	21803683	PRJEB64798_P_NODE_140978_length_193_cov_2.486111_g139212_i0	PRJEB64798	140978	193	2.486111	4.79819423	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	302	1.5e-77	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g139212	i0	94.845	10.6010362694301	194	9	100	1	1	193	2060992	2061185	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	2046	302	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
21803880	21803880	PRJEB64798_P_NODE_153938_length_186_cov_6.759124_g152172_i0	PRJEB64798	153938	186	6.759124	12.57197064	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	143	9.17e-30	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g152172	i0	87.302	173.354838709677	126	14	67	2	30	154	2980769	2980893	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	32244	143	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
21805881	21805881	PRJEB64798_P_NODE_51918_length_271_cov_37.400901_g50153_i0	PRJEB64798	51918	271	37.400901	101.35644171	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	337	6.129999999999998e-88	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g50153	i0	89.007	336.055350553506	282	17	99	4	1	268	2062761	2062480	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	91071	337	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
24354280	24354280	PRJEB64798_P_NODE_24380_length_399_cov_7.922857_g22632_i0	PRJEB64798	24380	399	7.922857	31.61219943	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	584	3.0499999999999987e-162	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g22632	i0	93.451	170.83709273183	397	21	98	5	6	397	1596391	1595995	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	68164	584	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
24354511	24354511	PRJEB64798_P_NODE_29480_length_362_cov_10.680511_g27724_i0	PRJEB64798	29480	362	10.680511	38.66344982	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	375	1.79e-99	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g27724	i0	86.08	268.524861878453	352	45	97	4	10	359	1595420	1595071	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	97206	375	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
24355244	24355244	PRJEB64798_P_NODE_68740_length_233_cov_14.652174_g66975_i0	PRJEB64798	68740	233	14.652174	34.13956542	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	300	6.74e-77	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g66975	i0	95.699	187.497854077253	186	8	98	0	43	228	2062085	2061900	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	43687	300	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota 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);;