metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA681861" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA681861" and tax_phylum = "Deinococcota"

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
657438	657438	PRJNA681861_P_NODE_46581_length_153_cov_2.000000_g44481_i0	PRJNA681861	46581	153	2	3.06	Deinococcus metallilatus	1211322	Bacteria	Bacteria	91.6	2.66e-14	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g44481	i0	90.278	341.352941176471	72	3	46	4	1	70	329053	329122	Deinococcus metallilatus strain MA1002 chromosome	blastn	52227	91.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
1171360	1171360	PRJNA681861_P_NODE_46901_length_151_cov_3.368852_g44801_i0	PRJNA681861	46901	151	3.368852	5.08696652	Truepera	332248	Bacteria	Bacteria	191	2.4999999999999997e-44	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g44801	i0	89.404	6	151	16	100	0	1	151	937	1087	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	906	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
1933549	1933549	PRJNA681861_P_NODE_12862_length_473_cov_18.531532_g10841_i0	PRJNA681861	12862	473	18.531532	87.65414636	Deinococcus ficus	317577	Bacteria	Bacteria	575	2.2099999999999994e-159	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g10841	i0	88.773	227.243128964059	481	38	99	12	2	472	2343010	2342536	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	107486	575	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
2446736	2446736	PRJNA681861_P_NODE_33262_length_199_cov_2.947059_g31162_i0	PRJNA681861	33262	199	2.947059	5.86464741	Truepera	332248	Bacteria	Bacteria	268	1.5799999999999998e-67	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g31162	i0	91.71	312.482412060301	193	16	97	0	7	199	310	502	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	62184	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3208395	3208395	PRJNA681861_P_NODE_9163_length_641_cov_2.988562_g7357_i0	PRJNA681861	9163	641	2.988562	19.15668242	Trueperaceae bacterium	2026798	Bacteria	Bacteria	765	0	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g7357	i0	88.372	339.538221528861	645	64	99	7	5	641	8286	7645	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	217644	765	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
5761140	5761140	PRJNA681861_P_NODE_10905_length_550_cov_70.216891_g8959_i0	PRJNA681861	10905	550	70.216891	386.1929005	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	815	0	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g8959	i0	95	209.147272727273	520	24	94	2	1	518	1507930	1508449	Deinococcus sp. QL22 chromosome, complete genome	blastn	115031	815	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
7036096	7036096	PRJNA681861_P_NODE_17046_length_368_cov_11.840708_g14950_i0	PRJNA681861	17046	368	11.840708	43.57380544	Deinococcus ficus	317577	Bacteria	Bacteria	403	8.38e-108	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g14950	i0	93.431	160.573369565217	274	15	74	2	97	367	2342737	2343010	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	59091	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8824321	8824321	PRJNA681861_P_NODE_19867_length_318_cov_32.948097_g17767_i0	PRJNA681861	19867	318	32.948097	104.77494846	Deinococcus	1298	Bacteria	Bacteria	468	2.5e-127	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g17767	i0	94.194	195.342767295597	310	13	97	5	12	318	2868	2561	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	62119	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11375009	11375009	PRJNA681861_P_NODE_33669_length_197_cov_52.369048_g31569_i0	PRJNA681861	33669	197	52.369048	103.16702456	Deinococcus	1298	Bacteria	Bacteria	331	1.96e-86	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g31569	i0	96.954	215.756345177665	197	6	100	0	1	197	69923	69727	Deinococcus puniceus strain DY1, complete genome	blastn	42504	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
12136950	12136950	PRJNA681861_P_NODE_20810_length_305_cov_32.652174_g18710_i0	PRJNA681861	20810	305	32.652174	99.5891307	Deinococcus radiodurans	1299	Bacteria	Bacteria	449	8.63e-122	NTclustered	gi\|2106677644\|pdb\|7A18\|X	243230	g18710	i0	93.464	210.668852459016	306	14	100	5	1	305	2697	2397	Chain X, RNA (2699-MER)	blastn	64254	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
17749182	17749182	PRJNA681861_P_NODE_16674_length_376_cov_72.815562_g14579_i0	PRJNA681861	16674	376	72.815562	273.78651312	Deinococcus	1298	Bacteria	Bacteria	623	6.049999999999999e-174	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g14579	i0	96.543	213.135638297872	376	13	100	0	1	376	2672450	2672075	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	80139	628	0.99203821656051006	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
18509651	18509651	PRJNA681861_P_NODE_44655_length_163_cov_2.343284_g42555_i0	PRJNA681861	44655	163	2.343284	3.81955292	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	169	1.29e-37	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g42555	i0	85.629	76.079754601227	167	16	100	7	1	163	543501	543339	Deinococcus sp. NW-56 chromosome, complete genome	blastn	12401	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
19784487	19784487	PRJNA681861_P_NODE_10816_length_555_cov_68.017110_g8872_i0	PRJNA681861	10816	555	68.01711	377.4949605	Deinococcus metallilatus	1211322	Bacteria	Bacteria	806	0	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g8872	i0	94.466	209.18018018018	524	27	94	2	33	555	329881	329359	Deinococcus metallilatus strain MA1002 chromosome	blastn	116095	806	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
25397833	25397833	PRJNA681861_P_NODE_14440_length_427_cov_87.768844_g12370_i0	PRJNA681861	14440	427	87.768844	374.77296388	Deinococcus	1298	Bacteria	Bacteria	623	6.959999999999999e-174	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g12370	i0	93.735	227.180327868852	415	26	97	0	8	422	1051	637	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	97006	625	0.9968	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
25397854	25397854	PRJNA681861_P_NODE_43620_length_169_cov_2.214286_g41520_i0	PRJNA681861	43620	169	2.214286	3.74214334	Meiothermus	65551	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g41520	i0	100	39	169	0	100	0	1	169	2439	2271	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	6591	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber

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