metadata: contig_metadata: 28 rows where bioproject = "PRJNA641991" and tax

28 rows where bioproject = "PRJNA641991" 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
1894025	1894025	PRJNA641991_S_NODE_9382_length_185_cov_0.823529_g9263_i0	PRJNA641991	9382	185	0.823529	1.52352865	Maribacter sp. R86514	3093854	Bacteria	Bacteria	69.4	1.57e-7	NTclustered	gi\|2845113958\|gb\|CP138999.1\|	3093854	g9263	i0	93.478	3.40540540540541	46	3	25	0	37	82	1039078	1039033	Maribacter sp. R86514 chromosome, complete genome	blastn	630	69.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Maribacter	Maribacter sp. R86514
2433542	2433542	PRJNA641991_S_NODE_12602_length_166_cov_0.871795_g12483_i0	PRJNA641991	12602	166	0.871795	1.4471797	Flavobacterium	237	Bacteria	Bacteria	237	3.58e-58	NTclustered	gi\|2643654678\|gb\|CP136574.1\|	239	g12483	i0	93.168	3.59638554216867	161	11	97	0	1	161	1539044	1539204	MAG: Flavobacterium sp. isolate GU0601_MAG5 chromosome, complete genome	blastn	597	237	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
8271035	8271035	PRJNA641991_S_NODE_14407_length_162_cov_0.902655_g14288_i0	PRJNA641991	14407	162	0.902655	1.4623011	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g14288	i0	100	49.7222222222222	162	0	100	0	1	162	151146	150985	Flavobacterium sp. TR2 chromosome, complete genome	blastn	8055	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2
10086915	10086915	PRJNA641991_S_NODE_11288_length_171_cov_1.254098_g11169_i0	PRJNA641991	11288	171	1.254098	2.14450758	Aquirufa	2676247	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g11169	i0	98.83	347.654970760234	171	2	100	0	1	171	360555	360725	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	59449	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
12097159	12097159	PRJNA641991_S_NODE_10030_length_180_cov_1.137405_g9911_i0	PRJNA641991	10030	180	1.137405	2.047329	Spirosoma radiotolerans	1379870	Bacteria	Bacteria	102	1.49e-17	NTclustered	gi\|808692684\|gb\|CP010429.1\|	1379870	g9911	i0	94.03	20.2666666666667	67	4	37	0	1	67	4385050	4385116	Spirosoma radiotolerans strain DG5A, complete genome	blastn	3648	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma radiotolerans
15186864	15186864	PRJNA641991_S_NODE_14412_length_162_cov_0.902655_g14293_i0	PRJNA641991	14412	162	0.902655	1.4623011	Chryseobacterium	59732	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g14293	i0	100	91.2222222222222	162	0	100	0	1	162	3306083	3305922	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	14778	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
15920605	15920605	PRJNA641991_S_NODE_10953_length_173_cov_1.233871_g10834_i0	PRJNA641991	10953	173	1.233871	2.13459683	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g10834	i0	99.422	98.6820809248555	173	1	100	0	1	173	1118616	1118444	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	17072	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes
17736313	17736313	PRJNA641991_S_NODE_3174_length_296_cov_2.008097_g3055_i0	PRJNA641991	3174	296	2.008097	5.94396712	Flavobacterium	237	Bacteria	Bacteria	444	3.88e-120	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g3055	i0	93.919	525.760135135135	296	14	99	4	3	296	979677	979384	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	155625	448	0.991071428571429	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
19744620	19744620	PRJNA641991_S_NODE_13796_length_163_cov_0.894737_g13677_i0	PRJNA641991	13796	163	0.894737	1.45842131	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g13677	i0	92.638	11.920245398773	163	12	100	0	1	163	300137	300299	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	1943	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
21020189	21020189	PRJNA641991_S_NODE_5417_length_232_cov_1.617486_g5298_i0	PRJNA641991	5417	232	1.617486	3.75256752	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	403	4.97e-108	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g5298	i0	98.276	6.15086206896552	232	1	100	1	1	232	1320621	1320849	Flavobacterium sp. TR2 chromosome, complete genome	blastn	1427	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2
22294868	22294868	PRJNA641991_S_NODE_13958_length_163_cov_0.894737_g13839_i0	PRJNA641991	13958	163	0.894737	1.45842131	Tellurirhabdus bombi	2907205	Bacteria	Bacteria	94.7	2.6200000000000003e-21	NR	WP_234734396.1	2907205	g13839	i0	83.3	8.94478527607362	54	9	99.4	0	163	2	90	143	WP_234734396.1 alanine dehydrogenase [Tellurirhabdus bombi]	diamond	1458	94.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus bombi
26669449	26669449	PRJNA641991_S_NODE_13321_length_164_cov_0.886957_g13202_i0	PRJNA641991	13321	164	0.886957	1.45460948	Bacteroidota bacterium	1898104	Bacteria	Bacteria	82.4	1.08e-17	NR	MBM3185382.1	1898104	g13202	i0	72.5	0.932926829268293	51	14	93.3	0	157	5	59	109	MBM3185382.1 peptide-methionine (S)-S-oxide reductase MsrA [Bacteroidota bacterium]	diamond	153	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27744895	27744895	PRJNA641991_S_NODE_10704_length_175_cov_0.873016_g10585_i0	PRJNA641991	10704	175	0.873016	1.527778	Flavobacterium sp. LM5	1938610	Bacteria	Bacteria	97.4	1.32e-22	NR	WP_369803206.1	1938610	g10585	i0	100	0.84	49	0	84	0	173	27	264	312	WP_369803206.1 tyrosine-type recombinase/integrase [Flavobacterium sp. LM5]	diamond	147	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. LM5
28009712	28009712	PRJNA641991_S_NODE_5905_length_224_cov_1.457143_g5786_i0	PRJNA641991	5905	224	1.457143	3.26400032	Apibacter	1778601	Bacteria	Bacteria	102	7.169999999999998e-24	NR	WP_105298061.1	1778601	g5786	i0	63	17.5580357142857	73	27	97.8	0	3	221	278	350	WP_105298061.1 MULTISPECIES: elongation factor Tu [Apibacter]	diamond	3933	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Apibacter
28249679	28249679	PRJNA641991_S_NODE_6746_length_212_cov_1.098160_g6627_i0	PRJNA641991	6746	212	1.09816	2.3280992	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	138	2.12e-36	NR	MCF7838365.1	2026760	g6627	i0	82.9	0.990566037735849	70	12	99.1	0	1	210	297	366	MCF7838365.1 phosphoenolpyruvate carboxykinase (GTP) [Fidelibacterota bacterium]	diamond	210	138	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
28356723	28356723	PRJNA641991_P_NODE_626_length_444_cov_1.065823_g585_i0	PRJNA641991	626	444	1.065823	4.73225412	Bacteria	2	Bacteria	Bacteria	45.1	0.0346	NR	MDD2419128.1	2030927	g585	i0	40	1.12162162162162	50	30	33.8	0	169	20	115	164	MDD2419128.1 TonB family protein [Bacteroidales bacterium]	diamond	498	45.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28420180	28420180	PRJNA641991_S_NODE_13506_length_164_cov_0.886957_g13387_i0	PRJNA641991	13506	164	0.886957	1.45460948	Spirosomataceae	2896860	Bacteria	Bacteria	68.2	1.2e-11	NR	WP_071501647.1	1750698	g13387	i0	70.8	4.95731707317073	48	14	87.8	0	4	147	7	54	WP_071501647.1 SDR family NAD(P)-dependent oxidoreductase [Arsenicibacter rosenii]	diamond	813	68.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Arsenicibacter	Arsenicibacter rosenii
28755010	28755010	PRJNA641991_S_NODE_3627_length_277_cov_4.885965_g3508_i0	PRJNA641991	3627	277	4.885965	13.53412305	Flavobacterium sasangense	503361	Bacteria	Bacteria	146	7.55e-43	NR	WP_026724891.1	503361	g3508	i0	93.3	0.974729241877256	90	6	97.5	0	275	6	50	139	WP_026724891.1 hypothetical protein [Flavobacterium sasangense]	diamond	270	146	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sasangense
28912613	28912613	PRJNA641991_S_NODE_8568_length_192_cov_1.069930_g8449_i0	PRJNA641991	8568	192	1.06993	2.0542656	Bacteroidia bacterium	2044936	Bacteria	Bacteria	64.7	1.38e-11	NR	MFN0200197.1	2044936	g8449	i0	49.2	3.625	59	30	92.2	0	180	4	8	66	MFN0200197.1 tetratricopeptide repeat protein [Bacteroidia bacterium]	diamond	696	64.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
29556491	29556491	PRJNA641991_S_NODE_14630_length_161_cov_0.910714_g14511_i0	PRJNA641991	14630	161	0.910714	1.46624954	Flavobacteriaceae	49546	Bacteria	Bacteria	90.1	9.95e-22	NR	WP_188465134.1	1495645	g14511	i0	81.1	1.97515527950311	53	10	98.8	0	160	2	28	80	WP_188465134.1 hypothetical protein [Bizionia arctica]	diamond	318	90.9	0.991199119911991	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Bizionia	Bizionia arctica
30397695	30397695	PRJNA641991_S_NODE_14833_length_161_cov_0.910714_g14714_i0	PRJNA641991	14833	161	0.910714	1.46624954	Prevotella sp.	59823	Bacteria	Bacteria	43.5	0.00655	NR	MBR4698528.1	59823	g14714	i0	42.6	1.00621118012422	54	30	98.8	1	161	3	30	83	MBR4698528.1 TMEM43 family protein [Prevotella sp.]	diamond	162	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
30554975	30554975	PRJNA641991_S_NODE_10773_length_174_cov_1.632000_g10654_i0	PRJNA641991	10773	174	1.632	2.83968	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	43.9	0.0056	NR	MBK9513374.1	2021391	g10654	i0	42.6	0.931034482758621	54	31	93.1	0	9	170	91	144	MBK9513374.1 DUF3667 domain-containing protein [Flavobacteriales bacterium]	diamond	162	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30649722	30649722	PRJNA641991_P_NODE_713_length_411_cov_3.198895_g672_i0	PRJNA641991	713	411	3.198895	13.14745845	Flavobacterium sasangense	503361	Bacteria	Bacteria	230	2.14e-75	NR	WP_026724891.1	503361	g672	i0	94.2	1	137	8	100	0	411	1	2	138	WP_026724891.1 hypothetical protein [Flavobacterium sasangense]	diamond	411	230	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sasangense
30997600	30997600	PRJNA641991_S_NODE_13274_length_164_cov_0.930435_g13155_i0	PRJNA641991	13274	164	0.930435	1.5259134	Sediminitomix flava	379075	Bacteria	Bacteria	45.8	9.07e-4	NR	WP_109622361.1	379075	g13155	i0	42.6	2.89024390243902	54	31	98.8	0	163	2	92	145	WP_109622361.1 ABC transporter ATP-binding protein [Sediminitomix flava]	diamond	474	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Sediminitomix	Sediminitomix flava
31123522	31123522	PRJNA641991_P_NODE_2975_length_175_cov_1.214286_g2934_i0	PRJNA641991	2975	175	1.214286	2.1250005	Chlorobiota bacterium	2268192	Bacteria	Bacteria	39.7	0.0476	NR	KAA0244550.1	2268192	g2934	i0	48.9	0.771428571428571	45	22	75.4	1	160	29	1	45	KAA0244550.1 MAG: hypothetical protein EDM72_08225 [Chlorobiota bacterium]	diamond	135	39.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
31262626	31262626	PRJNA641991_S_NODE_13755_length_163_cov_0.894737_g13636_i0	PRJNA641991	13755	163	0.894737	1.45842131	Weeksellaceae	2762318	Bacteria	Bacteria	95.5	8.04e-22	NR	MDO4225188.1	1015	g13636	i0	83	2.92638036809816	53	9	97.5	0	161	3	173	225	MDO4225188.1 type IX secretion system protein PorQ [Bergeyella zoohelcum]	diamond	477	95.9	0.995828988529718	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella zoohelcum
32053383	32053383	PRJNA641991_S_NODE_4078_length_264_cov_1.516279_g3959_i0	PRJNA641991	4078	264	1.516279	4.00297656	FCB group	1783270	Bacteria	Bacteria	43.1	0.0306	NR	HTF05980.1	2044936	g3959	i0	43.8	1.42045454545455	48	27	54.5	0	69	212	171	218	HTF05980.1 toxin-antitoxin system YwqK family antitoxin [Bacteroidia bacterium]	diamond	375	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
32830905	32830905	PRJNA641991_S_NODE_14340_length_162_cov_0.902655_g14221_i0	PRJNA641991	14340	162	0.902655	1.4623011	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	42.7	0.012	NR	MBT6699684.1	2021391	g14221	i0	76	0.907407407407407	25	6	46.3	0	3	77	34	58	MBT6699684.1 MORN motif-containing protein [Flavobacteriales bacterium]	diamond	147	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales 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);;