metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA721440" 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
3745383	3745383	PRJNA721440_S_NODE_20263_length_160_cov_3.504505_g20137_i0	PRJNA721440	20263	160	3.504505	5.607208	Flavobacterium	237	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g20137	i0	100	529.275	160	0	100	0	1	160	1249807	1249648	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	84684	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
8846620	8846620	PRJNA721440_S_NODE_2867_length_333_cov_8.570423_g2741_i0	PRJNA721440	2867	333	8.570423	28.53950859	Chitinophagaceae	563835	Bacteria	Bacteria	527	4.2799999999999985e-145	NTclustered	gi\|1033838715\|gb\|CP015772.1\|	1176587	g2741	i0	95.21	249.087087087087	334	15	100	1	1	333	994696	994363	Niabella ginsenosidivorans strain BS26 chromosome, complete genome	blastn	82946	532	0.990601503759398	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella ginsenosidivorans
9638604	9638604	PRJNA721440_S_NODE_1048_length_511_cov_3.231602_g924_i0	PRJNA721440	1048	511	3.231602	16.51348622	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	693	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g924	i0	91.085	261.050880626223	516	40	100	4	1	511	2978205	2977691	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	133397	693	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
13463885	13463885	PRJNA721440_S_NODE_11071_length_197_cov_8.243243_g10945_i0	PRJNA721440	11071	197	8.243243	16.23918871	Flavobacterium sp. TBRC 19032	3379707	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|2892685960\|gb\|CP174373.1\|	3379708	g10945	i0	100	551.705583756345	197	0	100	0	1	197	1282990	1283186	Flavobacterium sp. TBRC 19032 chromosome, complete genome	blastn	108686	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TBRC 19032
13463924	13463924	PRJNA721440_S_NODE_4631_length_274_cov_5.604444_g4505_i0	PRJNA721440	4631	274	5.604444	15.35617656	Flavobacterium mekongense	3379707	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g4505	i0	100	478.412408759124	274	0	100	0	1	274	1249674	1249401	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	131085	507	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
14739203	14739203	PRJNA721440_S_NODE_5632_length_254_cov_1.258537_g5506_i0	PRJNA721440	5632	254	1.258537	3.19668398	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	433	7.05e-117	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g5506	i0	97.266	245.877952755906	256	5	100	1	1	254	338789	339044	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	62453	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
15222197	15222197	PRJNA721440_S_NODE_4152_length_286_cov_5.358650_g4026_i0	PRJNA721440	4152	286	5.35865	15.325739	Sediminibacterium	504481	Bacteria	Bacteria	473	4.7599999999999997e-129	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g4026	i0	96.503	313.321678321678	286	10	100	0	1	286	55574	55859	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	89610	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
15222201	15222201	PRJNA721440_S_NODE_7372_length_229_cov_1.855556_g7246_i0	PRJNA721440	7372	229	1.855556	4.24922324	Sediminibacterium	504481	Bacteria	Bacteria	318	1.82e-82	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g7246	i0	91.739	23.9082969432314	230	18	100	1	1	229	55599	55370	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	5475	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
16012669	16012669	PRJNA721440_S_NODE_18533_length_165_cov_1.344828_g18407_i0	PRJNA721440	18533	165	1.344828	2.2189662	Psychroserpens sp. NJDZ02	2570561	Bacteria	Bacteria	111	2.24e-20	NTclustered	gi\|1624181815\|gb\|CP039451.1\|	2570561	g18407	i0	83.471	3.96363636363636	121	19	73	1	42	162	886876	886757	Psychroserpens sp. NJDZ02 chromosome, complete genome	blastn	654	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroserpens	Psychroserpens sp. NJDZ02
16496567	16496567	PRJNA721440_S_NODE_393_length_769_cov_4.673611_g319_i0	PRJNA721440	393	769	4.673611	35.94006859	Sediminibacterium	504481	Bacteria	Bacteria	1227	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g319	i0	95.455	259.028608582575	770	34	100	1	1	769	2980388	2979619	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	199193	1232	0.995941558441558	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
19045437	19045437	PRJNA721440_S_NODE_8635_length_216_cov_1.000000_g8509_i0	PRJNA721440	8635	216	1	2.16	Hymenobacter	89966	Bacteria	Bacteria	309	1.02e-79	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g8509	i0	92.593	204.75462962963	216	14	99	2	2	216	1423874	1423660	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	44227	311	0.993569131832797	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
20320045	20320045	PRJNA721440_S_NODE_15416_length_174_cov_9.824000_g15290_i0	PRJNA721440	15416	174	9.824	17.09376	Flavobacteriaceae	49546	Bacteria	Bacteria	134	5.08e-27	NTclustered	gi\|2738792914\|gb\|CP155618.1\|	3045158	g15290	i0	90.909	14.6436781609195	99	9	57	0	1	99	1776729	1776631	Mariniflexile litorale strain KMM 9835 chromosome, complete genome	blastn	2548	135	0.992592592592593	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Mariniflexile	Mariniflexile litorale
21112773	21112773	PRJNA721440_S_NODE_7817_length_224_cov_1.480000_g7691_i0	PRJNA721440	7817	224	1.48	3.3152	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	409	1.03e-109	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g7691	i0	99.554	409	224	1	100	0	1	224	1905652	1905875	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	91616	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
22387559	22387559	PRJNA721440_S_NODE_12198_length_190_cov_2.092199_g12072_i0	PRJNA721440	12198	190	2.092199	3.9751781	Flavobacterium ardleyense	2038737	Bacteria	Bacteria	335	1.4499999999999993e-87	NTclustered	gi\|2619744541\|gb\|CP137891.1\|	2038737	g12072	i0	98.421	499.394736842105	190	3	100	0	1	190	30522	30711	Flavobacterium ardleyense strain A2-1 chromosome, complete genome	blastn	94885	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ardleyense
23663191	23663191	PRJNA721440_S_NODE_18079_length_166_cov_1.435897_g17953_i0	PRJNA721440	18079	166	1.435897	2.38358902	Mucilaginibacter jinjuensis	1176721	Bacteria	Bacteria	272	9.8e-69	NTclustered	gi\|2442599841\|gb\|CP117167.1\|	1176721	g17953	i0	97.484	340.048192771084	159	4	96	0	8	166	5328954	5329112	Mucilaginibacter jinjuensis strain KACC 16571 chromosome, complete genome	blastn	56448	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter jinjuensis
24145169	24145169	PRJNA721440_S_NODE_16939_length_169_cov_1.216667_g16813_i0	PRJNA721440	16939	169	1.216667	2.05616723	root	1	Root_unresolved	Root_unresolved	313	5.859999999999999e-81	NTclustered	gi\|2850837537\|gb\|PQ578042.1\|	239	g16813	i0	100	105.988165680473	169	0	100	0	1	169	1268	1100	Flavobacterium sp. strain TBRC 19031 16S ribosomal RNA gene, partial sequence	blastn	17912	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
24145174	24145174	PRJNA721440_S_NODE_19019_length_164_cov_0.904348_g18893_i0	PRJNA721440	19019	164	0.904348	1.48313072	Macellibacteroides	1159323	Bacteria	Bacteria	252	1.26e-62	NTclustered	gi\|2814788327\|emb\|OY761811.2\|	879969	g18893	i0	94.512	526.25	164	8	99	1	2	164	309009	308846	MAG: Macellibacteroides fermentans isolate d0a889a5-798e-43a2-b832-13c0a728dcc0 genome assembly, chromosome: 1	blastn	86305	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Macellibacteroides	Macellibacteroides fermentans
24936689	24936689	PRJNA721440_S_NODE_17260_length_168_cov_1.638655_g17134_i0	PRJNA721440	17260	168	1.638655	2.7529404	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g17134	i0	97.024	85.7440476190476	168	5	100	0	1	168	2978001	2977834	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	14405	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
25420214	25420214	PRJNA721440_S_NODE_9300_length_210_cov_1.621118_g9174_i0	PRJNA721440	9300	210	1.621118	3.4043478	Flavobacterium	237	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|2850837537\|gb\|PQ578042.1\|	239	g9174	i0	100	103.857142857143	210	0	100	0	1	210	638	429	Flavobacterium sp. strain TBRC 19031 16S ribosomal RNA gene, partial sequence	blastn	21810	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.

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