metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB80557" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB80557" 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	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
1413732	1413732	PRJEB80557_S_NODE_25422_length_191_cov_1.591549_g25026_i0	PRJEB80557	25422	191	1.591549	3.03985859	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	351	1.45e-92	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g25026	i0	100	98.8062827225131	190	0	99	2	191	770520	770331	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	18872	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
1413783	1413783	PRJEB80557_S_NODE_31602_length_172_cov_2.536585_g31206_i0	PRJEB80557	31602	172	2.536585	4.3629262	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	313	5.989999999999998e-81	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g31206	i0	99.419	12	172	1	100	1	172	1762970	1762799	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	2064	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
4824655	4824655	PRJEB80557_S_NODE_4804_length_390_cov_2.568915_g4408_i0	PRJEB80557	4804	390	2.568915	10.0187685	Fusobacterium	848	Bacteria	Bacteria	678	0	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g4408	i0	100	94.1076923076923	367	0	94	1	367	1984599	1984233	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	36702	678	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9066345	9066345	PRJEB80557_S_NODE_17648_length_225_cov_0.886364_g17252_i0	PRJEB80557	17648	225	0.886364	1.994319	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	226	1.1099999999999999e-54	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g17252	i0	84.821	96.1155555555556	224	34	99	1	224	2155745	2155522	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	21626	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
11617618	11617618	PRJEB80557_S_NODE_22910_length_199_cov_3.653333_g22514_i0	PRJEB80557	22910	199	3.653333	7.27013267	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g22514	i0	94.118	0.170854271356784	34	2	17	51	84	1247404	1247371	Leptotrichia sp. SK-5 DNA, complete genome	blastn	34	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
11617791	11617791	PRJEB80557_S_NODE_6930_length_336_cov_2.898955_g6534_i0	PRJEB80557	6930	336	2.898955	9.7404888	Fusobacterium vincentii	155615	Bacteria	Bacteria	599	9.029999999999998e-167	NTclustered	gi\|2706463290\|gb\|CP084077.1\|	155615	g6534	i0	98.81	54.0267857142857	336	4	100	1	336	2128975	2129310	Fusobacterium vincentii strain SB054 chromosome, complete genome	blastn	18153	599	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium vincentii
15024386	15024386	PRJEB80557_S_NODE_16412_length_232_cov_1.486339_g16016_i0	PRJEB80557	16412	232	1.486339	3.44830648	Fusobacterium	848	Bacteria	Bacteria	387	5.01e-103	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g16016	i0	100	440.801724137931	209	0	90	1	209	461701	461493	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	102266	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
17990486	17990486	PRJEB80557_S_NODE_10895_length_278_cov_1.615721_g10499_i0	PRJEB80557	10895	278	1.615721	4.49170438	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|1276712381\|gb\|CP024701.1\|	2663009	g10499	i0	99.64	480.147482014389	278	1	100	1	278	1998756	1998479	Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome	blastn	133481	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
22673422	22673422	PRJEB80557_S_NODE_15498_length_238_cov_1.825397_g15102_i0	PRJEB80557	15498	238	1.825397	4.34444486	Fusobacterium	848	Bacteria	Bacteria	424	3.93e-114	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g15102	i0	98.739	38.9873949579832	238	3	100	1	238	1445113	1445350	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	9279	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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