metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_phylum = "Gemmatimonadota"

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
9173229	9173229	PRJNA1120060_P_NODE_1975868_length_273_cov_8.160000_g1957840_i0	PRJNA1120060	1975868	273	8.16	22.2768	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	313	1.04e-80	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g1957840	i0	87.97	75.9487179487179	266	30	97	2	6	270	399297	399033	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	20734	313	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9184226	9184226	PRJNA1120060_P_NODE_2849448_length_245_cov_0.901163_g2831362_i0	PRJNA1120060	2849448	245	0.901163	2.20784935	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g2831362	i0	100	0.126530612244898	31	0	13	0	168	198	5654556	5654526	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9192203	9192203	PRJNA1120060_P_NODE_3576408_length_200_cov_8.661417_g3558281_i0	PRJNA1120060	3576408	200	8.661417	17.322834	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	281	2.04e-71	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g3558281	i0	92	37.765	200	16	100	0	1	200	1060128	1060327	Gemmatimonas phototrophica strain AP64, complete genome	blastn	7553	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
10467552	10467552	PRJNA1120060_P_NODE_3537049_length_203_cov_16.053846_g3518922_i0	PRJNA1120060	3537049	203	16.053846	32.58930738	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	204	4.619999999999999e-48	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g3518922	i0	84.804	1.00492610837438	204	29	100	2	1	203	1051956	1051754	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	204	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18115767	18115767	PRJNA1120060_P_NODE_3524855_length_204_cov_15.641221_g3506728_i0	PRJNA1120060	3524855	204	15.641221	31.90809084	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	156	1.32e-33	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g3506728	i0	81.538	0.955882352941177	195	30	94	4	13	204	4609445	4609636	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	195	156	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20659029	20659029	PRJNA1120060_P_NODE_2977557_length_242_cov_0.917160_g2959463_i0	PRJNA1120060	2977557	242	0.91716	2.2195272	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g2959463	i0	86.01	66.1280991735537	193	25	79	2	48	239	591760	591951	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	16003	206	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23202596	23202596	PRJNA1120060_P_NODE_2334159_length_260_cov_1.342246_g2316099_i0	PRJNA1120060	2334159	260	1.342246	3.4898396	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	283	7.719999999999999e-72	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g2316099	i0	86.486	86.6807692307692	259	33	99	2	1	258	4433472	4433729	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	22537	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
24473777	24473777	PRJNA1120060_P_NODE_2144260_length_267_cov_1.809278_g2126214_i0	PRJNA1120060	2144260	267	1.809278	4.83077226	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	182	2.99e-41	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g2126214	i0	83.938	1.14606741573034	193	27	72	4	77	267	669360	669170	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	306	182	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis

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