metadata: contig_metadata: 28 rows where bioproject = "PRJNA588137" and tax

28 rows where bioproject = "PRJNA588137" 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
564808	564808	PRJNA588137_S_NODE_7441_length_249_cov_0.875000_g7408_i0	PRJNA588137	7441	249	0.875	2.17875	Porphyromonas pogonae	867595	Bacteria	Bacteria	165	2.77e-36	NTclustered	gi\|2665661841\|gb\|CP143258.1\|	867595	g7408	i0	84.211	5.10843373493976	171	25	68	1	77	245	307667	307497	Porphyromonas pogonae strain PP01-1 chromosome, complete genome	blastn	1272	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pogonae
1840269	1840269	PRJNA588137_S_NODE_3582_length_304_cov_1.333333_g3549_i0	PRJNA588137	3582	304	1.333333	4.05333232	Bacteroidota bacterium	1898104	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2916445283\|gb\|CP170458.1\|	1898104	g3549	i0	100	1.41118421052632	30	0	10	0	45	74	231532	231503	MAG: Bacteroidota bacterium isolate tig00000052 chromosome, complete genome	blastn	429	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
1840294	1840294	PRJNA588137_S_NODE_6582_length_251_cov_0.865169_g6549_i0	PRJNA588137	6582	251	0.865169	2.17157419	Spirosoma rhododendri	2728024	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g6549	i0	100	0.111553784860558	28	0	11	0	22	49	3975849	3975822	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
4392300	4392300	PRJNA588137_S_NODE_9064_length_245_cov_0.895349_g9031_i0	PRJNA588137	9064	245	0.895349	2.19360505	Capnocytophaga granulosa	45242	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g9031	i0	98.367	2	245	4	100	0	1	245	428494	428250	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	490	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
5668532	5668532	PRJNA588137_S_NODE_9905_length_243_cov_0.905882_g9872_i0	PRJNA588137	9905	243	0.905882	2.20129326	Porphyromonas catoniae	41976	Bacteria	Bacteria	169	1.49e-49	NR	WP_005469261.1	41976	g9872	i0	100	3	81	0	100	0	243	1	140	220	WP_005469261.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Porphyromonas catoniae]	diamond	729	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas catoniae
9493225	9493225	PRJNA588137_S_NODE_9008_length_245_cov_0.895349_g8975_i0	PRJNA588137	9008	245	0.895349	2.19360505	Chryseobacterium gambrini	373672	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g8975	i0	99.592	45.1102040816327	245	1	100	0	1	245	136312	136556	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	11052	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
12043850	12043850	PRJNA588137_S_NODE_10790_length_242_cov_0.911243_g10757_i0	PRJNA588137	10790	242	0.911243	2.20520806	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|1527179843\|gb\|CP034173.1\|	536441	g10757	i0	95.885	10.8347107438017	243	9	100	1	1	242	1447896	1448138	Chryseobacterium taklimakanense strain F9257 chromosome, complete genome	blastn	2622	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
13892521	13892521	PRJNA588137_S_NODE_4511_length_283_cov_2.247619_g4478_i0	PRJNA588137	4511	283	2.247619	6.36076177	Flavobacterium	237	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g4478	i0	100	357.56890459364	283	0	100	0	1	283	718697	718415	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	101192	523	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
16441228	16441228	PRJNA588137_S_NODE_6193_length_253_cov_1.266667_g6160_i0	PRJNA588137	6193	253	1.266667	3.20466751	Tenacibaculum	104267	Bacteria	Bacteria	191	4.66e-44	NTclustered	gi\|1231648903\|emb\|LT899436.1\|	584609	g6160	i0	80.392	87.802371541502	255	46	100	4	1	253	1535460	1535208	Tenacibaculum jejuense strain KCTC 22618(T) genome assembly, chromosome: TJEJU	blastn	22214	191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum jejuense
17716410	17716410	PRJNA588137_S_NODE_8854_length_246_cov_0.890173_g8821_i0	PRJNA588137	8854	246	0.890173	2.18982558	Weeksellaceae	2762318	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g8821	i0	100	421.894308943089	246	0	100	0	1	246	167697	167452	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	103786	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
18989821	18989821	PRJNA588137_S_NODE_1735_length_385_cov_1.839744_g1702_i0	PRJNA588137	1735	385	1.839744	7.0830144	Flavobacterium	237	Bacteria	Bacteria	712	0	NTclustered	gi\|1608347023\|gb\|MK757666.1\|	239	g1702	i0	100	107.919480519481	385	0	100	0	1	385	365	749	Flavobacterium sp. strain 816OP8 16S ribosomal RNA gene, partial sequence	blastn	41549	712	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
20265021	20265021	PRJNA588137_S_NODE_7116_length_250_cov_0.870056_g7083_i0	PRJNA588137	7116	250	0.870056	2.17514	Prevotella	838	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2127636518\|gb\|CP085943.1\|	28132	g7083	i0	98.8	11	250	3	100	0	1	250	1119584	1119335	Prevotella melaninogenica strain FDAARGOS_1566 chromosome 2, complete sequence	blastn	2750	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
22241895	22241895	PRJNA588137_S_NODE_718_length_547_cov_2.447257_g686_i0	PRJNA588137	718	547	2.447257	13.38649579	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	1011	0	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g686	i0	100	451.283363802559	547	0	100	0	1	547	105083	104537	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	246852	1011	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
23517104	23517104	PRJNA588137_S_NODE_10859_length_241_cov_1.750000_g10826_i0	PRJNA588137	10859	241	1.75	4.2175	Flavobacterium cerinum	2502784	Bacteria	Bacteria	177	2.1e-52	NR	WP_128390300.1	2502784	g10826	i0	94.9	0.983402489626556	79	4	98.3	0	1	237	306	384	WP_128390300.1 ergothioneine biosynthesis protein EgtB [Flavobacterium cerinum]	diamond	237	177	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
26921492	26921492	PRJNA588137_S_NODE_8802_length_246_cov_0.890173_g8769_i0	PRJNA588137	8802	246	0.890173	2.18982558	Bacteroidota bacterium	1898104	Bacteria	Bacteria	100	1.37e-24	NR	MBS1656041.1	1898104	g8769	i0	65.3	0.878048780487805	72	25	87.8	0	242	27	41	112	MBS1656041.1 hypothetical protein [Bacteroidota bacterium]	diamond	216	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26966549	26966549	PRJNA588137_S_NODE_11302_length_241_cov_0.916667_g11269_i0	PRJNA588137	11302	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	77.4	1.54e-15	NR	WP_013407084.1	316068	g11269	i0	46.1	12.0871369294606	76	41	94.6	0	241	14	35	110	WP_013407084.1 NUDIX domain-containing protein [Leadbetterella byssophila]	diamond	2913	77.8	0.994858611825193	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Leadbetterella	Leadbetterella byssophila
27048116	27048116	PRJNA588137_S_NODE_8442_length_247_cov_0.867816_g8409_i0	PRJNA588137	8442	247	0.867816	2.14350552	Flavobacterium rhizophilum	3163296	Bacteria	Bacteria	96.7	2.4600000000000003e-21	NR	WP_408073799.1	3163296	g8409	i0	64.9	0.898785425101215	74	26	89.9	0	3	224	49	122	WP_408073799.1 conjugative transposon protein TraM [Flavobacterium rhizophilum]	diamond	222	96.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium rhizophilum
27806415	27806415	PRJNA588137_S_NODE_2884_length_325_cov_0.916667_g2851_i0	PRJNA588137	2884	325	0.916667	2.97916775	Prevotella sp. P3-12	59823	Bacteria	Bacteria	71.6	4.35e-14	NR	WP_216822835.1	2024220	g2851	i0	91.4	0.323076923076923	35	3	32.3	0	61	165	3	37	WP_216822835.1 hypothetical protein, partial [Prevotella sp. P3-120]	diamond	105	71.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. P3-120
28279619	28279619	PRJNA588137_S_NODE_9546_length_244_cov_0.900585_g9513_i0	PRJNA588137	9546	244	0.900585	2.1974274	Pedobacter xixiisoli	1476464	Bacteria	Bacteria	148	5.72e-41	NR	WP_097133315.1	1476464	g9513	i0	93.8	1.99180327868852	81	5	99.6	0	1	243	238	318	WP_097133315.1 class I SAM-dependent rRNA methyltransferase [Pedobacter xixiisoli]	diamond	486	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter xixiisoli
29542695	29542695	PRJNA588137_S_NODE_5070_length_272_cov_1.487437_g5037_i0	PRJNA588137	5070	272	1.487437	4.04582864	Bizionia paragorgiae	283786	Bacteria	Bacteria	43.1	0.0285	NR	WP_092133343.1	283786	g5037	i0	45.5	0.606617647058823	55	29	59.6	1	110	271	69	123	WP_092133343.1 glycoside hydrolase family 19 protein [Bizionia paragorgiae]	diamond	165	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Bizionia	Bizionia paragorgiae
29984949	29984949	PRJNA588137_S_NODE_8671_length_246_cov_0.890173_g8638_i0	PRJNA588137	8671	246	0.890173	2.18982558	Fluviicola sp.	1917219	Bacteria	Bacteria	45.1	0.00541	NR	HRP53004.1	1917219	g8638	i0	68.6	0.426829268292683	35	11	42.7	0	105	1	1	35	HRP53004.1 glycosyltransferase [Fluviicola sp.]	diamond	105	45.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola sp.
30016606	30016606	PRJNA588137_S_NODE_9571_length_244_cov_0.900585_g9538_i0	PRJNA588137	9571	244	0.900585	2.1974274	Flavobacterium cerinum	2502784	Bacteria	Bacteria	132	7.339999999999998e-35	NR	WP_128389844.1	2502784	g9538	i0	84.4	0.94672131147541	77	12	94.7	0	2	232	236	312	WP_128389844.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Flavobacterium cerinum]	diamond	231	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
30187850	30187850	PRJNA588137_S_NODE_7832_length_248_cov_0.880000_g7799_i0	PRJNA588137	7832	248	0.88	2.1824	Spirosoma	107	Bacteria	Bacteria	78.2	1.3e-14	NR	WP_018620097.1	431553	g7799	i0	94.9	2.83064516129032	39	2	47.2	0	246	130	582	620	WP_018620097.1 ABC transporter ATP-binding protein [Spirosoma luteum]	diamond	702	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma luteum
30364464	30364464	PRJNA588137_S_NODE_9232_length_245_cov_0.895349_g9199_i0	PRJNA588137	9232	245	0.895349	2.19360505	Chryseobacterium sp. G	1871047	Bacteria	Bacteria	130	7.37e-33	NR	WP_123942433.1	2487064	g9199	i0	76.3	0.979591836734694	80	19	98	0	244	5	1978	2057	WP_123942433.1 polymorphic toxin type 23 domain-containing protein [Chryseobacterium sp. G0186]	diamond	240	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. G0186
31153566	31153566	PRJNA588137_S_NODE_8115_length_247_cov_0.885057_g8082_i0	PRJNA588137	8115	247	0.885057	2.18609079	Sediminibacterium sp.	1917865	Bacteria	Bacteria	59.3	5.23e-8	NR	HEX7692709.1	1917865	g8082	i0	41.1	0.88663967611336	73	39	83.8	1	232	26	59	131	HEX7692709.1 hypothetical protein [Sediminibacterium sp.]	diamond	219	59.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp.
31185249	31185249	PRJNA588137_S_NODE_7555_length_249_cov_0.875000_g7522_i0	PRJNA588137	7555	249	0.875	2.17875	Taibaiella chishuiensis	1434707	Bacteria	Bacteria	153	7.61e-46	NR	WP_281257984.1	1434707	g7522	i0	96.3	0.987951807228916	82	3	98.8	0	247	2	15	96	WP_281257984.1 helix-turn-helix domain-containing protein [Taibaiella chishuiensis]	diamond	246	153	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Taibaiella	Taibaiella chishuiensis
31343711	31343711	PRJNA588137_S_NODE_6696_length_251_cov_0.865169_g6663_i0	PRJNA588137	6696	251	0.865169	2.17157419	Flavobacterium cerinum	2502784	Bacteria	Bacteria	165	3.07e-45	NR	WP_206619124.1	2502784	g6663	i0	94	0.99203187250996006	83	5	99.2	0	3	251	678	760	WP_206619124.1 T9SS type B sorting domain-containing protein [Flavobacterium cerinum]	diamond	249	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
32640110	32640110	PRJNA588137_S_NODE_10040_length_243_cov_0.905882_g10007_i0	PRJNA588137	10040	243	0.905882	2.20129326	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	110	4.1e-28	NR	RYF45007.1	2026729	g10007	i0	63.6	1.08641975308642	88	25	100	1	243	1	7	94	RYF45007.1 MAG: ATP-binding cassette domain-containing protein, partial [Cytophagaceae bacterium]	diamond	264	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium

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