metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA235310" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA235310" 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
1056685	1056685	PRJNA235310_P_NODE_2781_length_229_cov_1.155556_g2755_i0	PRJNA235310	2781	229	1.155556	2.64622324	Niabella	379899	Bacteria	Bacteria	350	6.47e-92	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g2755	i0	94.348	289.087336244541	230	10	100	3	1	229	3745012	3744785	Niabella sp. I6 chromosome	blastn	66201	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6
2917946	2917946	PRJNA235310_P_NODE_2003_length_278_cov_1.829694_g1977_i0	PRJNA235310	2003	278	1.829694	5.08654932	Filimonas lacunae	477680	Bacteria	Bacteria	392	1.3299999999999997e-104	NTclustered	gi\|1031978622\|dbj\|AP017422.1\|	477680	g1977	i0	92.086	173.13309352518	278	22	100	0	1	278	5597958	5598235	Filimonas lacunae DNA, complete genome, strain: NBRC 104114	blastn	48131	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Filimonas	Filimonas lacunae
3607130	3607130	PRJNA235310_P_NODE_6163_length_163_cov_0.912281_g6137_i0	PRJNA235310	6163	163	0.912281	1.48701803	Sphingobacterium	28453	Bacteria	Bacteria	209	7.62e-50	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g6137	i0	91.083	123.110429447853	157	10	95	4	9	163	1769941	1769787	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	20067	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
4194488	4194488	PRJNA235310_P_NODE_5804_length_165_cov_0.896552_g5778_i0	PRJNA235310	5804	165	0.896552	1.4793108	Phnomibacter ginsenosidimutans	2676868	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|1783227364\|gb\|CP046566.1\|	2676868	g5778	i0	98.788	1	165	2	100	0	1	165	1042017	1042181	Phnomibacter ginsenosidimutans strain SB-02 chromosome, complete genome	blastn	165	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Phnomibacter	Phnomibacter ginsenosidimutans
6745072	6745072	PRJNA235310_P_NODE_6426_length_162_cov_0.920354_g6400_i0	PRJNA235310	6426	162	0.920354	1.49097348	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	172	9.92e-39	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g6400	i0	89.13	2.19753086419753	138	15	85	0	23	160	3979105	3978968	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	356	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8020727	8020727	PRJNA235310_P_NODE_1207_length_366_cov_1.801262_g1181_i0	PRJNA235310	1207	366	1.801262	6.59261892	Polaribacter dokdonensis	326329	Bacteria	Bacteria	93.5	2.05e-14	NTclustered	gi\|2274417251\|gb\|CP101505.1\|	326329	g1181	i0	74.766	1.32513661202186	214	50	58	4	135	346	2246732	2246943	Polaribacter dokdonensis strain KCTC 12392 chromosome, complete genome	blastn	485	93.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter dokdonensis
15670158	15670158	PRJNA235310_P_NODE_3233_length_211_cov_1.277778_g3207_i0	PRJNA235310	3233	211	1.277778	2.69611158	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	289	1.2999999999999999e-73	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g3207	i0	92.647	244.227488151659	204	10	97	4	1	204	2978879	2978681	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	51532	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
18908095	18908095	PRJNA235310_P_NODE_4535_length_175_cov_1.238095_g4509_i0	PRJNA235310	4535	175	1.238095	2.16666625	Sphingobacterium	28453	Bacteria	Bacteria	318	1.32e-82	NTclustered	gi\|2235481910\|gb\|CP080574.1\|	459529	g4509	i0	99.429	15	175	1	100	0	1	175	3104182	3104356	Sphingobacterium siyangense strain FTD2 chromosome, complete genome	blastn	2625	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium siyangense
19493329	19493329	PRJNA235310_P_NODE_4096_length_186_cov_1.211679_g4070_i0	PRJNA235310	4096	186	1.211679	2.25372294	Runella sp. SP2	2268026	Bacteria	Bacteria	322	1.1e-83	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g4070	i0	97.861	287.263440860215	187	3	100	1	1	186	5733124	5733310	Runella sp. SP2 chromosome, complete genome	blastn	53431	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2

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