metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA908278" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA908278" 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
890136	890136	PRJNA908278_P_NODE_11581_length_361_cov_1.666667_g11478_i0	PRJNA908278	11581	361	1.666667	6.01666787	Philodina citrina	468664	Rotifera	other_Eukaryota	472	2.22e-128	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g11478	i0	90.476	58.1578947368421	357	34	99	0	3	359	5283	5639	Philodina citrina complete mitochondrial genome	blastn	20995	472	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
890453	890453	PRJNA908278_P_NODE_6961_length_447_cov_2.906417_g6858_i0	PRJNA908278	6961	447	2.906417	12.99168399	Philodina citrina	468664	Rotifera	other_Eukaryota	494	5.98e-135	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g6858	i0	86.637	15.5055928411633	449	56	100	4	1	447	9738	10184	Philodina citrina complete mitochondrial genome	blastn	6931	494	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
2165793	2165793	PRJNA908278_P_NODE_6722_length_454_cov_2.716535_g6619_i0	PRJNA908278	6722	454	2.716535	12.3330689	Adineta vaga	104782	Rotifera	other_Eukaryota	466	1.3299999999999999e-126	NTclustered	gi\|187233665\|gb\|EU643499.1\|	104782	g6619	i0	86.811	0.918502202643172	417	55	92	0	22	438	1	417	Adineta vaga ribosomal protein L26 mRNA, partial cds	blastn	417	466	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
4718955	4718955	PRJNA908278_P_NODE_5424_length_501_cov_1.439252_g5321_i0	PRJNA908278	5424	501	1.439252	7.21065252	Adineta vaga	104782	Rotifera	other_Eukaryota	442	2.4899999999999995e-119	NTclustered	gi\|187233667\|gb\|EU643500.1\|	104782	g5321	i0	85.817	33.8822355289421	416	59	83	0	1	416	506	91	Adineta vaga ribosomal protein L11 mRNA, partial cds	blastn	16975	442	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
5993641	5993641	PRJNA908278_P_NODE_4085_length_570_cov_0.867203_g3982_i0	PRJNA908278	4085	570	0.867203	4.9430571	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	628	2.0399999999999998e-175	NTclustered	gi\|402761761\|gb\|JX184012.1\|	104788	g3982	i0	86.667	7.38947368421053	570	72	99	4	3	570	22	589	Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	4212	628	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
8543152	8543152	PRJNA908278_P_NODE_19187_length_292_cov_1.739726_g19084_i0	PRJNA908278	19187	292	1.739726	5.07999992	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	263	1.15e-65	NTclustered	gi\|402761789\|gb\|JX184026.1\|	104786	g19084	i0	83.103	37.9931506849315	290	48	99	1	3	292	1040	752	Habrotrocha constricta cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	11094	263	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
9818150	9818150	PRJNA908278_P_NODE_2308_length_736_cov_8.745098_g2210_i0	PRJNA908278	2308	736	8.745098	64.36392128	Philodina citrina	468664	Rotifera	other_Eukaryota	1003	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2210	i0	91.363	25.3532608695652	741	53	100	7	1	736	1659	2393	Philodina citrina complete mitochondrial genome	blastn	18660	1003	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
11094069	11094069	PRJNA908278_P_NODE_8329_length_413_cov_1.964706_g8226_i0	PRJNA908278	8329	413	1.964706	8.11423578	Philodina roseola	96448	Rotifera	other_Eukaryota	553	8.929999999999998e-153	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g8226	i0	93.75	30.7845036319613	368	23	89	0	1	368	27393	27760	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	12714	553	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
12369301	12369301	PRJNA908278_P_NODE_14950_length_325_cov_2.750000_g14847_i0	PRJNA908278	14950	325	2.75	8.9375	Adineta vaga	104782	Rotifera	other_Eukaryota	340	5.819999999999999e-89	NTclustered	gi\|187233663\|gb\|EU643498.1\|	104782	g14847	i0	89.299	1.75692307692308	271	29	83	0	5	275	293	23	Adineta vaga ribosomal protein S1a mRNA, partial cds	blastn	571	340	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
12369363	12369363	PRJNA908278_P_NODE_21010_length_282_cov_1.473684_g20907_i0	PRJNA908278	21010	282	1.473684	4.15578888	Philodina roseola	96448	Rotifera	other_Eukaryota	303	6.5e-78	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g20907	i0	100	1.99290780141844	164	0	99	0	117	280	34465	34628	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	562	303	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
12369587	12369587	PRJNA908278_P_NODE_9090_length_398_cov_1.384615_g8987_i0	PRJNA908278	9090	398	1.384615	5.5107677	Philodina roseola	96448	Rotifera	other_Eukaryota	641	1.7799999999999994e-179	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g8987	i0	99.157	32.035175879397	356	3	100	0	43	398	40086	40441	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	12750	641	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
13643786	13643786	PRJNA908278_P_NODE_12611_length_348_cov_2.141818_g12508_i0	PRJNA908278	12611	348	2.1418180000000002	7.45352664	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	555	2.0599999999999994e-153	NTclustered	gi\|62362203\|gb\|AY942841.1\|	317012	g12508	i0	98.418	1.2183908045977	316	4	91	1	34	348	639	324	Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds	blastn	424	555	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
13644013	13644013	PRJNA908278_P_NODE_33971_length_243_cov_0.905882_g33868_i0	PRJNA908278	33971	243	0.905882	2.20129326	Philodina roseola	96448	Rotifera	other_Eukaryota	388	1.47e-103	NTclustered	gi\|209867657\|gb\|EU637020.1\|	96448	g33868	i0	95.473	1	243	11	100	0	1	243	19951	20193	Philodina roseola peptidylprolyl isomerase-like 2 isoform a-like protein gene, partial cds; and chitin deacetylase 1-like protein, oxysterol-binding protein-like protein, COMM domain containing 9-like protein, T54 protein-like protein, Hox-5d, unconventional myosin heavy chain-like protein, hypothetical proteins, nuclear membrane protein XMAN1-like protein, conserved hypothetical protein, hypothetical protein, pleckstrin homology domain containing family G-like protein, cell division cycle 42-like protein, and ubiquitin ligase E3 alpha-II-like protein genes, complete cds	blastn	243	388	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
14918263	14918263	PRJNA908278_P_NODE_2292_length_738_cov_2.362406_g2194_i0	PRJNA908278	2292	738	2.362406	17.43455628	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	789	0	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g2194	i0	86.16	9.96883468834688	737	94	99	7	6	738	28	760	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	7357	789	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
17468509	17468509	PRJNA908278_P_NODE_2254_length_743_cov_5.491045_g2156_i0	PRJNA908278	2254	743	5.491045	40.79846435	Philodina citrina	468664	Rotifera	other_Eukaryota	689	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2156	i0	84.011	21.9676985195155	738	96	98	17	13	740	2408	1683	Philodina citrina complete mitochondrial genome	blastn	16322	689	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
18741879	18741879	PRJNA908278_P_NODE_30435_length_247_cov_0.885057_g30332_i0	PRJNA908278	30435	247	0.885057	2.18609079	Philodina roseola	96448	Rotifera	other_Eukaryota	298	2.6e-76	NTclustered	gi\|187936090\|gb\|EU652318.1\|	96448	g30332	i0	89.388	0.991902834008097	245	15	95	5	7	241	11507	11264	Philodina roseola 7TM protein 66, histone H4, histone H3, histone H2B, osteopetrosis associated transmembrane protein, cleft lip and palate associated transmembrane protein, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, hypothetical protein 21, putative GPCR, and hypothetical protein 22 genes, complete cds	blastn	245	298	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
18741932	18741932	PRJNA908278_P_NODE_3995_length_576_cov_2.616302_g3892_i0	PRJNA908278	3995	576	2.616302	15.06989952	Philodina citrina	468664	Rotifera	other_Eukaryota	603	1.2499999999999999e-167	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g3892	i0	85.689	2.84027777777778	573	81	99	1	1	573	10462	11033	Philodina citrina complete mitochondrial genome	blastn	1636	603	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
20375404	20375404	PRJNA908278_P_NODE_7836_length_424_cov_1.532764_g7733_i0	PRJNA908278	7836	424	1.532764	6.49891936	Eurotatoria	2816136	Rotifera	other_Eukaryota	496	1.57e-135	NTclustered	gi\|703599946\|gb\|KM043180.1\|	104782	g7733	i0	88.35	87.1132075471698	412	48	97	0	13	424	305	716	Adineta vaga voucher AD003 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial	blastn	36936	497	0.997987927565392	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
22567544	22567544	PRJNA908278_P_NODE_618_length_1243_cov_1.814530_g572_i0	PRJNA908278	618	1243	1.81453	22.5546079	Philodina citrina	468664	Rotifera	other_Eukaryota	1513	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g572	i0	88.647	43.3057119871279	1242	141	99	0	2	1243	223	1464	Philodina citrina complete mitochondrial genome	blastn	53829	1513	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
23842569	23842569	PRJNA908278_P_NODE_31319_length_246_cov_0.890173_g31216_i0	PRJNA908278	31319	246	0.890173	2.18982558	Philodina roseola	96448	Rotifera	other_Eukaryota	291	4.33e-74	NTclustered	gi\|183178937\|gb\|EU432547.1\|	96448	g31216	i0	91.121	1.73983739837398	214	19	87	0	1	214	15562	15349	Philodina roseola TAR protein gene, partial cds; U1-like Zn-finger-containing protein (U1Zn_1), unknown (PruORF0001_1), unknown (PrPCG0001_1), methione sulfide reductase B (MSRB_1), Strabismus, serine-threonin kinase copy 1, plasma membrane calcium-dependent ATPase (CAse_1), myosin essential light chain (MELC_1), and 82 kDa heat shock protein (hsp82_1) genes, complete cds; FBoxLRR_1 gene, complete sequence; and TPRA_1 (TPRA_1) gene, complete cds	blastn	428	291	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
25116499	25116499	PRJNA908278_P_NODE_7920_length_422_cov_2.143266_g7817_i0	PRJNA908278	7920	422	2.143266	9.04458252	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	435	3.4500000000000004e-117	NTclustered	gi\|402761725\|gb\|JX183994.1\|	104786	g7817	i0	85.343	1.96682464454976	423	58	99	4	1	421	140	560	Habrotrocha constricta ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial	blastn	830	435	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta

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