metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA661142" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA661142" 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
628106	628106	PRJNA661142_P_NODE_11341_length_167_cov_0.864407_g11276_i0	PRJNA661142	11341	167	0.864407	1.44355969	Deinococcus grandis	57498	Bacteria	Bacteria	252	1.29e-62	NTclustered	gi\|1751874214\|dbj\|AP021850.1\|	57498	g11276	i0	94.479	33.1976047904192	163	9	98	0	5	167	227637	227799	Deinococcus grandis ATCC 43672 plasmid: pDEGR-1 DNA, complete genome	blastn	5544	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
3179023	3179023	PRJNA661142_P_NODE_3763_length_404_cov_3.478873_g3699_i0	PRJNA661142	3763	404	3.478873	14.05464692	Deinococcus metallilatus	1211322	Bacteria	Bacteria	259	2.13e-64	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g3699	i0	79.793	5.49009900990099	386	55	93	17	29	404	555088	554716	Deinococcus metallilatus strain MA1002 chromosome	blastn	2218	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
4456072	4456072	PRJNA661142_P_NODE_7744_length_272_cov_0.914798_g7679_i0	PRJNA661142	7744	272	0.914798	2.48825056	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	459	1.2599999999999999e-124	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g7679	i0	97.407	180.970588235294	270	6	99	1	1	270	543528	543260	Deinococcus sp. NW-56 chromosome, complete genome	blastn	49224	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
5731597	5731597	PRJNA661142_P_NODE_6025_length_313_cov_10.670455_g5960_i0	PRJNA661142	6025	313	10.670455	33.39852415	Thermus oshimai	56957	Bacteria	Bacteria	568	2.3499999999999998e-157	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g5960	i0	99.361	12.3003194888179	313	2	100	0	1	313	1227310	1226998	Thermus oshimai strain Blanco chromosome, complete genome	blastn	3850	568	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
7006746	7006746	PRJNA661142_P_NODE_5346_length_335_cov_58.884615_g5281_i0	PRJNA661142	5346	335	58.884615	197.26346025	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	577	4.2199999999999986e-160	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g5281	i0	100	162.591044776119	312	0	93	0	3	314	56934	56623	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	54468	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
8281361	8281361	PRJNA661142_P_NODE_7307_length_281_cov_5.103448_g7242_i0	PRJNA661142	7307	281	5.103448	14.34068888	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	440	4.729999999999998e-119	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g7242	i0	95.307	40.9039145907473	277	13	99	0	5	281	993733	993457	Thermus sp. NEB1569 chromosome, complete genome	blastn	11494	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
9556630	9556630	PRJNA661142_P_NODE_3648_length_411_cov_18.671271_g3584_i0	PRJNA661142	3648	411	18.671271	76.73892381	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	660	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g3584	i0	97.179	21.7785888077859	390	11	95	0	20	409	1174979	1175368	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	8951	660	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
10090354	10090354	PRJNA661142_P_NODE_3868_length_398_cov_2.547278_g3804_i0	PRJNA661142	3868	398	2.547278	10.13816644	Thermus	270	Bacteria	Bacteria	327	5.66e-85	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g3804	i0	89.394	66.4798994974874	264	22	100	5	138	398	1960143	1960403	Thermus scotoductus SA-01, complete genome	blastn	26459	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
11365162	11365162	PRJNA661142_P_NODE_2189_length_530_cov_113.667360_g2126_i0	PRJNA661142	2189	530	113.66736	602.437008	Deinococcus	1298	Bacteria	Bacteria	776	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g2126	i0	94.175	294.611320754717	515	21	96	6	22	530	1792037	1792548	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	156144	776	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12107514	12107514	PRJNA661142_P_NODE_4110_length_385_cov_2.732143_g4045_i0	PRJNA661142	4110	385	2.732143	10.51875055	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	580	3.7899999999999985e-161	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g4045	i0	96.591	15.8597402597403	352	9	91	2	6	354	394351	394702	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	6106	580	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
12640962	12640962	PRJNA661142_P_NODE_4250_length_378_cov_9.310030_g4185_i0	PRJNA661142	4250	378	9.31003	35.1919134	Deinococcus	1298	Bacteria	Bacteria	604	2.2e-168	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g4185	i0	99.107	17.042328042328	336	3	89	0	1	336	1546335	1546000	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	6442	610	0.99016393442623	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
13382251	13382251	PRJNA661142_P_NODE_811_length_774_cov_81.277241_g760_i0	PRJNA661142	811	774	81.277241	629.08584534	Deinococcus taeanensis	2737050	Bacteria	Bacteria	1046	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g760	i0	91.942	202.136950904393	757	45	97	11	1	753	983	1727	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	156454	1046	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
13915757	13915757	PRJNA661142_P_NODE_5231_length_339_cov_2.813793_g5166_i0	PRJNA661142	5231	339	2.813793	9.53875827	Thermus	270	Bacteria	Bacteria	436	7.559999999999999e-118	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g5166	i0	90.361	50.3834808259587	332	32	98	0	8	339	1567366	1567697	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	17080	438	0.995433789954338	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
14657130	14657130	PRJNA661142_P_NODE_812_length_774_cov_75.275862_g761_i0	PRJNA661142	812	774	75.275862	582.63517188	Deinococcus taeanensis	2737050	Bacteria	Bacteria	1035	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g761	i0	91.667	200.719638242894	756	49	97	9	22	774	1727	983	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	155357	1035	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
20288244	20288244	PRJNA661142_P_NODE_996_length_722_cov_67.980684_g942_i0	PRJNA661142	996	722	67.980684	490.82053848	Deinococcus	1298	Bacteria	Bacteria	1007	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g942	i0	91.873	361.13296398892	726	51	100	4	1	722	2084318	2085039	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	260738	1011	0.996043521266073	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
21030694	21030694	PRJNA661142_P_NODE_6677_length_296_cov_3.048583_g6612_i0	PRJNA661142	6677	296	3.048583	9.02380568	Thermus scotoductus	37636	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g6612	i0	100	12.875	296	0	100	0	1	296	295935	296230	Thermus scotoductus SA-01, complete genome	blastn	3811	547	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
22839240	22839240	PRJNA661142_P_NODE_6358_length_305_cov_1.066406_g6293_i0	PRJNA661142	6358	305	1.066406	3.2525383	Deinococcus	1298	Bacteria	Bacteria	268	2.59e-67	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g6293	i0	84.962	16.8885245901639	266	38	87	2	11	275	2208989	2209253	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	5151	270	0.992592592592593	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
24854399	24854399	PRJNA661142_P_NODE_4860_length_352_cov_12.237624_g4795_i0	PRJNA661142	4860	352	12.237624	43.07643648	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	603	7.319999999999999e-168	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g4795	i0	100	18.6931818181818	326	0	93	0	1	326	1462101	1462426	Thermus sp. NEB1569 chromosome, complete genome	blastn	6580	603	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569

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