metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA485080" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA485080" 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
449035	449035	PRJNA485080_P_NODE_16001_length_286_cov_1.084507_g15907_i0	PRJNA485080	16001	286	1.084507	3.10169002	Tenacibaculum maritimum	107401	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2863875894\|gb\|CP137255.1\|	107401	g15907	i0	100	3.03496503496504	28	0	10	0	92	119	1352266	1352239	Tenacibaculum maritimum strain CCCM 101 chromosome, complete genome	blastn	868	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum maritimum
1723800	1723800	PRJNA485080_P_NODE_24122_length_250_cov_0.870056_g24028_i0	PRJNA485080	24122	250	0.870056	2.17514	Flavobacterium azooxidireducens	1871076	Bacteria	Bacteria	388	1.5199999999999998e-103	NTclustered	gi\|2232519123\|gb\|CP096205.1\|	1871076	g24028	i0	95.122	9.344	246	12	98	0	5	250	1621981	1621736	Flavobacterium azooxidireducens strain IGB 4-14 chromosome, complete genome	blastn	2336	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium azooxidireducens
1723929	1723929	PRJNA485080_P_NODE_33642_length_246_cov_0.890173_g33548_i0	PRJNA485080	33642	246	0.890173	2.18982558	uncultured Allomuricauda sp.	622614	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2893358458\|emb\|OZ220751.1\|	622614	g33548	i0	100	0.113821138211382	28	0	11	0	107	134	1075752	1075779	MAG: uncultured Allomuricauda sp. isolate c4ee9e33-ed4c-4824-ad75-49ddbc269399 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Allomuricauda	uncultured Allomuricauda sp.
3000064	3000064	PRJNA485080_P_NODE_3723_length_485_cov_2.825243_g3629_i0	PRJNA485080	3723	485	2.825243	13.70242855	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	802	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g3629	i0	96.509	256.534020618557	487	13	100	3	1	485	2978007	2978491	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	124419	802	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
3000170	3000170	PRJNA485080_P_NODE_5743_length_403_cov_2.657576_g5649_i0	PRJNA485080	5743	403	2.657576	10.71003128	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	601	3.0599999999999998e-167	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g5649	i0	93.58	250.550868486352	405	22	100	4	1	403	2977648	2978050	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	100972	601	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
3648538	3648538	PRJNA485080_P_NODE_33083_length_246_cov_0.890173_g32989_i0	PRJNA485080	33083	246	0.890173	2.18982558	Bacteroides	816	Bacteria	Bacteria	183	7.549999999999997e-42	NTclustered	gi\|2202814649\|gb\|CP092641.1\|	818	g32989	i0	80.738	54.4878048780488	244	39	98	7	7	246	1448031	1447792	Bacteroides thetaiotaomicron strain VPI 5482 chromosome, complete genome	blastn	13404	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides thetaiotaomicron
6826862	6826862	PRJNA485080_P_NODE_36746_length_244_cov_0.900585_g36652_i0	PRJNA485080	36746	244	0.900585	2.1974274	Flavobacterium crocinum	2183896	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1389162878\|gb\|CP029255.1\|	2183896	g36652	i0	100	0.114754098360656	28	0	11	0	145	172	2864412	2864385	Flavobacterium crocinum strain HYN0056 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium crocinum
8102390	8102390	PRJNA485080_P_NODE_39387_length_243_cov_0.905882_g39293_i0	PRJNA485080	39387	243	0.905882	2.20129326	Muribaculum gordoncarteri	2530390	Bacteria	Bacteria	217	7.34e-52	NTclustered	gi\|1622715784\|gb\|CP039393.1\|	2530390	g39293	i0	82.857	9.46913580246914	245	39	100	3	1	243	2288544	2288301	Muribaculum gordoncarteri strain TLL-A4 chromosome	blastn	2301	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Muribaculum	Muribaculum gordoncarteri
8750379	8750379	PRJNA485080_P_NODE_9367_length_342_cov_2.851301_g9273_i0	PRJNA485080	9367	342	2.851301	9.75144942	Sediminibacterium	504481	Bacteria	Bacteria	580	3.329999999999999e-161	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g9273	i0	97.384	242.06432748538	344	4	100	5	1	342	55295	54955	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	82786	580	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
9376726	9376726	PRJNA485080_P_NODE_11288_length_323_cov_1.040000_g11194_i0	PRJNA485080	11288	323	1.04	3.3592	Segatella copri	165179	Bacteria	Bacteria	69.4	3.01e-7	NTclustered	gi\|1906888224\|gb\|CP042464.1\|	165179	g11194	i0	89.286	0.442724458204334	56	4	17	2	254	308	1040841	1040787	Segatella copri strain YF2 chromosome	blastn	143	69.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
13203013	13203013	PRJNA485080_P_NODE_4831_length_434_cov_1.775623_g4737_i0	PRJNA485080	4831	434	1.775623	7.70620382	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	769	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g4737	i0	98.618	272.569124423963	434	6	100	0	1	434	2980292	2979859	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	118295	769	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
15751860	15751860	PRJNA485080_P_NODE_30353_length_247_cov_0.885057_g30259_i0	PRJNA485080	30353	247	0.885057	2.18609079	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	58.4	4.8e-4	NTclustered	gi\|2919513563\|emb\|OZ238267.1\|	1871037	g30259	i0	100	0.125506072874494	31	0	13	0	206	236	937746	937776	MAG: Flavobacteriaceae bacterium isolate 09b6b137-068c-45fe-842c-bd307207bc05 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
17026465	17026465	PRJNA485080_P_NODE_30994_length_247_cov_0.885057_g30900_i0	PRJNA485080	30994	247	0.885057	2.18609079	Cloacibacterium caeni	2004710	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g30900	i0	97.166	13.6761133603239	247	7	100	0	1	247	774412	774658	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	3378	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
18300621	18300621	PRJNA485080_P_NODE_18875_length_267_cov_1.520619_g18781_i0	PRJNA485080	18875	267	1.520619	4.06005273	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1958081313\|gb\|CP064999.1\|	2044944	g18781	i0	100	0.104868913857678	28	0	10	0	56	83	5762650	5762623	Sphingobacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.067_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
23401192	23401192	PRJNA485080_P_NODE_11119_length_324_cov_3.067729_g11025_i0	PRJNA485080	11119	324	3.067729	9.93944196	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	436	7.1899999999999985e-118	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g11025	i0	91.022	160.237654320988	323	29	99	0	1	323	1672405	1672727	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	51917	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans

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