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

16 rows where analysis = "blastn", bioproject = "PRJDB14275" and tax_phylum = "Bacteroidota"

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
8648	8648	PRJDB14275_P_NODE_6561_length_178_cov_2.064748_g6502_i0	PRJDB14275	6561	178	2.064748	3.67525144	Lacibacter sediminis	2760713	Bacteria	Bacteria	147	6.72e-31	NTclustered	gi\|1888315716\|gb\|CP060007.1\|	2760713	g6502	i0	81.564	1.84831460674157	179	31	100	2	1	178	3512572	3512395	Lacibacter sediminis strain S13-6-22 chromosome, complete genome	blastn	329	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sediminis
1282867	1282867	PRJDB14275_P_NODE_4862_length_230_cov_2.596859_g4803_i0	PRJDB14275	4862	230	2.596859	5.9727757	Flavihumibacter fluvii	2838157	Bacteria	Bacteria	165	2.53e-36	NTclustered	gi\|2198886192\|gb\|CP092333.1\|	2838157	g4803	i0	79.741	2.01739130434783	232	43	100	4	1	230	3301946	3301717	Flavihumibacter fluvii strain IMCC34837 chromosome, complete genome	blastn	464	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter fluvii
1282886	1282886	PRJDB14275_P_NODE_6582_length_178_cov_1.172662_g6523_i0	PRJDB14275	6582	178	1.172662	2.08733836	Pseudobacter ginsenosidimutans	661488	Bacteria	Bacteria	99	1.91e-16	NTclustered	gi\|1721651342\|gb\|CP042431.1\|	661488	g6523	i0	81.513	0.831460674157303	119	22	67	0	25	143	2344461	2344579	Pseudobacter ginsenosidimutans strain Gsoil 221 chromosome, complete genome	blastn	148	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Pseudobacter ginsenosidimutans
2256232	2256232	PRJDB14275_P_NODE_1262_length_662_cov_2.497592_g1208_i0	PRJDB14275	1262	662	2.497592	16.53405904	Pedobacter	84567	Bacteria	Bacteria	1057	0	NTclustered	gi\|1712837605\|gb\|CP042171.1\|	2578106	g1208	i0	95.475	433.457703927492	663	28	100	2	1	662	15025	14364	Pedobacter sp. KBS0701 chromosome, complete genome	blastn	286949	1057	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. KBS0701
3834773	3834773	PRJDB14275_P_NODE_3464_length_314_cov_3.418182_g3405_i0	PRJDB14275	3464	314	3.418182	10.73309148	Aureispira anguillae	2864201	Bacteria	Bacteria	442	1.4899999999999994e-119	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g3405	i0	92.038	376.656050955414	314	25	100	0	1	314	217572	217259	Aureispira anguillae EL160426 DNA, complete genome	blastn	118270	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
3834829	3834829	PRJDB14275_P_NODE_8184_length_153_cov_1.412281_g8125_i0	PRJDB14275	8184	153	1.412281	2.16078993	Pedobacter sp. PACM 27299	1727164	Bacteria	Bacteria	115	1.58e-21	NTclustered	gi\|941972584\|gb\|CP012996.1\|	1727164	g8125	i0	84.483	1.60130718954248	116	18	76	0	38	153	3708892	3709007	Pedobacter sp. PACM 27299 strain PAMC 27299 chromosome, complete genome	blastn	245	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. PACM 27299
7660909	7660909	PRJDB14275_P_NODE_5027_length_224_cov_2.621622_g4968_i0	PRJDB14275	5027	224	2.621622	5.87243328	Pedobacter sp. HDW13	2714940	Bacteria	Bacteria	342	1.0499999999999999e-89	NTclustered	gi\|1821195603\|gb\|CP049868.1\|	2714940	g4968	i0	94.196	255.361607142857	224	13	100	0	1	224	881840	881617	Pedobacter sp. HDW13 chromosome, complete genome	blastn	57201	342	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. HDW13
11184400	11184400	PRJDB14275_P_NODE_5609_length_202_cov_2.490798_g5550_i0	PRJDB14275	5609	202	2.490798	5.03141196	Pedobacter	84567	Bacteria	Bacteria	324	3.38e-84	NTclustered	gi\|1527210401\|gb\|CP034190.1\|	2482728	g5550	i0	98.895	250.683168316832	181	2	90	0	1	181	1754482	1754302	Pedobacter sp. G11 chromosome	blastn	50638	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. G11
11486544	11486544	PRJDB14275_P_NODE_8030_length_155_cov_1.327586_g7971_i0	PRJDB14275	8030	155	1.327586	2.0577583	Pseudocnuella soli	2502779	Bacteria	Bacteria	69.4	1.27e-7	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g7971	i0	89.091	4.87741935483871	55	6	48	0	7	61	91589	91643	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	756	69.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
12460173	12460173	PRJDB14275_P_NODE_1670_length_549_cov_2.586275_g1612_i0	PRJDB14275	1670	549	2.586275	14.19864975	Pedobacter	84567	Bacteria	Bacteria	920	0	NTclustered	gi\|1712837605\|gb\|CP042171.1\|	2578106	g1612	i0	96.903	344.007285974499	549	17	100	0	1	549	14594	14046	Pedobacter sp. KBS0701 chromosome, complete genome	blastn	188860	926	0.993520518358531	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. KBS0701
14036655	14036655	PRJDB14275_P_NODE_5052_length_224_cov_0.881081_g4993_i0	PRJDB14275	5052	224	0.881081	1.97362144	Capnocytophaga granulosa	45242	Bacteria	Bacteria	398	2.2199999999999997e-106	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g4993	i0	98.661	390.727678571429	224	3	100	0	1	224	1523725	1523948	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	87523	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
15310675	15310675	PRJDB14275_P_NODE_1793_length_528_cov_2.654397_g1735_i0	PRJDB14275	1793	528	2.654397	14.01521616	Saprospira sp. CCB-QB6	3023936	Bacteria	Bacteria	562	1.94e-155	NTclustered	gi\|2440421932\|gb\|CP116808.1\|	3023936	g1735	i0	86.77	352.931818181818	514	57	97	8	19	528	1610165	1610671	Saprospira sp. CCB-QB6 chromosome, complete genome	blastn	186348	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira sp. CCB-QB6
16585426	16585426	PRJDB14275_P_NODE_4154_length_266_cov_2.202643_g4095_i0	PRJDB14275	4154	266	2.202643	5.85903038	Winogradskyella sp. PG-2	754409	Bacteria	Bacteria	464	2.64e-126	NTclustered	gi\|631782943\|dbj\|AP014583.1\|	754409	g4095	i0	99.225	244.112781954887	258	1	97	1	9	266	227930	228186	Winogradskyella sp. PG-2 DNA, complete genome	blastn	64934	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella sp. PG-2
21685208	21685208	PRJDB14275_P_NODE_7258_length_166_cov_1.582677_g7199_i0	PRJDB14275	7258	166	1.582677	2.62724382	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	185	1.3099999999999999e-42	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g7199	i0	93.6	188.614457831325	125	7	75	1	12	136	57010	56887	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	31310	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
22960562	22960562	PRJDB14275_P_NODE_5999_length_192_cov_1.032680_g5940_i0	PRJDB14275	5999	192	1.03268	1.9827456	Pedobacter sp. HDW13	2714940	Bacteria	Bacteria	344	2.44e-90	NTclustered	gi\|1821195603\|gb\|CP049868.1\|	2714940	g5940	i0	98.958	14.5520833333333	192	2	100	0	1	192	78910	78719	Pedobacter sp. HDW13 chromosome, complete genome	blastn	2794	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. HDW13
24234482	24234482	PRJDB14275_P_NODE_5880_length_194_cov_4.845161_g5821_i0	PRJDB14275	5880	194	4.845161	9.39961234	Filimonas lacunae	477680	Bacteria	Bacteria	243	9.26e-60	NTclustered	gi\|1031978622\|dbj\|AP017422.1\|	477680	g5821	i0	90.27	189.731958762887	185	18	95	0	1	185	4485945	4486129	Filimonas lacunae DNA, complete genome, strain: NBRC 104114	blastn	36808	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Filimonas	Filimonas lacunae

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