metadata: contig_metadata: 27 rows where bioproject = "PRJNA1001940" and tax

27 rows where bioproject = "PRJNA1001940" 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
999443	999443	PRJNA1001940_S_NODE_161381_length_171_cov_1.375000_g160327_i0	PRJNA1001940	161381	171	1.375	2.35125	Cytophaga	978	Bacteria	Bacteria	265	1.69e-66	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g160327	i0	95.732	354.368421052632	164	7	96	0	1	164	889	1052	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	60597	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
1422919	1422919	PRJNA1001940_S_NODE_86522_length_233_cov_4.168421_g85468_i0	PRJNA1001940	86522	233	4.168421	9.71242093	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	318	1.86e-82	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g85468	i0	92.377	142.103004291845	223	17	96	0	2	224	2956913	2957135	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	33110	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3971938	3971938	PRJNA1001940_S_NODE_108404_length_208_cov_1.969697_g107350_i0	PRJNA1001940	108404	208	1.969697	4.09696976	Paludibacter propionicigenes	185300	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|312441806\|gb\|CP002345.1\|	694427	g107350	i0	100	0.134615384615385	28	0	13	0	17	44	731637	731610	Paludibacter propionicigenes WB4, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
7800756	7800756	PRJNA1001940_S_NODE_87007_length_233_cov_1.447368_g85953_i0	PRJNA1001940	87007	233	1.447368	3.37236744	Hymenobacter sp. BRD67	2675877	Bacteria	Bacteria	394	3.01e-105	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g85953	i0	97.021	269.287553648069	235	5	100	2	1	233	433260	433026	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	62744	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
8652781	8652781	PRJNA1001940_S_NODE_85807_length_234_cov_4.926702_g84753_i0	PRJNA1001940	85807	234	4.926702	11.52848268	Bacteroides coprosuis	151276	Bacteria	Bacteria	157	4.77e-43	NR	WP_276776066.1	151276	g84753	i0	96.1	0.987179487179487	77	3	98.7	0	3	233	56	132	WP_276776066.1 trehalase family glycosidase [Bacteroides coprosuis]	diamond	231	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides coprosuis
9074772	9074772	PRJNA1001940_S_NODE_25028_length_404_cov_3.590028_g23982_i0	PRJNA1001940	25028	404	3.590028	14.50371312	Dyadobacter sp. NIV53	2861765	Bacteria	Bacteria	686	0	NTclustered	gi\|2084058630\|gb\|CP081299.1\|	2861765	g23982	i0	97.277	172.455445544554	404	11	100	0	1	404	3851647	3851244	Dyadobacter sp. NIV53 chromosome, complete genome	blastn	69672	686	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. NIV53
9927560	9927560	PRJNA1001940_S_NODE_42348_length_328_cov_5.333333_g41294_i0	PRJNA1001940	42348	328	5.333333	17.49333224	Phocaeicola	909656	Bacteria	Bacteria	606	5.249999999999998e-169	NTclustered	gi\|2290438071\|gb\|CP103067.1\|	821	g41294	i0	100	460.356707317073	328	0	100	0	1	328	320524	320197	Phocaeicola vulgatus strain BFG-626 chromosome, complete genome	blastn	150997	606	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
11202721	11202721	PRJNA1001940_S_NODE_156909_length_173_cov_2.576923_g155855_i0	PRJNA1001940	156909	173	2.576923	4.45807679	Croceibacter	216431	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|921059822\|gb\|KP887607.1\|	165436	g155855	i0	100	330.843930635838	173	0	100	0	1	173	1679	1851	Uncultured Flavobacteriaceae bacterium clone 770_WTL 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57236	320	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		uncultured Flavobacteriaceae bacterium
16302182	16302182	PRJNA1001940_S_NODE_93593_length_224_cov_2.121547_g92539_i0	PRJNA1001940	93593	224	2.121547	4.75226528	root	1	Root_unresolved	Root_unresolved	414	2.1999999999999996e-111	NTclustered	gi\|2050639041\|gb\|CP054204.1\|	820	g92539	i0	100	18	224	0	100	0	1	224	1973952	1974175	Bacteroides uniformis strain JCM13288 chromosome, complete genome	blastn	4032	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
16724573	16724573	PRJNA1001940_S_NODE_5134_length_668_cov_5.561600_g4393_i0	PRJNA1001940	5134	668	5.5616	37.151488	Pseudobacter ginsenosidimutans	661488	Bacteria	Bacteria	920	0	NTclustered	gi\|1721651342\|gb\|CP042431.1\|	661488	g4393	i0	91.617	338.449101796407	668	52	99	3	1	666	497576	496911	Pseudobacter ginsenosidimutans strain Gsoil 221 chromosome, complete genome	blastn	226084	920	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Pseudobacter ginsenosidimutans
17998185	17998185	PRJNA1001940_S_NODE_162695_length_170_cov_1.889764_g161641_i0	PRJNA1001940	162695	170	1.889764	3.2125988	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	143	8.2e-30	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g161641	i0	82.184	13.0705882352941	174	23	100	6	1	170	5916764	5916933	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2222	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17999643	17999643	PRJNA1001940_S_NODE_67435_length_264_cov_7.665158_g66381_i0	PRJNA1001940	67435	264	7.665158	20.23601712	Prevotella intermedia	28131	Bacteria	Bacteria	283	7.859999999999999e-72	NTclustered	gi\|1276663706\|gb\|CP024723.1\|	28131	g66381	i0	86.415	224.382575757576	265	29	100	6	4	264	981500	981239	Prevotella intermedia strain KCOM 2837 chromosome 1, complete sequence	blastn	59237	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
20548672	20548672	PRJNA1001940_S_NODE_38617_length_342_cov_2.568562_g37563_i0	PRJNA1001940	38617	342	2.568562	8.78448204	Chryseobacterium capnotolerans	2759528	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2169822356\|gb\|CP065589.1\|	2759528	g37563	i0	100	0.0818713450292398	28	0	8	0	171	198	346374	346401	Chryseobacterium capnotolerans isolate DH-B6 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium capnotolerans
20548704	20548704	PRJNA1001940_S_NODE_40957_length_333_cov_4.406897_g39903_i0	PRJNA1001940	40957	333	4.406897	14.67496701	Capnocytophaga granulosa	45242	Bacteria	Bacteria	499	9.32e-137	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g39903	i0	94.19	32.3093093093093	327	19	98	0	7	333	495958	495632	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	10759	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
22676304	22676304	PRJNA1001940_S_NODE_141998_length_182_cov_1.726619_g140944_i0	PRJNA1001940	141998	182	1.726619	3.14244658	root	1	Root_unresolved	Root_unresolved	337	3.82e-88	NTclustered	gi\|1873649864\|gb\|MT774753.1\|	245	g140944	i0	100	100	182	0	100	0	1	182	373	192	Flavobacterium aquatile strain WFH119 16S ribosomal RNA gene, partial sequence	blastn	18200	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium aquatile
23100102	23100102	PRJNA1001940_S_NODE_68279_length_263_cov_1.618182_g67225_i0	PRJNA1001940	68279	263	1.618182	4.25581866	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	309	1.29e-79	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g67225	i0	87.879	32.5247148288973	264	30	100	2	1	263	339671	339409	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	8554	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
25225749	25225749	PRJNA1001940_S_NODE_73340_length_254_cov_1.592417_g72286_i0	PRJNA1001940	73340	254	1.592417	4.04473918	Prevotella	838	Bacteria	Bacteria	444	3.26e-120	NTclustered	gi\|2028848006\|gb\|CP072343.1\|	28132	g72286	i0	98.795	238.161417322835	249	3	98	0	6	254	382816	383064	Prevotella melaninogenica strain F0695 chromosome 1, complete sequence	blastn	60493	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
26590898	26590898	PRJNA1001940_S_NODE_165481_length_169_cov_1.142857_g164427_i0	PRJNA1001940	165481	169	1.142857	1.93142833	Sphingobacterium sp. UT-1RO-CII-1	2995225	Bacteria	Bacteria	89.4	5.08e-21	NR	WP_268230863.1	2995225	g164427	i0	88.7	0.940828402366864	53	6	94.1	0	160	2	27	79	WP_268230863.1 ORF6N domain-containing protein [Sphingobacterium sp. UT-1RO-CII-1]	diamond	159	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. UT-1RO-CII-1
27097533	27097533	PRJNA1001940_S_NODE_59082_length_282_cov_2.983264_g58028_i0	PRJNA1001940	59082	282	2.983264	8.41280448	Niastella sp.	1869183	Bacteria	Bacteria	55.5	1.51e-6	NR	MBO9566002.1	1869183	g58028	i0	89.7	3.3936170212766	29	3	30.9	0	1	87	237	265	MBO9566002.1 class I SAM-dependent methyltransferase [Niastella sp.]	diamond	957	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella sp.
28739764	28739764	PRJNA1001940_S_NODE_154047_length_175_cov_1.454545_g152993_i0	PRJNA1001940	154047	175	1.454545	2.54545375	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.00432	NR	HYL29474.1	2448054	g152993	i0	45.7	0.788571428571429	46	22	78.9	1	11	148	146	188	HYL29474.1 formimidoylglutamate deiminase [Gemmatimonadales bacterium]	diamond	138	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28739768	28739768	PRJNA1001940_S_NODE_79127_length_244_cov_3.019900_g78073_i0	PRJNA1001940	79127	244	3.0199	7.368556	Dysgonamonadaceae bacterium	2065189	Bacteria	Bacteria	138	1.4e-36	NR	MDD2551303.1	2065189	g78073	i0	85.2	1.99180327868852	81	12	99.6	0	244	2	35	115	MDD2551303.1 sodium:proton antiporter NhaD [Dysgonamonadaceae bacterium]	diamond	486	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonamonadaceae bacterium
28992659	28992659	PRJNA1001940_S_NODE_83648_length_237_cov_8.824742_g82594_i0	PRJNA1001940	83648	237	8.824742	20.91463854	Aureitalea sp. L	1872661	Bacteria	Bacteria	42.4	0.047	NR	WP_265198814.1	2816962	g82594	i0	34.3	0.848101265822785	67	43	83.5	1	12	209	230	296	WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47]	diamond	201	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureitalea	Aureitalea sp. L0-47
29150586	29150586	PRJNA1001940_S_NODE_54529_length_293_cov_3.368000_g53475_i0	PRJNA1001940	54529	293	3.368	9.86824	Bacteroidales bacterium	2030927	Bacteria	Bacteria	181	1.93e-52	NR	MBO5876770.1	2030927	g53475	i0	100	0.993174061433447	97	0	99.3	0	292	2	363	459	MBO5876770.1 TolC family protein [Bacteroidales bacterium]	diamond	291	181	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29276359	29276359	PRJNA1001940_S_NODE_162349_length_170_cov_2.834646_g161295_i0	PRJNA1001940	162349	170	2.8346460000000002	4.8188982	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	118	5.28e-33	NR	MBR6065094.1	2748031	g161295	i0	98.2	0.988235294117647	56	1	98.8	0	2	169	39	94	MBR6065094.1 cation transporter [Paludibacteraceae bacterium]	diamond	168	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
29654990	29654990	PRJNA1001940_S_NODE_190070_length_157_cov_1.684211_g189016_i0	PRJNA1001940	190070	157	1.684211	2.64421127	Bacteroidales bacterium	2030927	Bacteria	Bacteria	99.4	3.0299999999999996e-23	NR	MBQ2372957.1	2030927	g189016	i0	100	0.898089171974522	47	0	89.8	0	2	142	296	342	MBQ2372957.1 DUF4837 family protein [Bacteroidales bacterium]	diamond	141	99.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29908170	29908170	PRJNA1001940_S_NODE_143211_length_181_cov_3.992754_g142157_i0	PRJNA1001940	143211	181	3.992754	7.22688474	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	78.2	2e-16	NR	MDD6747873.1	2748031	g142157	i0	66.7	0.845303867403315	51	17	84.5	0	164	12	17	67	MDD6747873.1 transcriptional repressor [Paludibacteraceae bacterium]	diamond	153	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
30002945	30002945	PRJNA1001940_S_NODE_141891_length_182_cov_2.071942_g140837_i0	PRJNA1001940	141891	182	2.071942	3.77093444	Bacteroidales bacterium	2030927	Bacteria	Bacteria	106	4.4900000000000006e-27	NR	MDD6787673.1	2030927	g140837	i0	88.3	0.989010989010989	60	7	98.9	0	1	180	62	121	MDD6787673.1 hypothetical protein [Bacteroidales bacterium]	diamond	180	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales 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);;