metadata: contig_metadata: 19 rows where bioproject = "PRJNA1065838" and tax

19 rows where bioproject = "PRJNA1065838" 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
1012631	1012631	PRJNA1065838_S_NODE_33061_length_167_cov_0.864407_g32959_i0	PRJNA1065838	33061	167	0.864407	1.44355969	Bacteroidota	976	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g32959	i0	100	3.93413173652695	167	0	100	0	1	167	145080	145246	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	657	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
4006538	4006538	PRJNA1065838_S_NODE_32284_length_168_cov_0.907563_g32182_i0	PRJNA1065838	32284	168	0.907563	1.52470584	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	237	3.63e-58	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g32182	i0	92.308	2.00595238095238	169	9	99	4	2	168	2650550	2650384	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	337	237	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
5282983	5282983	PRJNA1065838_S_NODE_7265_length_280_cov_2.134199_g7163_i0	PRJNA1065838	7265	280	2.134199	5.9757572	Bacteroides fragilis	817	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2323343196\|gb\|CP083688.1\|	817	g7163	i0	100	1.40357142857143	29	0	10	0	252	280	4505790	4505818	Bacteroides fragilis strain DH4096B chromosome	blastn	393	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
6115991	6115991	PRJNA1065838_S_NODE_9125_length_256_cov_0.990338_g9023_i0	PRJNA1065838	9125	256	0.990338	2.53526528	Weeksellaceae	2762318	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|1497470369\|gb\|CP023540.1\|	2039166	g9023	i0	100	76.46484375	256	0	100	0	1	256	899419	899674	Chryseobacterium sp. 6424 chromosome, complete genome	blastn	19575	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 6424
9107617	9107617	PRJNA1065838_S_NODE_20348_length_201_cov_1.006579_g20246_i0	PRJNA1065838	20348	201	1.006579	2.02322379	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	322	1.21e-83	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g20246	i0	95.522	80.4228855721393	201	9	100	0	1	201	588436	588636	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	16165	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
11216044	11216044	PRJNA1065838_S_NODE_34429_length_165_cov_0.870690_g34327_i0	PRJNA1065838	34429	165	0.87069	1.4366385	Weeksellaceae	2762318	Bacteria	Bacteria	270	3.4999999999999993e-68	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g34327	i0	96.341	96.1030303030303	164	6	99	0	1	164	2164445	2164282	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	15857	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
11658542	11658542	PRJNA1065838_S_NODE_11470_length_234_cov_2.156757_g11368_i0	PRJNA1065838	11470	234	2.156757	5.04681138	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	399	6.499999999999999e-107	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g11368	i0	97.436	17.457264957265	234	6	100	0	1	234	2759203	2758970	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	4085	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
11658738	11658738	PRJNA1065838_S_NODE_36310_length_162_cov_0.920354_g36208_i0	PRJNA1065838	36310	162	0.920354	1.49097348	Hymenobacter volaticus	2932254	Bacteria	Bacteria	209	7.56e-50	NTclustered	gi\|2221929187\|gb\|CP095061.1\|	2932254	g36208	i0	90.062	10.9938271604938	161	16	99	0	1	161	1612403	1612563	Hymenobacter volaticus strain 5420 S-77 chromosome, complete genome	blastn	1781	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter volaticus
12933860	12933860	PRJNA1065838_S_NODE_34971_length_164_cov_0.904348_g34869_i0	PRJNA1065838	34971	164	0.904348	1.48313072	Pedobacter aquae	2605747	Bacteria	Bacteria	128	2.21e-25	NTclustered	gi\|1733060322\|gb\|CP043329.1\|	2605747	g34869	i0	80.864	2.41463414634146	162	31	99	0	3	164	2140424	2140263	Pedobacter aquae strain CJ43 chromosome, complete genome	blastn	396	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter aquae
15040485	15040485	PRJNA1065838_S_NODE_7472_length_277_cov_1.105263_g7370_i0	PRJNA1065838	7472	277	1.105263	3.06157851	Bacteroidota	976	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|1943023671\|gb\|CP065590.1\|	253	g7370	i0	99.639	7.70758122743682	277	1	100	0	1	277	2360629	2360353	Chryseobacterium indologenes strain DSM 16777 chromosome, complete genome	blastn	2135	507	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
16756890	16756890	PRJNA1065838_S_NODE_15794_length_215_cov_0.915663_g15692_i0	PRJNA1065838	15794	215	0.915663	1.96867545	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	326	1.01e-84	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g15692	i0	97.872	1.73488372093023	188	4	87	0	28	215	1397196	1397009	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	373	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
18031785	18031785	PRJNA1065838_S_NODE_28575_length_177_cov_0.859375_g28473_i0	PRJNA1065838	28575	177	0.859375	1.52109375	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	294	2.25e-75	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g28473	i0	96.61	3.95480225988701	177	6	100	0	1	177	1779589	1779413	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	700	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
18863956	18863956	PRJNA1065838_S_NODE_19035_length_205_cov_1.410256_g18933_i0	PRJNA1065838	19035	205	1.410256	2.8910248	Weeksellaceae	2762318	Bacteria	Bacteria	377	2.6e-100	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g18933	i0	100	32.9560975609756	204	0	99	0	2	205	872977	873180	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	6756	379	0.994722955145119	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
21856976	21856976	PRJNA1065838_S_NODE_5298_length_319_cov_1.062963_g5196_i0	PRJNA1065838	5298	319	1.062963	3.39085197	Chryseobacterium sp. C-71	2893882	Bacteria	Bacteria	510	4.11e-140	NTclustered	gi\|2153927454\|gb\|CP087131.1\|	2893882	g5196	i0	97.959	4.73354231974922	294	6	92	0	26	319	1185399	1185106	Chryseobacterium sp. C-71 chromosome, complete genome	blastn	1510	510	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. C-71
23965081	23965081	PRJNA1065838_S_NODE_35759_length_163_cov_0.885965_g35657_i0	PRJNA1065838	35759	163	0.885965	1.44412295	Elizabethkingia	308865	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1601534959\|tpg\|BK010610.1\|	1117645	g35657	i0	98.773	99.1411042944785	163	2	100	0	1	163	41843	41681	TPA_exp: Elizabethkingia anophelis integrative and conjugative element ICEEaIII(5)_NUHP1 genomic sequence	blastn	16160	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
23965238	23965238	PRJNA1065838_S_NODE_8399_length_265_cov_1.064815_g8297_i0	PRJNA1065838	8399	265	1.064815	2.82175975	Chryseobacterium	59732	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g8297	i0	100	476.445283018868	265	0	100	0	1	265	1758158	1757894	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	126258	490	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
23965272	23965272	PRJNA1065838_S_NODE_9499_length_252_cov_1.729064_g9397_i0	PRJNA1065838	9499	252	1.729064	4.35724128	Bacteroidota	976	Bacteria	Bacteria	444	3.2299999999999996e-120	NTclustered	gi\|1943023671\|gb\|CP065590.1\|	253	g9397	i0	98.413	6.96428571428571	252	4	100	0	1	252	2360715	2360966	Chryseobacterium indologenes strain DSM 16777 chromosome, complete genome	blastn	1755	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
27888280	27888280	PRJNA1065838_S_NODE_17785_length_209_cov_0.975000_g17683_i0	PRJNA1065838	17785	209	0.975	2.03775	Flavobacterium rhizophilum	3163296	Bacteria	Bacteria	120	1.49e-32	NR	WP_408076268.1	3163296	g17683	i0	100	0.904306220095694	63	0	90.4	0	3	191	109	171	WP_408076268.1 hypothetical protein, partial [Flavobacterium rhizophilum]	diamond	189	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium rhizophilum
31955296	31955296	PRJNA1065838_S_NODE_24097_length_191_cov_1.098592_g23995_i0	PRJNA1065838	24097	191	1.098592	2.09831072	Pseudomonadati	3379134	Bacteria	Bacteria	113	7.659999999999999e-31	NR	PAM92647.1	2026304	g23995	i0	100	1.63350785340314	52	0	81.7	0	191	36	59	110	PAM92647.1 hypothetical protein B4N84_22100, partial [Flavobacterium sp. IR1]	diamond	312	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. IR1

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