metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_phylum = "Armatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3087973	3087973	PRJNA558770_P_NODE_102303_length_234_cov_11.944724_g100298_i0	PRJNA558770	102303	234	11.944724	27.95065416	Capsulimonas corticalis	2219043	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g100298	i0	100	0.11965811965812	28	0	12	0	182	209	5129127	5129154	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
3680967	3680967	PRJNA558770_P_NODE_3263_length_861_cov_11.277240_g2335_i0	PRJNA558770	3263	861	11.27724	97.0970364	Fimbriimonas	1005038	Bacteria	Bacteria	647	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g2335	i0	89.844	122.358885017422	512	39	69	5	2	512	29058	28559	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	105351	647	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8781795	8781795	PRJNA558770_P_NODE_16627_length_477_cov_10.404977_g14824_i0	PRJNA558770	16627	477	10.404977	49.63174029	Fimbriimonas	1005038	Bacteria	Bacteria	292	2.51e-74	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g14824	i0	88.889	71.8658280922432	243	20	68	5	3	243	28546	28309	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	34280	292	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
13293894	13293894	PRJNA558770_P_NODE_241831_length_234_cov_2.497487_g239826_i0	PRJNA558770	241831	234	2.497487	5.84411958	Fimbriimonas sp.	1936159	Bacteria	Bacteria	134	7.28e-27	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g239826	i0	100	46.3119658119658	72	0	63	0	160	231	1688491	1688562	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	10837	134	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
13883169	13883169	PRJNA558770_P_NODE_240011_length_234_cov_2.537688_g238006_i0	PRJNA558770	240011	234	2.537688	5.93818992	Armatimonadota	67819	Bacteria	Bacteria	134	7.28e-27	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g238006	i0	100	14.1837606837607	72	0	62	0	159	230	35467	35538	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	3319	134	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus

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