metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA454154" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA454154" 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
1093463	1093463	PRJNA454154_S_NODE_501_length_168_cov_1.625954_g498_i0	PRJNA454154	501	168	1.625954	2.73160272	Bacteria	2	Bacteria	Bacteria	82.4	1.8e-11	NTclustered	gi\|1173527474\|gb\|CP015402.2\|	1796646	g498	i0	94.34	52.9404761904762	53	3	32	0	11	63	2294310	2294362	Muribaculum intestinale strain YL27 chromosome, complete genome	blastn	8894	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Muribaculum	Muribaculum intestinale
1716820	1716820	PRJNA454154_S_NODE_222_length_216_cov_9.458101_g219_i0	PRJNA454154	222	216	9.458101	20.42949816	Cytophagales bacterium Alg240-R148	2305985	Bacteria	Bacteria	141	3.95e-29	NTclustered	gi\|1805798710\|emb\|LS999827.1\|	2305985	g219	i0	90.09	150.462962962963	111	7	50	4	1	109	454	562	Cytophagales bacterium Alg240-R148 genome assembly, chromosome: II	blastn	32500	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium Alg240-R148
8746423	8746423	PRJNA454154_S_NODE_187_length_234_cov_4.583756_g184_i0	PRJNA454154	187	234	4.583756	10.72598904	Hymenobacter	89966	Bacteria	Bacteria	340	3.989999999999999e-89	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g184	i0	96.154	271.611111111111	208	8	90	0	5	212	504308	504515	Hymenobacter swuensis DY53, complete genome	blastn	63557	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
9369793	9369793	PRJNA454154_S_NODE_288_length_198_cov_7.509317_g285_i0	PRJNA454154	288	198	7.509317	14.86844766	Lacibacter sediminis	2760713	Bacteria	Bacteria	351	1.51e-92	NTclustered	gi\|1888315716\|gb\|CP060007.1\|	2760713	g285	i0	98.98	161.373737373737	196	2	99	0	3	198	867360	867555	Lacibacter sediminis strain S13-6-22 chromosome, complete genome	blastn	31952	351	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sediminis
11296584	11296584	PRJNA454154_S_NODE_69_length_318_cov_15.733096_g66_i0	PRJNA454154	69	318	15.733096	50.03124528	Flavobacterium	237	Bacteria	Bacteria	545	1.1199999999999999e-150	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g66	i0	99.013	658.160377358491	304	3	96	0	1	304	473316	473619	Flavobacterium columnare strain B185, complete genome	blastn	209295	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
17671055	17671055	PRJNA454154_S_NODE_94_length_289_cov_4.309524_g91_i0	PRJNA454154	94	289	4.309524	12.45452436	Flavobacterium	237	Bacteria	Bacteria	444	3.78e-120	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g91	i0	94.444	643.647058823529	288	16	99	0	1	288	472841	472554	Flavobacterium columnare strain B185, complete genome	blastn	186014	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
18293618	18293618	PRJNA454154_S_NODE_215_length_219_cov_76.554945_g212_i0	PRJNA454154	215	219	76.554945	167.65532955	Flavobacterium sediminis	2201181	Bacteria	Bacteria	366	6.09e-97	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g212	i0	99.02	640.127853881278	204	2	93	0	2	205	2900089	2900292	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	140188	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis
18293623	18293623	PRJNA454154_S_NODE_95_length_289_cov_3.928571_g92_i0	PRJNA454154	95	289	3.928571	11.35357019	Fulvivirga lutea	2810512	Bacteria	Bacteria	158	5.51e-34	NTclustered	gi\|1995470682\|gb\|CP070608.1\|	2810512	g92	i0	78.092	40.8650519031142	283	38	93	19	4	273	479519	479248	Fulvivirga lutea strain S481 chromosome, complete genome	blastn	11810	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga lutea
20219664	20219664	PRJNA454154_S_NODE_536_length_164_cov_3.480315_g533_i0	PRJNA454154	536	164	3.480315	5.7077166	Flavobacterium	237	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|21832090\|dbj\|AB078045.1\|	994	g533	i0	100	170.993902439024	164	0	100	0	1	164	160	323	Flavobacterium johnsoniae subsp. aurantiacum gene for 16S rRNA, strain:IFO 16024	blastn	28043	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
20843644	20843644	PRJNA454154_S_NODE_317_length_193_cov_5.865385_g314_i0	PRJNA454154	317	193	5.865385	11.32019305	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	267	5.4599999999999996e-67	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g314	i0	91.667	649.336787564767	192	16	99	0	2	193	1333368	1333177	Flavobacterium sp. N1719 chromosome, complete genome	blastn	125322	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
21495255	21495255	PRJNA454154_S_NODE_257_length_206_cov_7.976331_g254_i0	PRJNA454154	257	206	7.976331	16.43124186	Bacteroidota	976	Bacteria	Bacteria	202	1.6899999999999999e-47	NTclustered	gi\|1352177909\|gb\|CP027062.1\|	2094025	g254	i0	84.878	350.203883495146	205	25	99	6	2	204	2227700	2227900	Pukyongia salina strain RR4-38 chromosome, complete genome	blastn	72142	204	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pukyongia	Pukyongia salina
23394151	23394151	PRJNA454154_S_NODE_19_length_450_cov_11.326877_g16_i0	PRJNA454154	19	450	11.326877	50.9709465	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	726	0	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g16	i0	95.973	561.606666666667	447	18	99	0	1	447	1334339	1333893	Flavobacterium sp. N1719 chromosome, complete genome	blastn	252723	726	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
23394155	23394155	PRJNA454154_S_NODE_619_length_155_cov_1.050847_g616_i0	PRJNA454154	619	155	1.050847	1.62881285	Runella rosea	2259595	Bacteria	Bacteria	156	9.44e-34	NTclustered	gi\|1430388288\|gb\|CP030850.1\|	2259595	g616	i0	87.407	59.8	135	17	87	0	1	135	4137684	4137550	Runella rosea strain HYN0085 chromosome, complete genome	blastn	9269	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella rosea

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