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

16 rows where analysis = "blastn", bioproject = "PRJNA1151638" 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
301865	301865	PRJNA1151638_P_NODE_2401_length_318_cov_1.330612_g2334_i0	PRJNA1151638	2401	318	1.330612	4.23134616	Spirosoma foliorum	2710596	Bacteria	Bacteria	477	4.149999999999998e-130	NTclustered	gi\|1886902300\|gb\|CP059732.1\|	2710596	g2334	i0	94.025	239.465408805031	318	14	99	5	1	316	2246014	2245700	Spirosoma foliorum strain KCTC 72228 chromosome, complete genome	blastn	76150	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma foliorum
1576665	1576665	PRJNA1151638_P_NODE_782_length_498_cov_3.214118_g715_i0	PRJNA1151638	782	498	3.214118	16.00630764	Spirosoma sp. KUDC1026	2745947	Bacteria	Bacteria	826	0	NTclustered	gi\|1863088467\|gb\|CP056032.1\|	2745947	g715	i0	96.586	275.748995983936	498	17	100	0	1	498	445869	446366	Spirosoma sp. KUDC1026 chromosome, complete genome	blastn	137323	826	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KUDC1026
2312247	2312247	PRJNA1151638_P_NODE_3922_length_269_cov_2.117347_g3855_i0	PRJNA1151638	3922	269	2.117347	5.69566343	Weeksellaceae	2762318	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3855	i0	100	495.100371747212	269	0	100	0	1	269	129950	129682	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	133182	497	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
2852975	2852975	PRJNA1151638_P_NODE_6703_length_242_cov_0.923077_g6636_i0	PRJNA1151638	6703	242	0.923077	2.23384634	Spirosoma oryzicola	2898794	Bacteria	Bacteria	182	2.66e-41	NTclustered	gi\|2168315906\|gb\|CP089538.1\|	2898794	g6636	i0	80.87	2.52479338842975	230	44	95	0	13	242	5524712	5524483	Spirosoma oryzicola strain RHs26 chromosome, complete genome	blastn	611	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma oryzicola
5405018	5405018	PRJNA1151638_P_NODE_3105_length_290_cov_3.013825_g3038_i0	PRJNA1151638	3105	290	3.013825	8.7400925	Spirosoma sp. KCTC 42546	2520506	Bacteria	Bacteria	364	3.0399999999999992e-96	NTclustered	gi\|1702113944\|gb\|CP041360.1\|	2520506	g3038	i0	89.347	202.565517241379	291	29	100	2	1	290	677880	678169	Spirosoma sp. KCTC 42546 chromosome, complete genome	blastn	58744	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KCTC 42546
6139781	6139781	PRJNA1151638_P_NODE_265_length_855_cov_2.650895_g208_i0	PRJNA1151638	265	855	2.650895	22.66515225	Weeksellaceae	2762318	Bacteria	Bacteria	1474	0	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g208	i0	97.78	459.293567251462	856	17	100	2	1	855	2628997	2628143	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	392696	1487	0.991257565568258	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
6139788	6139788	PRJNA1151638_P_NODE_3765_length_272_cov_5.839196_g3698_i0	PRJNA1151638	3765	272	5.839196	15.88261312	Spirosoma	107	Bacteria	Bacteria	316	8.019999999999998e-82	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g3698	i0	88.192	112.963235294118	271	25	99	7	2	272	6728966	6728703	Spirosoma linguale DSM 74, complete genome	blastn	30726	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
10505731	10505731	PRJNA1151638_P_NODE_1829_length_350_cov_1.350181_g1762_i0	PRJNA1151638	1829	350	1.350181	4.7256335	Spirosoma aureum	2692134	Bacteria	Bacteria	340	6.3e-89	NTclustered	gi\|1823150813\|gb\|CP050063.1\|	2692134	g1762	i0	84.551	201.862857142857	356	41	100	13	1	350	445001	445348	Spirosoma aureum strain BT328 chromosome, complete genome	blastn	70652	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aureum
11240220	11240220	PRJNA1151638_P_NODE_1389_length_388_cov_3.692063_g1322_i0	PRJNA1151638	1389	388	3.692063	14.32520444	Spirosoma	107	Bacteria	Bacteria	628	1.3499999999999994e-175	NTclustered	gi\|1864207079\|ref\|NR_169373.1\|	1806202	g1322	i0	95.897	101.886597938144	390	12	100	4	1	388	800	413	Spirosoma areae strain Arct 1-12 16S ribosomal RNA, partial sequence	blastn	39532	628	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma areae
11780515	11780515	PRJNA1151638_P_NODE_1890_length_345_cov_2.411765_g1823_i0	PRJNA1151638	1890	345	2.411765	8.32058925	Fibrella aestuarina	651143	Bacteria	Bacteria	499	9.7e-137	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g1823	i0	92.795	542.220289855072	347	22	100	3	1	345	610997	610652	Fibrella aestuarina BUZ 2 drat genome	blastn	187066	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
13790311	13790311	PRJNA1151638_P_NODE_7211_length_213_cov_9.864286_g7144_i0	PRJNA1151638	7211	213	9.864286	21.01092918	Flavobacteriales	200644	Bacteria	Bacteria	390	3.499999999999999e-104	NTclustered	gi\|2428403098\|gb\|CP115636.1\|	238	g7144	i0	100	443.821596244131	211	0	99	0	1	211	168266	168056	Elizabethkingia meningoseptica strain 2022CK-00380 chromosome, complete genome	blastn	94534	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
15064628	15064628	PRJNA1151638_P_NODE_1112_length_430_cov_2.523810_g1045_i0	PRJNA1151638	1112	430	2.52381	10.852383	Sphingobacteriaceae	84566	Bacteria	Bacteria	623	7.009999999999999e-174	NTclustered	gi\|1062635033\|gb\|CP017141.1\|	430522	g1045	i0	92.824	438.909302325581	432	27	100	4	1	430	1129666	1130095	Pedobacter steynii strain DX4 chromosome, complete genome	blastn	188731	628	0.99203821656051006	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter steynii
17614695	17614695	PRJNA1151638_P_NODE_4734_length_253_cov_1.211111_g4667_i0	PRJNA1151638	4734	253	1.211111	3.06411083	Hymenobacter	89966	Bacteria	Bacteria	315	2.65e-81	NTclustered	gi\|1899473058\|gb\|CP060784.1\|	1385715	g4667	i0	89.837	245.426877470356	246	23	97	2	1	246	935946	936189	Hymenobacter qilianensis strain JCM 19763 chromosome, complete genome	blastn	62093	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter qilianensis
21978831	21978831	PRJNA1151638_P_NODE_5798_length_247_cov_0.896552_g5731_i0	PRJNA1151638	5798	247	0.896552	2.21448344	Bacteroidales bacterium	2030927	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|2907625724\|emb\|OZ223284.1\|	2030927	g5731	i0	92.029	138.748987854251	138	9	55	2	20	156	225427	225291	MAG: Bacteroidales bacterium isolate 96dce958-db9f-4d15-8e2e-9d99d82f70a0 genome assembly, chromosome: 2	blastn	34271	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
23989195	23989195	PRJNA1151638_P_NODE_2079_length_334_cov_2.628352_g2012_i0	PRJNA1151638	2079	334	2.628352	8.77869568	Spirosoma	107	Bacteria	Bacteria	484	2.6199999999999996e-132	NTclustered	gi\|470485150\|ref\|NR_076687.1\|	108	g2012	i0	93.051	369.997005988024	331	23	99	0	1	331	727	1057	Spirosoma linguale strain DSM 74 23S ribosomal RNA gene, complete sequence	blastn	123579	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
24527977	24527977	PRJNA1151638_P_NODE_680_length_535_cov_1.638528_g613_i0	PRJNA1151638	680	535	1.638528	8.7661248	Hymenobacter baengnokdamensis	2615203	Bacteria	Bacteria	773	0	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g613	i0	92.764	309.41308411215	539	31	100	8	1	535	1424025	1424559	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	165536	773	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis

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