metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax_phylum = "Rhodophyta"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
707418	707418	PRJNA716463_P_NODE_122561_length_220_cov_4.714286_g122143_i0	PRJNA716463	122561	220	4.714286	10.3714292	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	407	3.61e-109	NTclustered	gi\|2745680298\|gb\|PP918987.1\|	1262161	g122143	i0	100	2	220	0	100	0	1	220	22575	22356	Pyropia haitanensis isolate T2-4 female sex-linked region	blastn	440	407	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
708201	708201	PRJNA716463_P_NODE_5981_length_443_cov_10.962162_g5572_i0	PRJNA716463	5981	443	10.962162	48.56237766	Pyropia yezoensis	2788	Rhodophyta	other_Eukaryota	228	6.629999999999999e-55	NTclustered	gi\|2026667496\|dbj\|LC216214.1\|	2788	g5572	i0	84.255	0.530474040632054	235	35	53	2	35	269	111	343	Pyropia yezoensis hipnB mRNA for hypothetical protein, complete cds	blastn	235	228	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia yezoensis
3259087	3259087	PRJNA716463_P_NODE_30903_length_309_cov_2.449153_g30486_i0	PRJNA716463	30903	309	2.449153	7.56788277	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	479	1.1199999999999996e-130	NTclustered	gi\|1494245825\|gb\|MG765436.1\|	1262161	g30486	i0	93.146	11.4757281553398	321	10	100	1	1	309	202	522	Pyropia haitanensis mitogen-activated protein kinase 13 mRNA, complete cds	blastn	3546	479	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
3259472	3259472	PRJNA716463_P_NODE_56523_length_286_cov_2.023474_g56106_i0	PRJNA716463	56523	286	2.023474	5.78713564	Pyropia yezoensis	2788	Rhodophyta	other_Eukaryota	468	2.21e-127	NTclustered	gi\|30525877\|gb\|AY273820.1\|	2788	g56106	i0	96.154	74.5489510489511	286	11	100	0	1	286	959	1244	Porphyra yezoensis cytosolic glyceraldehyde 3-phosphate dehydrogenase (GAPC) mRNA, complete cds	blastn	21321	468	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia yezoensis
3260118	3260118	PRJNA716463_P_NODE_96623_length_254_cov_2.674033_g96206_i0	PRJNA716463	96623	254	2.674033	6.79204382	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	470	5.37e-128	NTclustered	gi\|193792559\|gb\|EU807991.1\|	1262161	g96206	i0	100	3.73622047244094	254	0	100	0	1	254	265	12	Porphyra haitanensis cytosolic ascorbate peroxidase (APX) mRNA, complete cds	blastn	949	470	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
7087443	7087443	PRJNA716463_P_NODE_9186_length_382_cov_3.336570_g8772_i0	PRJNA716463	9186	382	3.33657	12.7456974	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	427	5.18e-115	NTclustered	gi\|693266814\|gb\|KM102541.1\|	1262161	g8772	i0	99.573	1.39267015706806	234	1	100	0	149	382	761	528	Pyropia haitanensis heat shock protein 40 (HSP40) mRNA, complete cds	blastn	532	427	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
8361945	8361945	PRJNA716463_P_NODE_8507_length_394_cov_1.249221_g8094_i0	PRJNA716463	8507	394	1.249221	4.92193074	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	385	3.27e-102	NTclustered	gi\|567767244\|gb\|KF715271.1\|	1262161	g8094	i0	99.526	4.60913705583756	211	1	54	0	65	275	1469	1679	Pyropia haitanensis heat shock protein 70-5 (HSP70-5) mRNA, complete cds	blastn	1816	385	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
9637030	9637030	PRJNA716463_P_NODE_80808_length_268_cov_1.558974_g80391_i0	PRJNA716463	80808	268	1.558974	4.17805032	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	473	4.419999999999999e-129	NTclustered	gi\|736075336\|gb\|KM655307.1\|	1262161	g80391	i0	99.614	0.966417910447761	259	1	97	0	10	268	1293	1035	Pyropia haitanensis TR mRNA, complete cds	blastn	259	473	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
10911569	10911569	PRJNA716463_P_NODE_13429_length_328_cov_4.929412_g13013_i0	PRJNA716463	13429	328	4.929412	16.16847136	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	606	5.249999999999998e-169	NTclustered	gi\|402483698\|gb\|JX188386.1\|	1262161	g13013	i0	100	1	328	0	100	0	1	328	2256	2583	Porphyra haitanensis lipoxygenase (lox) mRNA, complete cds	blastn	328	606	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
13460977	13460977	PRJNA716463_P_NODE_114871_length_237_cov_2.481707_g114453_i0	PRJNA716463	114871	237	2.481707	5.88164559	Pyropia yezoensis	2788	Rhodophyta	other_Eukaryota	318	1.8999999999999998e-82	NTclustered	gi\|528746196\|gb\|KC904979.1\|	2788	g114453	i0	91.139	1	237	18	100	2	1	237	461	228	Pyropia yezoensis S-phase kinase-associated protein 1 (SKP1) mRNA, complete cds	blastn	237	318	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia yezoensis
16011186	16011186	PRJNA716463_P_NODE_85013_length_264_cov_3.445026_g84596_i0	PRJNA716463	85013	264	3.445026	9.09486864	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	60.2	1.44e-4	NTclustered	gi\|1067908609\|gb\|KU726060.1\|	1262161	g84596	i0	97.222	1.06439393939394	36	0	13	1	52	86	638	603	Pyropia haitanensis large subunit ribosomal RNA gene, partial sequence	blastn	281	60.2	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
17286445	17286445	PRJNA716463_P_NODE_71594_length_275_cov_1.955446_g71177_i0	PRJNA716463	71594	275	1.955446	5.3774765	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	486	5.8499999999999985e-133	NTclustered	gi\|2745680298\|gb\|PP918987.1\|	1262161	g71177	i0	98.545	2	275	4	100	0	1	275	102054	102328	Pyropia haitanensis isolate T2-4 female sex-linked region	blastn	550	486	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
21111362	21111362	PRJNA716463_P_NODE_94017_length_257_cov_1.277174_g93600_i0	PRJNA716463	94017	257	1.277174	3.28233718	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	470	5.45e-128	NTclustered	gi\|736075312\|gb\|KM655303.1\|	1262161	g93600	i0	99.611	1	257	1	100	0	1	257	68	324	Pyropia haitanensis CAT mRNA, complete cds	blastn	257	470	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis
22384782	22384782	PRJNA716463_P_NODE_114318_length_238_cov_2.175758_g113900_i0	PRJNA716463	114318	238	2.175758	5.17830404	Pyropia yezoensis	2788	Rhodophyta	other_Eukaryota	143	1.2299999999999998e-29	NTclustered	gi\|223588265\|dbj\|AB480828.1\|	2788	g113900	i0	90.654	0.449579831932773	107	10	45	0	36	142	533	427	Porphyra yezoensis PyMBF1 mRNA for multiprotein bridging factor 1, complete cds	blastn	107	143	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia yezoensis
23661610	23661610	PRJNA716463_P_NODE_82199_length_267_cov_1.231959_g81782_i0	PRJNA716463	82199	267	1.231959	3.28933053	Pyropia yezoensis	2788	Rhodophyta	other_Eukaryota	361	3.57e-95	NTclustered	gi\|2236026315\|gb\|MW410947.1\|	388772	g81782	i0	91.011	1.9812734082397	267	24	100	0	1	267	1749	2015	Pyropia yezoensis f. yezoensis nitrate reductase (NR) gene, partial cds	blastn	529	361	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia yezoensis
24933895	24933895	PRJNA716463_P_NODE_115980_length_235_cov_3.000000_g115562_i0	PRJNA716463	115980	235	3	7.05	Pyropia haitanensis	1262161	Rhodophyta	other_Eukaryota	422	1.39e-113	NTclustered	gi\|567767244\|gb\|KF715271.1\|	1262161	g115562	i0	99.145	1.99574468085106	234	2	99	0	1	234	2002	2235	Pyropia haitanensis heat shock protein 70-5 (HSP70-5) mRNA, complete cds	blastn	469	422	1	Eukaryota	Rhodophyta	Bangiophyceae	Bangiales	Bangiaceae	Pyropia	Pyropia haitanensis

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