metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1068830" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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
183643	183643	PRJNA1068830_P_NODE_77401_length_249_cov_3.687500_g76698_i0	PRJNA1068830	77401	249	3.6875	9.181875	Philodina sp. A754P1	1236085	Rotifera	other_Eukaryota	307	4.3600000000000006e-79	NTclustered	gi\|407081081\|gb\|JQ309152.1\|	1236085	g76698	i0	92.166	86.9839357429719	217	17	87	0	28	244	1	217	Philodina sp. A754P1 cytochrome c oxidase subunit I (cox1) gene, partial cds; mitochondrial	blastn	21659	307	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. A754P1
2733415	2733415	PRJNA1068830_P_NODE_46783_length_321_cov_1.846774_g46080_i0	PRJNA1068830	46783	321	1.846774	5.92814454	Philodina roseola	96448	Rotifera	other_Eukaryota	366	9.47e-97	NTclustered	gi\|183178918\|gb\|EU432546.1\|	96448	g46080	i0	88.026	27.4672897196262	309	37	96	0	5	313	34705	34397	Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_4), 7 transmembrane receptor (rhodopsin family) B (7tmrB_4), 7 transmembrane receptor (rhodopsin family) C (7tmrC_4), 7 transmembrane receptor (rhodopsin family) D (7tmrD_4), myosin essential light chain (MELC_4), ArkA_4 (arkA_4), ArkB_4 (arkB_4), ArkC_4 (arkC_4), TPR-repeat containing protein A (TPRA_4), 82 kDa heat shock protein (hsp82_4), LicD motif-containing protein (LicD_4), low density lipoprotein receptor (LDL_4), Zn carboxypeptidase (Zncarb_4), phosphoribosylaminoimidazole carboxylase, phosphoribosylaminoimidazole succinocarboxamide synthetase (PAICS_4), unknown (PrPCG0002_4), lung-like 7 transmembrane receptor (lung_4), and phosphoglycerate-bisphosphoglycerate mutase family M protein (PGAM_4) genes, complete cds	blastn	8817	366	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
9110465	9110465	PRJNA1068830_P_NODE_48888_length_313_cov_6.958333_g48185_i0	PRJNA1068830	48888	313	6.958333	21.77958229	Philodina roseola	96448	Rotifera	other_Eukaryota	568	2.3499999999999998e-157	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g48185	i0	99.361	53.7635782747604	313	2	100	0	1	313	1505	1817	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	16828	568	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
14210931	14210931	PRJNA1068830_P_NODE_19392_length_544_cov_1.486200_g18695_i0	PRJNA1068830	19392	544	1.4862	8.084928	Philodina roseola	96448	Rotifera	other_Eukaryota	449	1.6199999999999995e-121	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g18695	i0	86.364	22.3952205882353	418	49	76	6	1	414	40499	40086	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	12183	449	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
18034962	18034962	PRJNA1068830_P_NODE_62315_length_275_cov_1.851485_g61612_i0	PRJNA1068830	62315	275	1.851485	5.09158375	Philodina citrina	468664	Rotifera	other_Eukaryota	326	1.35e-84	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g61612	i0	88.476	36.1745454545455	269	31	98	0	3	271	5260	4992	Philodina citrina complete mitochondrial genome	blastn	9948	326	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
19308944	19308944	PRJNA1068830_P_NODE_6656_length_999_cov_3.555076_g6131_i0	PRJNA1068830	6656	999	3.555076	35.51520924	Adineta vaga	104782	Rotifera	other_Eukaryota	1029	0	NTclustered	gi\|402761739\|gb\|JX184001.1\|	104782	g6131	i0	85.329	68.9289289289289	1002	139	99	5	2	999	427	1424	Adineta vaga cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	68860	1029	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
20140479	20140479	PRJNA1068830_P_NODE_14876_length_635_cov_6.875445_g14198_i0	PRJNA1068830	14876	635	6.875445	43.65907575	Adineta	104781	Rotifera	other_Eukaryota	1151	0	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g14198	i0	99.37	42.2125984251969	635	4	100	0	1	635	2147	1513	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	26805	1157	0.994814174589456	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
24408006	24408006	PRJNA1068830_P_NODE_11200_length_748_cov_10.300741_g10547_i0	PRJNA1068830	11200	748	10.300741	77.04954268	Philodina citrina	468664	Rotifera	other_Eukaryota	614	7.619999999999998e-171	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g10547	i0	82.021	22.9986631016043	762	100	99	30	1	747	2390	1651	Philodina citrina complete mitochondrial genome	blastn	17203	614	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina

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