metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB2925" 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
2575931	2575931	PRJEB2925_P_NODE_13543_length_282_cov_16.578947_g12265_i0	PRJEB2925	13543	282	16.578947	46.75263054	Truepera radiovictrix	332249	Bacteria	Bacteria	466	7.84e-127	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g12265	i0	96.454	392.457446808511	282	10	100	0	1	282	946698	946417	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	110673	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3538695	3538695	PRJEB2925_P_NODE_5763_length_552_cov_438.344294_g4695_i0	PRJEB2925	5763	552	438.344294	2419.66050288	Deinococcus	1298	Bacteria	Bacteria	599	1.55e-166	NTclustered	gi\|1219686863\|gb\|MF524660.1\|	47478	g4695	i0	91.344	85.7083333333333	439	37	80	1	114	552	25	462	Deinococcus sp. strain MadaFrogSkinBac.DB-.3438 16S ribosomal RNA gene, partial sequence	blastn	47311	603	0.993366500829187	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
6404309	6404309	PRJEB2925_P_NODE_16806_length_233_cov_2.525253_g15528_i0	PRJEB2925	16806	233	2.525253	5.88383949	Deinococcus yunweiensis	367282	Bacteria	Bacteria	174	4.27e-39	NTclustered	gi\|2890657226\|gb\|CP177254.1\|	367282	g15528	i0	88.591	1.84549356223176	149	10	62	7	2	146	36966	37111	Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP2, complete sequence	blastn	430	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
7678319	7678319	PRJEB2925_P_NODE_12827_length_295_cov_10.980769_g11550_i0	PRJEB2925	12827	295	10.980769	32.39326855	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	390	5.11e-104	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g11550	i0	91.289	308.074576271186	287	24	97	1	1	286	543391	543105	Deinococcus sp. NW-56 chromosome, complete genome	blastn	90882	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
8953132	8953132	PRJEB2925_P_NODE_4108_length_688_cov_10.119449_g3203_i0	PRJEB2925	4108	688	10.119449	69.62180912	Deinococcus grandis	57498	Bacteria	Bacteria	1009	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g3203	i0	94.769	206.888081395349	650	30	100	4	1	648	74084	73437	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	142339	1009	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
9916294	9916294	PRJEB2925_P_NODE_6168_length_528_cov_150.545639_g5064_i0	PRJEB2925	6168	528	150.545639	794.88097392	Truepera	332248	Bacteria	Bacteria	457	9.4e-124	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5064	i0	83.203	719.181818181818	512	72	96	13	24	528	15	519	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	379728	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12467163	12467163	PRJEB2925_P_NODE_11490_length_324_cov_221.186851_g10215_i0	PRJEB2925	11490	324	221.186851	716.64539724	Deinococcus	1298	Bacteria	Bacteria	340	5.8e-89	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g10215	i0	86.581	195.753086419753	313	36	96	6	5	314	1121	812	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	63424	340	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
12779642	12779642	PRJEB2925_P_NODE_1491_length_1554_cov_17.313364_g1097_i0	PRJEB2925	1491	1554	17.313364	269.04967656	Deinococcus gobiensis	502394	Bacteria	Bacteria	1888	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g1097	i0	90.649	256.724581724582	1433	116	92	13	120	1539	111016	109589	Deinococcus gobiensis I-0, complete genome	blastn	398950	1888	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
21390259	21390259	PRJEB2925_P_NODE_2157_length_1117_cov_24.817930_g1612_i0	PRJEB2925	2157	1117	24.81793	277.2162781	Deinococcus	1298	Bacteria	Bacteria	1596	0	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g1612	i0	92.665	288.570277529096	1118	67	99	14	9	1117	116913	115802	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	322333	1596	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
21702861	21702861	PRJEB2925_P_NODE_4118_length_687_cov_12.756135_g3212_i0	PRJEB2925	4118	687	12.756135	87.63464745	Deinococcus taeanensis	2737050	Bacteria	Bacteria	928	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g3212	i0	92.627	207.496360989811	651	38	94	10	4	647	1954	1307	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	142550	928	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
24251913	24251913	PRJEB2925_P_NODE_2480_length_985_cov_26.603158_g1852_i0	PRJEB2925	2480	985	26.603158	262.0411063	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	1652	0	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g1852	i0	96.866	334.435532994924	989	27	100	3	1	985	200216	201204	Deinococcus sp. AJ005 chromosome, complete genome	blastn	329419	1652	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005

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