metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
1252741	1252741	PRJNA928559_P_NODE_142701_length_296_cov_1.278027_g141132_i0	PRJNA928559	142701	296	1.278027	3.78295992	Gemmatimonas	173479	Bacteria	Bacteria	230	1.1799999999999998e-55	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g141132	i0	84.681	7.49662162162162	235	31	78	4	30	261	135	367	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	2219	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
2179444	2179444	PRJNA928559_P_NODE_48962_length_488_cov_5.930120_g47400_i0	PRJNA928559	48962	488	5.93012	28.9389856	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	187	1.2499999999999997e-42	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g47400	i0	77.581	7.69262295081967	339	56	69	14	40	374	3058954	3059276	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	3754	187	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
3453955	3453955	PRJNA928559_P_NODE_183683_length_256_cov_1.453552_g182114_i0	PRJNA928559	183683	256	1.453552	3.72109312	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g182114	i0	94.444	0.140625	36	2	14	0	83	118	673865	673830	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	36	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5081003	5081003	PRJNA928559_P_NODE_126604_length_316_cov_1.292181_g125035_i0	PRJNA928559	126604	316	1.292181	4.08329196	Gemmatimonas	173479	Bacteria	Bacteria	318	2.64e-82	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g125035	i0	86	20.2784810126582	300	38	94	4	10	307	1528	1231	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	6408	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
8905511	8905511	PRJNA928559_P_NODE_143827_length_294_cov_3.457014_g142258_i0	PRJNA928559	143827	294	3.457014	10.16362116	Gemmatimonas	173479	Bacteria	Bacteria	529	1.0299999999999996e-145	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g142258	i0	99.315	132.234693877551	292	2	99	0	1	292	292	1	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	38877	532	0.994360902255639	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
9830429	9830429	PRJNA928559_P_NODE_153068_length_284_cov_3.720379_g151499_i0	PRJNA928559	153068	284	3.720379	10.56587636	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	217	8.79e-52	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g151499	i0	87.634	58.0528169014084	186	23	65	0	1	186	806536	806351	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	16487	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
9830756	9830756	PRJNA928559_P_NODE_174348_length_264_cov_1.565445_g172779_i0	PRJNA928559	174348	264	1.565445	4.1327748	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	329	9.95e-86	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g172779	i0	89.434	81.6704545454545	265	22	98	6	3	262	3042305	3042568	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	21561	329	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9830957	9830957	PRJNA928559_P_NODE_188608_length_253_cov_0.866667_g187039_i0	PRJNA928559	188608	253	0.866667	2.19266751	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	176	1.31e-39	NTclustered	gi\|2107901501\|gb\|CP070815.1\|	2026742	g187039	i0	80.579	140.97628458498	242	36	92	7	18	250	1294871	1294632	MAG: Gemmatimonadetes bacterium isolate bin118 chromosome	blastn	35667	176	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
13655755	13655755	PRJNA928559_P_NODE_110971_length_338_cov_5.675472_g109402_i0	PRJNA928559	110971	338	5.675472	19.18309536	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2893358392\|emb\|OZ220683.1\|	2026742	g109402	i0	96.875	0.180473372781065	32	1	9	0	79	110	1905812	1905843	MAG: Gemmatimonadota bacterium isolate c4f6f2ca-7934-440c-833b-e1b430e415c5 genome assembly, chromosome: 1	blastn	61	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
14932668	14932668	PRJNA928559_P_NODE_99352_length_358_cov_1.515789_g97783_i0	PRJNA928559	99352	358	1.515789	5.42652462	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	267	1.11e-66	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g97783	i0	83.562	78.4022346368715	292	41	91	6	28	317	438966	439252	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	28068	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18754810	18754810	PRJNA928559_P_NODE_194575_length_250_cov_1.254237_g193006_i0	PRJNA928559	194575	250	1.254237	3.1355925	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g193006	i0	86.694	121.444	248	25	98	8	6	250	3042472	3042714	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	30361	268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20028748	20028748	PRJNA928559_P_NODE_118516_length_327_cov_2.145669_g116947_i0	PRJNA928559	118516	327	2.145669	7.01633763	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	148	3.81e-31	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g116947	i0	79.018	21.3608562691131	224	41	68	5	1	221	7120889	7120669	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	6985	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20029279	20029279	PRJNA928559_P_NODE_156796_length_281_cov_0.865385_g155227_i0	PRJNA928559	156796	281	0.865385	2.43173185	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	298	3.01e-76	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g155227	i0	85.866	98.8896797153025	283	36	100	2	1	281	5908728	5908448	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	27788	298	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales 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);;