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

5 rows where analysis = "blastn", bioproject = "PRJNA715461" 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
705127	705127	PRJNA715461_S_NODE_901_length_264_cov_3.256545_g827_i0	PRJNA715461	901	264	3.256545	8.5972788	Deinococcus taeanensis	2737050	Bacteria	Bacteria	405	1.61e-108	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g827	i0	94.34	196.981060606061	265	13	100	2	1	264	1569	1306	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	52003	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
5808784	5808784	PRJNA715461_S_NODE_745_length_297_cov_8.138393_g671_i0	PRJNA715461	745	297	8.138393	24.17102721	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	436	6.519999999999999e-118	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g671	i0	100	133.750841750842	236	0	79	0	4	239	57054	56819	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	39724	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
16495120	16495120	PRJNA715461_S_NODE_353_length_459_cov_4.585492_g282_i0	PRJNA715461	353	459	4.585492	21.04740828	Deinococcus	1298	Bacteria	Bacteria	623	7.529999999999998e-174	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g282	i0	94.776	182.858387799564	402	17	87	4	60	459	423877	423478	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	83932	628	0.99203821656051006	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
21594447	21594447	PRJNA715461_S_NODE_697_length_307_cov_2.888889_g623_i0	PRJNA715461	697	307	2.888889	8.86888923	Deinococcus	1298	Bacteria	Bacteria	418	2.449999999999999e-112	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g623	i0	91.447	166.465798045603	304	26	99	0	4	307	298	601	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	51105	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
24143819	24143819	PRJNA715461_S_NODE_259_length_543_cov_113.917021_g201_i0	PRJNA715461	259	543	113.917021	618.56942403	Deinococcus	1298	Bacteria	Bacteria	787	0	NTclustered	gi\|1095429301\|gb\|KY056229.1\|	47478	g201	i0	99.087	107.740331491713	438	4	81	0	102	539	817	380	Deinococcus sp. strain 6004 16S ribosomal RNA gene, partial sequence	blastn	58503	787	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.

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