contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax_superkingdom = "Archaea"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 937384 | 937384 | PRJNA951810_P_NODE_43801_length_310_cov_8.025316_g43458_i0 | PRJNA951810 | 43801 | 310 | 8.025316 | 24.8784796 | Salinirubellus litoreus | 3131999 | Archaea | Archaea | 111 | 4.71e-20 | NTclustered | gi|2700494409|gb|CP147841.1| | 3131999 | g43458 | i0 | 83.471 | 25.6677419354839 | 121 | 18 | 39 | 2 | 20 | 139 | 991275 | 991156 | Salinirubellus litoreus strain SYNS196 chromosome, complete genome | blastn | 7957 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus litoreus | |
| 3487562 | 3487562 | PRJNA951810_P_NODE_197363_length_198_cov_4.688000_g197018_i0 | PRJNA951810 | 197363 | 198 | 4.688 | 9.28224 | Halosolutus halophilus | 1552990 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|2221357424|gb|CP094974.1| | 1552990 | g197018 | i0 | 100 | 0.146464646464646 | 29 | 0 | 15 | 0 | 77 | 105 | 1695617 | 1695645 | Halosolutus halophilus strain LT55 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halosolutus | Halosolutus halophilus | |
| 6039027 | 6039027 | PRJNA951810_P_NODE_133225_length_270_cov_10.223350_g132880_i0 | PRJNA951810 | 133225 | 270 | 10.22335 | 27.603045 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 499 | 7.349999999999998e-137 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g132880 | i0 | 100 | 3.18518518518519 | 270 | 0 | 100 | 0 | 1 | 270 | 559417 | 559148 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 860 | 499 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 7313897 | 7313897 | PRJNA951810_P_NODE_132766_length_271_cov_2.727273_g132421_i0 | PRJNA951810 | 132766 | 271 | 2.727273 | 7.39090983 | uncultured marine group II/III euryarchaeote KM3_181_H05 | 1457945 | Archaea | Archaea | 60.2 | 1.49e-4 | NTclustered | gi|663514819|gb|KF900736.1| | 1457945 | g132421 | i0 | 92.857 | 0.154981549815498 | 42 | 2 | 15 | 1 | 189 | 230 | 23684 | 23724 | Uncultured marine group II/III euryarchaeote KM3_181_H05 genomic sequence | blastn | 42 | 60.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote KM3_181_H05 | ||||||
| 11139448 | 11139448 | PRJNA951810_P_NODE_1289_length_1472_cov_6.825590_g1179_i0 | PRJNA951810 | 1289 | 1472 | 6.82559 | 100.4726848 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 54.7 | 0.042 | NTclustered | gi|2108379079|gb|CP070647.1| | 2026714 | g1179 | i0 | 100 | 0.0197010869565217 | 29 | 0 | 2 | 0 | 146 | 174 | 654270 | 654298 | MAG: Candidatus Bathyarchaeota archaeon isolate bin882 chromosome | blastn | 29 | 54.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 14017949 | 14017949 | PRJNA951810_P_NODE_7731_length_672_cov_6.015025_g7447_i0 | PRJNA951810 | 7731 | 672 | 6.015025 | 40.420968 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.005 | NTclustered | gi|1657691899|gb|CP040330.1| | 88724 | g7447 | i0 | 90.476 | 0.130952380952381 | 42 | 4 | 6 | 0 | 271 | 312 | 1087290 | 1087331 | Natrinema versiforme strain BOL5-4 chromosome, complete genome | blastn | 88 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema versiforme | |
| 17515572 | 17515572 | PRJNA951810_P_NODE_44954_length_310_cov_7.337553_g44611_i0 | PRJNA951810 | 44954 | 310 | 7.337553 | 22.7464143 | uncultured Methanoregulaceae archaeon | 1392423 | Archaea | Archaea | 65.8 | 3.72e-6 | NTclustered | gi|2874253886|emb|OY970061.1| | 1392423 | g44611 | i0 | 100 | 4.38709677419355 | 35 | 0 | 11 | 0 | 256 | 290 | 344874 | 344840 | MAG: uncultured Methanoregulaceae archaeon isolate MFD01231.bin.c.5 genome assembly, chromosome: 1 | blastn | 1360 | 65.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | uncultured Methanoregulaceae archaeon | ||
| 22615036 | 22615036 | PRJNA951810_P_NODE_73538_length_299_cov_8.840708_g73194_i0 | PRJNA951810 | 73538 | 299 | 8.840708 | 26.43371692 | Halorussus aquaticus | 2953748 | Archaea | Archaea | 132 | 3.47e-26 | NTclustered | gi|2269702782|gb|CP100400.1| | 2953748 | g73194 | i0 | 82.667 | 35.9230769230769 | 150 | 24 | 50 | 2 | 150 | 298 | 1267331 | 1267479 | Halorussus aquaticus strain XZYJ18 chromosome, complete genome | blastn | 10741 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus aquaticus | |
| 23888175 | 23888175 | PRJNA951810_P_NODE_128199_length_274_cov_4.348259_g127854_i0 | PRJNA951810 | 128199 | 274 | 4.348259 | 11.91422966 | Natribaculum luteum | 1586232 | Archaea | Archaea | 429 | 9.949999999999999e-116 | NTclustered | gi|2224381015|gb|CP095398.1| | 1586232 | g127854 | i0 | 94.891 | 24.3430656934307 | 274 | 14 | 100 | 0 | 1 | 274 | 825712 | 825439 | Natribaculum luteum strain IBRC-M 10912 plasmid unnamed1, complete sequence | blastn | 6670 | 429 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natribaculum | Natribaculum luteum | |
| 23889842 | 23889842 | PRJNA951810_P_NODE_42939_length_310_cov_8.687764_g42596_i0 | PRJNA951810 | 42939 | 310 | 8.687764 | 26.9320684 | Halovivax gelatinilyticus | 2961597 | Archaea | Archaea | 52.8 | 0.029 | NTclustered | gi|2273668750|gb|CP101322.1| | 2961597 | g42596 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 121 | 148 | 662442 | 662415 | Halovivax gelatinilyticus strain CGA30 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax gelatinilyticus |
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);;