metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax

16 rows where analysis = "blastn", bioproject = "PRJDB4941" 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
10311	10311	PRJDB4941_P_NODE_24781_length_202_cov_1.908497_g24013_i0	PRJDB4941	24781	202	1.908497	3.85516394	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	241	3.5e-59	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g24013	i0	88.406	7.39108910891089	207	14	100	6	1	202	421937	422138	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1493	241	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
2560323	2560323	PRJDB4941_P_NODE_34403_length_169_cov_0.866667_g33635_i0	PRJDB4941	34403	169	0.866667	1.46466723	Chryseobacterium sp. POL2	2713414	Bacteria	Bacteria	165	1.74e-36	NTclustered	gi\|1817959117\|gb\|CP049298.1\|	2713414	g33635	i0	92.308	2.27810650887574	117	7	68	1	45	159	583703	583587	Chryseobacterium sp. POL2 chromosome, complete genome	blastn	385	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. POL2
5112620	5112620	PRJDB4941_P_NODE_22145_length_215_cov_2.240964_g21377_i0	PRJDB4941	22145	215	2.240964	4.8180726	Flavobacterium pectinovorum	29533	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g21377	i0	92.308	0.181395348837209	39	1	17	2	61	97	2890497	2890535	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	39	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
5112931	5112931	PRJDB4941_P_NODE_40845_length_162_cov_0.920354_g40077_i0	PRJDB4941	40845	162	0.920354	1.49097348	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g40077	i0	99.383	18.9814814814815	162	1	100	0	1	162	2040155	2039994	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	3075	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
7662450	7662450	PRJDB4941_P_NODE_15887_length_264_cov_2.674419_g15119_i0	PRJDB4941	15887	264	2.674419	7.06046616	Candidatus Ornithobacterium hominis	2497989	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2502739559\|emb\|OX579588.1\|	2497989	g15119	i0	100	0.106060606060606	28	0	11	0	123	150	91817	91790	Candidatus Ornithobacterium hominis strain MSHR-COH1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Candidatus Ornithobacterium hominis
12763766	12763766	PRJDB4941_P_NODE_21631_length_218_cov_2.497041_g20863_i0	PRJDB4941	21631	218	2.497041	5.44354938	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	93.5	1.14e-14	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g20863	i0	82.569	1.61467889908257	109	16	50	3	103	210	810540	810646	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	352	93.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14038204	14038204	PRJDB4941_P_NODE_16712_length_256_cov_1.507246_g15944_i0	PRJDB4941	16712	256	1.507246	3.85854976	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	182	2.84e-41	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g15944	i0	80.769	38.30078125	234	43	91	2	13	245	2260562	2260794	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	9805	182	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
14038455	14038455	PRJDB4941_P_NODE_29532_length_183_cov_2.059701_g28764_i0	PRJDB4941	29532	183	2.059701	3.76925283	Prosthecochloris sp. GSB1	281093	Bacteria	Bacteria	122	1.1699999999999997e-23	NTclustered	gi\|1227310175\|gb\|CP022571.1\|	281093	g28764	i0	85.965	9.12568306010929	114	16	62	0	37	150	1491329	1491216	Prosthecochloris sp. GSB1 strain TY Vent = GSB1 = Ty-1 chromosome, complete genome	blastn	1670	122	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. GSB1
14038589	14038589	PRJDB4941_P_NODE_39492_length_163_cov_1.368421_g38724_i0	PRJDB4941	39492	163	1.368421	2.23052623	Chryseobacterium indologenes	253	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g38724	i0	100	99.8895705521472	163	0	100	0	1	163	3849572	3849410	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	16282	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
16284312	16284312	PRJDB4941_P_NODE_36393_length_167_cov_0.881356_g35625_i0	PRJDB4941	36393	167	0.881356	1.47186452	Flavobacterium	237	Bacteria	Bacteria	270	3.5499999999999993e-68	NTclustered	gi\|2775797868\|gb\|CP162004.1\|	3234138	g35625	i0	95.808	98.437125748502993	167	7	100	0	1	167	2648242	2648076	Flavobacterium sp. WC2421 chromosome, complete genome	blastn	16439	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WC2421
19135689	19135689	PRJDB4941_P_NODE_17976_length_244_cov_1.528205_g17208_i0	PRJDB4941	17976	244	1.528205	3.7288202	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	143	1.27e-29	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g17208	i0	79.327	0.852459016393443	208	39	84	4	39	244	1621969	1621764	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	208	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21687110	21687110	PRJDB4941_P_NODE_38678_length_164_cov_0.904348_g37910_i0	PRJDB4941	38678	164	0.904348	1.48313072	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g37910	i0	100	3.98170731707317	164	0	100	0	1	164	1555543	1555380	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	653	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
21687115	21687115	PRJDB4941_P_NODE_38918_length_164_cov_0.904348_g38150_i0	PRJDB4941	38918	164	0.904348	1.48313072	Kaistella sp. 97-N-M2	2908645	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|2180339451\|gb\|CP090976.1\|	2908645	g38150	i0	98.171	1	164	3	100	0	1	164	2751242	2751405	Kaistella sp. 97-N-M2 chromosome, complete genome	blastn	164	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella sp. 97-N-M2
22962449	22962449	PRJDB4941_P_NODE_36779_length_166_cov_0.888889_g36011_i0	PRJDB4941	36779	166	0.888889	1.47555574	Flavobacterium commune	1306519	Bacteria	Bacteria	191	2.82e-44	NTclustered	gi\|1095440834\|gb\|CP017774.1\|	1306519	g36011	i0	88.125	0.963855421686747	160	19	96	0	7	166	1491801	1491642	Flavobacterium commune strain PK15 chromosome, complete genome	blastn	160	191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium commune
22962476	22962476	PRJDB4941_P_NODE_38799_length_164_cov_0.904348_g38031_i0	PRJDB4941	38799	164	0.904348	1.48313072	Prevotella intermedia	28131	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|1276668420\|gb\|CP024727.1\|	28131	g38031	i0	99.39	18.9390243902439	164	1	100	0	1	164	419455	419292	Prevotella intermedia strain KCOM 1949 chromosome 1, complete sequence	blastn	3106	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
22962507	22962507	PRJDB4941_P_NODE_40999_length_162_cov_0.920354_g40231_i0	PRJDB4941	40999	162	0.920354	1.49097348	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	278	2.04e-70	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g40231	i0	97.531	1	162	4	100	0	1	162	1601663	1601824	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	162	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.

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