metadata: contig_metadata: 14 rows where bioproject = "PRJEB15333" and tax

14 rows where bioproject = "PRJEB15333" 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
4813677	4813677	PRJEB15333_P_NODE_17264_length_168_cov_1.747899_g17180_i0	PRJEB15333	17264	168	1.747899	2.93647032	Cytophaga	978	Bacteria	Bacteria	239	1.01e-58	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g17180	i0	92.308	256.767857142857	169	12	100	1	1	168	66	234	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	43137	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
6088949	6088949	PRJEB15333_P_NODE_5985_length_269_cov_1.250000_g5901_i0	PRJEB15333	5985	269	1.25	3.3625	Leadbetterella	319458	Bacteria	Bacteria	209	1.38e-49	NTclustered	gi\|470487076\|ref\|NR_076799.1\|	316068	g5901	i0	81.091	308.985130111524	275	40	100	12	1	269	501	233	Leadbetterella byssophila strain 4M15 23S ribosomal RNA gene, complete sequence	blastn	83117	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Leadbetterella	Leadbetterella byssophila
7673868	7673868	PRJEB15333_P_NODE_18767_length_165_cov_2.620690_g18683_i0	PRJEB15333	18767	165	2.62069	4.3241385	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g18683	i0	92.727	335.993939393939	165	12	100	0	1	165	217218	217054	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	55439	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
8638923	8638923	PRJEB15333_P_NODE_17287_length_168_cov_1.579832_g17203_i0	PRJEB15333	17287	168	1.579832	2.65411776	Aquirufa	2676247	Bacteria	Bacteria	246	6.03e-61	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g17203	i0	97.887	254.690476190476	142	3	98	0	4	145	359717	359858	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	42788	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
10224355	10224355	PRJEB15333_P_NODE_13449_length_187_cov_2.166667_g13365_i0	PRJEB15333	13449	187	2.166667	4.05166729	Arcticibacter sp. MXS-1	3341726	Bacteria	Bacteria	252	1.47e-62	NTclustered	gi\|2802081668\|gb\|CP169244.1\|	3341726	g13365	i0	91.304	319.27807486631	184	16	98	0	4	187	2251033	2251216	Arcticibacter sp. MXS-1 chromosome, complete genome	blastn	59705	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Arcticibacter	Arcticibacter sp. MXS-1
11189187	11189187	PRJEB15333_P_NODE_20149_length_163_cov_0.912281_g20065_i0	PRJEB15333	20149	163	0.912281	1.48701803	Cloacibacterium	501783	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g20065	i0	98.773	9.76073619631902	163	2	100	0	1	163	2595696	2595534	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1591	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
12465002	12465002	PRJEB15333_P_NODE_21250_length_158_cov_2.055046_g21166_i0	PRJEB15333	21250	158	2.055046	3.24697268	Pedobacter	84567	Bacteria	Bacteria	193	7.38e-45	NTclustered	gi\|2738722518\|gb\|CP157278.1\|	1503925	g21166	i0	90	208.455696202532	150	14	94	1	1	149	2592470	2592619	Pedobacter lusitanus strain NL19 chromosome, complete genome	blastn	32936	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter lusitanus
14049756	14049756	PRJEB15333_P_NODE_19572_length_164_cov_0.904348_g19488_i0	PRJEB15333	19572	164	0.904348	1.48313072	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	237	3.52e-58	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g19488	i0	92.683	333.44512195122	164	12	100	0	1	164	1308542	1308705	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	54685	237	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
17873230	17873230	PRJEB15333_P_NODE_18315_length_166_cov_1.606838_g18231_i0	PRJEB15333	18315	166	1.606838	2.66735108	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	237	3.58e-58	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g18231	i0	93.252	193.343373493976	163	7	97	4	3	163	805493	805653	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	32095	237	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
22662777	22662777	PRJEB15333_P_NODE_7858_length_238_cov_2.952381_g7774_i0	PRJEB15333	7858	238	2.952381	7.02666678	Chryseobacterium	59732	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g7774	i0	100	489.773109243697	238	0	100	0	1	238	2627119	2626882	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	116566	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
26716168	26716168	PRJEB15333_P_NODE_14081_length_183_cov_3.380597_g13997_i0	PRJEB15333	14081	183	3.380597	6.18649251	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	49.7	5.79e-5	NR	WP_249755517.1	2942477	g13997	i0	55.1	0.80327868852459	49	16	70.5	3	41	169	210	258	WP_249755517.1 RNA-directed DNA polymerase, partial [Algibacter sp. L4_22]	diamond	147	49.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22
28043882	28043882	PRJEB15333_P_NODE_19565_length_164_cov_0.904348_g19481_i0	PRJEB15333	19565	164	0.904348	1.48313072	Pedobacter cryoconitis	188932	Bacteria	Bacteria	79.3	6.3e-16	NR	WP_184657472.1	188932	g19481	i0	97.4	0.713414634146341	39	1	71.3	0	47	163	1	39	WP_184657472.1 alpha/beta hydrolase [Pedobacter cryoconitis]	diamond	117	79.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter cryoconitis
28201554	28201554	PRJEB15333_P_NODE_20206_length_163_cov_0.912281_g20122_i0	PRJEB15333	20206	163	0.912281	1.48701803	Pedobacter cryoconitis	188932	Bacteria	Bacteria	97.1	7.87e-23	NR	WP_068405685.1	188932	g20122	i0	90.7	0.993865030674847	54	5	99.4	0	162	1	17	70	WP_068405685.1 N-acetylmuramic acid 6-phosphate etherase [Pedobacter cryoconitis]	diamond	162	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter cryoconitis
31392129	31392129	PRJEB15333_P_NODE_14396_length_182_cov_0.774436_g14312_i0	PRJEB15333	14396	182	0.774436	1.40947352	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	43.9	0.00365	NR	MBQ3622304.1	2212467	g14312	i0	43.2	0.725274725274725	44	24	70.9	1	35	163	90	133	MBQ3622304.1 DUF805 domain-containing protein [Bacteroidaceae bacterium]	diamond	132	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium

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