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

10 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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
2705213	2705213	PRJNA1010662_S_NODE_2483_length_208_cov_5.600000_g2438_i0	PRJNA1010662	2483	208	5.6	11.648	Deinococcus puniceus	1182568	Bacteria	Bacteria	331	2.0900000000000002e-86	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g2438	i0	95.652	199.389423076923	207	8	99	1	1	207	72026	71821	Deinococcus puniceus strain DY1, complete genome	blastn	41473	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
6104621	6104621	PRJNA1010662_P_NODE_9445_length_188_cov_1.899281_g9386_i0	PRJNA1010662	9445	188	1.899281	3.57064828	Deinococcus	1298	Bacteria	Bacteria	320	4e-83	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g9386	i0	100	216.56914893617	173	0	92	0	16	188	1793549	1793377	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	40715	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
7379023	7379023	PRJNA1010662_P_NODE_4626_length_247_cov_1.722222_g4567_i0	PRJNA1010662	4626	247	1.722222	4.25388834	Deinococcus	1298	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g4567	i0	100	133.846153846154	247	0	100	0	1	247	788	542	D.radiodurans 16S ribosomal RNA gene	blastn	33060	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
9082403	9082403	PRJNA1010662_P_NODE_4148_length_259_cov_1.728571_g4089_i0	PRJNA1010662	4148	259	1.728571	4.47699889	uncultured Deinococcota bacterium	179882	Bacteria	Bacteria	440	4.309999999999998e-119	NTclustered	gi\|134152601\|dbj\|AB265894.2\|	179882	g4089	i0	97.308	100.181467181467	260	6	100	1	1	259	355	96	Uncultured Thermus/Deinococcus group bacterium gene for 16S rRNA, partial sequence, clone: LH-71	blastn	25947	440	1	Bacteria	Thermotogati	Deinococcota					uncultured Deinococcota bacterium
9082475	9082475	PRJNA1010662_S_NODE_228_length_541_cov_26.610442_g185_i0	PRJNA1010662	228	541	26.610442	143.96249122	Deinococcus radiophilus	32062	Bacteria	Bacteria	944	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g185	i0	98.866	96.7153419593346	529	6	98	0	1	529	203145	202617	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	52323	944	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
10358113	10358113	PRJNA1010662_S_NODE_4509_length_163_cov_5.458333_g4464_i0	PRJNA1010662	4509	163	5.458333	8.89708279	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	300	4.39e-77	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g4464	i0	100	81.558282208589	162	0	100	0	1	162	2130278	2130117	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	13294	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12480261	12480261	PRJNA1010662_P_NODE_16670_length_162_cov_0.920354_g16611_i0	PRJNA1010662	16670	162	0.920354	1.49097348	Deinococcus	1298	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g16611	i0	100	8	162	0	100	0	1	162	307021	306860	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1296	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
13754840	13754840	PRJNA1010662_P_NODE_371_length_814_cov_2.060131_g328_i0	PRJNA1010662	371	814	2.060131	16.76946634	Deinococcus	1298	Bacteria	Bacteria	1441	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g328	i0	98.649	357.19656019656	814	10	100	1	1	814	1792805	1791993	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	290758	1441	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21403590	21403590	PRJNA1010662_S_NODE_657_length_351_cov_28.435065_g612_i0	PRJNA1010662	657	351	28.435065	99.80707815	Deinococcus	1298	Bacteria	Bacteria	625	1.5599999999999998e-174	NTclustered	gi\|2549460888\|gb\|OR304356.1\|	32062	g612	i0	98.864	104.019943019943	352	0	99	3	2	351	764	415	Deinococcus radiophilus strain LMITABS01070 16S ribosomal RNA gene, partial sequence	blastn	36511	625	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
22678330	22678330	PRJNA1010662_S_NODE_698_length_339_cov_18.327703_g653_i0	PRJNA1010662	698	339	18.327703	62.13091317	Deinococcus	1298	Bacteria	Bacteria	608	1.509999999999999e-169	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g653	i0	99.115	134	339	1	99	2	2	339	816	479	D.radiodurans 16S ribosomal RNA gene	blastn	45426	608	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans

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