metadata: contig_metadata: 12 rows where bioproject = "PRJNA816527" and tax

12 rows where bioproject = "PRJNA816527" 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
3370168	3370168	PRJNA816527_P_NODE_13943_length_281_cov_1.480769_g13893_i0	PRJNA816527	13943	281	1.480769	4.16096089	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	451	2.19e-122	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g13893	i0	95.714	292.626334519573	280	12	99	0	1	280	2089	1810	Pedobacter sp. SL55 chromosome	blastn	82228	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
4647852	4647852	PRJNA816527_P_NODE_19124_length_245_cov_0.895349_g19074_i0	PRJNA816527	19124	245	0.895349	2.19360505	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g19074	i0	100	367.673469387755	245	0	100	0	1	245	807180	806936	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	90080	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
5922623	5922623	PRJNA816527_P_NODE_16705_length_251_cov_1.460674_g16655_i0	PRJNA816527	16705	251	1.460674	3.66629174	Pseudomonadati	3379134	Bacteria	Bacteria	128	2.15e-34	NR	MDQ8036280.1	1411316	g16655	i0	88.3	1.8406374501992	77	9	92	0	5	235	128	204	MDQ8036280.1 M48 family metallopeptidase [Pedobacter sp.]	diamond	462	129	0.992248062015504	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp.
6332054	6332054	PRJNA816527_P_NODE_20225_length_242_cov_0.911243_g20175_i0	PRJNA816527	20225	242	0.911243	2.20520806	Chryseobacterium	59732	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1519503470\|gb\|CP033928.1\|	254	g20175	i0	100	474.851239669421	242	0	100	0	1	242	1185115	1185356	Chryseobacterium indoltheticum strain G0211 chromosome, complete genome	blastn	114914	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indoltheticum
10156447	10156447	PRJNA816527_P_NODE_11948_length_304_cov_2.246753_g11898_i0	PRJNA816527	11948	304	2.246753	6.83012912	Flavobacterium	237	Bacteria	Bacteria	385	2.46e-102	NTclustered	gi\|1481170622\|gb\|CP023642.1\|	459526	g11898	i0	89.474	535.996710526316	304	32	100	0	1	304	1125431	1125734	Flavobacterium anhuiense strain M168 chromosome, complete genome	blastn	162943	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium anhuiense
10156502	10156502	PRJNA816527_P_NODE_3428_length_548_cov_2.338947_g3378_i0	PRJNA816527	3428	548	2.338947	12.81742956	Flavobacterium	237	Bacteria	Bacteria	880	0	NTclustered	gi\|2447257787\|gb\|CP092822.1\|	1454066	g3378	i0	95.62	438.027372262774	548	24	100	0	1	548	1450609	1451156	Flavobacterium sp. WW92 chromosome, complete genome	blastn	240039	880	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WW92
12298681	12298681	PRJNA816527_P_NODE_19770_length_243_cov_0.905882_g19720_i0	PRJNA816527	19770	243	0.905882	2.20129326	Chryseobacterium indologenes	253	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1158824264\|gb\|CP018786.1\|	253	g19720	i0	100	515.851851851852	243	0	100	0	1	243	457417	457175	Chryseobacterium indologenes strain AA5 chromosome, complete genome	blastn	125352	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
15256035	15256035	PRJNA816527_P_NODE_6892_length_392_cov_1.376176_g6842_i0	PRJNA816527	6892	392	1.376176	5.39460992	Myroides	76831	Bacteria	Bacteria	697	0	NTclustered	gi\|2636494101\|gb\|CP139975.1\|	256	g6842	i0	98.724	685.474489795918	392	5	100	0	1	392	484489	484880	Myroides odoratus strain HAMBI_1923 chromosome, complete genome	blastn	268706	697	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratus
16122061	16122061	PRJNA816527_P_NODE_18593_length_246_cov_1.404624_g18543_i0	PRJNA816527	18593	246	1.404624	3.45537504	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	147	9.909999999999998e-31	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g18543	i0	83.974	52.390243902439	156	21	63	4	48	201	1131534	1131687	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	12888	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
19079554	19079554	PRJNA816527_P_NODE_14535_length_275_cov_1.450495_g14485_i0	PRJNA816527	14535	275	1.450495	3.98886125	Flavobacterium	237	Bacteria	Bacteria	350	8e-92	NTclustered	gi\|2447257787\|gb\|CP092822.1\|	1454066	g14485	i0	90.805	1.89818181818182	261	24	95	0	1	261	3764135	3763875	Flavobacterium sp. WW92 chromosome, complete genome	blastn	522	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WW92
24179619	24179619	PRJNA816527_P_NODE_18159_length_247_cov_2.551724_g18109_i0	PRJNA816527	18159	247	2.551724	6.30275828	Flavobacterium	237	Bacteria	Bacteria	405	1.49e-108	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g18109	i0	96.341	476.206477732794	246	9	99	0	2	247	717924	718169	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	117623	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
27433928	27433928	PRJNA816527_P_NODE_6603_length_399_cov_2.340491_g6553_i0	PRJNA816527	6603	399	2.340491	9.33855909	Phocaeicola vulgatus	821	Bacteria	Bacteria	134	1.21e-37	NR	WP_050229787.1	821	g6553	i0	99.2	0.954887218045113	127	1	95.5	0	12	392	1	127	WP_050229787.1 hypothetical protein [Phocaeicola vulgatus]	diamond	381	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus

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