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

5 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax_kingdom = "Fusobacteriati"

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
1760444	1760444	PRJNA509429_P_NODE_32742_length_210_cov_1.794286_g31914_i0	PRJNA509429	32742	210	1.794286	3.7680006	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g31914	i0	99.524	402.504761904762	210	1	100	0	1	210	52994	52785	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	84526	383	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7488841	7488841	PRJNA509429_P_NODE_30326_length_222_cov_3.903743_g29498_i0	PRJNA509429	30326	222	3.903743	8.66630946	Cetobacterium	180162	Bacteria	Bacteria	327	2.92e-85	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g29498	i0	93.243	529.391891891892	222	15	100	0	1	222	280770	280549	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	117525	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8138308	8138308	PRJNA509429_P_NODE_27367_length_240_cov_4.253659_g26539_i0	PRJNA509429	27367	240	4.253659	10.2087816	Cetobacterium somerae	188913	Bacteria	Bacteria	307	4.17e-79	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g26539	i0	91.189	470.420833333333	227	18	95	2	15	240	941243	941018	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	112901	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8138355	8138355	PRJNA509429_P_NODE_43687_length_170_cov_0.881481_g42859_i0	PRJNA509429	43687	170	0.881481	1.4985177	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	298	1.65e-76	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g42859	i0	98.235	430.458823529412	170	3	100	0	1	170	51999	52168	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	73178	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11313925	11313925	PRJNA509429_P_NODE_28489_length_233_cov_5.136364_g27661_i0	PRJNA509429	28489	233	5.136364	11.96772812	Cetobacterium	180162	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g27661	i0	100	533.68669527897	233	0	100	0	1	233	280770	280538	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	124349	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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