metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJEB6055" and tax

18 rows where analysis = "diamond", bioproject = "PRJEB6055" 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
5228097	5228097	PRJEB6055_S_NODE_3925_length_175_cov_1.207143_g3901_i0	PRJEB6055	3925	175	1.207143	2.11250025	Flectobacillus sp. BAB-3569	1509483	Bacteria	Bacteria	90.9	6.2500000000000006e-21	NR	WP_095160867.1	1509483	g3901	i0	100	0.805714285714286	47	0	80.6	0	175	35	156	202	WP_095160867.1 OmpH family outer membrane protein [Flectobacillus sp. BAB-3569]	diamond	141	90.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. BAB-3569
21802294	21802294	PRJEB6055_S_NODE_5598_length_154_cov_1.008403_g5574_i0	PRJEB6055	5598	154	1.008403	1.55294062	Bacteroidota	976	Bacteria	Bacteria	102	8.54e-26	NR	WP_229761431.1	563172	g5574	i0	95.7	25.987012987013	46	2	89.6	0	3	140	37	82	WP_229761431.1 RNA polymerase sigma factor [Ferruginibacter lapsinanis]	diamond	4002	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
24351380	24351380	PRJEB6055_S_NODE_460_length_342_cov_10780.716612_g436_i0	PRJEB6055	460	342	10780.716612	36870.05081304	Flectobacillaceae	3141701	Bacteria	Bacteria	146	6.5e-42	NR	WP_026995258.1	103	g436	i0	89.5	1.50877192982456	86	8	75.4	1	316	59	1	85	WP_026995258.1 translation initiation factor IF-3 [Flectobacillus major]	diamond	516	146	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus major
27216232	27216232	PRJEB6055_S_NODE_2742_length_197_cov_2.024691_g2718_i0	PRJEB6055	2742	197	2.024691	3.98864127	Flectobacillus	101	Bacteria	Bacteria	118	3.07e-33	NR	WP_166550197.1	976	g2718	i0	93.8	1.9492385786802	64	4	97.5	0	3	194	11	74	WP_166550197.1 MULTISPECIES: hypothetical protein [Bacteroidota]	diamond	384	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
28075821	28075821	PRJEB6055_S_NODE_3105_length_189_cov_3.032468_g3081_i0	PRJEB6055	3105	189	3.032468	5.73136452	unclassified Chryseobacterium	2593645	Bacteria	Bacteria	110	9.4e-30	NR	WP_336691114.1	2593645	g3081	i0	96.7	0.968253968253968	61	2	96.8	0	188	6	11	71	WP_336691114.1 MULTISPECIES: hypothetical protein [unclassified Chryseobacterium]	diamond	183	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium
28202037	28202037	PRJEB6055_S_NODE_3306_length_185_cov_1.333333_g3282_i0	PRJEB6055	3306	185	1.333333	2.46666605	Chryseobacterium mucoviscidosis	1945581	Bacteria	Bacteria	117	5.510000000000001e-29	NR	WP_336718543.1	1945581	g3282	i0	100	0.989189189189189	61	0	98.9	0	2	184	410	470	WP_336718543.1 reverse transcriptase domain-containing protein [Chryseobacterium mucoviscidosis]	diamond	183	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium mucoviscidosis
28707531	28707531	PRJEB6055_S_NODE_1147_length_262_cov_4.220264_g1123_i0	PRJEB6055	1147	262	4.220264	11.05709168	Danxiaibacter flavus	3049108	Bacteria	Bacteria	45.4	0.00176	NR	WP_369329180.1	3049108	g1123	i0	56.5	0.526717557251908	46	20	52.7	0	232	95	41	86	WP_369329180.1 Spy/CpxP family protein refolding chaperone [Danxiaibacter flavus]	diamond	138	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Danxiaibacter	Danxiaibacter flavus
28896743	28896743	PRJEB6055_S_NODE_5668_length_153_cov_2.169492_g5644_i0	PRJEB6055	5668	153	2.169492	3.31932276	Flectobacillus longus	2984207	Bacteria	Bacteria	88.2	4.77e-21	NR	WP_283325609.1	2984207	g5644	i0	100	0.980392156862745	50	0	98	0	152	3	5	54	WP_283325609.1 hypothetical protein [Flectobacillus longus]	diamond	150	88.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus longus
29149866	29149866	PRJEB6055_S_NODE_4129_length_172_cov_2.372263_g4105_i0	PRJEB6055	4129	172	2.372263	4.08029236	Chryseobacterium	59732	Bacteria	Bacteria	107	3.32e-25	NR	WP_116098686.1	59732	g4105	i0	100	0.976744186046512	56	0	97.7	0	1	168	1838	1893	WP_116098686.1 MULTISPECIES: toxin TcdB middle/N-terminal domain-containing protein [Chryseobacterium]	diamond	168	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium
29244232	29244232	PRJEB6055_S_NODE_2289_length_209_cov_2.005747_g2265_i0	PRJEB6055	2289	209	2.005747	4.19201123	Chryseobacterium sp. SL1	2995159	Bacteria	Bacteria	93.6	1.1e-22	NR	WP_268052142.1	2995159	g2265	i0	92	0.717703349282297	50	4	71.8	0	207	58	3	52	WP_268052142.1 hypothetical protein [Chryseobacterium sp. SL1]	diamond	150	93.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. SL1
29496765	29496765	PRJEB6055_S_NODE_3170_length_188_cov_1.705882_g3146_i0	PRJEB6055	3170	188	1.705882	3.20705816	Chryseobacterium ginsenosidimutans	687846	Bacteria	Bacteria	44.7	0.00374	NR	WP_259128526.1	687846	g3146	i0	80.6	0.574468085106383	36	7	57.4	0	1	108	314	349	WP_259128526.1 peptidoglycan DD-metalloendopeptidase family protein [Chryseobacterium ginsenosidimutans]	diamond	108	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium ginsenosidimutans
30128130	30128130	PRJEB6055_S_NODE_4792_length_163_cov_1.804688_g4768_i0	PRJEB6055	4792	163	1.804688	2.94164144	Chryseobacterium sp. SL1	2995159	Bacteria	Bacteria	65.9	3.06e-12	NR	WP_268027653.1	2995159	g4768	i0	80.4	0.846625766871166	46	9	84.7	0	150	13	1	46	WP_268027653.1 hypothetical protein [Chryseobacterium sp. SL1]	diamond	138	65.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. SL1
30633756	30633756	PRJEB6055_S_NODE_1993_length_219_cov_5.771739_g1969_i0	PRJEB6055	1993	219	5.771739	12.64010841	Bacteroidales bacterium	2030927	Bacteria	Bacteria	48.5	2.14e-5	NR	MDE7149459.1	2030927	g1969	i0	50	1.26027397260274	64	26	79.5	1	179	6	11	74	MDE7149459.1 hypothetical protein [Bacteroidales bacterium]	diamond	276	48.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30658734	30658734	PRJEB6055_S_NODE_3493_length_182_cov_1.755102_g3469_i0	PRJEB6055	3493	182	1.755102	3.19428564	Bacteroidota	976	Bacteria	Bacteria	56.6	5.14e-8	NR	WP_166552178.1	2683263	g3469	i0	100	1.33516483516484	27	0	44.5	0	181	101	6	32	WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP]	diamond	243	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
31708737	31708737	PRJEB6055_S_NODE_3377_length_184_cov_1.577181_g3353_i0	PRJEB6055	3377	184	1.577181	2.90201304	Pseudarcicella hirudinis	1079859	Bacteria	Bacteria	110	4.77e-29	NR	WP_092019860.1	1079859	g3353	i0	100	0.91304347826087	56	0	91.3	0	183	16	91	146	WP_092019860.1 LytR/AlgR family response regulator transcription factor [Pseudarcicella hirudinis]	diamond	168	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Pseudarcicella	Pseudarcicella hirudinis
31835067	31835067	PRJEB6055_S_NODE_5737_length_152_cov_2.615385_g5713_i0	PRJEB6055	5737	152	2.615385	3.9753852	Chryseobacterium mucoviscidosis	1945581	Bacteria	Bacteria	85.5	9.13e-18	NR	WP_336717408.1	1945581	g5713	i0	95.5	0.868421052631579	44	2	86.8	0	2	133	939	982	WP_336717408.1 leucine-rich repeat protein [Chryseobacterium mucoviscidosis]	diamond	132	85.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium mucoviscidosis
32088362	32088362	PRJEB6055_S_NODE_1998_length_219_cov_2.956522_g1974_i0	PRJEB6055	1998	219	2.956522	6.47478318	Chryseobacterium mucoviscidosis	1945581	Bacteria	Bacteria	125	1.41e-35	NR	WP_336715297.1	1945581	g1974	i0	100	0.780821917808219	57	0	78.1	0	49	219	1	57	WP_336715297.1 hypothetical protein [Chryseobacterium mucoviscidosis]	diamond	171	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium mucoviscidosis
32246921	32246921	PRJEB6055_S_NODE_4958_length_161_cov_1.111111_g4934_i0	PRJEB6055	4958	161	1.111111	1.78888871	Flectobacillus	101	Bacteria	Bacteria	87	2.59e-18	NR	WP_095161254.1	101	g4934	i0	100	0.838509316770186	45	0	83.9	0	161	27	416	460	WP_095161254.1 MULTISPECIES: efflux RND transporter periplasmic adaptor subunit [Flectobacillus]	diamond	135	87	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus

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);;