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

5 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax_kingdom = "Thermotogati"

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
7389356	7389356	PRJNA1061474_P_NODE_12546_length_586_cov_1.489279_g12309_i0	PRJNA1061474	12546	586	1.489279	8.72717494	Deinococcus	1298	Bacteria	Bacteria	1009	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g12309	i0	98.599	206.988054607509	571	6	97	2	17	586	2148004	2148573	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	121295	1009	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
9939841	9939841	PRJNA1061474_P_NODE_47628_length_249_cov_0.909091_g47382_i0	PRJNA1061474	47628	249	0.909091	2.26363659	Deinococcus	1298	Bacteria	Bacteria	324	4.33e-84	NTclustered	gi\|1562202923\|gb\|MK446833.1\|	47478	g47382	i0	98.895	97.0522088353414	181	2	86	0	34	214	746	566	Deinococcus sp. strain NW-56 16S ribosomal RNA gene, partial sequence	blastn	24166	327	0.990825688073395	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16314091	16314091	PRJNA1061474_P_NODE_37413_length_294_cov_0.995475_g37167_i0	PRJNA1061474	37413	294	0.995475	2.9266965	FCB group	1783270	Bacteria	Bacteria	492	1.36e-134	NTclustered	gi\|2461130873\|gb\|OQ647704.1\|	47478	g37167	i0	96.939	102.010204081633	294	8	100	1	1	294	558	266	Deinococcus sp. strain BFS3LA3 16S ribosomal RNA gene, partial sequence	blastn	29991	496	0.991935483870968	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23130763	23130763	PRJNA1061474_P_NODE_35019_length_307_cov_2.611111_g34773_i0	PRJNA1061474	35019	307	2.611111	8.01611077	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	451	2.42e-122	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g34773	i0	98.069	256.035830618893	259	5	84	0	49	307	1792217	1792475	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	78603	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23964088	23964088	PRJNA1061474_P_NODE_34259_length_312_cov_1.251046_g34013_i0	PRJNA1061474	34259	312	1.251046	3.90326352	Deinococcus	1298	Bacteria	Bacteria	267	9.57e-67	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g34013	i0	83.849	190.416666666667	291	36	93	7	1	291	750	471	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	59410	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis

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