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

16 rows where analysis = "blastn", bioproject = "PRJNA385396" 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
406995	406995	PRJNA385396_P_NODE_21301_length_241_cov_0.916667_g21209_i0	PRJNA385396	21301	241	0.916667	2.20916747	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	344	3.199999999999999e-90	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g21209	i0	96.209	0.87551867219917	211	7	87	1	1	210	2886319	2886529	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	211	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
4233905	4233905	PRJNA385396_P_NODE_14004_length_251_cov_0.865169_g13912_i0	PRJNA385396	14004	251	0.865169	2.17157419	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g13912	i0	95.219	1	251	12	100	0	1	251	1449205	1448955	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	251	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
4904549	4904549	PRJNA385396_P_NODE_3244_length_426_cov_0.875354_g3152_i0	PRJNA385396	3244	426	0.875354	3.72900804	Weeksellaceae	2762318	Bacteria	Bacteria	689	0	NTclustered	gi\|2870348478\|gb\|CP175957.1\|	34085	g3152	i0	95.794	368.866197183099	428	16	100	2	1	426	998878	998451	Riemerella anatipestifer strain RAf490 chromosome, complete genome	blastn	157137	689	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
9335029	9335029	PRJNA385396_P_NODE_18308_length_245_cov_0.895349_g18216_i0	PRJNA385396	18308	245	0.895349	2.19360505	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g18216	i0	96.327	66.7755102040816	245	9	100	0	1	245	1783194	1783438	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	16360	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
9335045	9335045	PRJNA385396_P_NODE_18888_length_244_cov_0.900585_g18796_i0	PRJNA385396	18888	244	0.900585	2.1974274	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g18796	i0	99.18	1	244	2	100	0	1	244	735389	735632	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	244	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
10610998	10610998	PRJNA385396_P_NODE_8629_length_302_cov_1.008734_g8537_i0	PRJNA385396	8629	302	1.008734	3.04637668	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	448	3.0699999999999995e-121	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g8537	i0	93.399	354.771523178808	303	18	100	2	1	302	3683	3382	Dyadobacter pollutisoli strain U1 chromosome	blastn	107141	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
11279759	11279759	PRJNA385396_P_NODE_7969_length_311_cov_0.915966_g7877_i0	PRJNA385396	7969	311	0.915966	2.84865426	Niabella	379899	Bacteria	Bacteria	492	1.45e-134	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g7877	i0	95.469	232.183279742765	309	12	100	2	4	311	1679396	1679089	Niabella sp. I6 chromosome	blastn	72209	492	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6
11885428	11885428	PRJNA385396_P_NODE_11030_length_273_cov_1.540000_g10938_i0	PRJNA385396	11030	273	1.54	4.2042	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	497	2.68e-136	NTclustered	gi\|1527179843\|gb\|CP034173.1\|	536441	g10938	i0	99.632	65.5274725274725	272	1	99	0	2	273	642570	642841	Chryseobacterium taklimakanense strain F9257 chromosome, complete genome	blastn	17889	497	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
13160846	13160846	PRJNA385396_P_NODE_4671_length_373_cov_1.183333_g4579_i0	PRJNA385396	4671	373	1.183333	4.41383209	Antarcticibacterium sp. 1MA-6-2	2908210	Bacteria	Bacteria	536	8.039999999999999e-148	NTclustered	gi\|2181152707\|gb\|CP091036.1\|	2908210	g4579	i0	100	320.109919571046	290	0	99	0	83	372	297128	297417	Antarcticibacterium sp. 1MA-6-2 chromosome, complete genome	blastn	119401	536	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Antarcticibacterium	Antarcticibacterium sp. 1MA-6-2
13160955	13160955	PRJNA385396_P_NODE_7931_length_311_cov_1.352941_g7839_i0	PRJNA385396	7931	311	1.352941	4.20764651	Epilithonimonas zeae	1416779	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g7839	i0	100	482.900321543408	311	0	100	0	1	311	2242796	2242486	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	150182	575	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
16984252	16984252	PRJNA385396_P_NODE_16134_length_248_cov_0.880000_g16042_i0	PRJNA385396	16134	248	0.88	2.1824	Prevotella bivia	28125	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|2515259909\|gb\|CP126677.1\|	28125	g16042	i0	97.984	2	248	5	100	0	1	248	830558	830311	Prevotella bivia strain PLW0727 chromosome 2, complete sequence	blastn	496	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
18928041	18928041	PRJNA385396_P_NODE_135_length_1608_cov_3.820847_g95_i0	PRJNA385396	135	1608	3.820847	61.43921976	Aquirufa	2676247	Bacteria	Bacteria	1751	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g95	i0	86.442	474.071517412935	1630	184	100	32	1	1608	358668	360282	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	762307	1766	0.991506228765572	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
23358939	23358939	PRJNA385396_P_NODE_16819_length_247_cov_0.885057_g16727_i0	PRJNA385396	16819	247	0.885057	2.18609079	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	224	4.469999999999999e-54	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g16727	i0	83.471	0.979757085020243	242	38	98	2	7	247	1973106	1972866	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	242	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.
23359060	23359060	PRJNA385396_P_NODE_21899_length_229_cov_2.391026_g21807_i0	PRJNA385396	21899	229	2.391026	5.47544954	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	385	1.77e-102	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g21807	i0	96.943	442.318777292576	229	7	100	0	1	229	1407667	1407895	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	101291	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
24633171	24633171	PRJNA385396_P_NODE_12780_length_256_cov_1.169399_g12688_i0	PRJNA385396	12780	256	1.169399	2.99366144	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	106	1.76e-18	NTclustered	gi\|2874253929\|emb\|OY970254.1\|	866510	g12688	i0	83.051	0.4609375	118	18	46	2	139	255	2227535	2227651	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.1.55 genome assembly, chromosome: 1	blastn	118	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
24633533	24633533	PRJNA385396_P_NODE_6500_length_333_cov_1.503846_g6408_i0	PRJNA385396	6500	333	1.503846	5.00780718	Bergeyella cardium	1585976	Bacteria	Bacteria	436	7.409999999999999e-118	NTclustered	gi\|2504455906\|gb\|CP121693.1\|	1585976	g6408	i0	90.476	419.585585585586	336	25	100	4	1	333	993440	993771	Bergeyella cardium strain BC chromosome, complete genome	blastn	139722	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium

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