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

8 rows where analysis = "blastn", bioproject = "PRJNA385073" 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
1681419	1681419	PRJNA385073_P_NODE_64742_length_204_cov_6.236641_g64580_i0	PRJNA385073	64742	204	6.236641	12.72274764	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	200	6.01e-47	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g64580	i0	84.541	3	207	26	100	3	1	204	146380	146177	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	612	200	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4233101	4233101	PRJNA385073_P_NODE_36204_length_262_cov_3.518519_g36042_i0	PRJNA385073	36204	262	3.518519	9.21851978	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	364	2.7e-96	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g36042	i0	92.607	298.786259541985	257	13	97	6	9	262	1904040	1904293	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	78282	364	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4904149	4904149	PRJNA385073_P_NODE_30564_length_277_cov_2.068627_g30402_i0	PRJNA385073	30564	277	2.068627	5.73009679	Gemmatimonadota	142182	Bacteria	Bacteria	375	1.3299999999999998e-99	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g30402	i0	91.039	109.967509025271	279	23	100	2	1	277	1605910	1606188	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	30461	375	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8059050	8059050	PRJNA385073_P_NODE_28227_length_284_cov_1.303318_g28065_i0	PRJNA385073	28227	284	1.303318	3.70142312	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	222	1.89e-53	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g28065	i0	81.716	3.65492957746479	268	47	94	2	18	284	1658433	1658167	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1038	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11884753	11884753	PRJNA385073_P_NODE_39490_length_255_cov_1.313187_g39328_i0	PRJNA385073	39490	255	1.313187	3.34862685	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	252	2.13e-62	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g39328	i0	84.706	53.4078431372549	255	35	99	4	1	253	2840644	2840392	Gemmatimonas phototrophica strain AP64, complete genome	blastn	13619	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
13160358	13160358	PRJNA385073_P_NODE_65371_length_198_cov_7.376000_g65209_i0	PRJNA385073	65371	198	7.376	14.60448	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	305	1.19e-78	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g65209	i0	94.872	122.545454545455	195	10	100	0	4	198	172854	172660	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	24264	305	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18258059	18258059	PRJNA385073_P_NODE_63275_length_221_cov_6.486486_g63113_i0	PRJNA385073	63275	221	6.486486	14.33513406	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	350	6.2e-92	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g63113	i0	95.434	113.58371040724	219	10	99	0	3	221	172390	172172	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	25102	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20202576	20202576	PRJNA385073_P_NODE_59716_length_240_cov_2.263473_g59554_i0	PRJNA385073	59716	240	2.263473	5.4323352	Bacteria	2	Bacteria	Bacteria	69.4	2.14e-7	NTclustered	gi\|2893356056\|emb\|OZ220479.1\|	2910168	g59554	i0	86.885	6.1	61	8	25	0	146	206	649458	649398	MAG: Longimicrobiales bacterium isolate ffc3e9c5-5d9e-49e8-9e51-7ae5a16491fe genome assembly, chromosome: 1	blastn	1464	69.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales 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);;