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

15 rows where analysis = "blastn", bioproject = "PRJNA401346" 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
2356514	2356514	PRJNA401346_P_NODE_1862_length_359_cov_1.738255_g1841_i0	PRJNA401346	1862	359	1.738255	6.24033545	Fluviicola	332102	Bacteria	Bacteria	562	1.27e-155	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g1841	i0	94.986	256.729805013928	359	16	100	2	1	359	707	351	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	92166	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
5518037	5518037	PRJNA401346_P_NODE_565_length_614_cov_2.144665_g544_i0	PRJNA401346	565	614	2.144665	13.1682431	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	800	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g544	i0	91.122	482.92345276873	597	44	99	6	21	614	217657	217067	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	296515	800	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
8733929	8733929	PRJNA401346_P_NODE_947_length_478_cov_1.683453_g926_i0	PRJNA401346	947	478	1.683453	8.04690534	Flavobacterium	237	Bacteria	Bacteria	822	0	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g926	i0	97.704	465.445606694561	479	10	100	1	1	478	718257	717779	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	222483	822	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
10009161	10009161	PRJNA401346_P_NODE_108_length_1266_cov_1.982573_g100_i0	PRJNA401346	108	1266	1.982573	25.09937418	Fluviicola	332102	Bacteria	Bacteria	1720	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g100	i0	91.287	409.650078988942	1274	92	100	14	1	1266	519	1781	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	518617	1720	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
10618141	10618141	PRJNA401346_P_NODE_3849_length_269_cov_0.923077_g3828_i0	PRJNA401346	3849	269	0.923077	2.48307713	Candidatus Pedobacter colombiensis	3121371	Bacteria	Bacteria	460	3.45e-125	NTclustered	gi\|2457514890\|gb\|CP119313.1\|	3121371	g3828	i0	99.219	328.657992565056	256	1	95	1	15	269	5517	5262	MAG: Candidatus Pedobacter colombiensis isolate MAG_3858 chromosome, complete genome	blastn	88409	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Candidatus Pedobacter colombiensis
12559766	12559766	PRJNA401346_P_NODE_110_length_1265_cov_1.891196_g100_i1	PRJNA401346	110	1265	1.891196	23.9236294	Fluviicola	332102	Bacteria	Bacteria	1775	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g100	i1	92.072	437.321739130435	1274	81	100	15	1	1265	519	1781	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	553212	1775	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
13167983	13167983	PRJNA401346_P_NODE_3591_length_276_cov_0.944186_g3570_i0	PRJNA401346	3591	276	0.944186	2.60595336	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	396	1.02e-105	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g3570	i0	92.701	545.539855072464	274	20	99	0	1	274	786304	786577	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	150569	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
16383484	16383484	PRJNA401346_P_NODE_1533_length_390_cov_1.167173_g1512_i0	PRJNA401346	1533	390	1.167173	4.5519747	Weeksellaceae	2762318	Bacteria	Bacteria	686	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1512	i0	98.705	483.320512820513	386	5	99	0	1	386	2158283	2158668	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	188495	691	0.992764109985528	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
16991882	16991882	PRJNA401346_P_NODE_8694_length_201_cov_0.914286_g8673_i0	PRJNA401346	8694	201	0.914286	1.83771486	Pedobacter heparinus	984	Bacteria	Bacteria	171	4.6299999999999996e-38	NTclustered	gi\|255342900\|gb\|CP001681.1\|	485917	g8673	i0	86.164	0.791044776119403	159	20	79	2	44	201	1724739	1724896	Pedobacter heparinus DSM 2366, complete genome	blastn	159	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
18265805	18265805	PRJNA401346_P_NODE_2035_length_347_cov_1.951049_g2014_i0	PRJNA401346	2035	347	1.951049	6.77014003	Flavobacterium sp. N1994	2986827	Bacteria	Bacteria	531	3.4599999999999992e-146	NTclustered	gi\|2324023692\|gb\|CP109999.1\|	2986827	g2014	i0	94.236	716.780979827089	347	20	100	0	1	347	903425	903771	Flavobacterium sp. N1994 chromosome, complete genome	blastn	248723	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1994
18265956	18265956	PRJNA401346_P_NODE_755_length_530_cov_1.371002_g734_i0	PRJNA401346	755	530	1.371002	7.2663106	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	610	6.84e-170	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g734	i0	88.583	251.309433962264	508	51	95	7	1	504	359553	359049	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	133194	610	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
19540107	19540107	PRJNA401346_P_NODE_7596_length_205_cov_0.888889_g7575_i0	PRJNA401346	7596	205	0.888889	1.82222245	Chryseobacterium gambrini	373672	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g7575	i0	100	94.8731707317073	205	0	100	0	1	205	526531	526327	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	19449	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
22758034	22758034	PRJNA401346_P_NODE_2738_length_307_cov_1.308943_g2717_i0	PRJNA401346	2738	307	1.308943	4.01845501	Fluviicola	332102	Bacteria	Bacteria	534	2.33e-147	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g2717	i0	98.046	268.918566775244	307	6	100	0	1	307	2461	2155	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	82558	534	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
23366229	23366229	PRJNA401346_P_NODE_1219_length_429_cov_1.437500_g1198_i0	PRJNA401346	1219	429	1.4375	6.166875	Flavobacterium channae	2897181	Bacteria	Bacteria	344	6.1e-90	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g1198	i0	88.055	362.21678321678303	293	32	68	3	103	393	486073	485782	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	155391	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
23366236	23366236	PRJNA401346_P_NODE_1399_length_403_cov_1.061404_g1378_i0	PRJNA401346	1399	403	1.061404	4.27745812	Pedobacter sp. KACC 23697	3149230	Bacteria	Bacteria	617	3.0399999999999997e-172	NTclustered	gi\|2739540447\|gb\|CP157485.1\|	3149230	g1378	i0	95.385	376.54094292804	390	14	100	4	16	403	13949	13562	Pedobacter sp. KACC 23697 chromosome, complete genome	blastn	151746	617	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. KACC 23697

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