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

13 rows where analysis = "blastn", bioproject = "PRJNA1074407" 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
1016276	1016276	PRJNA1074407_P_NODE_133681_length_252_cov_1.290503_g129843_i0	PRJNA1074407	133681	252	1.290503	3.25206756	Pontibacter	323449	Bacteria	Bacteria	409	1.18e-109	NTclustered	gi\|1654106087\|gb\|CP028092.1\|	2571030	g129843	i0	96.016	293.924603174603	251	10	99	0	2	252	274462	274212	Pontibacter sp. SGAir0037 chromosome, complete genome	blastn	74069	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter sp. SGAir0037
2739043	2739043	PRJNA1074407_P_NODE_122643_length_280_cov_1.835749_g118805_i0	PRJNA1074407	122643	280	1.835749	5.1400972	Zunongwangia profunda	398743	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|294979899\|gb\|CP001650.1\|	655815	g118805	i0	100	0.1	28	0	10	0	197	224	4231602	4231629	Zunongwangia profunda SM-A87, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Zunongwangia	Zunongwangia profunda
2739091	2739091	PRJNA1074407_P_NODE_124843_length_274_cov_2.124378_g121005_i0	PRJNA1074407	124843	274	2.124378	5.82079572	Spirosoma endbachense	2666025	Bacteria	Bacteria	346	1.03e-90	NTclustered	gi\|1805980863\|gb\|CP045997.1\|	2666025	g121005	i0	89.744	180.324817518248	273	24	99	4	1	271	2751683	2751953	Spirosoma endbachense strain I-24 chromosome	blastn	49409	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma endbachense
4016930	4016930	PRJNA1074407_P_NODE_72464_length_475_cov_1.649254_g68630_i0	PRJNA1074407	72464	475	1.649254	7.8339565	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2621786220\|emb\|OY782678.1\|	2030927	g68630	i0	100	0.0589473684210526	28	0	6	0	236	263	1455825	1455798	MAG: Bacteroidales bacterium isolate 1f9300ae-d6db-4a26-8fb7-1be2ee45184d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
7841022	7841022	PRJNA1074407_P_NODE_118767_length_291_cov_0.816514_g114929_i0	PRJNA1074407	118767	291	0.816514	2.37605574	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	442	1.3699999999999994e-119	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g114929	i0	94.158	303.312714776632	291	15	100	2	1	291	4832342	4832054	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	88264	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
7843227	7843227	PRJNA1074407_P_NODE_79707_length_434_cov_2.357341_g75871_i0	PRJNA1074407	79707	434	2.357341	10.23085994	Niastella koreensis	354356	Bacteria	Bacteria	65.8	5.38e-6	NTclustered	gi\|361057412\|gb\|CP003178.1\|	700598	g75871	i0	95.238	34.3847926267281	42	1	11	1	73	114	1767252	1767292	Niastella koreensis GR20-10, complete genome	blastn	14923	65.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella koreensis
8669531	8669531	PRJNA1074407_P_NODE_118387_length_292_cov_0.890411_g114549_i0	PRJNA1074407	118387	292	0.890411	2.60000012	Flavihumibacter	1004301	Bacteria	Bacteria	409	1.39e-109	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g114549	i0	94.074	260.647260273973	270	15	92	1	1	270	1076296	1076028	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	76109	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
9118230	9118230	PRJNA1074407_P_NODE_82008_length_423_cov_2.011429_g78172_i0	PRJNA1074407	82008	423	2.011429	8.50834467	Lewinella sp. LCG006	3231911	Bacteria	Bacteria	270	1.03e-67	NTclustered	gi\|2773055173\|gb\|CP160680.1\|	3231911	g78172	i0	78.605	167.706855791962	430	76	100	15	1	423	791159	791579	Lewinella sp. LCG006 chromosome, complete genome	blastn	70940	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	Lewinella sp. LCG006
14217438	14217438	PRJNA1074407_P_NODE_137332_length_247_cov_1.580460_g133494_i0	PRJNA1074407	137332	247	1.58046	3.9037362	Flavobacterium flavipigmentatum	2893884	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2153951074\|gb\|CP087133.1\|	2893884	g133494	i0	100	0.117408906882591	29	0	12	0	19	47	3729926	3729898	Flavobacterium flavipigmentatum strain F-70 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium flavipigmentatum
16765851	16765851	PRJNA1074407_P_NODE_145474_length_241_cov_0.869048_g141636_i0	PRJNA1074407	145474	241	0.869048	2.09440568	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g141636	i0	90.336	180.564315352697	238	20	98	3	4	239	1743458	1743222	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	43516	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
21867105	21867105	PRJNA1074407_P_NODE_67118_length_511_cov_1.771689_g63291_i0	PRJNA1074407	67118	511	1.771689	9.05333079	Flavobacterium capsici	3075618	Bacteria	Bacteria	747	0	NTclustered	gi\|2582099103\|gb\|CP134890.1\|	3075618	g63291	i0	93.151	402.041095890411	511	32	100	3	1	511	1074590	1075097	Flavobacterium capsici strain PMTSA4 chromosome, complete genome	blastn	205443	747	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium capsici
24414705	24414705	PRJNA1074407_P_NODE_139600_length_246_cov_0.872832_g135762_i0	PRJNA1074407	139600	246	0.872832	2.14716672	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	344	3.27e-90	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g135762	i0	91.903	215.333333333333	247	18	100	2	1	246	1673769	1673524	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	52972	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
24414786	24414786	PRJNA1074407_P_NODE_144320_length_241_cov_2.880952_g140482_i0	PRJNA1074407	144320	241	2.880952	6.94309432	Flavobacterium channae	2897181	Bacteria	Bacteria	385	1.88e-102	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g140482	i0	95.436	485.294605809129	241	11	100	0	1	241	1908122	1908362	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	116956	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae

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