metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA733995" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA733995" and tax_phylum = "Chordata"

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
716601	716601	PRJNA733995_P_NODE_10621_length_266_cov_1.476684_g10574_i0	PRJNA733995	10621	266	1.476684	3.92797944	Gracilinanus agilis	191870	Chordata	Chordata	63.9	1.12e-5	NTclustered	gi\|2119465822\|ref\|XM_044684080.1\|	191870	g10574	i0	100	0.443609022556391	34	0	13	0	188	221	311	278	PREDICTED: Gracilinanus agilis forkhead box protein O1-like (LOC123255241), partial mRNA	blastn	118	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Didelphimorphia	Didelphidae	Gracilinanus	Gracilinanus agilis
1196704	1196704	PRJNA733995_P_NODE_13541_length_242_cov_1.857988_g13494_i0	PRJNA733995	13541	242	1.857988	4.49633096	Fringillidae	9133	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2917653667\|emb\|OZ228737.1\|	160760	g13494	i0	96.875	0.396694214876033	32	0	13	1	53	84	12654781	12654811	Spinus spinus genome assembly, chromosome: 19	blastn	96	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus
1992656	1992656	PRJNA733995_P_NODE_3182_length_496_cov_1.796690_g3135_i0	PRJNA733995	3182	496	1.79669	8.9115824	Mesoplodon densirostris	48708	Chordata	Chordata	322	3.34e-83	NTclustered	gi\|2589171607\|ref\|XM_060109623.1\|	48708	g3135	i0	80.37	89	433	77	86	7	27	455	1527	1099	PREDICTED: Mesoplodon densirostris COPI coat complex subunit gamma 1 (COPG1), mRNA	blastn	44144	322	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Ziphiidae	Mesoplodon	Mesoplodon densirostris
1992669	1992669	PRJNA733995_P_NODE_5202_length_378_cov_1.206557_g5155_i0	PRJNA733995	5202	378	1.206557	4.56078546	Echinops telfairi	9371	Chordata	Chordata	326	1.92e-84	NTclustered	gi\|2160825162\|ref\|XM_045293844.1\|	9371	g5155	i0	83.286	11.3518518518519	353	59	93	0	1	353	1559	1911	PREDICTED: Echinops telfairi lysyl-tRNA synthetase 1 (KARS1), transcript variant X1, mRNA	blastn	4291	326	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia		Tenrecidae	Echinops	Echinops telfairi
1992696	1992696	PRJNA733995_P_NODE_9442_length_281_cov_1.480769_g9395_i0	PRJNA733995	9442	281	1.480769	4.16096089	Gymnogyps californianus	33616	Chordata	Chordata	52.8	0.026	NTclustered	gi\|2312056901\|ref\|XM_050910693.1\|	33616	g9395	i0	100	0.099644128113879	28	0	10	0	201	228	34	61	PREDICTED: Gymnogyps californianus JunD proto-oncogene, AP-1 transcription factor subunit (JUND), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Accipitriformes	Cathartidae	Gymnogyps	Gymnogyps californianus
2472093	2472093	PRJNA733995_P_NODE_4762_length_397_cov_0.950617_g4715_i0	PRJNA733995	4762	397	0.950617	3.77394949	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	8.17e-4	NTclustered	gi\|55792325\|gb\|AC130671.7\|	10090	g4715	i0	100	5.77329974811083	31	0	8	0	93	123	40460	40430	Mus musculus chromosome 15, clone RP24-90K19, complete sequence	blastn	2292	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
3267917	3267917	PRJNA733995_P_NODE_10543_length_267_cov_1.587629_g10496_i0	PRJNA733995	10543	267	1.587629	4.23896943	Ficedula albicollis	59894	Chordata	Chordata	189	1.78e-43	NTclustered	gi\|1020965978\|ref\|XM_005058029.2\|	59894	g10496	i0	86.982	63.059925093633	169	20	63	2	1	168	711	544	PREDICTED: Ficedula albicollis protein phosphatase 2 regulatory subunit B, alpha (PPP2R2A), transcript variant X2, mRNA	blastn	16837	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Muscicapidae	Ficedula	Ficedula albicollis
3748457	3748457	PRJNA733995_P_NODE_8143_length_301_cov_1.350877_g8096_i0	PRJNA733995	8143	301	1.350877	4.06613977	Metazoa	33208	Chordata	Chordata	52.8	0.028	NTclustered	gi\|1900012142\|ref\|XM_036114070.1\|	9711	g8096	i0	100	1.11627906976744	28	0	9	0	274	301	6912	6885	PREDICTED: Halichoerus grypus solute carrier family 8 member A2 (SLC8A2), mRNA	blastn	336	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Halichoerus	Halichoerus grypus
3748460	3748460	PRJNA733995_P_NODE_8803_length_290_cov_1.013825_g8756_i0	PRJNA733995	8803	290	1.013825	2.9400925	Lampetra	13103	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2815003353\|emb\|OZ078614.2\|	7748	g8756	i0	100	0.582758620689655	29	0	12	0	9	37	1613045	1613073	Lampetra fluviatilis genome assembly, chromosome: 46	blastn	169	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
5820276	5820276	PRJNA733995_P_NODE_9625_length_278_cov_2.673171_g9578_i0	PRJNA733995	9625	278	2.673171	7.43141538	Dromiciops gliroides	33562	Chordata	Chordata	52.8	0.026	NTclustered	gi\|2102646128\|ref\|XM_043979956.1\|	33562	g9578	i0	100	0.100719424460432	28	0	10	0	211	238	1712	1685	PREDICTED: Dromiciops gliroides kelch domain containing 4 (KLHDC4), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Microbiotheria	Microbiotheriidae	Dromiciops	Dromiciops gliroides
7095290	7095290	PRJNA733995_P_NODE_10306_length_270_cov_1.203046_g10259_i0	PRJNA733995	10306	270	1.203046	3.2482242	Molossus molossus	27622	Chordata	Chordata	52.8	0.025	NTclustered	gi\|1910855947\|ref\|XM_036257872.1\|	27622	g10259	i0	100	0.103703703703704	28	0	10	0	28	55	782	755	PREDICTED: Molossus molossus SIK family kinase 3 (SIK3), transcript variant X7, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Molossidae	Molossus	Molossus molossus
7574667	7574667	PRJNA733995_P_NODE_7526_length_313_cov_1.604167_g7479_i0	PRJNA733995	7526	313	1.604167	5.02104271	Mammalia	40674	Chordata	Chordata	89.8	2.23e-13	NTclustered	gi\|2871647313\|ref\|XR_011489537.1\|	9874	g7479	i0	94.737	17.4856230031949	57	3	18	0	257	313	79	23	PREDICTED: Odocoileus virginianus U6 spliceosomal RNA (LOC139036702), ncRNA	blastn	5473	89.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Odocoileus	Odocoileus virginianus
8369909	8369909	PRJNA733995_P_NODE_13347_length_243_cov_2.117647_g13300_i0	PRJNA733995	13347	243	2.117647	5.14588221	Pristis pectinata	685728	Chordata	Chordata	183	7.44e-42	NTclustered	gi\|2329021467\|ref\|XM_052015982.1\|	685728	g13300	i0	80.488	7.5761316872428	246	42	100	5	1	243	572	330	PREDICTED: Pristis pectinata cilia and flagella associated protein 20 (cfap20), mRNA	blastn	1841	183	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rhinopristiformes	Pristidae	Pristis	Pristis pectinata
8849777	8849777	PRJNA733995_P_NODE_8287_length_299_cov_1.362832_g8240_i0	PRJNA733995	8287	299	1.362832	4.07486768	Polypteridae	8289	Chordata	Chordata	76.8	1.65e-9	NTclustered	gi\|2327606559\|ref\|XM_051930614.1\|	27687	g8240	i0	88.71	6.17391304347826	62	7	21	0	226	287	2354	2293	PREDICTED: Erpetoichthys calabaricus CWC22 spliceosome associated protein homolog (cwc22), transcript variant X2, mRNA	blastn	1846	76.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
9645160	9645160	PRJNA733995_P_NODE_8488_length_295_cov_1.040541_g8441_i0	PRJNA733995	8488	295	1.040541	3.06959595	Heliangelus exortis	472823	Chordata	Chordata	56.5	0.002	NTclustered	gi\|2920658670\|ref\|XM_071769054.1\|	472823	g8441	i0	100	1.76610169491525	30	0	10	0	265	294	215	244	PREDICTED: Heliangelus exortis DENN domain containing 5B (DENND5B), transcript variant X1, mRNA	blastn	521	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apodiformes	Trochilidae	Heliangelus	Heliangelus exortis
10920544	10920544	PRJNA733995_P_NODE_11729_length_253_cov_1.283333_g11682_i0	PRJNA733995	11729	253	1.283333	3.24683249	Nannospalax galili	1026970	Chordata	Chordata	52.8	0.023	NTclustered	gi\|674057651\|ref\|XM_008837138.1\|	1026970	g11682	i0	94.286	0.138339920948617	35	0	14	2	181	215	649	617	PREDICTED: Nannospalax galili one cut homeobox 3 (Onecut3), mRNA	blastn	35	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Spalacidae	Nannospalax	Nannospalax galili
10920637	10920637	PRJNA733995_P_NODE_9109_length_286_cov_1.084507_g9062_i0	PRJNA733995	9109	286	1.084507	3.10169002	Felis catus	9685	Chordata	Chordata	54.7	0.007	NTclustered	gi\|1524318341\|gb\|MH270429.1\|	9685	g9062	i0	96.875	0.335664335664336	32	1	11	0	234	265	51378	51347	Felis catus clone RPCI-86:544B22-Y12 CUL4BY (CUL4BY) gene, partial cds; NTY1 (NTY1) gene, complete cds; and TSPY (TSPY) and CCDC71LY (CCDC71LY) genes, partial cds	blastn	96	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
11400458	11400458	PRJNA733995_P_NODE_6089_length_347_cov_4.386861_g6042_i0	PRJNA733995	6089	347	4.386861	15.22240767	Diprotodontia	38609	Chordata	Chordata	52.8	0.033	NTclustered	gi\|1561866263\|ref\|XM_027854484.1\|	29139	g6042	i0	100	0.161383285302594	28	0	8	0	11	38	4132	4105	PREDICTED: Vombatus ursinus CCR4-NOT transcription complex subunit 6 like (CNOT6L), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Diprotodontia	Vombatidae	Vombatus	Vombatus ursinus
12676335	12676335	PRJNA733995_P_NODE_13330_length_243_cov_3.170588_g13283_i0	PRJNA733995	13330	243	3.170588	7.70452884	Felidae	9681	Chordata	Chordata	115	2.7500000000000003e-21	NTclustered	gi\|2130910639\|ref\|XM_011289091.4\|	9685	g13283	i0	82.812	37.4609053497942	128	22	53	0	21	148	1222	1349	PREDICTED: Felis catus adaptor related protein complex 1 subunit mu 2 (AP1M2), transcript variant X2, mRNA	blastn	9103	115	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
13470439	13470439	PRJNA733995_P_NODE_9971_length_274_cov_1.502488_g9924_i0	PRJNA733995	9971	274	1.502488	4.11681712	Heteronotia binoei	13085	Chordata	Chordata	60.2	1.5e-4	NTclustered	gi\|2593490941\|ref\|XM_060260961.1\|	13085	g9924	i0	89.796	0.551094890510949	49	2	17	3	58	103	44	92	PREDICTED: Heteronotia binoei RAB26, member RAS oncogene family (RAB26), mRNA	blastn	151	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Gekkonidae	Heteronotia	Heteronotia binoei
15225309	15225309	PRJNA733995_P_NODE_3892_length_444_cov_2.380054_g3845_i0	PRJNA733995	3892	444	2.380054	10.56743976	Diprotodontia	38609	Chordata	Chordata	52.8	0.043	NTclustered	gi\|1561866263\|ref\|XM_027854484.1\|	29139	g3845	i0	100	0.126126126126126	28	0	6	0	55	82	4132	4105	PREDICTED: Vombatus ursinus CCR4-NOT transcription complex subunit 6 like (CNOT6L), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Diprotodontia	Vombatidae	Vombatus	Vombatus ursinus
16499743	16499743	PRJNA733995_P_NODE_13453_length_243_cov_0.905882_g13406_i0	PRJNA733995	13453	243	0.905882	2.20129326	Chordata	7711	Chordata	Chordata	52.8	0.022	NTclustered	gi\|2312778373\|ref\|XM_050977944.1\|	9135	g13406	i0	100	7.60493827160494	28	0	12	0	204	231	868	895	PREDICTED: Serinus canaria protein phosphatase 1 regulatory subunit 7 (PPP1R7), transcript variant X4, mRNA	blastn	1848	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Serinus	Serinus canaria
16499756	16499756	PRJNA733995_P_NODE_7533_length_313_cov_1.283333_g7486_i0	PRJNA733995	7533	313	1.283333	4.01683229	Metazoa	33208	Chordata	Chordata	54.7	0.008	NTclustered	gi\|2805738024\|emb\|OZ078451.1\|	7748	g7486	i0	96.97	3.79872204472843	33	0	10	1	84	115	9168031	9168063	Lampetra fluviatilis genome assembly, chromosome: 48	blastn	1189	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
17294656	17294656	PRJNA733995_P_NODE_12514_length_248_cov_0.880000_g12467_i0	PRJNA733995	12514	248	0.88	2.1824	Petromyzon marinus	7757	Chordata	Chordata	52.8	0.022	NTclustered	gi\|1822435087\|ref\|XM_032978824.1\|	7757	g12467	i0	100	0.112903225806452	28	0	11	0	185	212	1105	1132	PREDICTED: Petromyzon marinus phosphatidylinositol 3,4,5-trisphosphate 3-phosphatase and dual-specificity protein phosphatase PTEN-like (LOC116956938), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
17294715	17294715	PRJNA733995_P_NODE_8174_length_300_cov_2.123348_g8127_i0	PRJNA733995	8174	300	2.123348	6.370044	Latimeria chalumnae	7897	Chordata	Chordata	54.7	0.008	NTclustered	gi\|2721784575\|ref\|XM_064562371.1\|	7897	g8127	i0	96.875	0.426666666666667	32	1	11	0	197	228	1537	1506	PREDICTED: Latimeria chalumnae uncharacterized LOC102352647 (LOC102352647), transcript variant X2, mRNA	blastn	128	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
20323249	20323249	PRJNA733995_P_NODE_3356_length_482_cov_1.129584_g3309_i0	PRJNA733995	3356	482	1.129584	5.44459488	Lampetra	13103	Chordata	Chordata	62.1	7.8e-5	NTclustered	gi\|2805738463\|emb\|OZ078455.1\|	7748	g3309	i0	91.111	30.9522821576763	45	4	9	0	28	72	3891741	3891697	Lampetra fluviatilis genome assembly, chromosome: 52	blastn	14919	62.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
22394162	22394162	PRJNA733995_P_NODE_1458_length_746_cov_72.393759_g1414_i0	PRJNA733995	1458	746	72.393759	540.05744214	Amblyraja radiata	386614	Chordata	Chordata	147	3.33e-30	NTclustered	gi\|1822543604\|ref\|XM_033026553.1\|	386614	g1414	i0	91.509	3.52680965147453	106	9	14	0	437	542	232	127	PREDICTED: Amblyraja radiata ribosomal protein S29 (rps29), mRNA	blastn	2631	147	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Amblyraja	Amblyraja radiata
24943131	24943131	PRJNA733995_P_NODE_7960_length_305_cov_1.327586_g7913_i0	PRJNA733995	7960	305	1.327586	4.0491373	Nannospalax galili	1026970	Chordata	Chordata	54.7	0.008	NTclustered	gi\|1691670814\|ref\|XM_008832112.3\|	1026970	g7913	i0	94.286	0.114754098360656	35	2	11	0	173	207	92	126	PREDICTED: Nannospalax galili neurochondrin (Ncdn), transcript variant X3, mRNA	blastn	35	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Spalacidae	Nannospalax	Nannospalax galili

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