metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax_clade = "FCB group"

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
2406240	2406240	PRJNA562549_P_NODE_27342_length_225_cov_2.378049_g27109_i0	PRJNA562549	27342	225	2.378049	5.35061025	Sphingobacterium	28453	Bacteria	Bacteria	411	2.869999999999999e-110	NTclustered	gi\|2844665728\|gb\|CP162525.1\|	259	g27109	i0	100	423.208888888889	222	0	99	0	3	224	1058315	1058094	Sphingobacterium thalpophilum strain UPB 1353 chromosome, complete genome	blastn	95222	412	0.997572815533981	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
2406244	2406244	PRJNA562549_P_NODE_27742_length_224_cov_1.208589_g27509_i0	PRJNA562549	27742	224	1.208589	2.70723936	Prevotella	838	Bacteria	Bacteria	353	4.87e-93	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g27509	i0	100	181.40625	191	0	85	0	34	224	167125	167315	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	40635	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
8198652	8198652	PRJNA562549_P_NODE_28407_length_221_cov_1.625000_g28174_i0	PRJNA562549	28407	221	1.625	3.59125	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	385	1.6999999999999995e-102	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g28174	i0	98.618	228.248868778281	217	3	98	0	1	217	1077246	1077030	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	50443	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
9474338	9474338	PRJNA562549_P_NODE_28448_length_221_cov_1.512500_g28215_i0	PRJNA562549	28448	221	1.5125	3.342625	Prevotella sp.	59823	Bacteria	Bacteria	326	1.05e-84	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g28215	i0	93.243	441.656108597285	222	13	100	2	1	221	1097	877	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	97606	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
10059310	10059310	PRJNA562549_P_NODE_15188_length_295_cov_3.991453_g14955_i0	PRJNA562549	15188	295	3.991453	11.77478635	Sphingobacterium	28453	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|2306435172\|gb\|CP094931.1\|	34087	g14955	i0	100	394.637288135593	295	0	100	0	1	295	227985	227691	Sphingobacterium faecium strain WB1 chromosome, complete genome	blastn	116418	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium faecium
12024914	12024914	PRJNA562549_P_NODE_36210_length_202_cov_1.843972_g35977_i0	PRJNA562549	36210	202	1.843972	3.72482344	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	267	5.77e-67	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g35977	i0	90.547	16.8267326732673	201	19	99	0	1	201	3043566	3043766	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	3399	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
12609786	12609786	PRJNA562549_P_NODE_22010_length_249_cov_1.308511_g21777_i0	PRJNA562549	22010	249	1.308511	3.25819239	Sphingobacterium	28453	Bacteria	Bacteria	327	3.34e-85	NTclustered	gi\|2306435172\|gb\|CP094931.1\|	34087	g21777	i0	97.884	337.333333333333	189	4	76	0	61	249	226752	226940	Sphingobacterium faecium strain WB1 chromosome, complete genome	blastn	83996	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium faecium
12609822	12609822	PRJNA562549_P_NODE_26870_length_227_cov_1.837349_g26637_i0	PRJNA562549	26870	227	1.837349	4.17078223	Flectobacillus	101	Bacteria	Bacteria	364	2.289999999999999e-96	NTclustered	gi\|4127845\|emb\|AJ011917.1\|	50419	g26637	i0	95.633	92.8590308370044	229	6	100	4	1	227	1425	1199	Flectobacillus sp. 16S rRNA gene, partial, strain MWH38	blastn	21079	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
15848630	15848630	PRJNA562549_P_NODE_28033_length_222_cov_3.559006_g27800_i0	PRJNA562549	28033	222	3.559006	7.90099332	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	239	1.41e-58	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g27800	i0	88.832	94.1396396396396	197	18	87	2	29	222	421019	420824	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	20899	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15848695	15848695	PRJNA562549_P_NODE_36493_length_202_cov_0.921986_g36260_i0	PRJNA562549	36493	202	0.921986	1.86241172	Chryseolinea soli	2321403	Bacteria	Bacteria	222	1.27e-53	NTclustered	gi\|1481087475\|gb\|CP032382.1\|	2321403	g36260	i0	86.935	27.8514851485149	199	24	98	2	1	198	902014	902211	Chryseolinea soli strain KIS68-18 chromosome, complete genome	blastn	5626	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea soli
15848696	15848696	PRJNA562549_P_NODE_36833_length_200_cov_2.776978_g36600_i0	PRJNA562549	36833	200	2.776978	5.553956	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	287	4.38e-73	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g36600	i0	92.929	306.04	198	12	99	2	1	197	3564	3368	Dyadobacter pollutisoli strain U1 chromosome	blastn	61208	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
17123477	17123477	PRJNA562549_P_NODE_29774_length_216_cov_1.883871_g29541_i0	PRJNA562549	29774	216	1.883871	4.06916136	Hymenobacter sp. BT18	2835648	Bacteria	Bacteria	388	1.28e-103	NTclustered	gi\|1829874072\|gb\|CP050954.1\|	2835648	g29541	i0	99.074	419.069444444444	216	2	100	0	1	216	1253783	1253568	Hymenobacter sp. BT18 chromosome, complete genome	blastn	90519	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BT18
17123612	17123612	PRJNA562549_P_NODE_9774_length_368_cov_2.394137_g9541_i0	PRJNA562549	9774	368	2.394137	8.81042416	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	562	1.31e-155	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g9541	i0	94.309	413.654891304348	369	18	99	2	1	366	361096	360728	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	152225	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
17708873	17708873	PRJNA562549_P_NODE_38334_length_185_cov_4.943548_g38101_i0	PRJNA562549	38334	185	4.943548	9.1455638	Aquirufa	2676247	Bacteria	Bacteria	243	8.73e-60	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g38101	i0	91.573	325.913513513514	178	12	96	3	9	185	361433	361258	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	60294	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
19672255	19672255	PRJNA562549_P_NODE_28656_length_220_cov_2.062893_g28423_i0	PRJNA562549	28656	220	2.062893	4.5383646	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	278	2.95e-70	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g28423	i0	89.593	35.5454545454545	221	20	100	2	1	220	3043416	3043634	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	7820	278	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20947805	20947805	PRJNA562549_P_NODE_1717_length_827_cov_2.365535_g1615_i0	PRJNA562549	1717	827	2.365535	19.56297445	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	1064	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g1615	i0	90.024	405.54292623942	832	70	100	10	1	827	217564	216741	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	335384	1064	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
21532746	21532746	PRJNA562549_P_NODE_12017_length_330_cov_3.360595_g11784_i0	PRJNA562549	12017	330	3.360595	11.0899635	Cloacibacterium	501783	Bacteria	Bacteria	544	4.1999999999999997e-150	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g11784	i0	96.364	473.530303030303	330	12	100	0	1	330	129905	130234	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	156265	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
21532860	21532860	PRJNA562549_P_NODE_26017_length_230_cov_2.414201_g25784_i0	PRJNA562549	26017	230	2.414201	5.5526623	Flavobacterium	237	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|2450142067\|gb\|OQ546431.1\|	239	g25784	i0	100	99.9913043478261	230	0	100	0	1	230	246	17	Flavobacterium sp. strain CA_R2146_A 16S ribosomal RNA gene, partial sequence	blastn	22998	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
21532921	21532921	PRJNA562549_P_NODE_36817_length_200_cov_2.992806_g36584_i0	PRJNA562549	36817	200	2.992806	5.985612	Bacteroidota	976	Bacteria	Bacteria	222	1.25e-53	NTclustered	gi\|332168736\|gb\|CP002528.1\|	983548	g36584	i0	86.935	260.205	199	24	99	2	1	198	2386335	2386532	Dokdonia sp. 4H-3-7-5 chromosome, complete genome	blastn	52041	224	0.991071428571429	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Dokdonia	Dokdonia sp. 4H-3-7-5
22222680	22222680	PRJNA562549_P_NODE_13578_length_312_cov_1.856574_g13345_i0	PRJNA562549	13578	312	1.856574	5.79251088	Flavobacterium sp. ZE23DGlu08	3059026	Bacteria	Bacteria	538	1.8399999999999993e-148	NTclustered	gi\|2548163737\|gb\|CP130045.1\|	3059026	g13345	i0	97.756	557.028846153846	312	7	100	0	1	312	884415	884726	Flavobacterium sp. ZE23DGlu08 chromosome, complete genome	blastn	173793	538	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. ZE23DGlu08
23498239	23498239	PRJNA562549_P_NODE_6059_length_467_cov_2.431034_g5826_i0	PRJNA562549	6059	467	2.431034	11.35292878	Fulvivirga ulvae	2904245	Bacteria	Bacteria	536	1.0299999999999999e-147	NTclustered	gi\|2174454039\|gb\|CP089981.1\|	2904245	g5826	i0	89.041	276.967880085653	438	41	93	7	35	467	448115	447680	Fulvivirga ulvae strain SS9-22 chromosome, complete genome	blastn	129344	536	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ulvae

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