metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6027569	6027569	PRJNA944406_P_NODE_29345_length_282_cov_2.588517_g28386_i0	PRJNA944406	29345	282	2.588517	7.29961794	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	387	6.279999999999998e-103	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g28386	i0	91.319	195.574468085106	288	18	100	4	1	282	806353	806639	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	55152	387	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
8577927	8577927	PRJNA944406_P_NODE_89387_length_245_cov_1.401163_g88428_i0	PRJNA944406	89387	245	1.401163	3.43284935	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	292	1.2e-74	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g88428	i0	88.211	78.8122448979592	246	27	100	2	1	245	268177	268421	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	19309	292	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
9852278	9852278	PRJNA944406_P_NODE_17808_length_310_cov_1.396624_g16849_i0	PRJNA944406	17808	310	1.396624	4.3295344	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	353	7.09e-93	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g16849	i0	87.22	101.938709677419	313	37	100	3	1	310	806694	807006	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	31601	353	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
11128111	11128111	PRJNA944406_P_NODE_35509_length_277_cov_1.171569_g34550_i0	PRJNA944406	35509	277	1.171569	3.24524613	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	291	4.96e-74	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g34550	i0	85.56	246.696750902527	277	40	100	0	1	277	1309135	1309411	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	68335	291	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
11128691	11128691	PRJNA944406_P_NODE_87989_length_246_cov_0.890173_g87030_i0	PRJNA944406	87989	246	0.890173	2.18982558	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	296	9.3e-76	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g87030	i0	92.344	6.30894308943089	209	14	85	2	1	208	3063014	3063221	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1552	296	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
12738659	12738659	PRJNA944406_P_NODE_101330_length_243_cov_0.905882_g100371_i0	PRJNA944406	101330	243	0.905882	2.20129326	Salinibacter	146918	Bacteria	Bacteria	124	4.579999999999999e-24	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g100371	i0	80.357	8.18930041152263	168	29	68	4	1	166	1718900	1719065	Salinibacter ruber strain P13 chromosome, complete genome	blastn	1990	124	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
14952803	14952803	PRJNA944406_P_NODE_7172_length_470_cov_10.851385_g6216_i0	PRJNA944406	7172	470	10.851385	51.0015095	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	455	2.98e-123	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g6216	i0	84.716	238.465957446809	458	66	97	4	1	457	3830635	3830181	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	112079	455	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
15287302	15287302	PRJNA944406_P_NODE_18892_length_302_cov_2.017467_g17933_i0	PRJNA944406	18892	302	2.017467	6.09275034	Rhodothermales	1853224	Bacteria	Bacteria	390	5.249999999999998e-104	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g17933	i0	90.196	176.341059602649	306	21	100	8	1	302	2905757	2906057	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	53255	390	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
18776023	18776023	PRJNA944406_P_NODE_17075_length_314_cov_0.958506_g16116_i0	PRJNA944406	17075	314	0.958506	3.00970884	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	486	6.7999999999999986e-133	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g16116	i0	94.586	166.248407643312	314	17	100	0	1	314	1307817	1308130	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	52202	486	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
20050852	20050852	PRJNA944406_P_NODE_13316_length_348_cov_1.505455_g12357_i0	PRJNA944406	13316	348	1.505455	5.2389834	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	174	6.74e-39	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g12357	i0	79.31	38.0114942528736	261	45	74	8	1	257	2529385	2529640	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	13228	174	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
24211213	24211213	PRJNA944406_P_NODE_98079_length_243_cov_1.476471_g97120_i0	PRJNA944406	98079	243	1.476471	3.58782453	Rhodothermales	1853224	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g97120	i0	82.041	58.2962962962963	245	36	99	7	2	242	1422202	1422442	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	14166	202	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
25150358	25150358	PRJNA944406_P_NODE_107680_length_241_cov_0.916667_g106721_i0	PRJNA944406	107680	241	0.916667	2.20916747	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	267	7.12e-67	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g106721	i0	86.667	93.195020746888	240	32	99	0	2	241	3029298	3029059	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	22460	267	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871

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