metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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
25531821	25531821	PRJNA1233465a_S_NODE_157145_length_192_cov_0.846154_g155871_i0	PRJNA1233465	157145	192	0.846154	1.62461568	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	211	2.58e-50	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g155871	i0	87.5	11.65625	184	21	95	2	6	188	3905943	3905761	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2238	211	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
25543070	25543070	PRJNA1233465d_S_NODE_29233_length_306_cov_2.003891_g28122_i0	PRJNA1233465	29233	306	2.003891	6.13190646	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	226	1.59e-54	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g28122	i0	83.265	13.0915032679739	245	41	80	0	3	247	761128	761372	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	4006	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25544351	25544351	PRJNA1233465d_S_NODE_65569_length_217_cov_1.214286_g64458_i0	PRJNA1233465	65569	217	1.214286	2.63500062	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	165	2.3600000000000002e-36	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g64458	i0	84.756	2.61290322580645	164	25	76	0	52	215	490462	490625	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	567	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
25808203	25808203	PRJNA1233465a_S_NODE_99995_length_229_cov_1.588889_g98721_i0	PRJNA1233465	99995	229	1.588889	3.63855581	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	233	6.799999999999999e-57	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g98721	i0	85.845	3.87336244541485	219	31	96	0	11	229	1050465	1050683	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	887	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
25818194	25818194	PRJNA1233465e_S_NODE_109307_length_186_cov_1.116788_g107997_i0	PRJNA1233465	109307	186	1.116788	2.07722568	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	93.5	9.37e-15	NTclustered	gi\|2108172456\|gb\|CP070716.1\|	2026742	g107997	i0	80.488	1.58064516129032	123	23	66	1	29	151	1589861	1589982	MAG: Gemmatimonadetes bacterium isolate bin486 chromosome	blastn	294	93.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
25819927	25819927	PRJNA1233465e_S_NODE_156427_length_163_cov_1.500000_g155117_i0	PRJNA1233465	156427	163	1.5	2.445	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	134	4.72e-27	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g155117	i0	81.875	2.92638036809816	160	27	98	2	1	159	5354741	5354583	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	477	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26031303	26031303	PRJNA1233465f_S_NODE_147332_length_202_cov_1.575163_g145052_i0	PRJNA1233465	147332	202	1.575163	3.18182926	root	1	Root_unresolved	Root_unresolved	82.4	2.24e-11	NTclustered	gi\|219811715\|gb\|FJ551929.1\|	221169	g145052	i0	100	37.9158415841584	44	0	22	0	1	44	432	475	Uncultured Gemmatimonas sp. clone LTSP_BACT_P4N09 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	7659	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	uncultured Gemmatimonas sp.
26083258	26083258	PRJNA1233465b_S_NODE_318293_length_170_cov_1.578512_g316608_i0	PRJNA1233465	318293	170	1.578512	2.6834704	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	152	1.36e-32	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g316608	i0	83.851	26.9705882352941	161	24	94	2	11	170	1888139	1887980	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	4585	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26164474	26164474	PRJNA1233465b_S_NODE_247565_length_191_cov_1.260563_g245880_i0	PRJNA1233465	247565	191	1.260563	2.40767533	Gemmatimonadaceae	219687	Bacteria	Bacteria	169	1.56e-37	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g245880	i0	86.452	3.27225130890052	155	19	81	2	38	191	5227881	5228034	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	625	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
26491003	26491003	PRJNA1233465b_S_NODE_264896_length_185_cov_1.632353_g263211_i0	PRJNA1233465	264896	185	1.632353	3.01985305	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	224	3.16e-54	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g263211	i0	88.649	1	185	19	99	2	2	185	7408009	7408192	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	185	224	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);;