metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA694557" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA694557" 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
1949302	1949302	PRJNA694557_P_NODE_22802_length_255_cov_3.219780_g22582_i0	PRJNA694557	22802	255	3.21978	8.210439	Hymenobacter sp. NBH84	2596915	Bacteria	Bacteria	346	9.49e-91	NTclustered	gi\|1890952207\|gb\|CP043646.1\|	2596915	g22582	i0	95	3.72941176470588	220	11	86	0	13	232	73759	73540	Hymenobacter sp. NBH84 plasmid unnamed2, complete sequence	blastn	951	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. NBH84
1949358	1949358	PRJNA694557_P_NODE_25182_length_243_cov_3.000000_g24962_i0	PRJNA694557	25182	243	3	7.29	Myroides phaeus	702745	Bacteria	Bacteria	178	3.4599999999999993e-40	NTclustered	gi\|1787534517\|gb\|CP047050.1\|	702745	g24962	i0	82.126	2.58847736625514	207	37	85	0	24	230	2668712	2668918	Myroides phaeus strain 18QD1AZ29W chromosome, complete genome	blastn	629	178	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides phaeus
2454845	2454845	PRJNA694557_P_NODE_21622_length_265_cov_1.916667_g21402_i0	PRJNA694557	21622	265	1.916667	5.07916755	Blattabacterium	34098	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|507148310\|ref\|NR_103113.1\|	331104	g21402	i0	100	104.045283018868	265	0	100	0	1	265	2280	2544	Blattabacterium sp. (Blattella germanica) str. Bge strain Alboraia 23S ribosomal RNA, complete sequence	blastn	27572	490	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium sp. (Blattella germanica)
3224468	3224468	PRJNA694557_P_NODE_6303_length_578_cov_1.629703_g6084_i0	PRJNA694557	6303	578	1.629703	9.41968334	Chryseobacterium gambrini	373672	Bacteria	Bacteria	1040	0	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g6084	i0	99.135	32.961937716263	578	5	100	0	1	578	857571	858148	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	19052	1040	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
4501296	4501296	PRJNA694557_P_NODE_18824_length_290_cov_2.714286_g18604_i0	PRJNA694557	18824	290	2.714286	7.8714294	Spirosoma taeanense	2735870	Bacteria	Bacteria	348	3.06e-91	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g18604	i0	88.772	93.2931034482759	285	30	98	2	7	290	3383094	3382811	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	27055	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
4501375	4501375	PRJNA694557_P_NODE_23964_length_248_cov_2.891429_g23744_i0	PRJNA694557	23964	248	2.891429	7.17074392	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	211	3.5e-50	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g23744	i0	87.234	0.758064516129032	188	20	75	3	26	211	2033188	2033003	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	188	211	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
5776684	5776684	PRJNA694557_P_NODE_12365_length_377_cov_7.848684_g12145_i0	PRJNA694557	12365	377	7.848684	29.58953868	Cloacibacterium caeni	2004710	Bacteria	Bacteria	593	4.759999999999998e-165	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g12145	i0	96.901	3.76127320954907	355	10	94	1	24	377	1472700	1473054	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	1418	593	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
6283434	6283434	PRJNA694557_P_NODE_14365_length_344_cov_3.431734_g14145_i0	PRJNA694557	14365	344	3.431734	11.80516496	Hymenobacter	89966	Bacteria	Bacteria	630	3.289999999999999e-176	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g14145	i0	99.709	275.122093023256	344	1	100	0	1	344	273367	273024	Hymenobacter sp. DG01 chromosome, complete genome	blastn	94642	630	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
7051924	7051924	PRJNA694557_P_NODE_20366_length_276_cov_2.093596_g20146_i0	PRJNA694557	20366	276	2.093596	5.77832496	Kaistella haifensis	421525	Bacteria	Bacteria	427	3.61e-115	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g20146	i0	96.863	1.84782608695652	255	8	92	0	22	276	1365008	1364754	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	510	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
7557418	7557418	PRJNA694557_P_NODE_18346_length_295_cov_3.243243_g18126_i0	PRJNA694557	18346	295	3.243243	9.56756685	Hymenobacter	89966	Bacteria	Bacteria	444	3.87e-120	NTclustered	gi\|2221889893\|gb\|CP095058.1\|	2932253	g18126	i0	95.053	217.840677966102	283	13	96	1	10	291	1008155	1007873	Hymenobacter sp. 5516J-16 chromosome, complete genome	blastn	64263	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 5516J-16
8326284	8326284	PRJNA694557_P_NODE_11827_length_389_cov_1.993671_g11607_i0	PRJNA694557	11827	389	1.993671	7.75538019	Dysgonomonas sp. HDW5B	2714927	Bacteria	Bacteria	145	5.9599999999999994e-30	NTclustered	gi\|1821111738\|gb\|CP049858.1\|	2714927	g11607	i0	87.121	9.86375321336761	132	12	33	5	261	388	941267	941137	Dysgonomonas sp. HDW5B chromosome, complete genome	blastn	3837	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5B
8326362	8326362	PRJNA694557_P_NODE_17087_length_309_cov_3.576271_g16867_i0	PRJNA694557	17087	309	3.576271	11.05067739	Cloacibacterium caeni	2004710	Bacteria	Bacteria	505	1.8399999999999998e-138	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g16867	i0	98.27	14.7313915857605	289	4	93	1	1	288	415425	415137	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	4552	505	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
9601714	9601714	PRJNA694557_P_NODE_18288_length_296_cov_1.878924_g18068_i0	PRJNA694557	18288	296	1.878924	5.56161504	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	525	1.35e-144	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g18068	i0	98.649	1	296	4	100	0	1	296	3095402	3095697	Hymenobacter sp. DG01 chromosome, complete genome	blastn	296	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
10877290	10877290	PRJNA694557_P_NODE_16749_length_313_cov_2.862500_g16529_i0	PRJNA694557	16749	313	2.8625	8.959625	Cloacibacterium caeni	2004710	Bacteria	Bacteria	510	4.02e-140	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g16529	i0	97.643	12.9776357827476	297	7	95	0	1	297	562085	562381	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	4062	510	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
12659227	12659227	PRJNA694557_P_NODE_9530_length_445_cov_1.537634_g9310_i0	PRJNA694557	9530	445	1.537634	6.8424713	Hoylesella	2974257	Bacteria	Bacteria	363	1.75e-95	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g9310	i0	82.885	209.478651685393	409	65	91	4	17	422	211038	211444	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	93218	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
14702133	14702133	PRJNA694557_P_NODE_10252_length_425_cov_4.519886_g10032_i0	PRJNA694557	10252	425	4.519886	19.2095155	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	785	0	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g10032	i0	100	3.68	425	0	100	0	1	425	2297330	2297754	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	1564	785	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
14702149	14702149	PRJNA694557_P_NODE_11752_length_390_cov_6.908517_g11532_i0	PRJNA694557	11752	390	6.908517	26.9432163	Cloacibacterium caeni	2004710	Bacteria	Bacteria	571	2.3099999999999993e-158	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g11532	i0	94.823	3.58974358974359	367	18	94	1	1	366	2219161	2218795	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1400	571	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
17251142	17251142	PRJNA694557_P_NODE_17034_length_310_cov_1.772152_g16814_i0	PRJNA694557	17034	310	1.772152	5.4936712	Hymenobacter yonginensis	748197	Bacteria	Bacteria	505	1.85e-138	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g16814	i0	97.01	6.36774193548387	301	8	97	1	10	310	3015026	3014727	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	1974	505	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
17251269	17251269	PRJNA694557_P_NODE_23514_length_250_cov_2.858757_g23294_i0	PRJNA694557	23514	250	2.858757	7.1468925	Chryseobacterium lactis	1241981	Bacteria	Bacteria	196	9.88e-46	NTclustered	gi\|1519559429\|gb\|CP033925.1\|	1241981	g23294	i0	81.2	5.216	250	42	99	3	3	250	4930089	4930335	Chryseobacterium lactis strain G0197 chromosome, complete genome	blastn	1304	196	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium lactis
17251305	17251305	PRJNA694557_P_NODE_25154_length_243_cov_4.529412_g24934_i0	PRJNA694557	25154	243	4.529412	11.00647116	Chryseobacterium gambrini	373672	Bacteria	Bacteria	390	4.089999999999999e-104	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g24934	i0	98.643	12.761316872428	221	2	91	1	1	220	2105870	2105650	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	3101	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
17757351	17757351	PRJNA694557_P_NODE_18374_length_295_cov_1.905405_g18154_i0	PRJNA694557	18374	295	1.905405	5.62094475	Weeksellaceae	2762318	Bacteria	Bacteria	518	2.25e-142	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g18154	i0	99.303	118.35593220339	287	0	97	2	1	286	4116290	4116575	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	34915	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
18525126	18525126	PRJNA694557_P_NODE_10515_length_418_cov_4.144928_g10295_i0	PRJNA694557	10515	418	4.144928	17.32579904	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	438	2.639999999999999e-118	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g10295	i0	88.251	0.875598086124402	366	43	88	0	53	418	1605339	1605704	Lacibacter sp. MH-610 chromosome	blastn	366	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
18525280	18525280	PRJNA694557_P_NODE_20215_length_277_cov_3.004902_g19995_i0	PRJNA694557	20215	277	3.004902	8.32357854	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	433	7.79e-117	NTclustered	gi\|1958211526\|gb\|CP068082.1\|	258	g19995	i0	96.899	2.83754512635379	258	8	93	0	20	277	1678927	1678670	Sphingobacterium spiritivorum strain FDAARGOS_1146 chromosome, complete genome	blastn	786	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
18525296	18525296	PRJNA694557_P_NODE_21355_length_267_cov_2.175258_g21135_i0	PRJNA694557	21355	267	2.175258	5.80793886	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	420	5.81e-113	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g21135	i0	97.551	0.917602996254682	245	6	92	0	23	267	3144706	3144462	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	245	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
18525351	18525351	PRJNA694557_P_NODE_24475_length_246_cov_3.115607_g24255_i0	PRJNA694557	24475	246	3.115607	7.66439322	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g24255	i0	97.967	1	246	5	100	0	1	246	3490401	3490156	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	246	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
19800130	19800130	PRJNA694557_P_NODE_15436_length_329_cov_2.703125_g15216_i0	PRJNA694557	15436	329	2.703125	8.89328125	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	514	3.29e-141	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g15216	i0	95.092	0.990881458966565	326	16	99	0	1	326	3242121	3242446	Hymenobacter sp. DG01 chromosome, complete genome	blastn	326	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
19800190	19800190	PRJNA694557_P_NODE_18716_length_291_cov_3.110092_g18496_i0	PRJNA694557	18716	291	3.110092	9.05036772	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	468	2.26e-127	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g18496	i0	98.134	24.1477663230241	268	5	92	0	15	282	1070086	1069819	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	7027	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
19800218	19800218	PRJNA694557_P_NODE_20256_length_277_cov_1.975490_g20036_i0	PRJNA694557	20256	277	1.97549	5.4721073	Hymenobacter sedentarius	1411621	Bacteria	Bacteria	416	7.839999999999999e-112	NTclustered	gi\|972940812\|gb\|CP013909.1\|	1411621	g20036	i0	94.444	214.624548736462	270	15	98	0	8	277	386973	386704	Hymenobacter sedentarius strain DG5B chromosome, complete genome	blastn	59451	416	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sedentarius
21075888	21075888	PRJNA694557_P_NODE_26537_length_231_cov_5.506329_g26317_i0	PRJNA694557	26537	231	5.506329	12.71961999	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	283	6.72e-72	NTclustered	gi\|2622071896\|emb\|OY787448.1\|	2212467	g26317	i0	93.299	450.887445887446	194	10	84	3	38	231	1075755	1075565	MAG: Bacteroidaceae bacterium isolate 2aaebec7-4bc4-47dc-875d-c6aa3f85175a genome assembly, chromosome: 1	blastn	104155	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
21581809	21581809	PRJNA694557_P_NODE_21957_length_262_cov_2.423280_g21737_i0	PRJNA694557	21957	262	2.42328	6.3489936	Spirosoma	107	Bacteria	Bacteria	377	3.47e-100	NTclustered	gi\|1163018612\|gb\|CP020105.1\|	564064	g21737	i0	93.023	262.400763358779	258	18	98	0	1	258	1093777	1094034	Spirosoma rigui strain KCTC 12531 chromosome, complete genome	blastn	68749	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rigui

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