metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJEB17675" and tax

32 rows where analysis = "blastn", bioproject = "PRJEB17675" 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
21658	21658	PRJEB17675_P_NODE_15981_length_201_cov_1.656627_g15677_i0	PRJEB17675	15981	201	1.656627	3.32982027	Hymenobacter nivis	1850093	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1391209682\|gb\|CP029145.1\|	1850093	g15677	i0	100	0.139303482587065	28	0	14	0	22	49	3947525	3947552	Hymenobacter nivis strain NBRC 111535 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter nivis
21689	21689	PRJEB17675_P_NODE_3461_length_528_cov_3.569980_g3179_i0	PRJEB17675	3461	528	3.56998	18.8494944	Chryseobacterium endophyticum	1854762	Bacteria	Bacteria	913	0	NTclustered	gi\|2731632474\|gb\|CP154834.1\|	1854762	g3179	i0	97.917	379.202651515152	528	10	100	1	1	528	102879	102353	Chryseobacterium endophyticum strain OsEnb-ALM-A6 chromosome, complete genome	blastn	200219	913	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium endophyticum
2571530	2571530	PRJEB17675_P_NODE_2003_length_695_cov_3.243939_g1574_i1	PRJEB17675	2003	695	3.243939	22.54537605	Chryseobacterium sp. E1	2853434	Bacteria	Bacteria	915	0	NTclustered	gi\|2065946897\|gb\|CP078104.1\|	2853434	g1574	i1	90.531	494.879136690647	697	59	99	7	1	694	1142268	1141576	Chryseobacterium sp. E1 chromosome, complete genome	blastn	343941	915	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. E1
3536443	3536443	PRJEB17675_P_NODE_14163_length_218_cov_1.803279_g13859_i0	PRJEB17675	14163	218	1.803279	3.93114822	Flavihumibacter	1004301	Bacteria	Bacteria	327	2.86e-85	NTclustered	gi\|2198890466\|gb\|CP092334.1\|	2838156	g13859	i0	93.981	230.678899082569	216	13	99	0	1	216	90556	90341	Flavihumibacter rivuli strain IMCC34838 chromosome, complete genome	blastn	50288	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter rivuli
3536445	3536445	PRJEB17675_P_NODE_18343_length_184_cov_1.463087_g18039_i0	PRJEB17675	18343	184	1.463087	2.69208008	Sediminibacterium	504481	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g18039	i0	100	282.423913043478	184	0	100	0	1	184	54955	55138	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	51966	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
3847817	3847817	PRJEB17675_P_NODE_10104_length_274_cov_2.811715_g9800_i0	PRJEB17675	10104	274	2.811715	7.7040991	Runella sp. SP2	2268026	Bacteria	Bacteria	385	2.18e-102	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g9800	i0	91.971	121.456204379562	274	22	100	0	1	274	5735387	5735660	Runella sp. SP2 chromosome, complete genome	blastn	33279	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
3847839	3847839	PRJEB17675_P_NODE_14624_length_213_cov_1.634831_g14320_i0	PRJEB17675	14624	213	1.634831	3.48219003	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	322	1.29e-83	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g14320	i0	93.897	408.399061032864	213	13	100	0	1	213	2012999	2012787	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	86989	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
3847866	3847866	PRJEB17675_P_NODE_24144_length_155_cov_1.000000_g23840_i0	PRJEB17675	24144	155	1	1.55	Polaribacter batillariae	2808900	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2013087451\|gb\|CP071795.1\|	2808900	g23840	i0	90.698	0.27741935483871	43	1	26	3	57	96	1458923	1458881	Polaribacter batillariae strain G4M1 chromosome, complete genome	blastn	43	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter batillariae
6399823	6399823	PRJEB17675_P_NODE_4286_length_472_cov_4.620137_g3989_i0	PRJEB17675	4286	472	4.620137	21.80704664	Runella sp. SP2	2268026	Bacteria	Bacteria	451	3.87e-122	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g3989	i0	84.134	422.012711864407	479	62	100	13	1	472	5735406	5735877	Runella sp. SP2 chromosome, complete genome	blastn	199190	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
7673905	7673905	PRJEB17675_P_NODE_17787_length_187_cov_25.552632_g17483_i0	PRJEB17675	17787	187	25.552632	47.78342184	Fulvivirga ligni	2904246	Bacteria	Bacteria	217	5.36e-52	NTclustered	gi\|2174437639\|gb\|CP089979.1\|	2904246	g17483	i0	87.766	290.363636363636	188	20	100	3	1	187	410616	410801	Fulvivirga ligni strain W9P-11 chromosome, complete genome	blastn	54298	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ligni
7673981	7673981	PRJEB17675_P_NODE_9927_length_277_cov_7.173554_g9623_i0	PRJEB17675	9927	277	7.173554	19.87074458	Pedobacter sp. KACC 23697	3149230	Bacteria	Bacteria	412	1.0099999999999997e-110	NTclustered	gi\|2739540447\|gb\|CP157485.1\|	3149230	g9623	i0	94.118	306.462093862816	272	14	98	2	7	277	13363	13093	Pedobacter sp. KACC 23697 chromosome, complete genome	blastn	84890	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. KACC 23697
8638945	8638945	PRJEB17675_P_NODE_22107_length_163_cov_1.351562_g21803_i0	PRJEB17675	22107	163	1.351562	2.20304606	Chryseobacterium	59732	Bacteria	Bacteria	298	1.58e-76	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g21803	i0	100	506.742331288344	161	0	99	0	2	162	2626854	2627014	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	82599	300	0.993333333333333	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
9914014	9914014	PRJEB17675_P_NODE_21828_length_164_cov_1.798450_g21524_i0	PRJEB17675	21828	164	1.79845	2.949458	root	1	Root_unresolved	Root_unresolved	239	9.79e-59	NTclustered	gi\|2868812398\|dbj\|LC855767.1\|	50419	g21524	i0	99.242	101.829268292683	132	1	100	0	33	164	543	674	Flectobacillus sp. FWB18 gene for 16S ribosomal RNA, partial sequence	blastn	16700	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
10224402	10224402	PRJEB17675_P_NODE_18309_length_184_cov_1.684564_g18005_i0	PRJEB17675	18309	184	1.684564	3.09959776	Bacteroidales bacterium	2030927	Bacteria	Bacteria	207	3.16e-49	NTclustered	gi\|2621703439\|emb\|OY762520.1\|	2030927	g18005	i0	87.709	101.489130434783	179	20	97	1	1	179	2589893	2590069	MAG: Bacteroidales bacterium isolate 9ba16ef7-025e-48a1-a3a8-4edb704cbcd3 genome assembly, chromosome: 1	blastn	18674	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
10224403	10224403	PRJEB17675_P_NODE_18849_length_181_cov_1.116438_g18545_i0	PRJEB17675	18849	181	1.116438	2.02075278	Candidatus Pedobacter colombiensis	3121371	Bacteria	Bacteria	82.4	1.96e-11	NTclustered	gi\|2457514890\|gb\|CP119313.1\|	3121371	g18545	i0	89.231	1.12707182320442	65	7	36	0	33	97	843081	843017	MAG: Candidatus Pedobacter colombiensis isolate MAG_3858 chromosome, complete genome	blastn	204	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Candidatus Pedobacter colombiensis
10224461	10224461	PRJEB17675_P_NODE_9189_length_292_cov_2.463035_g8885_i0	PRJEB17675	9189	292	2.463035	7.1920622	Parabacteroides distasonis	823	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1848637015\|gb\|CP054012.1\|	823	g8885	i0	96.875	0.215753424657534	32	0	11	1	232	262	2023542	2023511	Parabacteroides distasonis strain FDAARGOS_759 chromosome, complete genome	blastn	63	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
11499671	11499671	PRJEB17675_P_NODE_1790_length_731_cov_3.349138_g1574_i0	PRJEB17675	1790	731	3.349138	24.48219878	Chryseobacterium sp. E1	2853434	Bacteria	Bacteria	867	0	NTclustered	gi\|2065946897\|gb\|CP078104.1\|	2853434	g1574	i0	88.115	449.852257181943	732	83	99	4	1	730	1142305	1141576	Chryseobacterium sp. E1 chromosome, complete genome	blastn	328842	867	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. E1
12775208	12775208	PRJEB17675_P_NODE_12971_length_231_cov_2.637755_g12667_i0	PRJEB17675	12971	231	2.637755	6.09321405	Fluviicola sp.	1917219	Bacteria	Bacteria	339	1.41e-88	NTclustered	gi\|2916411764\|gb\|CP170456.1\|	1917219	g12667	i0	93.074	349.225108225108	231	16	100	0	1	231	1783460	1783230	MAG: Fluviicola sp. isolate tig00002473 chromosome, complete genome	blastn	80671	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola sp.
12775225	12775225	PRJEB17675_P_NODE_17451_length_190_cov_1.406452_g17147_i0	PRJEB17675	17451	190	1.406452	2.6722588	Olivibacter sp. SDN3	2764720	Bacteria	Bacteria	195	2.56e-45	NTclustered	gi\|1897593526\|gb\|CP060497.1\|	2764720	g17147	i0	86.264	281.421052631579	182	21	95	3	4	183	385722	385543	Olivibacter sp. SDN3 chromosome, complete genome	blastn	53470	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Olivibacter	Olivibacter sp. SDN3
15323811	15323811	PRJEB17675_P_NODE_16133_length_200_cov_1.418182_g15829_i0	PRJEB17675	16133	200	1.418182	2.836364	Hymenobacter sp. HDW8	2714932	Bacteria	Bacteria	167	5.95e-37	NTclustered	gi\|1821217176\|gb\|CP049907.1\|	2714932	g15829	i0	85.057	229.455	174	14	84	10	1	168	3412769	3412602	Hymenobacter sp. HDW8 chromosome, complete genome	blastn	45891	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. HDW8
16598534	16598534	PRJEB17675_P_NODE_9034_length_296_cov_1.413793_g8730_i0	PRJEB17675	9034	296	1.413793	4.18482728	Pedobacter sp. G11	2482728	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1527210401\|gb\|CP034190.1\|	2482728	g8730	i0	100	0.0945945945945946	28	0	9	0	53	80	3089793	3089766	Pedobacter sp. G11 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. G11
18837653	18837653	PRJEB17675_P_NODE_20015_length_174_cov_1.129496_g19711_i0	PRJEB17675	20015	174	1.129496	1.96532304	Cytophagales	768507	Bacteria	Bacteria	150	5.05e-32	NTclustered	gi\|808182281\|gb\|CP009621.1\|	400092	g19711	i0	100	74.8448275862069	81	0	47	0	74	154	995375	995295	Pontibacter korlensis strain X14-1T, complete genome	blastn	13023	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter korlensis
19147090	19147090	PRJEB17675_P_NODE_10956_length_260_cov_1.275556_g10652_i0	PRJEB17675	10956	260	1.275556	3.3164456	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	165	2.92e-36	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g10652	i0	79.592	120.026923076923	245	38	93	11	5	243	2309	2071	Dyadobacter pollutisoli strain U1 chromosome	blastn	31207	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
20112393	20112393	PRJEB17675_P_NODE_13696_length_223_cov_1.606383_g13392_i0	PRJEB17675	13696	223	1.606383	3.58223409	Sphingobacterium	28453	Bacteria	Bacteria	324	3.8e-84	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g13392	i0	100	153.90134529148	175	0	78	0	49	223	1769955	1770129	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	34320	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
20112400	20112400	PRJEB17675_P_NODE_22116_length_163_cov_1.250000_g21812_i0	PRJEB17675	22116	163	1.25	2.0375	Flectobacillus	101	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|1420811895\|gb\|MH591747.1\|	50419	g21812	i0	98.75	98.159509202454	160	2	98	0	1	160	193	352	Flectobacillus sp. strain PW22 16S ribosomal RNA gene, partial sequence	blastn	16000	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
20112410	20112410	PRJEB17675_P_NODE_5456_length_410_cov_5.752000_g5157_i0	PRJEB17675	5456	410	5.752	23.5832	Sphingobacterium	28453	Bacteria	Bacteria	728	0	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g5157	i0	98.778	419.826829268293	409	5	99	0	1	409	3720947	3721355	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	172129	734	0.991825613079019	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
20422388	20422388	PRJEB17675_P_NODE_3477_length_527_cov_3.709350_g3195_i0	PRJEB17675	3477	527	3.70935	19.5482745	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	510	7.1e-140	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g3195	i0	86.066	639.278937381404	488	52	91	12	49	527	2011869	2012349	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	336900	510	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
21698361	21698361	PRJEB17675_P_NODE_15338_length_206_cov_3.596491_g15034_i0	PRJEB17675	15338	206	3.596491	7.40877146	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	353	4.41e-93	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g15034	i0	98.985	159.718446601942	197	2	96	0	1	197	54221	54025	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	32902	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
24247482	24247482	PRJEB17675_P_NODE_19460_length_177_cov_1.408451_g19156_i0	PRJEB17675	19460	177	1.408451	2.49295827	Sphingobacterium multivorum	28454	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|1958258319\|gb\|CP068086.1\|	28454	g19156	i0	99.435	7.85310734463277	177	1	100	0	1	177	4124917	4125093	Sphingobacterium multivorum strain FDAARGOS_1143 chromosome, complete genome	blastn	1390	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
24247501	24247501	PRJEB17675_P_NODE_23280_length_158_cov_1.414634_g22976_i0	PRJEB17675	23280	158	1.414634	2.23512172	Arenibacter antarcticus	2040469	Bacteria	Bacteria	189	9.54e-44	NTclustered	gi\|2788695829\|gb\|CP166679.1\|	2040469	g22976	i0	88.608	349.23417721519	158	14	99	4	1	156	23350	23505	Arenibacter antarcticus strain KCTC 52924T chromosome, complete genome	blastn	55179	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Arenibacter	Arenibacter antarcticus
24247551	24247551	PRJEB17675_P_NODE_8800_length_301_cov_2.285714_g8496_i0	PRJEB17675	8800	301	2.285714	6.87999914	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	231	3.35e-56	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g8496	i0	81.229	227.421926910299	293	50	96	5	1	290	2013605	2013315	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	68454	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
24247556	24247556	PRJEB17675_P_NODE_9840_length_279_cov_1.909836_g9536_i0	PRJEB17675	9840	279	1.909836	5.32844244	uncultured Flavobacteriales bacterium	213322	Bacteria	Bacteria	399	7.969999999999998e-107	NTclustered	gi\|2308952759\|emb\|OX044359.1\|	213322	g9536	i0	92.78	211.146953405018	277	19	99	1	1	277	216371	216096	MAG: uncultured Flavobacteriales bacterium isolate C_MB391 genome assembly, chromosome: C_MB391_contig-1	blastn	58910	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			uncultured Flavobacteriales 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);;