metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1001940" and tax

16 rows where analysis = "blastn", 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
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

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