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

7 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax_phylum = "Fibrobacterota"

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
5536170	5536170	PRJNA437204_P_NODE_35105_length_338_cov_4.301887_g34806_i0	PRJNA437204	35105	338	4.301887	14.54037806	Fibrobacter succinogenes	833	Bacteria	Bacteria	265	3.7599999999999995e-66	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g34806	i0	82.133	26.1775147928994	347	27	100	11	1	338	753675	753355	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	8848	265	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
5537079	5537079	PRJNA437204_P_NODE_82485_length_251_cov_0.865169_g82186_i0	PRJNA437204	82485	251	0.865169	2.17157419	Fibrobacter succinogenes	833	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g82186	i0	81.739	1.83266932270916	230	42	92	0	20	249	3663843	3663614	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	460	193	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
5537409	5537409	PRJNA437204_P_NODE_99945_length_247_cov_0.885057_g99646_i0	PRJNA437204	99945	247	0.885057	2.18609079	Fibrobacter succinogenes	833	Bacteria	Bacteria	261	3.41e-65	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g99646	i0	86.555	1.92712550607287	238	30	96	2	11	247	407879	408115	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	476	261	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
6810039	6810039	PRJNA437204_P_NODE_27886_length_365_cov_5.208904_g27587_i0	PRJNA437204	27886	365	5.208904	19.0124996	Fibrobacter succinogenes	833	Bacteria	Bacteria	368	3.03e-97	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g27587	i0	85.714	24.372602739726	371	28	99	12	1	362	753355	753709	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	8896	368	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
17010628	17010628	PRJNA437204_P_NODE_83474_length_250_cov_2.875706_g83175_i0	PRJNA437204	83474	250	2.875706	7.189265	Fibrobacter succinogenes	833	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g83175	i0	84.545	35.684	220	22	88	5	23	242	753587	753380	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	8921	207	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
19558660	19558660	PRJNA437204_P_NODE_49956_length_300_cov_3.180617_g49657_i0	PRJNA437204	49956	300	3.180617	9.541851	Fibrobacter succinogenes	833	Bacteria	Bacteria	427	3.97e-115	NTclustered	gi\|559133573\|tpe\|HG788729.1\|	59374	g49657	i0	92.409	4.93333333333333	303	18	100	5	1	300	7	307	TPA: Fibrobacter succinogenes subsp. succinogenes S85 transfer-messenger mRNA Fibro_succi_S85, single chain mature transcript	blastn	1480	427	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
23385597	23385597	PRJNA437204_P_NODE_84779_length_250_cov_0.870056_g84480_i0	PRJNA437204	84779	250	0.870056	2.17514	Fibrobacter succinogenes	833	Bacteria	Bacteria	318	2.02e-82	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g84480	i0	89.6	2	250	26	100	0	1	250	3678339	3678588	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	500	318	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes

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