metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA515078" 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
1110946	1110946	PRJNA515078_P_NODE_23621_length_178_cov_3.312057_g23388_i0	PRJNA515078	23621	178	3.312057	5.89546146	Bacteroidota	976	Bacteria	Bacteria	84.2	5.34e-12	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g23388	i0	97.917	17.9943820224719	48	1	27	0	109	156	1705	1752	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	3203	84.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
3037886	3037886	PRJNA515078_P_NODE_22803_length_182_cov_1.075862_g22570_i0	PRJNA515078	22803	182	1.075862	1.95806884	Cryomorphaceae bacterium	1898111	Bacteria	Bacteria	91.6	3.28e-14	NTclustered	gi\|2022030222\|gb\|CP059070.1\|	1898111	g22570	i0	83.505	1.45054945054945	97	16	53	0	3	99	631610	631514	Cryomorphaceae bacterium strain ECT2AJA-044 chromosome, complete genome	blastn	264	91.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Cryomorphaceae		Cryomorphaceae bacterium
4313785	4313785	PRJNA515078_P_NODE_26804_length_168_cov_1.190840_g26571_i0	PRJNA515078	26804	168	1.19084	2.0006112	Fulvivirga lutea	2810512	Bacteria	Bacteria	126	8.2e-25	NTclustered	gi\|1995470682\|gb\|CP070608.1\|	2810512	g26571	i0	81.595	1.14285714285714	163	20	94	9	1	158	290192	290035	Fulvivirga lutea strain S481 chromosome, complete genome	blastn	192	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga lutea
5590644	5590644	PRJNA515078_P_NODE_25085_length_173_cov_2.007353_g24852_i0	PRJNA515078	25085	173	2.007353	3.47272069	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	257	2.87e-64	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g24852	i0	93.605	411.508670520231	172	11	99	0	2	173	1078288	1078117	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	71191	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
5590680	5590680	PRJNA515078_P_NODE_29585_length_160_cov_3.170732_g29352_i0	PRJNA515078	29585	160	3.170732	5.0731712	Spirosoma taeanense	2735870	Bacteria	Bacteria	193	7.489999999999999e-45	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g29352	i0	95.833	104.35625	120	3	74	2	1	118	5552685	5552804	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	16697	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
6864571	6864571	PRJNA515078_P_NODE_19526_length_196_cov_1.968553_g19293_i0	PRJNA515078	19526	196	1.968553	3.85836388	Spirosoma aerolatum	1211326	Bacteria	Bacteria	283	5.519999999999999e-72	NTclustered	gi\|1163013319\|gb\|CP020104.1\|	1211326	g19293	i0	92.965	181.505102040816	199	7	100	6	1	196	753326	753520	Spirosoma aerolatum strain KACC 17939 chromosome, complete genome	blastn	35575	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aerolatum
6864590	6864590	PRJNA515078_P_NODE_21286_length_188_cov_1.291391_g21053_i0	PRJNA515078	21286	188	1.291391	2.42781508	Flavobacterium sp. N2038	2986829	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2324023810\|gb\|CP110001.1\|	2986829	g21053	i0	97.059	0.180851063829787	34	0	18	1	47	79	675189	675156	Flavobacterium sp. N2038 chromosome, complete genome	blastn	34	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
8139849	8139849	PRJNA515078_P_NODE_16847_length_212_cov_2.165714_g16614_i0	PRJNA515078	16847	212	2.165714	4.59131368	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2907625911\|emb\|OZ223471.1\|	2030927	g16614	i0	100	0.132075471698113	28	0	13	0	27	54	2932040	2932013	MAG: Bacteroidales bacterium isolate a5dadea3-f0cc-47fd-ae8e-5886e0073126 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
9414968	9414968	PRJNA515078_P_NODE_22568_length_183_cov_1.068493_g22335_i0	PRJNA515078	22568	183	1.068493	1.95534219	Pedobacter sp. UC225_65	3350173	Bacteria	Bacteria	62.1	2.59e-5	NTclustered	gi\|2814008831\|gb\|CP170550.1\|	3350173	g22335	i0	97.222	0.349726775956284	36	1	20	0	143	178	488952	488917	Pedobacter sp. UC225_65 chromosome, complete genome	blastn	64	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. UC225_65
10690534	10690534	PRJNA515078_P_NODE_129_length_1945_cov_10.772537_g107_i0	PRJNA515078	129	1945	10.772537	209.52584465	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	2113	0	NTclustered	gi\|2874253714\|emb\|OY969556.1\|	152509	g107	i0	86.619	310.598457583548	1943	222	99	33	27	1945	168585	170513	MAG: uncultured Bacteroidetes bacterium isolate MFD09286.bin.c.1 genome assembly, chromosome: 1	blastn	604114	2113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
11314099	11314099	PRJNA515078_P_NODE_15129_length_225_cov_2.537234_g14896_i0	PRJNA515078	15129	225	2.537234	5.7087765	Fluviicola	332102	Bacteria	Bacteria	394	2.89e-105	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g14896	i0	98.222	364.808888888889	225	4	100	0	1	225	906	682	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	82082	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
11314127	11314127	PRJNA515078_P_NODE_27209_length_167_cov_1.200000_g26976_i0	PRJNA515078	27209	167	1.2	2.004	Mucilaginibacter	423349	Bacteria	Bacteria	134	4.86e-27	NTclustered	gi\|2451268147\|gb\|CP118631.1\|	3029053	g26976	i0	94.318	109.479041916168	88	4	53	1	52	139	3103608	3103522	Mucilaginibacter sp. SJ chromosome, complete genome	blastn	18283	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. SJ
11965518	11965518	PRJNA515078_P_NODE_1530_length_788_cov_2.777630_g1366_i0	PRJNA515078	1530	788	2.77763	21.8877244	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	1048	0	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g1366	i0	90.657	267.654822335025	792	68	100	6	1	788	1076371	1077160	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	210912	1048	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
11965701	11965701	PRJNA515078_P_NODE_8290_length_318_cov_2.220641_g8057_i0	PRJNA515078	8290	318	2.220641	7.06163838	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	529	1.1299999999999997e-145	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g8057	i0	96.562	366.852201257862	320	9	100	2	1	318	787742	787423	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	116659	529	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
14515817	14515817	PRJNA515078_P_NODE_29352_length_161_cov_1.258065_g29119_i0	PRJNA515078	29352	161	1.258065	2.02548465	Mucinivorans hirudinis	1433126	Bacteria	Bacteria	143	7.72e-30	NTclustered	gi\|656326619\|emb\|HG934468.1\|	1433126	g29119	i0	82.927	44.7080745341615	164	22	100	6	1	161	1648552	1648712	Mucinivorans hirudinis complete genome	blastn	7198	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Mucinivorans	Mucinivorans hirudinis
17064107	17064107	PRJNA515078_P_NODE_25094_length_173_cov_2.000000_g24861_i0	PRJNA515078	25094	173	2	3.46	Spirosoma linguale	108	Bacteria	Bacteria	196	6.339999999999999e-46	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g24861	i0	88.485	232.526011560694	165	15	94	4	9	171	3192358	3192196	Spirosoma linguale DSM 74, complete genome	blastn	40227	196	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
18338437	18338437	PRJNA515078_P_NODE_14275_length_233_cov_1.367347_g14042_i0	PRJNA515078	14275	233	1.367347	3.18591851	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	357	3.95e-94	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g14042	i0	94.421	255.68669527897	233	11	100	2	1	233	1077722	1077492	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	59575	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
18338439	18338439	PRJNA515078_P_NODE_14575_length_230_cov_1.616580_g14342_i0	PRJNA515078	14575	230	1.61658	3.718134	Chondrinema litorale	2994555	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2333396830\|gb\|CP111046.1\|	2994555	g14342	i0	100	0.121739130434783	28	0	12	0	183	210	172971	172998	Chondrinema litorale strain WSW3-B12 plasmid unnamed4	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Chondrinema	Chondrinema litorale
18338601	18338601	PRJNA515078_P_NODE_4175_length_472_cov_5.820690_g3943_i0	PRJNA515078	4175	472	5.82069	27.4736568	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	658	0	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g3943	i0	91.915	388.635593220339	470	38	99	0	3	472	786770	786301	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	183436	658	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
18962595	18962595	PRJNA515078_P_NODE_27975_length_165_cov_1.023438_g27742_i0	PRJNA515078	27975	165	1.023438	1.6886727	Bacteroidota	976	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|345847698\|gb\|JN541148.1\|	152509	g27742	i0	97.546	99.0242424242424	163	2	98	1	4	164	1077	1239	Uncultured Bacteroidetes bacterium clone CSC23 16S ribosomal RNA gene, partial sequence	blastn	16339	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
20237440	20237440	PRJNA515078_P_NODE_7956_length_326_cov_2.878893_g7723_i0	PRJNA515078	7956	326	2.878893	9.38519118	Bacteria	2	Bacteria	Bacteria	603	6.749999999999998e-168	NTclustered	gi\|1269625304\|dbj\|LC106299.1\|	1785891	g7723	i0	100	94.4938650306748	326	0	100	0	1	326	102	427	Bacteroidetes bacterium PW-32G gene for 16S ribosomal RNA, partial sequence	blastn	30805	603	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium PW-32G
22163534	22163534	PRJNA515078_P_NODE_11538_length_263_cov_1.553097_g11305_i0	PRJNA515078	11538	263	1.553097	4.08464511	Runella sp. SP2	2268026	Bacteria	Bacteria	165	2.96e-36	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g11305	i0	88.489	120.566539923954	139	13	52	3	127	263	5735512	5735375	Runella sp. SP2 chromosome, complete genome	blastn	31709	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
22163650	22163650	PRJNA515078_P_NODE_26298_length_169_cov_2.363636_g26065_i0	PRJNA515078	26298	169	2.363636	3.99454484	Flavihumibacter fluvii	2838157	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|2198886192\|gb\|CP092333.1\|	2838157	g26065	i0	98.225	278.301775147929	169	2	100	1	1	169	210143	209976	Flavihumibacter fluvii strain IMCC34837 chromosome, complete genome	blastn	47033	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter fluvii
22163668	22163668	PRJNA515078_P_NODE_28218_length_164_cov_1.228346_g27985_i0	PRJNA515078	28218	164	1.228346	2.01448744	Sphingobacterium oryzagri	3025669	Bacteria	Bacteria	58.4	2.94e-4	NTclustered	gi\|2446126086\|gb\|CP117880.1\|	3025669	g27985	i0	100	0.189024390243902	31	0	19	0	8	38	4135504	4135534	Sphingobacterium oryzagri strain KACC 22765 chromosome, complete genome	blastn	31	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium oryzagri
22788033	22788033	PRJNA515078_P_NODE_5238_length_415_cov_1.542328_g5005_i0	PRJNA515078	5238	415	1.542328	6.4006612	Bacteria	2	Bacteria	Bacteria	63.9	1.84e-5	NTclustered	gi\|1867918793\|dbj\|LC567144.1\|	2750729	g5005	i0	91.489	0.226506024096386	47	2	11	2	220	265	371	326	Flavobacteriales endosymbiont of Nosodendron coenosum 1-BH-2020 gene for 16S ribosomal RNA, partial sequence	blastn	94	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales endosymbiont of Nosodendron coenosum 1-BH-2020
24062850	24062850	PRJNA515078_P_NODE_1019_length_947_cov_13.065934_g116_i1	PRJNA515078	1019	947	13.065934	123.73439498	Aquirufa	2676247	Bacteria	Bacteria	1079	0	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g116	i1	88.082	204.630411826822	923	93	97	14	1	916	214582	213670	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	193785	1085	0.994470046082949	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
25337325	25337325	PRJNA515078_P_NODE_140_length_1911_cov_25.325507_g116_i0	PRJNA515078	140	1911	25.325507	483.97043877	Aquirufa	2676247	Bacteria	Bacteria	2084	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g116	i0	86.817	257.920983778127	1904	205	98	40	1	1879	360535	358653	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	492887	2102	0.991436726926736	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae

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