metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1002570" 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
4828699	4828699	PRJNA1002570_P_NODE_27024_length_275_cov_1.232673_g26829_i0	PRJNA1002570	27024	275	1.232673	3.38985075	Deinococcus	1298	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g26829	i0	100	201.174545454545	275	0	100	0	1	275	1454599	1454873	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	55323	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
7804691	7804691	PRJNA1002570_P_NODE_17147_length_302_cov_3.951965_g16952_i0	PRJNA1002570	17147	302	3.951965	11.9349343	Deinococcus grandis	57498	Bacteria	Bacteria	167	9.619999999999998e-37	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g16952	i0	93.043	22.8013245033113	115	6	38	2	189	302	1041744	1041857	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	6886	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7805254	7805254	PRJNA1002570_P_NODE_8307_length_395_cov_2.049689_g8112_i0	PRJNA1002570	8307	395	2.049689	8.09627155	Deinococcus radiomollis	468916	Bacteria	Bacteria	113	1.71e-20	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g8112	i0	85.981	6.4506329113924	107	13	27	2	1	106	828411	828516	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	2548	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
9079933	9079933	PRJNA1002570_P_NODE_35488_length_252_cov_1.318436_g35293_i0	PRJNA1002570	35488	252	1.318436	3.32245872	Deinococcus gobiensis	502394	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g35293	i0	99.206	2.66666666666667	252	2	100	0	1	252	1108628	1108377	Deinococcus gobiensis I-0, complete genome	blastn	672	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
14180820	14180820	PRJNA1002570_P_NODE_19452_length_292_cov_1.821918_g19257_i0	PRJNA1002570	19452	292	1.821918	5.32000056	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	418	2.3199999999999996e-112	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g19257	i0	91.935	2.12328767123288	310	7	100	6	1	292	2082257	2082566	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	620	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
15455117	15455117	PRJNA1002570_P_NODE_35573_length_251_cov_2.904494_g35378_i0	PRJNA1002570	35573	251	2.904494	7.29027994	Deinococcus taeanensis	2737050	Bacteria	Bacteria	174	4.65e-39	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g35378	i0	82.16	1.90836653386454	213	28	83	9	44	251	421856	421649	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	479	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
15455169	15455169	PRJNA1002570_P_NODE_38093_length_248_cov_2.262857_g37898_i0	PRJNA1002570	38093	248	2.262857	5.61188536	Deinococcus sp.	47478	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2425458090\|gb\|OQ221940.1\|	47478	g37898	i0	100	105.814516129032	248	0	100	0	1	248	152	399	Deinococcus sp. strain 926 16S ribosomal RNA gene, partial sequence	blastn	26242	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
19278136	19278136	PRJNA1002570_P_NODE_40756_length_245_cov_1.343023_g40561_i0	PRJNA1002570	40756	245	1.343023	3.29040635	Thermus sp. PS18	2849039	Bacteria	Bacteria	398	2.47e-106	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g40561	i0	95.918	4	245	10	100	0	1	245	2125223	2125467	Thermus sp. PS18 chromosome, complete genome	blastn	980	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
21402787	21402787	PRJNA1002570_P_NODE_26357_length_276_cov_2.147783_g26162_i0	PRJNA1002570	26357	276	2.147783	5.92788108	Deinococcus	1298	Bacteria	Bacteria	462	9.89e-126	NTclustered	gi\|161513486\|emb\|AM292065.1\|	1299	g26162	i0	97.08	126.507246376812	274	8	99	0	3	276	133	406	Deinococcus radiodurans partial 16S rRNA gene, isolate zf-69-II	blastn	34916	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
21829241	21829241	PRJNA1002570_P_NODE_33238_length_258_cov_2.491892_g33043_i0	PRJNA1002570	33238	258	2.491892	6.42908136	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	449	7.13e-122	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g33043	i0	98.062	99.2286821705426	258	5	100	0	1	258	285569	285312	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	25601	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis

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