metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA448207" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA448207" 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
8091996	8091996	PRJNA448207_P_NODE_30447_length_245_cov_0.877907_g30284_i0	PRJNA448207	30447	245	0.877907	2.15087215	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	361	3.2399999999999996e-95	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g30284	i0	93.145	322.555102040816	248	14	100	2	1	245	360717	360964	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	79026	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
9366794	9366794	PRJNA448207_P_NODE_33408_length_241_cov_0.916667_g33245_i0	PRJNA448207	33408	241	0.916667	2.20916747	Prevotella sp. oral taxon 299	652716	Bacteria	Bacteria	329	8.95e-86	NTclustered	gi\|532126075\|gb\|CP003667.1\|	575614	g33245	i0	91.286	244.207468879668	241	21	100	0	1	241	1523749	1523509	Prevotella sp. oral taxon 299 str. F0039 plasmid, complete sequence	blastn	58854	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 299
10642377	10642377	PRJNA448207_P_NODE_11649_length_365_cov_1.455479_g11487_i0	PRJNA448207	11649	365	1.455479	5.31249835	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	374	6.509999999999998e-99	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g11487	i0	85.366	57.5178082191781	369	44	100	8	1	365	217703	217341	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	20994	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
13192377	13192377	PRJNA448207_P_NODE_29931_length_245_cov_0.895349_g29768_i0	PRJNA448207	29931	245	0.895349	2.19360505	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	182	2.7e-41	NTclustered	gi\|1869340971\|gb\|CP058703.1\|	2099675	g29768	i0	80.478	255.265306122449	251	38	100	9	1	245	2013176	2013421	MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome	blastn	62540	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
13192550	13192550	PRJNA448207_S_NODE_1631_length_342_cov_1.486989_g1620_i0	PRJNA448207	1631	342	1.486989	5.08550238	Vaginella massiliensis	1816680	Bacteria	Bacteria	62.1	5.37e-5	NTclustered	gi\|2831277486\|gb\|CP171010.1\|	1816680	g1620	i0	86.207	0.169590643274854	58	6	17	2	1	57	1289943	1289887	Vaginella massiliensis strain WGS2087 chromosome, complete genome	blastn	58	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Vaginella	Vaginella massiliensis
13845812	13845812	PRJNA448207_P_NODE_22871_length_268_cov_1.117949_g22708_i0	PRJNA448207	22871	268	1.117949	2.99610332	Cytophagales	768507	Bacteria	Bacteria	265	2.9e-66	NTclustered	gi\|2581931629\|dbj\|AP025313.1\|	866807	g22708	i0	86.885	213.018656716418	244	23	89	9	21	259	5796	6035	Aureibacter tunicatorum NBRC 107587 plasmid pATrrn DNA, complete genome	blastn	57089	267	0.99250936329588	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Persicobacteraceae	Aureibacter	Aureibacter tunicatorum
17016240	17016240	PRJNA448207_P_NODE_6334_length_480_cov_1.378378_g6172_i0	PRJNA448207	6334	480	1.378378	6.6162144	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	676	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g6172	i0	92.083	300.395833333333	480	38	100	0	1	480	216826	217305	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	144190	676	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens

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