metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA345071" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA345071" 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
1070364	1070364	PRJNA345071_P_NODE_11261_length_228_cov_2.064516_g11221_i0	PRJNA345071	11261	228	2.064516	4.70709648	Elizabethkingia	308865	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g11221	i0	100	478.991228070175	228	0	100	0	1	228	304715	304942	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	109210	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
1070365	1070365	PRJNA345071_P_NODE_1921_length_406_cov_2.201201_g1881_i0	PRJNA345071	1921	406	2.201201	8.93687606	Hymenobacter	89966	Bacteria	Bacteria	649	0	NTclustered	gi\|1844056603\|gb\|CP053538.1\|	2735321	g1881	i0	95.556	281.551724137931	405	18	99	0	2	406	244081	244485	Hymenobacter taeanensis strain TS19 chromosome, complete genome	blastn	114310	649	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter taeanensis
4898217	4898217	PRJNA345071_P_NODE_10564_length_243_cov_0.917647_g10524_i0	PRJNA345071	10564	243	0.917647	2.22988221	Bacteroidota	976	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2290648998\|gb\|CP103151.1\|	817	g10524	i0	100	138.753086419753	243	0	100	0	1	243	4368962	4368720	Bacteroides fragilis strain BFG-167 chromosome, complete genome	blastn	33717	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
4898221	4898221	PRJNA345071_P_NODE_11044_length_236_cov_2.564417_g11004_i0	PRJNA345071	11044	236	2.564417	6.05202412	Hymenobacter	89966	Bacteria	Bacteria	427	3.01e-115	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g11004	i0	99.573	280.754237288136	234	1	99	0	1	234	505241	505474	Hymenobacter swuensis DY53, complete genome	blastn	66258	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
5497080	5497080	PRJNA345071_P_NODE_8765_length_249_cov_0.886364_g8725_i0	PRJNA345071	8765	249	0.886364	2.20704636	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g8725	i0	100	87.3614457831325	249	0	100	0	1	249	834441	834689	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	21753	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
8046680	8046680	PRJNA345071_P_NODE_6847_length_262_cov_1.587302_g6807_i0	PRJNA345071	6847	262	1.587302	4.15873124	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	462	9.319999999999999e-126	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g6807	i0	98.479	2.54961832061069	263	3	100	1	1	262	2036330	2036592	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	668	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
16372941	16372941	PRJNA345071_P_NODE_2873_length_350_cov_1.126354_g2833_i0	PRJNA345071	2873	350	1.126354	3.942239	Hymenobacter	89966	Bacteria	Bacteria	549	9.619999999999996e-152	NTclustered	gi\|1594476705\|gb\|CP037922.1\|	2496028	g2833	i0	95.129	318.754285714286	349	16	99	1	1	349	1252834	1253181	Hymenobacter radiodurans strain 17J36-26 chromosome, complete genome	blastn	111564	551	0.996370235934664	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter radiodurans
20196453	20196453	PRJNA345071_P_NODE_2856_length_350_cov_3.339350_g2816_i0	PRJNA345071	2856	350	3.33935	11.687725	Hymenobacter	89966	Bacteria	Bacteria	575	1.5899999999999994e-159	NTclustered	gi\|2221923801\|gb\|CP095046.1\|	2932248	g2816	i0	96.812	364.571428571429	345	10	99	1	1	345	978739	978396	Hymenobacter cellulosilyticus strain 5116 S-3 chromosome, complete genome	blastn	127600	580	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter cellulosilyticus
20794727	20794727	PRJNA345071_P_NODE_3397_length_331_cov_2.643411_g3357_i0	PRJNA345071	3397	331	2.643411	8.74969041	Hymenobacter sp. GOD-10R	3093922	Bacteria	Bacteria	551	2.5199999999999993e-152	NTclustered	gi\|2647515459\|gb\|CP141184.1\|	3093922	g3357	i0	96.677	281.634441087613	331	11	100	0	1	331	1703358	1703028	Hymenobacter sp. GOD-10R chromosome, complete genome	blastn	93221	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. GOD-10R
20794863	20794863	PRJNA345071_P_NODE_9617_length_246_cov_0.901734_g9577_i0	PRJNA345071	9617	246	0.901734	2.21826564	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g9577	i0	99.187	1.95528455284553	246	2	100	0	1	246	4738269	4738024	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	481	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
22069717	22069717	PRJNA345071_P_NODE_10518_length_243_cov_0.917647_g10478_i0	PRJNA345071	10518	243	0.917647	2.22988221	Capnocytophaga ochracea	1018	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2325766218\|gb\|CP110228.1\|	1018	g10478	i0	99.588	11.8271604938272	243	1	100	0	1	243	146459	146217	Capnocytophaga ochracea strain KCOM 2191 chromosome, complete genome	blastn	2874	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga ochracea

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