metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA627467" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA627467" and tax_phylum = "Rotifera"

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
599137	599137	PRJNA627467_P_NODE_17541_length_164_cov_3.565217_g17472_i0	PRJNA627467	17541	164	3.565217	5.84695588	Philodina roseola	96448	Rotifera	other_Eukaryota	156	1.01e-33	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g17472	i0	94.949	1.20731707317073	99	5	60	0	62	160	34465	34563	Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds	blastn	198	156	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
18451180	18451180	PRJNA627467_P_NODE_13875_length_174_cov_4.232000_g13806_i0	PRJNA627467	13875	174	4.232	7.36368	Adineta vaga	104782	Rotifera	other_Eukaryota	108	3.08e-19	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g13806	i0	96.923	0.649425287356322	65	0	64	2	11	74	3977	4040	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	113	108	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
19002438	19002438	PRJNA627467_P_NODE_8795_length_197_cov_8.574324_g8726_i0	PRJNA627467	8795	197	8.574324	16.89141828	Metazoa	33208	Rotifera	other_Eukaryota	353	4.18e-93	NTclustered	gi\|146157266\|gb\|EF485009.1\|	96448	g8726	i0	99.485	4.73096446700508	194	1	98	0	1	194	504	311	Philodina roseola clone Pr_TEL_J telomeric repeat and subterminal DNA junction	blastn	932	353	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
22276405	22276405	PRJNA627467_P_NODE_7558_length_230_cov_38.883978_g7489_i0	PRJNA627467	7558	230	38.883978	89.4331494	Philodina roseola	96448	Rotifera	other_Eukaryota	414	2.27e-111	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g7489	i0	100	48.3347826086957	224	0	97	0	1	224	1742	1519	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	11117	414	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola

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